A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
No of connection in Pool.
Joined: Jun 19, 2008
May 12, 2010 05:28:03
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,
I agree. Here's the link:
subject: No of connection in Pool.
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?
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015