Oracle

implproposalmainnone

The features are stored in an Oracle Spatial database.

Prerequisites

Since the Oracle JDBC driver is not open source, it is not included in the distribution. You have to download a recent ojdbc11.jar from the Oracle website and add it to the Store as resource with type oracle.

Limitations

• Only Oracle 19c has been tested.
• Only geometries in a 2D coordinate reference system are supported.
• All identifiers must be unquoted identifiers; that is the identifiers will be all uppercase.
• The option linearizeCurves is not supported. All geometries must conform to the OGC Simple
  Feature Access standard.
• The spatial operator S_CROSSES is not supported.
• The CQL2 functions DIAMETER2D() and DIAMETER3D() are not supported.
• CRUD operations are not supported.
• Columns with JSON content are not supported.

Configuration

Options

Name	Default	Description	Type	Since
connectionInfo		See Connection Info.	object	v2.0
sourcePathDefaults		Defaults for the path expressions in sourcePath, for details see Source Path Defaults below.	object	v2.0
queryGeneration		Options for query generation, for details see Query Generation below.	object	v2.0

Connection Info

The connection info object for Oracle databases has the following properties:

Name	Default	Description	Type	Since
database		The name of the database.	string	v2.0
host		The database host. To use a non-default port, add it to the host separated by :, e.g. db:1523.	string	v2.0
user		The user name.	string	v2.0
password		The base64 encoded password of the user.	string	v2.0
schemas	[]	The names of database schemas that should be used.	array	v2.0
pool	see below	Connection pool settings, for details see Pool below.	object	v2.0