Database Reference
In-Depth Information
userenv session_user : OSUSER
userenv os_user : OSUSER
userenv ip_address : 127.0.0.1
userenv terminal : unknown
userenv client_id : OSUSER
Read HR view!!!!!!!!!!!!!!!!!!!!
Review All the Pool Properties
We can also retrieve and review all the connection pool properties:
prop = cpool.getConnectionCacheProperties();
MaxStatementsLimit, 0
AbandonedConnectionTimeout, 0
MinLimit, 2
TimeToLiveTimeout, 0
LowerThresholdLimit, 20
InitialLimit, 3
ValidateConnection, false
ConnectionWaitTimeout, 0
PropertyCheckInterval, 900
InactivityTimeout, 0
LocalTransactionCommitOnClose, false
MaxLimit, 10
ClosestConnectionMatch, false
AttributeWeights, NULL
COMPILING, DEPRECATED METHODS AND ANNOTATIONS
When you compile OraSSOTests.java you will receive two warnings. Two of the methods we are calling
here are deprecated; that is, they are no longer promoted as current programming practices. You can see
what methods those are by providing an argument on the command line, like this:
javac -Xlint:deprecation OraSSOTests.java
OraSSOTests.java:265: warning: [deprecation] setConnectionCachingEnabled(boolean
) in oracle.jdbc.pool.OracleDataSource has been deprecated
cpool.setConnectionCachingEnabled(true);
^
OraSSOTests.java:274: warning: [deprecation] setConnectionCacheProperties(java.u
til.Properties) in oracle.jdbc.pool.OracleDataSource has been deprecated
cpool.setConnectionCacheProperties(prop);
^
2 warnings
