JDBC Driver Interface

Class	Implemented JDBC Interface
com.ingres.jdbc.IngresDriver	The Vector implementation of the JDBC Driver interface (java.sql.Driver).
com.ingres.jdbc.IngresDataSource	The Vector implementation of the JDBC DataSource interface (javax.sql.DataSource).
com.ingres.jdbc.IngresCPDataSource	The Vector implementation of the JDBC ConnectionPoolDataSource interface (javax.sql.ConnectionPoolDataSource).
com.ingres.jdbc.IngresXADataSource	The Vector implementation of the JDBC XADataSource interface (javax.sql.XADataSource).

Class

Implemented JDBC Interface

com.ingres.jdbc.IngresDriver

The Vector implementation of the JDBC Driver interface (java.sql.Driver).

com.ingres.jdbc.IngresDataSource

The Vector implementation of the JDBC DataSource interface (javax.sql.DataSource).

com.ingres.jdbc.IngresCPDataSource

The Vector implementation of the JDBC ConnectionPoolDataSource interface (javax.sql.ConnectionPoolDataSource).

com.ingres.jdbc.IngresXADataSource

The Vector implementation of the JDBC XADataSource interface (javax.sql.XADataSource).

Property	Attribute	Description
autocommit_mode	AUTO	Autocommit cursor handling mode. Valid values are: dbms–(Default) autocommit processing is done by the DBMS Server single–DAS enforces single cursor operation during autocommit multi–DAS simulates autocommit operations when more than one cursor is open. For further details, see How Transactions Are Autocommitted.
char_encode	ENCODE	Specifies the Java character encoding used for conversions between Unicode and character data types. Generally, the character encoding is determined automatically by the driver from the DAS installation character set. This property allows an alternate character encoding to be specified (if desired) or a valid character encoding to be used when the driver is unable to map the server's character set.
compression	COMPRESS	Whether data is compressed over the network. Valid values are: off–Compression off on–(Default) Compression on
connect_pool	POOL	Server connection pool control. Valid values are: off–Requests a non-pooled connection when server pooling is enabled on–Requests a pooled connection when server pooling is optional. The default is to allow the DAS configuration to determine pooling.
cursor_mode	CURSOR	Default cursor concurrency mode, which determines the concurrency of cursors that have no concurrency explicitly assigned. Valid values are: dbms–Concurrency is determined by the DBMS Server update–Provides updateable cursors readonly–(Default) Provides non-updateable cursors Further details are provided in Cursors and Result Set Characteristics.
date_alias	DATE	Specifies the data type of columns created using the alias keyword "date". Valid values are: "ansidate" or "ingresdate". Default value is "ansidate" if the property send_ingres_dates is set to false, otherwise it is "ingresdate". This property is not used directly by the driver but is sent to the DBMS and affects the processing of query text.
date_format	DATE_FMT	Specifies the Vector format for date literals. Corresponds to the Vector environment variable II_DATE_FORMAT and is assigned the same values. This property is not used directly by the driver, but is sent to the DBMS and affects the processing of query text.
dbms_password	DBPWD	The user's DBMS password (Vector -P flag).
dbms_user	DBUSR	The user name associated with the DBMS session (Vector -u flag, can require admin privileges).
decimal_char	DECIMAL	Specifies the character to be used as the decimal point in numeric literals. Corresponds to the Vector environment variable II_DECIMAL and is assigned the same values. This property is not used directly by the driver but is sent to the DBMS and affects the processing of query text.
encryption	ENCRYPT	Defines the default encryption mode used by client connections. Valid values are: on–Encryption is required and occurs unless no compatible encryption mechanism is available. Connection fails if encryption is not possible. off–(Default) Encryption is disabled.
group	GRP	The user's group identifier.
identity_query	IDENTITY	Enables or disables the identity query. Valid values are: on–(Default) Identity query is issued if no table key or object key is received and other conditions permit. This setting provides the best behavior for applications that use only table or object keys or only identity columns. off–Identity query is not issued and identity values are not returned. This setting is appropriate if only table or object keys are used.
metadata_underscore	META_UNDER	Enables or disables the underscore character, ‘_’, as a pattern wildcard in DatabaseMetaData methods whose parameters are defined as patterns. Valid values are: true–(Default) Underscore character is treated as a wildcard in metadata patterns. false–Underscore is treated as a literal character in metadata patterns.
money_format	MNY_FMT	Specifies the Vector format for money literals. Corresponds to the Vector environment variable II_MONEY_FORMAT and is assigned the same values. This property is not used directly by the driver but is sent to the DBMS and affects the processing of query text.
money_precision	MNY_PREC	Specifies the precision of money data values. Corresponds to the Vector environment variable II_MONEY_PREC and is assigned the same values. This property is not used directly by the driver but is sent to the DBMS and affects the processing of money values.
password	PWD	The user's operating system password.
role	ROLE	The desired role identifier. If a role password is required, include it with the role name as follows: name/password.
select_loop	LOOP	Select loop vs. cursor queries. Valid values are: on–Uses select loops to retrieve query results off–(Default) Uses cursors For further details, see Cursors and Select Loops.
send_ingres_dates	SEND_INGDATE	Specifies whether datetime values should be sent as INGRESDATE data type. Valid values are: false–Values sent as ANSI TIMESTAMP WITH TIMEZONE type true–Values sent as INGRESDATE type Default value is false if date_alias property is set to "ansidate"; otherwise it is true. Unlike date_format and date_alias, this property is internal to the driver, not sent to the DBMS, and affects the processing of query text.
send_integer_booleans	SEND_INTBOOL	Specifies if Boolean parameters are converted to tinyint values when sent to the DBMS. Valid values are: true–Boolean parameters are converted to tinyint values false–(Default) Boolean parameters are sent as Boolean values
timezone	TZ	Specifies the time zone associated with the client's location. Corresponds to the Vector environment variable II_TIMEZONE_NAME and is assigned the same values. This property is not used directly by the driver but is sent to the DBMS and affects the processing of dates.
user	UID	The user ID on the target DBMS Server machine. See the description of the vnode_usage property in this table. This property can be used if the user has no DBMS user ID and password assigned (see dbms_user and dbms_password in this table).
vnode_usage	VNODE	Allows the JDBC application to control the portions of the vnode information that are used to establish the connection to the remote DBMS server. Valid values are: connect–(Default) Only the vnode connection information is used to establish the connection. login–Both the vnode connection and login information are used to establish the connection. For further details, see JDBC User Authentication.

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	Vector decimal character
dateAlias	Vector date alias
dateFormat	Vector date format
encryption	Data encryption: off or on
moneyFormat	Vector money format
moneyPrecision	Vector money precision
sendIngresDates	Send datetime 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'

DS Property	Description
initialPoolSize	Initial connection pool size
minPoolSize	Minimum connection pool size
maxPoolSize	Maximum connection pool size
maxIdleTime	Maximum time in connection pool
propertyCycle	Wait time for checking the connection pool

DS Property

Description

initialPoolSize

Initial connection pool size

minPoolSize

Minimum connection pool size

maxPoolSize

Maximum connection pool size

maxIdleTime

Maximum time in connection pool

propertyCycle

Wait time for checking the connection pool