Use a monitoring tool on your RDBMS. For SQL Server I use "Profiler".
- Andrew > -----Original Message----- > From: Pop Marius [mailto:[EMAIL PROTECTED]] > Sent: Thursday, July 25, 2002 5:00 AM > To: tomcat > Subject: connection pooling > > > > Hi everybody ! > > I'm using Tomcat 4 and my application works. To get a > connection to database I have the following code: > > Context initCtx = new InitialContext(); > Context envCtx = (Context) initCtx.lookup("java:comp/env"); > > DataSource ds = (DataSource)envCtx.lookup("jdbc/orgDB"); > return ds.getConnection(); > > and of course in the server.xml the necessary resource > requirements ! The application works fine, but How could I > ensure myself that the connections provided are reused, that > the pooling machine works, and I really have a pooling mechanism. > > How can I test it ! The documentation sais that > ds.getConnection() gets a connection from the pool (which > pool, how) but I'm not sure that ! > > Any idea would be helpful ! > > > > > Pop Marius Lucian > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
