Sorry, I sent the message to the wrong group. :P
Nathan Maves
<[EMAIL PROTECTED] To: Tomcat Users List <[EMAIL
PROTECTED]>
.COM> cc:
Subject: Re: Long running JDBC session
04/05/2004 05:33
PM
Please respond to
"Tomcat Users
List"
This is really not a Tomcat question.
Are you using connection pooling? If so which one? How many
connections?
Why are you not using the latest jar from oracle? You should download
the 9i driver.
What is your code for how you obtain connection and how you create
statements. Are you using PreparedStatements?
Nathan
On May 4, 2004, at 2:31 PM, Carlos-Roberto Queiroz wrote:
>
>
>
>
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
