General Settings
Pool Name: testPool
Resource Type: javax.sql.DataSource javax.sql.XADataSource javax.sql.ConnectionPoolDataSource java.sql.Driver
Must be specified if the datasource class implements more than 1 of the interface.
Datasource Classname:
Vendor-specific classname that implements the DataSource and/or XADataSource APIs
Driver Classname:
Vendor-specific classname that implements the java.sql.Driver interface.
Ping: Enabled
User sa
DatabaseName Customer
ApplicationName Microsoft SQL Server JDBC Driver
LockTimeout -1
Password 123456
SendTimeAsDatetime true
SelectMethod direct
PacketSize 8000
SendStringParametersAsUnicode true
ServerName 200.200.200.39
LastUpdateCount
XopenStates false
WorkstationID sun
TrustServerCertificate false
Encrypt false
PortNumber 1433
URL jdbc:sqlserver://
LoginTimeout 15
ResponseBuffering adaptive
When enabled, the pool is pinged during creation or reconfiguration to identify and warn of any erroneous values for its attributes
Description:
Pool Settings
Initial and Minimum Pool Size: Connections
Minimum and initial number of connections maintained in the pool
Maximum Pool Size: Connections
Maximum number of connections that can be created to satisfy client requests
Pool Resize Quantity: Connections
Number of connections to be removed when pool idle timeout expires
Idle Timeout: Seconds
Maximum time that connection can remain idle in the pool
Max Wait Time: Milliseconds
Amount of time caller waits before connection timeout is sent
Transaction
Non Transactional Connections: Enabled
Returns non-transactional connections
Transaction Isolation: read-uncommitted read-committed repeatable-read serializable
If unspecified, use default level for JDBC Driver
Isolation Level: Guaranteed
All connections use same isolation level; requires Transaction Isolation
[Message sent by forum member 'cbreshma']
http://forums.java.net/jive/thread.jspa?messageID=486219