...
Name | Type | Required | Description |
id | string | yes | Unique identifier |
dbtype | 'oracle' | yes | The name of the driver to use, in this case Oracle |
host | string | yes | The hostname or ip address of the Oracle server |
port | number | yes | The port number that the Oracle instance is running on instance |
database | string | yes no | The Oracle instance to be connected to database parameter for the connection url |
username | string | yes | The userid used when connecting to the database |
password | string | yes | The password used when connecting to the database |
schema | string | no | The schema used when connecting to the database |
...
No connection pool configuration is provided with this driver, the driver manages the connection pooling itself.
If database starts with '(' then the format of the connection url will be
jdbc:oracle:thin:@database
If database starts with '/' then the format of the connection url will be
jdbc:oracle:thin:@//host:portdatabase
else the format of the connection url will be
jdbc:oracle:thin:@host:port:database
Examples
| Code Block | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
<spatial:spatialengine id="oracle">
<dbtype>oracle</dbtype>
<host>oradev</host>
<port>1521</port>
<instance>ORCL</instance>
<user>gis</user>
<passwd>hak0rz</passwd>
<schema>GIS</schema>
</spatial:spatialengine>
|
| Code Block | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
<spatial:spatialengine id="sdbeosdbeos"> <dbtype>oracle</dbtype> <host>sdbeo<<host>sdbeos</host> <port>1521</port> <database>sdbeotest<<database>staging</database> <user>sdbe<user>data_viewer</user> <passwd>sdbe0viewer<<passwd>ENCSSJKXUMJBMTPGEJFGCXCQFXJJZUTMJZJ</passwd> <schema>ASSETS</schema> </spatial:spatialengine> |