Dear David ,
Please noted that each connection may have a time
out period. If all of your statement use the same
connection object, it maybe timeout at some time.
Hope it can help ~
M.T.
--- David DELGRANCHE <[EMAIL PROTECTED]> wrote:
> Hi
>
> I have a question perhaps more on JDBC than on
> tomcat but perhaps someone
> could help me.
> I call a servlet using Tomcat 3.2.2. My servlet is
> doing an Oracle
> Database access using JDBC. I have to iterate many
> time in it. It seems
> that after several iteration my servlet is bugging.
> I have an exception
> telling me:
> java.sql.SQLException: Must be logged on to server
>
> In each iteration, I use the same
> PreparedStatement. I create a ResultSet
> for each iteration and kill it after.
>
> I don't know how to interprete this message and how
> to fix the bug!
>
> Can someone help me?
>
> Thanks
>
> David DELGRANCHE
> [EMAIL PROTECTED]
> Tel: 02.99.05.34.25
> Fax: 02.99.05.34.05
> Sogitec Industries
> 24, avenue Lavoisier
> ZI du Champ Niguel
> 35174 BRUZ CEDEX
>
>
__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com
