I have an error like the following!
I want to know when this error occurs!
I think something works wrong and couses to closing
connection by time out!
I use jboss, hibernate, and a blob field in Oracle and
I want to insert this field by a picture. If the
picture was very small I dont have this error1
the error log:
org.jboss.resource.JBossResourceException:
SQLException; - nested throwable:
(java.sql.SQLException: Io exception: Connection reset
by peer: socket write error)
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(Base\
WrapperManagedConnection.java:546)
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapper\
ManagedConnection.java:252)
at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(Int\
ernalManagedConnectionPool.java:502)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at
oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:648)
at
oracle.jdbc.driver.OraclePreparedStatement.privateClose(OraclePreparedStatement.\
java:485)
at
oracle.jdbc.driver.OraclePreparedStatement.close(OraclePreparedStatement.java:39\
3)
at
oracle.jdbc.driver.OracleConnection.close_statements(OracleConnection.java:2333)
at
oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1412)
at
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.destroy(BaseWrapper\
ManagedConnection.java:248)
... 69 more
15:20:17,852 WARN [JDBCExceptionReporter] SQL Error:
17002, SQLState: null
15:20:17,852 ERROR [JDBCExceptionReporter] Io
exception: Connection reset by peer: socket write
error
15:20:17,868 ERROR [JDBCExceptionReporter] could not
insert: [hibernate.TestUser#901]
java.sql.SQLException: Io exception: Connection reset
by peer: socket write error
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2061)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:270\
9)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement\
.java:589)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPr\
eparedStatement.java:324)
at
net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:468)
at
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
at
net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
at
net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)
at
net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371)
at
net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
at
net.sf.hibernate.transaction.JTATransaction.commit(JTATransaction.java:52)
at
jdbc.TestUserDaoImpl.insert(TestUserDaoImpl.java:42)
at
struts.InsertTestUserAction.execute(InsertTestUserAction.java:31)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.\
java:484)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:193)
at
filter.EncodingFilter.doFilter(EncodingFilter.java:35)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:213)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2\
56)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1\
91)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:643)
at
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm\
.java:220)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)
at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)
at
org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsVal\
ve.java:76)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java\
:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociatio\
nValve.java:65)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174\
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnectio\
n(Http11Protocol.java:549)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:67\
7)
at java.lang.Thread.run(Thread.java:534)
15:20:17,930 ERROR [SessionImpl] Could not synchronize
database state with session
net.sf.hibernate.JDBCException: could not insert:
[hibernate.TestUser#901]
at
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:478)
at
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
at
net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
at
net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2418)
at
net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2371)
at
net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2240)
at
net.sf.hibernate.transaction.JTATransaction.commit(JTATransaction.java:52)
at
jdbc.TestUserDaoImpl.insert(TestUserDaoImpl.java:42)
at
struts.InsertTestUserAction.execute(InsertTestUserAction.java:31)
at
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.\
java:484)
at
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:247)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:193)
at
filter.EncodingFilter.doFilter(EncodingFilter.java:35)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilt\
erChain.java:213)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.\
java:193)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:2\
56)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:1\
91)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:643)
at
org.jboss.web.tomcat.security.JBossSecurityMgrRealm.invoke(JBossSecurityMgrRealm\
.java:220)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)
at
org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)
at
org.jboss.web.tomcat.tc4.statistics.ContainerStatsValve.invoke(ContainerStatsVal\
ve.java:76)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:643)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java\
:171)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)
at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociatio\
nValve.java:65)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:577)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:641)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174\
)
at
org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNex\
t(StandardPipeline.java:643)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
at
org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
at
org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:197)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnectio\
n(Http11Protocol.java:549)
at
org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:605)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:67\
7)
at java.lang.Thread.run(Thread.java:534)
Caused by: java.sql.SQLException: Io exception:
Connection reset by peer: socket write error
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at
oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2061)
at
oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:270\
9)
at
oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement\
.java:589)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPr\
eparedStatement.java:324)
at
net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
at
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:468)
... 56 more