A data source configuration is a collection of information that identifies the target database to which the driver connects. The Data Source classes support the following data source properties and associated getter/setter methods.
DS Property | Description |
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 | IANA or 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' |
The data source properties marked as “required” correspond to parameters contained in a connection URL. For a description of these parameters, see DriverManager.getConnection() Method--Establish JDBC Driver Connection. The remaining Data Source properties correspond to the driver properties defined in JDBC Driver Properties.
