Page Comparison

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

database

string

no

The 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

minconnections

integer

no

The minimum number of pooled connection. Default 1

maxconnections

integer

no

The maximum number of open connections. Default 10

validateconnections

boolean

no

Check connection is alive before using it. Default false

fetchsize

integer

no

The number of records read with each iteraction with the dbms. Default 1000

connectiontimeout

integer

no

The number of seconds the connection pool will wait before timing out attempting to get a new connection. Default 20 (seconds)

primarykeymetadatatable

string

no

The optional table containing primary key structure and sequence associations. Can be expressed as 'schema.name' or just 'name'. Default none

maxopenpreparedstatements

integer

no

Maximum number of prepared statements kept open and cached for each connection in the pool. Set to 0 to have unbounded caching, to -1 to disable caching. Default 50