Oracle Informix Driver Properties

You can specify the following connectivity properties for your Informix database:

Basic

Property Description
Host Specifies either the IP address or the server name (if your network supports named servers) of the primary database server. For example, 122.23.15.12 or InformixServer.
Port Specifies the TCP port on which the database server listens for connections. The default varies depending on operating system.
User Specifies the case-insensitive default user name used to connect to your Informix database.
Password Specifies a case-insensitive password used to connect to your Informix database.
Database Specifies the name of the database to which you want to connect.
Server Specifies the name of the Informix database server to which you want to connect.
URL Defines the URL format used to connect to your database.

Advanced

Property Description
Root dbspace name Specifies the root dbspace of your Informix database. The rootdb space is the initial dbspace created by the Informix server. The root dbspace contains reserve pages and internal tables.

Properties

You can define name/value pairs to provide additional configuration properties to your database. See your vendor's documentation for more information.

Note: Connection property names are case-insensitive.

Runtime

Property Description
Maximum Pool Size Determines the maximum number of connections that can be created within the connection pool.
Maximum Connections Per User Determines the maximum number of connections that can be created per user.
Connection Idle Time (minutes) Specifies the maximum time, in minutes, that a database connection can remain idle before it is closed automatically.
Minimum Pool Size Determines the minimum number of connections that can be created within a connection pool.
Maximum Opened Cursors Determines the maximum number of cursors that can be opened at one time.