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
Key: Applies
to Java administrative console of Advanced Edition Version 4.0
Applies
to Web administrative console of Advanced Single Server Edition Version 4.0
Applies
to Application Client Resource Configuration Tool
- Category
- An optional category string that can be used to classify or group the
resource
- Confirm Password
or Re-Enter Password
- Confirm the password that you entered in the preceding field
- Connection timeout
- 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
or Property Set
- 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
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
A description of the data source, for your administrative
records Default Password or Password
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
or User
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
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
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
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
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
or Maximum Pool Size
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
See Maximum Connection Pool Size Minimum
Connection Pool Size
or Minimum Pool Size
The minimum number of connections in the pool.
This value must be a positive integer. Minimum Pool
Size
See Minimum Connection Pool Size Name
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
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
See Default Password Property Set
See the custom properties
Re-Enter Password
See Confirm Password Statement Cache or
Statement Cache Size
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
See Default User ID
|
|