Corporate Info  |  News  |  Solutions  |  Products  |  Partners  |  Services  |  Events  |  Download  |  How To Buy
	http://www.oracle.com/technology/documentation/index.html   |   Site Map   |   Search   |   PDF Files   |   Contact   |   Glossary
WebLogic Enterprise Doc Home   |   Tuxedo ATMI Topics   |   Previous Topic   |   Next Topic   |   Contents   |   Index

This class represents the configuration and run-time attributes of JDBC connection pools on a Java server. The attributes consist of statistics or values associated with each connection pool. Except for TA_STATE, attribute values are persistent in TUXCONFIG. Local attributes are local to the memory allocated to a Java server.

Table 0-30 T_JDBCCONNPOOL Class Definition Attribute Table

Attribute	Type	Permissions	Values	Default
TA_SRVID( r )( * )	string	ru-r--r--	1<=num<30,001	N/A
TA_SRVGRP( r )( * )	string	ru-r--r--	string[1...30]	N/A
TA_DSNAME( r )( * )	string	ru-r--r--	string[0...30]	N/A
TA_DRIVER	string	rw-r--r--	string[0...256]	N/A
TA_URL	string	rw-r--r--	string[2...256]	N/A
TA_STATE	string	rw-r--r--	GET:VALID SET:"{NEW|INVALID}"	N/A N/A
TA_DBNAME	string	rw-r--r--	string[0...30]	N/A
TA_DBUSER	string	rw-r--r--	string[0...30]	N/A
TA_DBPASSWORD	string	rw------	string[0...64]	N/A
TA_USERROLE	string	rw-r--r--	string[0...30]	N/A
TA_DBHOST	string	rw-r--r--	string[0...30]	N/A
TA_DBNETPROTOCOL	string	rw-r--r--	string[0...30]	N/A
TA_DBPORT	long	rw-r--r--	0<num<64K	N/A
TA_PROPS	string	rw-r--r--	string[0...256]	N/A
TA_ENABLEXA	string	rw-r--r--	{Y | N}	N
TA_CREATEONSTARTUP	string	rw-r--r--	{Y | N}	Y
TA_LOGINDELAY	long	rw-r--r--	0<=num	0
TA_INITCAPACITY	long	rw-r--r--	0<num	N/A
TA_MAXCAPACITY	long	rw-r--r--	0<num	N/A
TA_CAPACITYINCR	long	rw-r--r--	0<num	N/A
TA_ALLOWSHRINKING	string	rw-r--r--	{Y | N}	N
TA_SHRINKPERIOD	long	rw-r--r--	1<=num	15
TA_TESTTABLE	string	rw-r--r--	string[0...256]	N/A
TA_REFRESH	long	rw-r--r--	0<=num	5
TA_TESTONRESERVE	string	rw-r--r--	{Y | N}	N
TA_TESTONRELEASE	string	rw-r--r--	{Y | N}	N
TA_WAITFORCONN	string	rw-r--r--	{Y | N}	Y
TA_WAITTIMEOUT	long	rw-r--r--	0<=num	N/A
T_JDBCCONNPOOL Class:LOCAL Attributes
TA_CONNUSED	long	R--R--R--	0<=num	N/A
TA_CONNAVAILABLE	long	R--R--R--	0<=num	N/A
TA_HWMCONNUSE	long	R--R--R--	0<=num	N/A
TA_HWMCONNCREATED	long	R--R--R--	0<=num	N/A
TA_AWAITINGCONN	long	R--R--R--	0<=num	N/A
TA_HWMFORWAIT	long	R--R--R--	0<=num	N/A
( r ) - Required field for object creation (SET TA_STATE NEW) ( * ) - GET/SET key, one or more required for SET operations

Attribute Semantics

TA_SRVID 1<=num<30,001

Together with the server group name, this value is used to identify a Java server, specified in the SERVERS section of the UBBCONFIG, for which the connection pool is being described.

TA_SRVGRP string[1...30]

Name of a server group. This is used to identify a Java server, specified in the SERVERS section of the UBBCONFIG, for which the connection pool is being described.

TA_DSNAME string[0...30]

The data source name for the connection pool.

TA_DRIVER string[0...256]

The class name for the Java driver.

TA_URL string[0...256]

URL for a JDBC driver that is not JDBC 2.0-compliant.

TA_STATE

The INVALID state is used to delete entries from the configuration file on a SET request. VALID is always returned by a GET request.

TA_DBNAME string[0...30]

The database name.

TA_DBUSER string[0...30]

User's account name.

TA_DBPASSWORD string[0...64]

The user's password. The password entered by the user should not exceed 24 bytes.

TA_DBUSERROLE string[0...30]

The user's SQL role.

TA_DBHOST string[0...30]

Database server name.

TA_DBNETPROTOCOL string[0...30]

The protocol used to communicate with the database.

TA_DBPORT 0<num<64K

The port used for database connections.

TA_PROPS string[0...256]

Vendor-specific information for the JDBC driver.

TA_ENABLEXA Y or N

If set to Y, indicates that the pool supports XA mode.

TA_CREATEONSTARTUP Y or N

If set to Y, indicates that the connection pool is created when the server is started. If set to N, the pool is created when the first request arrives.

TA_LOGINDELAY

The login delay in seconds.

TA_INITCAPACITY 0<num

The number of connections initially supported in the connection pool. num should not exceed the value of TA_MAXCAPACITY.

TA_MAXCAPACITY 0<num

The maximum number of connections supported in the connection pool.

TA_CAPACITYINCR 0<num

The number of connections added to the pool when the current limit is exceeded but the maximum capacity has not yet been reached.

TA_ALLOWSHRINKING Y or N

If set to Y, allows connection pool shrinking.

TA_SHRINKPERIOD 1=<num

The interval after which shrinking occurs, in minutes.

TA_TESTTABLE string[0...256]

The name of a table in the database that is used to test the viability of connections in the connection pool. The query select count(*) from TESTTABLE is used to test a connection. The table must exist and be accessible to the database user for the connection.

TA_REFRESH 0<=num

The refresh interval, in minutes.

TA_TESTONRESERVE Y or N

If set to Y, the Java server tests a connection after removing it from the pool and before giving it to the client. The test adds a small delay in serving the client's request for a connection from the pool but ensures that the client receives a working connection. A value for TA_TESTTABLE must be set for this feature to work.

TA_TESTONRELEASE Y or N

If set to Y, the Java server tests a connection before returning it to the connection pool. If all the connections in the pool are already in use and a client is waiting for a connection, the client's wait will be slightly longer due to the test of the connection. A value for TA_TESTTABLE must be set for this feature to work.

TA_WAITFORCONN Y or N

If set to Y, enables an application to wait for a connection indefinitely if none is currently available. If set to N, a request for a connection returns to the caller immediately if there is no connection available. Y is assumed unless TA_WAITTIMEOUT is specified, in which case it becomes N.

TA_WAITTIMEOUT 0<num

Time in seconds that an application will wait for a connection to become available.