A simple Java demo application to show how to visualize spatial objects from an Oracle XE database.
It extracts spatial object data from user-defined tables in an Oracle database (Express Edition) and visualizes them in a separate window in a black-and-white mode.

Tables from which to extract data are defined by a user in a plaintext file tables.txt (one table name per line). This file must exist in the current work directory. Before running this application, the tables must be populated with user-defined spatial object data.

The application has been developed in course of my master studies at Riga Technical University (Specialized Database Systems (DSP 403), Prof. Dr. J. Eiduks).

Prerequisites:

• installed Oracle SQL Developer
• installed Oracle Database XE (version 11g was used originally)

External libraries (add to the project as a reference):

• ojdbc8.jar (located in .../sqldeveloper/jdbc/lib subfolder of your SQL Developer installation)
• sdoapi.jar (located in .../sqldeveloper/sqldeveloper/lib subfolder of your SQL Developer installation)

Run the application (from a commandline):

$>java -cp * SpatialVisualizerDemo