Register / Login
File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
JDBC and Relational Databases
No of connection in Pool.
posted 5 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,
Did you see how Paul
cut 87% off of his electric heat bill with 82 watts of micro heaters
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?