...
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 |
|---|
| xml |
|---|
| xml |
|---|
| title | Basic Oracle connection |
|---|
| linenumbers | truexml |
|---|
|
<spatial:spatialengine id="oracle">
<dbtype>oracle</dbtype>
<host>oradev</host>
<port>1521</port>
<user>gis</user>
<passwd>hak0rz</passwd>
<schema>GIS</schema>
</spatial:spatialengine>
|
| Code Block |
|---|
| xml |
|---|
| xml |
|---|
| title | Basic Oracle connection with the password using the osgi encrypt command and a database specified |
|---|
| linenumbers | truexml |
|---|
|
<spatial:spatialengine id="sdbeos">
<dbtype>oracle</dbtype>
<host>sdbeos</host>
<port>1521</port>
<database>staging</database>
<user>data_viewer</user>
<passwd>ENCSSJKXUMJBMTPGEJFGCXCQFXJJZUTMJZJ</passwd>
<schema>ASSETS</schema>
</spatial:spatialengine>
|
| Code Block |
|---|
| sql |
|---|
| sql |
|---|
| title | SQL create statement for gt_pk_metadata tablesql |
|---|
|
CREATE TABLE gt_pk_metadata (
table_schema VARCHAR(32),
table_name VARCHAR(32) NOT NULL,
pk_column VARCHAR(32) NOT NULL,
pk_column_idx INTEGER,
pk_policy VARCHAR(32),
pk_sequence VARCHAR(64),
unique (table_schema, table_name, pk_column),
check (pk_policy in ('sequence', 'assigned', 'autogenerated'))
)
|
...