tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Mack <cm...@spcie.de>
Subject RE: JDBC problems
Date Thu, 20 Apr 2000 18:40:54 GMT
Hi Lavon

It isn't sufficient to close the Statement's.
Check if you explicitely call rset.close() for all unused ResultSet's.
Oracle reuses them, and block a Cursor on the DB side for each.

Tschau
Christian

> -----Original Message-----
> From: Lavon_Loftin@enron.net [mailto:Lavon_Loftin@enron.net]
> Sent: Wednesday, April 19, 2000 12:13 AM
> To: tomcat-user@jakarta.apache.org
> Subject: JDBC problems
> 
> 
> 
> 
> I'm running TomCat with Apache.
> My application uses JDBC to access an Oracle database.  After 
> successfully
> connecting and exchanging data with the database, JDBC began 
> failing without
> throwing exceptions.
> 
> Generally, any attempt to execute a query and return a 
> ResultSet results in an
> empty result set.
> 
>      ResultSet rset = stmt.executeQuery("SELECT * FROM AUTHORS");
> 
> The first attempt the access rset throws a SQLException with 
> error message
> "Exhausted ResultSet". I can take the same select statement 
> and successful run
> it using SQL+ or SQL Navigator. I have also extracted the 
> JDBC code to a JAVA
> application and successfully run it.
> 
> Any ideas or suggestions?
> 
> Thanks
> 
> 
> R. Lavon Loftin <lavon_loftin@enron.net>
> Enron Broadband Services
> O: (503) 886-0587
> C: (503) 781-5675
> 
> 
> 
> --------------------------------------------------------------
> ------------
> To unsubscribe, email: tomcat-user-unsubscribe@jakarta.apache.org
> For additional commmands, email: tomcat-user-help@jakarta.apache.org
> 

Mime
View raw message