wood burning stoves 2.0*
The moose likes JDBC and the fly likes ORA-01000 error using WEBLOGIC server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ORA-01000 error using WEBLOGIC server" Watch "ORA-01000 error using WEBLOGIC server" New topic
Author

ORA-01000 error using WEBLOGIC server

Saurabh Dutt
Greenhorn

Joined: Sep 07, 2003
Posts: 5
I am obtaining ORA-01000 error in weblogic server, all the resultsets are properly closed in the finally block, can time factor cause this if the nested while loop queries in prepared statement are taking much time to execute can this be a possible reson , if yes how to get rid of it?
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30057
    
149

Saurabh,
Are you closing the statement too?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Saurabh Dutt
Greenhorn

Joined: Sep 07, 2003
Posts: 5
yes all the prepared statements are closed
 
 
subject: ORA-01000 error using WEBLOGIC server
 
Similar Threads
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
Statement and PreparedStatemnet---ORA-01000
ORA-01000: maximum open cursors exceeded
Error message : ORA-01000: Maximum number of open cursors reached ??
ORA-01000: maximum open cursors exceeded