Hi all,
I use Hibernate 3.0.5 for manipulation of Informix 7.0.3 with enough success, but since few hours I have strange Exception:
2006-01-17 15:25:07,188[WARN ][Thread-9](JDBCExceptionReporter.java:71) - SQL Error: -79730, SQLState: IX000
2006-01-17 15:25:07,188[ERROR][Thread-9](JDBCExceptionReporter.java:72) - Connection not established
2006-01-17 15:25:07,188[WARN ][Thread-9](JDBCExceptionReporter.java:71) - SQL Error: -79730, SQLState: IX000
2006-01-17 15:25:07,188[ERROR][Thread-9](JDBCExceptionReporter.java:72) - Connection not established
2006-01-17 15:25:07,208[ERROR][Thread-9](AbstractFlushingEventListener.java:277) - Could not synchronize database state wi
th session
org.hibernate.exception.GenericJDBCException: could not insert: [bg.latona.bca.hibernate.wp.CLIENTS_MESSAGES]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:324)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at bg.latona.nca.dti.wp.WpBgM28.processMsgBGM28(WpBgM28.java:74)
at bg.latona.nca.dti.wp.WebPortal.onMessage(WebPortal.java:661)
at com.swiftmq.jms.MessageConsumerImpl.invokeMessageListener(MessageConsumerImpl.java:220)
at com.swiftmq.jms.SessionImpl.doDeliverMessage(SessionImpl.java:619)
at com.swiftmq.jms.SessionImpl.processObject(SessionImpl.java:660)
at com.swiftmq.tools.queue.SimpleQueue.run(SimpleQueue.java:138)
Caused by: java.sql.SQLException: Connection not established
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
at com.informix.jdbc.IfxSqliConnect.h(IfxSqliConnect.java:5877)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1991)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:396)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:76)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:69)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:150)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1839)
... 16 more
org.hibernate.exception.GenericJDBCException: could not insert: [bg.latona.bca.hibernate.wp.CLIENTS_MESSAGES]
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:82)
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:70)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1869)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:2200)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:46)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:239)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:223)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:136)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:274)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:730)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:324)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:86)
at bg.latona.nca.dti.wp.WpBgM28.processMsgBGM28(WpBgM28.java:74)
at bg.latona.nca.dti.wp.WebPortal.onMessage(WebPortal.java:661)
at com.swiftmq.jms.MessageConsumerImpl.invokeMessageListener(MessageConsumerImpl.java:220)
at com.swiftmq.jms.SessionImpl.doDeliverMessage(SessionImpl.java:619)
at com.swiftmq.jms.SessionImpl.processObject(SessionImpl.java:660)
at com.swiftmq.tools.queue.SimpleQueue.run(SimpleQueue.java:138)
Caused by: java.sql.SQLException: Connection not established
at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:373)
at com.informix.jdbc.IfxSqliConnect.h(IfxSqliConnect.java:5877)
at com.informix.jdbc.IfxSqliConnect.prepareStatement(IfxSqliConnect.java:1991)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:396)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:76)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:69)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:150)
at org.hibernate.persister.entity.BasicEntityPersister.insert(BasicEntityPersister.java:1839)
... 16 more
2006-01-17 15:25:07,218[ERROR][Thread-9]( WpBgM28.java:91) - could not insert: [bg.latona.bca.hibernate.wp.CLIENTS_MESSAGE
S]
I know there is a problem when one Session operate and I update/delite the record with are load in The session cach...I keep this situation on left and I check the connection with the DB is fine. Do you know a reason, witch explain this kind error message and respectly the Exception? Thanck you!
|