Register / Login
Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
JDBC and Relational Databases
No of connection in Pool.
posted 6 years ago
I congifured for connection pooling in
and i am able to get the connections successfully and performing all the operation.
<Resource name="jdbc/oracleconn" auth="Container" type="oracle.jdbc.pool.OracleDataSource" driverClassName="oracle.jdbc.driver.OracleDriver" factory="oracle.jdbc.pool.OracleDataSourceFactory" url="jdbc:oracle:thin:@172.18.1.17:1521:XYZ" user="testing" password="testing" minIdle="10" maxActive="20" maxIdle="10" removeAbandoned="true" removeAbandonedTimeout="60" logAbandoned="true" maxWait="-1"/>
But, i am not seeing any connection detail,(i.e) session created in DB for pooled connection using toad.
Toad, always show only one connection that too TOAD's connection for my name.
Is there a way to check, no of connection in connection pool, which is created in tomcat.
If Yes, please reply.
Thanks In Advance,
Maintaining scalability in servlets programming
Help on Topic in JMS
How to get SID of Connection From Java.
Connection Pool Question
Is javax.sql.DataSource a costlier resource like java.sql.Connection?