File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
Win a copy of
OCA Java SE 8 Programmer I Study Guide 1Z0-808
this week in the
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,
It is sorta covered in the
JavaRanch Style Guide
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