Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Querys are nor exceuting after 14 hours in localhost

 
sudhakar Tadepalli
Ranch Hand
Posts: 130
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am using WSAD5.1.1 + Struts+Hibernate + Spring. I am runing web application in localhost, I left the server runing for 14 hours and when I run the application again , web app working fine but no data displaying on the pages, if i check the console, I can see bunch of log messages.

Is this problem with my local host or Hibernate?. Will it happen in the production too ?. If I restart my local host server evertying is fine. Trying to know what is really happening.

[8/17/05 8:44:07:211 CDT] 3a5460de StaleConnecti A CONM7007I: Mapping the following SQLException, with ErrorCode 17,410 and SQLState <null>, to a StaleConnectionException: java.sql.SQLException: No more data to read from socket
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:1160)
at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:963)
at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893)


[8/17/05 8:44:07:258 CDT] 3a5460de ConnectionEve A J2CA0056I: The Connection Manager received a fatal connection error from the Resource Adaptor for resource jdbc/life. The exception which was received is com.ibm.websphere.ce.cm.StaleConnectionException: No more data to read from socket
[8/17/05 8:44:07:320 CDT] 3a5460de JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: 17410, SQLState: null
[8/17/05 8:44:07:320 CDT] 3a5460de JDBCException E net.sf.hibernate.util.JDBCExceptionReporter No more data to read from socket
[8/17/05 8:44:07:320 CDT] 3a5460de JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: 17410, SQLState: null
[8/17/05 8:44:07:367 CDT] 3a5460de JDBCException E net.sf.hibernate.util.JDBCExceptionReporter No more data to read from socket
[8/17/05 8:44:07:398 CDT] 3a5460de BatcherImpl W net.sf.hibernate.impl.BatcherImpl exception clearing maxRows/queryTimeout
[8/17/05 8:44:07:398 CDT] 3a5460de BatcherImpl W net.sf.hibernate.impl.BatcherImpl TRAS0014I: The following exception was logged com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java:952)




com.ibm.websphere.ce.cm.ObjectClosedException: DSRA9110E: Statement is closed.
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.runtimeXIfNotClosed(WSJdbcStatement.java:952)
at com.ibm.ws.rsadapter.jdbc.WSJdbcStatement.getMaxRows(WSJdbcStatement.java:608)
at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:143)
at net.sf.hibernate.impl.BatcherImpl.closeQueryStatement(BatcherImpl.java:103)
at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:809)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java:189)
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:133)




[8/17/05 8:44:07:461 CDT] 3a5460de JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: 17410, SQLState: null
[8/17/05 8:44:07:508 CDT] 3a5460de JDBCException E net.sf.hibernate.util.JDBCExceptionReporter No more data to read from socket
[8/17/05 8:44:07:523 CDT] 3a5460de JDBCException W net.sf.hibernate.util.JDBCExceptionReporter SQL Error: 17410, SQLState: null
[8/17/05 8:44:07:523 CDT] 3a5460de JDBCException E net.sf.hibernate.util.JDBCExceptionReporter No more data to read from socket
[8/17/05 8:44:07:523 CDT] 3a5460de JDBCException E net.sf.hibernate.util.JDBCExceptionReporter Could not execute query
[8/17/05 8:44:07:570 CDT] 3a5460de JDBCException E net.sf.hibernate.util.JDBCExceptionReporter TRAS0014I: The following exception was logged com.ibm.websphere.ce.cm.StaleConnectionException: No more data to read from socket
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java(Compiled Code))



---- Begin backtrace for Nested Throwables
java.sql.SQLException: No more data to read from socket
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)


com.ibm.websphere.ce.cm.StaleConnectionException: No more data to read from socket
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java(Compiled Code))
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java(Compiled Code))
at java.lang.reflect.Constructor.newInstance(Constructor.java(Compiled Code))


[8/17/05 8:44:07:602 CDT] 3a5460de SystemErr R net.sf.hibernate.JDBCException: Could not execute query
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1546)
at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
at com.amfam.lifewkfl.dao.hibernateDao.DataDAOHibernate.searchData(DataDAOHibernate.java:50)
at com.amfam.lifewkfl.serviceImpl.DataManagerImpl.searchData(DataManagerImpl.java:41)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java(Compiled Code))



8/17/05 8:44:08:586 CDT] 309920dc SessionImpl W net.sf.hibernate.impl.SessionImpl finalizing unclosed session with closed connection

Thanks
Sudhakar
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic