Closed Resultset: next

[JBabu JayBabu]

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]

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?

[David O'Meara]

"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.