6.6.14.0.1: Properties of data sources

InfoCenter Home >
6: Administer applications >
6.6: Tools and resources quick reference >
6.6.14: Administering database connections (overview) >
6.6.14.0: Properties of JDBC and data source providers >
No Heading Found

6.6.14.0.1: Properties of data sources

Key:
Property name in the Java-based administrative console Applies to Java administrative console of Advanced Edition Version 4.0
Property name in the Web-based administrative console Applies to Web administrative console of Advanced Single Server Edition Version 4.0
Property name in the application client resource configuration tool Applies to Application Client Resource Configuration Tool

Category  Property name in the Web-based administrative console
An optional category string that can be used to classify or group the resource
Confirm Password  Property name in the Java-based administrative console or Re-Enter Password  Property name in the application client resource configuration tool
Confirm the password that you entered in the preceding field
Connection timeout  Property name in the Java-based administrative console  Property name in the Web-based administrative console
The maximum time in seconds that requests for a connection wait if the maximum number of connections is reached and all connections are in use

This value must be a positive integer.

Custom Properties  Property name in the Java-based administrative console  Property name in the application client resource configuration tool or Property Set  Property name in the Web-based administrative console
A set of custom name-value pairs describing properties of the data source

The following are the required properties for each database type:

DB2:

No required properties.

DB2 on iSeries -- toolbox driver:

serverName
The name of the server from which the data source will obtain connections, such as "MyServer"

DB2 on iSeries -- native driver:

No required properties.

Oracle:

URL
The url indicating the database from which the data source will obtain connections, such as "jdbc:oracle:thin:@myServer:1521:myDatabase," where "myServer" is the server name, "1521" is the port it is using for communication, and "myDatabase" is the database name.

Set the user and password in the field provided in the console.

Sybase:

serverName
The name of the database server, such as "db_machine"
portNumber
The tcpip port number through which all communications to the server take place, such as 4100.

Merant:

serverName
The name of the server where SequeLinkServer resides, such as "MyServer"
portNumber
The TCP/IP port SequeLinkServer uses for communication. By default, SequeLinkServer uses port 19996, such as "19996".
disable2Phase
By default, two phase connections are used by Merant always, because the same data source class is used for one phase and two phase commit protocols.

To use one phase connections, set disable2Phase to true.

Set the user and password in the field provided in the console.

InstantDB (NOT supported as an administrative database):

url
The url indicating the database from which the datasource will obtain conne ctions. Example: "jdbc:idb:"configurationFile where configurationFile is the name of the IDB configuration file.

Informix:

ifxIFXHOST
The physical machine name
serverName
The name of the Informix instance on the physical machine
portNumber
The port number of the Informix instance
informixLockModeWait
By default, Informix throws an exception when it cannot acquire a lock, rather than waiting for the current owner of the lock to release it. To modify this behavior, set this property to the number of seconds to wait for a lock. The default is 0 seconds. Any negative value means to wait forever.

The following are some additional, optional properties for various database types:

Sybase:

connectionProperties
CHARSET_CONVERTER_CLASS=com.sybase.jdbc2.utils.TruncationConverter

Setting the CHARSET_CONVERTER_CLASS can prevent exceptions such as this one when performing a dataSource.getConnection() call:
java.io.IOException: JZ0I6: An error occured converting UNICODE to the charset used by the server. Error message: java.io.CharConversionException: java.io.UnsupportedEncodingException: hp-roman8

Set additional connectionProperties by specifying them using the same pattern, separated by commas: PROPERTY_NAME =value;PROPERTY_NAME=value; ...

The following are some additional, optional properties for all database types:

Surge protector: (for more information, see 0.14.2: How the product manages connection pools

surgeThreshold
Setting this property to some positive integer less than the value of maxPoolSize sets a boundary in the connection pool. If a request is made to create a new connection while the total number of connections in the pool is below this boundary, no restrictions apply. However, if the total number of connections in the connection pool is at or above this boundary, the creation of a new connection is restricted by the surgeTime property.

The default value is – 1 (negative one), which means that the property is not in use.

surgeTime
Setting this property tells the connection pool how many seconds to wait before creating a new connection. Valid values for this property can be any positive integer. The default value is 20.
Database Name  Property name in the Java-based administrative console  Property name in the Web-based administrative console  Property name in the application client resource configuration tool
The name of the database used to store entity bean data

This is required for DB2, and sometimes required for Sybase, Merant, and Informix (depending on your database configuration), and ignored for Oracle.

Description  Property name in the Java-based administrative console  Property name in the Web-based administrative console  Property name in the application client resource configuration tool
A description of the data source, for your administrative records
Default Password  Property name in the Web-based administrative console or Password  Property name in the Java-based administrative console  Property name in the application client resource configuration tool
The password for connecting to the database when no user ID and password pair is specified by the application. If the default password is specified, the default user ID must also be specified.
Default User ID  Property name in the Web-based administrative console or User  Property name in the Java-based administrative console  Property name in the application client resource configuration tool
The user name for connecting to the database when no user ID and password pair is specified by the application. If the default user ID is specified, the default password must also be specified.
Disable Auto Connection Cleanup  Property name in the Java-based administrative console  Property name in the Web-based administrative console
Keeps the connection pooling software from automatically closing connections from this data source at the end of a transaction. This behavior is needed if you want to reuse the same connection across multiple transactions. When this is set, you must be sure to close the connection programmatically when you are through using it.
Idle timeout  Property name in the Java-based administrative console  Property name in the Web-based administrative console
The maximum time in seconds that an idle (unallocated) connection can remain in the pool before being removed to free resources.

This value must be a positive integer.

JDBC Provider  Property name in the Java-based administrative console
The JDBC driver (also known as data source provider) with which this data source is associated. It is used to connect to a relational database.
JNDI Name  Property name in the Java-based administrative console  Property name in the Web-based administrative console  Property name in the application client resource configuration tool
The JNDI name for the resource, including any naming subcontexts. This name is used as the linkage between the platform's binding information for resources defined in the client application's deployment descriptor and actual resources bound into JNDI by the platform.
Maximum Connection Pool Size  Property name in the Java-based administrative console or Maximum Pool Size  Property name in the Web-based administrative console
The maximum number of connections that can be in the pool. If the maximum number of connections is reached and all connections are in use, additional requests for a connection wait up to the number of seconds specified in the Connection timeout property.

This value must be a positive integer.

Maximum Pool Size  Property name in the Web-based administrative console
See Maximum Connection Pool Size
Minimum Connection Pool Size  Property name in the Java-based administrative console or Minimum Pool Size  Property name in the Web-based administrative console
The minimum number of connections in the pool.

This value must be a positive integer.

Minimum Pool Size  Property name in the Web-based administrative console
See Minimum Connection Pool Size
Name  Property name in the Java-based administrative console  Property name in the Web-based administrative console  Property name in the application client resource configuration tool
A name by which to administer the data source.

It is recommended that you enter a name that is suggestive of the database you will use to store entity bean data, such as WASDataSource, where WAS is the database name. The default value for this property is the value of the Name property prefixed with "jdbc/" (such as "jdbc/DataSourceName").

Orphan timeout  Property name in the Java-based administrative console  Property name in the Web-based administrative console
The maximum number of seconds that an application can hold a connection without using it before the connection can be returned to the pool.

This value must be a positive integer.

Note that the actual amount of time before a connection is closed is approximately twice the orphan timeout value.

Password  Property name in the Java-based administrative console  Property name in the application client resource configuration tool
See Default Password
Property Set  Property name in the Web-based administrative console
See the custom properties
Re-Enter Password  Property name in the application client resource configuration tool
See Confirm Password
Statement Cache  Property name in the Java-based administrative console or Statement Cache Size  Property name in the Web-based administrative console
The maximum number of prepared statements to cache for the data source. The limit is shared among all connections. The default value is 100.
User  Property name in the Java-based administrative console  Property name in the application client resource configuration tool
See Default User ID
Go to previous article: Properties of JDBC and data source providers Go to next article: Administering database connections with the Java console

 

 
Go to previous article: Properties of JDBC and data source providers Go to next article: Administering database connections with the Java console