Parameter Description
Non-transactionalConnections Clickthe check box if you want Application Server to return all
non-transactionalconnections.
TransactionIsolation Makesit possible to select the transaction isolation level for the connections
ofthis pool. If left unspecied, the connections operate with default
isolationlevels provided by the JDBC driver.
GuaranteedIsolation Level Onlyapplicable if the isolation level has been specied. If you select the
Guaranteedcheckbox, then all connections taken from the pool have the
sameisolation level. For example, if the isolation level for the connection is
changedprogrammatically (with con.setTransactionIsolation) when
lastused, this mechanism changes the status back to the specied isolation
level.
5. Changeproperties.
Inthe 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,
consultthe vendor’s documentation for details.
Editing JDBC Connection PoolAdvanced Attributes
Tohelp diagnose connection leaks and improve ease-of–use, Application Server 9.1 provides
severalnew attributes to congure a connection pool at the time of its creation.
1. Openthe Advanced tab and specify the following attributes.
Attribute Description
Name Nameof the JDBC connection pool whose
propertiesyou want to edit. You cannot change the
poolname, however.
StatementTimeout Timein seconds after which abnormally long
runningqueries will be terminated. Application
Serverwill set "QueryTimeout"on the statements
created.The default value of -1 implies that the
attributeis not enabled.
WrapJDBC Objects Whenset to true, application will get wrapped jdbc
objectsfor Statement, PreparedStatement,
CallableStatement,ResultSet, DatabaseMetaData.
Thedefault value is false.
2. Specifythe Connection Settings as explained in the following table.
WorkingwithJDBC Connection Pools
SunGlassFishEnterprise Ser ver2.1 Administration Guide • December 200850