hi,

occasionaly a thread gets stuck on transaction commit. the stacktrace is
attached below. the reason seems to be a transaction deadlock. is there anyway
to prevent a complete hang of the application server by setting a transaction
timeout or something?

we are using firebird 2.1 / jaybird 2.1.6 in a glassfish appserver.

thx for reading

lutz

java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.read(SocketInputStream.java:129)

org.firebirdsql.gds.impl.wire.XdrInputStream.read(XdrInputStream.java:253)

org.firebirdsql.gds.impl.wire.XdrInputStream.readInt(XdrInputStream.java:187)

org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.nextOperation(AbstractJavaGDSImpl.java:2144)

org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlExecute2(AbstractJavaGDSImpl.java:1173)

org.firebirdsql.gds.impl.GDSHelper.executeStatement(GDSHelper.java:226)

org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractPreparedStatement.java:726)

org.firebirdsql.jdbc.AbstractPreparedStatement.executeUpdate(AbstractPreparedStatement.java:190)
sun.reflect.GeneratedMethodAccessor380.invoke(Unknown Source)

sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)

org.firebirdsql.pool.PooledPreparedStatementHandler.invoke(PooledPreparedStatementHandler.java:166)
org.firebirdsql.pool.$Proxy36.executeUpdate(Unknown Source)

org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)

org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)

org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)

org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)

org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)

org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)

org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50)
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027)

org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:365)

org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:137)