Oracle¶
Note
GeoServer does not come built-in with support for Oracle; it must be installed through an extension. Proceed to Installing the Oracle extension for installation details.
Oracle Spatial and Locator are the spatial extensions of Oracle.
Installing the Oracle extension¶
Download the Oracle extension from the GeoServer download page.
Warning
Make sure to match the version of the extension to the version of the GeoServer instance!
Extract the contents of the archive into the WEB-INF/lib directory of he GeoServer installation.
Adding an Oracle datastore¶
Once the extension is properly installed Oracle will be an option in the Vector Data Sources list when creating a new data store.
Oracle in the list of data sources
Configuring an Oracle datastore¶
Configuring an Oracle datastore
| Option | Description |
| host | The oracle server host name or IP address. |
| port | The port on which the Oracle server is accepting connections - often this is port 1521. |
| database | The name of the database to connect to. |
| schema | The database schema to access tables from. Setting this value greatly increases the speed at which the data store displays its publishable tables and views, so it is advisable to set this. |
| user | The name of the user to use when connecting to the oracle database. |
| password | The password to use when connecting to the database. Leave blank for no password. |
| max connections min connections fetch size connection timeout validate connections | Connection pool configuration parameters. See the Database Connection Pooling section for details. |
| Loose bbox | Controls how bounding box comparisons are made against geometries in the database. See the Using loose bounding box section below. |
Using loose bounding box¶
When the loose bbox option is set, only the bounding box of a geometry is used. This results in a significant performance gain. The downside is that some geometries may be considered inside of a bounding box when they are technically not.
If the primary use of the database is through Web Map Service this flag can be set safely since a loss of some accuracy is usually acceptable. However if using Web Feature Service and making use of BBOX filtering capabilities, this flag should not be set.
Configuring an Oracle database with JNDI¶
See Setting up a JNDI connection pool with Tomcat for a step by step guide on setting up an Oracle JDNI connection.