Filter
Top Products
Parameter Description
Non-transactionalConnections Clickthe check box if youwant ApplicationServer to return all
non-transactional connections.
Transaction Isolation Makes it possible toselect the transaction isolation levelfor the connections
of this pool.If left unspecied, the connectionsoperate with default
isolation levels providedby the JDBC driver.
Guaranteed Isolation Level Only applicable ifthe isolation level has been specied.If you select the
Guaranteed checkbox,then all connections taken from thepool have the
same isolation level.For example, if theisolation level for the connection is
changed programmatically (withcon.setTransactionIsolation) when
last used, thismechanism changes the status back tothe specied isolation
level.
5. Change properties.
In the Additional Properties table, it is possible to specify properties, such as the database
name (URL), user name, and password. Because the properties vary with database vendor,
consult the vendor’s documentation for details.
Editing JDBC Connection Pool Advanced Attributes
To help diagnose connection leaks and improve ease-of–use, Application Server 9.1 provides
several new attributes to congure a connection pool at the time of its creation.
1. Open the Advanced tab and specify the following attributes.
Attribute Description
Name Nameof the JDBC connection pool whose
properties you wantto edit. You cannot change the
pool name, however.
Statement Timeout Time in secondsafter which abnormally long
running queries willbe terminated. Application
Server will set"QueryTimeout" on the statements
created. The defaultvalue of -1 implies that the
attribute is notenabled.
Wrap JDBC Objects When set totrue, application will get wrapped jdbc
objects for Statement,PreparedStatement,
CallableStatement, ResultSet, DatabaseMetaData.
The default valueis false.
2. Specify the Connection Settings as explained in the following table.
Workingwith JDBCConnectionPools
SunGlassFishEnterpriseServer2.1AdministrationGuide • December200850