description

Description of the data source

serverName

Server host name or network address (required).

Multiple hosts and associated ports can be specified using the following syntax:

host:port{,port}{;host:port{,port}}

TCP/IPv6 addresses (colon-hexadecimal format) must be enclosed in square brackets, for example: [::1]. If a single host name or address is provided with no port, the associated port must be provided using the portName or portNumber properties. If a port (or ports) is provided in this property, then the portName and portNumber properties should not be set.

portName

Symbolic port ID. Multiple ports can be provided, separated by commas. A port ID must be provided in the serverName, portName, or portNumber properties.

portNumber

Numeric port ID. A port ID must be provided either in the serverName, portName, or portNumber properties.

databaseName

Database name (required).

user

User's ID. (A user ID is required when the DAS is not on the same machine as the JDBC client; otherwise this property is optional.)

password

User's password. (A password is required when the DAS is not on the same machine as the JDBC client; otherwise this property is optional.)

roleName

DBMS role identifier

groupName

DBMS group identifier

dbmsUser

User ID for the DBMS session (-u flag)

dbmsPassword

User's DBMS password

compression

Data compression: off or on

connectionPool

Use pooled connection: 'off' or 'on'

autocommitMode

Autocommit cursor handling: 'dbms', 'single', 'multi'

selectLoop

Select loop processing: 'off', or 'on'

cursorMode

Default cursor concurrency: 'dbms', 'update', 'readonly'

vnodeUsage

Vnode usage for DBMS Server access: 'login', 'connect'

charEncode

Java character encoding

timeZone

Ingres timezone

decimalChar

Ingres decimal character

dateAlias

Ingres date alias

dateFormat

Ingres date format

encryption

Data encryption: off or on

moneyFormat

Ingres money format

moneyPrecision

Ingres money precision

sendIngresDates

Send date/time/timestamp values as ingresdate data type: 'true' or 'false'

sendIntegerBooleans

Send Boolean parameters as tinyint values: 'true' or 'false'

IdentityQuery

Issue identity query for identity columns: 'on' or 'off'

metadataUnderscore

Treat underscore character as metadata pattern wildcard: 'true' or 'false'