You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by David DELGRANCHE <dd...@sogitec.fr> on 2001/08/31 12:03:08 UTC

SQL Error

		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	
ddelgranche@sogitec.fr
Tel: 02.99.05.34.25
Fax: 02.99.05.34.05
Sogitec Industries	
24, avenue Lavoisier
ZI du Champ Niguel
35174 BRUZ CEDEX

Re: SQL Error

Posted by MindTerm <mi...@yahoo.com>.
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 <dd...@sogitec.fr> 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	
> ddelgranche@sogitec.fr
> 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