Working with Oracle data

Boundless Server can read and publish data from an Oracle Spatial database. Any table that has a valid geometry column can be published as a layer in GeoServer.

Installing Oracle support

Oracle support isn’t enabled by default, so it must be separately installed through an extension.

Installing support for this is the same as most Boundless Server Extensions.

Installation instructions are dependent on your operating system and method of install:

Note

The Boundless Server virtual machine has most extensions pre-installed.

Warning

Because of licensing issues, an additional file is required to be installed that is not part of the extension bundle. This file, the Oracle JDBC driver, is included as part of Oracle installations.

Verifying installation

To verify that the extension has been installed properly:

  1. Log in to the GeoServer web interface.

  2. Click Stores then Add new store.

  3. In the list of Vector Data Stores, you should see three entries that mention Oracle:

    ../../_images/oracle_storelink.png

    Oracle in the list of vector stores

    If you don’t see all three entries, then the Oracle JDBC driver was not copied to the correct location. The file must be copied to the same directory as the rest of the extension files.

    If you don’t see any entries, the extension itself did not install correctly.

For more information on adding a store and publishing layers, please see the GeoServer documentation for Oracle.

Caveats

Oracle data will be assumed to be point geometries, so new layers will be styled accordingly. Data can be rendered as intended by changing the styling of the layer to use the correct geometry.