aspose file tools*
The moose likes JDBC and the fly likes  Closed Resultset: next Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark " Closed Resultset: next" Watch " Closed Resultset: next" New topic
Author

Closed Resultset: next

JBabu JayBabu
Greenhorn

Joined: Nov 10, 2003
Posts: 1
Hi,
I'm using Weblogic 7.0 SP4 with Oracle Driver Type 4 to access database. When I try to execute any preparement and iterate through my resultset, i get the following error message. I didn't have this problem when I use Weblogic 6.1 SP4 or Weblogic 8.1, I only get this when I try to use Weblogic 7.0. Does any one experienced any issues like this? what are the possible causes?
java.sql.SQLException: Closed Resultset: next
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1129)
at oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:
196)
at weblogic.jdbc.pool.ResultSet.next(ResultSet.java:205)
at com.qwest.abacus.general.dao.OracleNetworkComponentDAO.getOnNetCityLi
st(OracleNetworkComponentDAO.java:469)
at com.qwest.abacus.general.OnNetCache.loadCache(OnNetCache.java:33)
at com.qwest.abacus.common.AbacusWLProperties.startup(AbacusWLProperties
.java:220)
at weblogic.t3.srvr.StartupClassService.invokeStartup(StartupClassServic
e.java:158)
at weblogic.t3.srvr.StartupClassService.invokeClass(StartupClassService.
java:139)
at weblogic.t3.srvr.StartupClassService.access$0(StartupClassService.jav
a:130)
at weblogic.t3.srvr.StartupClassService$1.run(StartupClassService.java:1
02)
at weblogic.security.service.SecurityServiceManager.runAs(SecurityServic
eManager.java:685)
at weblogic.t3.srvr.StartupClassService.invokeStartupClass(StartupClassS
ervice.java:97)
at weblogic.t3.srvr.StartupClassService.resume(StartupClassService.java:
76)
at weblogic.t3.srvr.ServerLifeCycleList.resume(ServerLifeCycleList.java:
67)
at weblogic.t3.srvr.T3Srvr.resume(T3Srvr.java:832)
at weblogic.t3.srvr.T3Srvr.run(T3Srvr.java:300)
at weblogic.Server.main(Server.java:32)
Thanks,
-Babu
Joe Ess
Bartender

Joined: Oct 29, 2001
Posts: 8907
    
    8

Originally posted by JBabu JayBabu:
what are the possible causes?
java.sql.SQLException: Closed Resultset: next

Calling close() on a ResultSet (or Statement or Connection) before calling next() on it. How's about sharing some code so we can see what you are doing?


"blabbing like a narcissistic fool with a superiority complex" ~ N.A.
[How To Ask Questions On JavaRanch]
David O'Meara
Rancher

Joined: Mar 06, 2001
Posts: 13459

"JBabu JayBabu",
Your display name is not valid. Please check out the JavaRanch naming rules then edit your profile.
Your display name must be two words: your first name, a space, then your last name. Fictitious names are not allowed.
thanks,
Dave.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Closed Resultset: next