Hi everyone,

the userapp 3.7 runs fine but every now and then the portal stops. I
think it looses the connection with the database. Is that what happens
here, and shouldn't the userapp automatically re-connect?

thanks
Casper

(w2k3sp2, idm 3.6.1, userapp 3.7, MS SQL 2005, sqljdbc.jar
1.0.809.102)

The error in the server.log is:
2010-05-02 10:22:47,444 WARN
[org.hibernate.util.JDBCExceptionReporter] (Thread-39) SQL Error: 0,
SQLState: 08S01
2010-05-02 10:22:47,444 ERROR
[org.hibernate.util.JDBCExceptionReporter] (Thread-39) An exception
occurred during the DBComms.transmit operation. Exception:Connection
reset by peer: socket write error. Context37)
[Thread[Thread-39,5,jboss], IO:0cece, Dbc:93bac].
2010-05-02 10:22:47,460 ERROR
[org.hibernate.transaction.JDBCTransaction] (Thread-39) JDBC rollback
failed
com.microsoft.sqlserver.jdbc.SQLServerException: The connection is
closed.
at
com.microsoft.sqlserver.jdbc.SQLServerException.ma keFromDriverError(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.c heckClosed(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.s etAutoCommit(Unknown
Source)
at
org.jboss.resource.adapter.jdbc.BaseWrapperManaged Connection.checkTransaction(BaseWrapperManagedConn ection.java:545)
at
org.jboss.resource.adapter.jdbc.WrappedConnection. checkTransaction(WrappedConnection.java:826)
at
org.jboss.resource.adapter.jdbc.WrappedConnection. rollback(WrappedConnection.java:499)
at
org.hibernate.transaction.JDBCTransaction.rollback AndResetAutoCommit(JDBCTransaction.java:217)
at
org.hibernate.transaction.JDBCTransaction.rollback (JDBCTransaction.java:196)
at
com.novell.soa.persist.HibernateUtil.rollback(Hibe rnateUtil.java:169)
at
com.novell.soa.persist.HibernateDAO.rollback(Hiber nateDAO.java:376)
at
com.novell.soa.af.impl.persist.EngineStateDAO.time outEngines(EngineStateDAO.java:348)
at
com.novell.soa.af.impl.core.EngineImpl$HeartbeatMo nitor.run(EngineImpl.java:1336)
at java.lang.Thread.run(Thread.java:619)
2010-05-02 10:22:47,460 ERROR [com.novell.soa.persist.HibernateUtil]
(Thread-39) Error rolling back transaction
org.hibernate.TransactionException: JDBC rollback failed
at
org.hibernate.transaction.JDBCTransaction.rollback (JDBCTransaction.java:204)
at
com.novell.soa.persist.HibernateUtil.rollback(Hibe rnateUtil.java:169)
at
com.novell.soa.persist.HibernateDAO.rollback(Hiber nateDAO.java:376)
at
com.novell.soa.af.impl.persist.EngineStateDAO.time outEngines(EngineStateDAO.java:348)
at
com.novell.soa.af.impl.core.EngineImpl$HeartbeatMo nitor.run(EngineImpl.java:1336)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The
connection is closed.
at
com.microsoft.sqlserver.jdbc.SQLServerException.ma keFromDriverError(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.c heckClosed(Unknown
Source)
at
com.microsoft.sqlserver.jdbc.SQLServerConnection.s etAutoCommit(Unknown
Source)
at
org.jboss.resource.adapter.jdbc.BaseWrapperManaged Connection.checkTransaction(BaseWrapperManagedConn ection.java:545)
at
org.jboss.resource.adapter.jdbc.WrappedConnection. checkTransaction(WrappedConnection.java:826)
at
org.jboss.resource.adapter.jdbc.WrappedConnection. rollback(WrappedConnection.java:499)
at
org.hibernate.transaction.JDBCTransaction.rollback AndResetAutoCommit(JDBCTransaction.java:217)
at
org.hibernate.transaction.JDBCTransaction.rollback (JDBCTransaction.java:196)
... 5 more


--
idmforumuser
------------------------------------------------------------------------
idmforumuser's Profile: http://forums.novell.com/member.php?userid=13895
View this thread: http://forums.novell.com/showthread.php?t=409363