Skip to Main Content

Java EE (Java Enterprise Edition) General Discussion

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

resultset is closing

843840Jun 30 2008 — edited Jun 30 2008
Hi all

i am getting following error when i using sevlet please give me the reason for these error thanks in advance

/mstemployee.dqlMessage: Operation not allowed after ResultSet closed Cause: null Error Message: Operation not allowed after ResultSet closed Cause: null Error code: 0 Error state: S1000 java.sql.SQLException: Operation not allowed after ResultSet closed Message: Communication link failure: java.net.SocketException, underlying cause: socket closed ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: socket closed STACKTRACE: java.net.SocketException: socket closed at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(Unknown Source) at java.io.BufferedInputStream.fill(Unknown Source) at java.io.BufferedInputStream.read1(Unknown Source) at java.io.BufferedInputStream.read(Unknown Source) at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1385) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1532) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1923) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1218) at com.mysql.jdbc.Connection.execSQL(Connection.java:2233) at com.mysql.jdbc.Connection.execSQL(Connection.java:2181) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1158) at com.mysql.jdbc.DatabaseMetaData.getPrimaryKeys(DatabaseMetaData.java:2604) at com.mysql.jdbc.UpdatableResultSet.checkUpdatability(UpdatableResultSet.java:2113) at com.mysql.jdbc.UpdatableResultSet.(UpdatableResultSet.java:105) at com.mysql.jdbc.MysqlIO.buildResultSetWithRows(MysqlIO.java:1454) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:333) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1319) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1218) at com.mysql.jdbc.Connection.execSQL(Connection.java:2233) at com.mysql.jdbc.Connection.execSQL(Connection.java:2181) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1158) at com.base.eterna.requesthandlers.MstEmployeeRequestHandler.processRequest(MstEmployeeRequestHandler.java:172) at com.base.eterna.controllers.RequestController.doPost(RequestController.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:212) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445) at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION ** Cause: null Error Message: Communication link failure: java.net.SocketException, underlying cause: socket closed ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: socket closed STACKTRACE: java.net.SocketException: socket closed at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(Unknown Source) at java.io.BufferedInputStream.fill(Unknown Source) at java.io.BufferedInputStream.read1(Unknown Source) at java.io.BufferedInputStream.read(Unknown Source) at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1385) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1532) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1923) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1218) at com.mysql.jdbc.Connection.execSQL(Connection.java:2233) at com.mysql.jdbc.Connection.execSQL(Connection.java:2181) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1158) at com.mysql.jdbc.DatabaseMetaData.getPrimaryKeys(DatabaseMetaData.java:2604) at com.mysql.jdbc.UpdatableResultSet.checkUpdatability(UpdatableResultSet.java:2113) at com.mysql.jdbc.UpdatableResultSet.(UpdatableResultSet.java:105) at com.mysql.jdbc.MysqlIO.buildResultSetWithRows(MysqlIO.java:1454) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:333) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1319) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1218) at com.mysql.jdbc.Connection.execSQL(Connection.java:2233) at com.mysql.jdbc.Connection.execSQL(Connection.java:2181) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1158) at com.base.eterna.requesthandlers.MstEmployeeRequestHandler.processRequest(MstEmployeeRequestHandler.java:172) at com.base.eterna.controllers.RequestController.doPost(RequestController.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:212) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445) at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION ** Cause: null Error code: 0 Error state: 08S01 java.sql.SQLException: Communication link failure: java.net.SocketException, underlying cause: socket closed ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: socket closed STACKTRACE: java.net.SocketException: socket closed at java.net.SocketInputStream.socketRead0(Native Method) at java.net.SocketInputStream.read(Unknown Source) at java.io.BufferedInputStream.fill(Unknown Source) at java.io.BufferedInputStream.read1(Unknown Source) at java.io.BufferedInputStream.read(Unknown Source) at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:1385) at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:1532) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:1923) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1163) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1272) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1218) at com.mysql.jdbc.Connection.execSQL(Connection.java:2233) at com.mysql.jdbc.Connection.execSQL(Connection.java:2181) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1158) at com.mysql.jdbc.DatabaseMetaData.getPrimaryKeys(DatabaseMetaData.java:2604) at com.mysql.jdbc.UpdatableResultSet.checkUpdatability(UpdatableResultSet.java:2113) at com.mysql.jdbc.UpdatableResultSet.(UpdatableResultSet.java:105) at com.mysql.jdbc.MysqlIO.buildResultSetWithRows(MysqlIO.java:1454) at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:333) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1319) at com.mysql.jdbc.MysqlIO.sqlQuery(MysqlIO.java:1218) at com.mysql.jdbc.Connection.execSQL(Connection.java:2233) at com.mysql.jdbc.Connection.execSQL(Connection.java:2181) at com.mysql.jdbc.Statement.executeQuery(Statement.java:1158) at com.base.eterna.requesthandlers.MstEmployeeRequestHandler.processRequest(MstEmployeeRequestHandler.java:172) at com.base.eterna.controllers.RequestController.doPost(RequestController.java:70) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:212) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445) at java.lang.Thread.run(Unknown Source) ** END NESTED EXCEPTION **
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 28 2008
Added on Jun 30 2008
3 comments
221 views