Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » Tomcat Users »

Long running JDBC session

Carlos-Roberto Queiroz

2004-05-04

Replies:





   Hello, I have a servlet that connects to an Oracle database (9i)
using classes12.jar JDBC file. In it, there´s a loop that executes a quick
query 3000 times, and that´s running for long 10 minutes !! Is there any
way I can optimize this connection (JDBC parameters maybe) for such case ?


Thanks


---------------------------------------------------------------------
To unsubscribe, e-mail: tomcat-user-unsubscribe@(protected)
For additional commands, e-mail: tomcat-user-help@(protected)

©2008 junlu.com - Jax Systems, LLC, U.S.A.