Hi Experts,

I am facing a strange problem with my Hibernate application deployed on WAS 6.0.2.17 ND. The transaction hangs after 6-7 days on one(any) of the nodes on the cluster.

Please help. Kindly let me know if more information is required.

[u]Hibernate Version = 2.1.8[/u]

[u]Resource Configuration[/u]

Type=javax.sql.DataSource
ResAuth=CONTAINER
ResSharingScope=SHAREABLE
IsolationLevel=TRANSACTION_READ_UNCOMMITTED

[u]Some config information[/u]

<property name="hibernate.cache.provider_class">net.sf.hibernate.cache.EhCacheProvider</property>

<property name="transaction.factory_class">net.sf.hibernate.transaction.JTATransactionFactory</property>

<property name="hibernate.transaction.manager_lookup_class">net.sf.hibernate.transaction.WebSphereTransactionManagerLookup</property>

<property name = "hibernate.cache.use_query_cache">true</property>


[u]Trace Log from WAS[/u]

PoolManager name:jdbc/DS_CSS
2647 PoolManager object:31287349
2648 Total number of connections: 2 (max/min 25/1, reap/unused/aged 180/1800/0, connectiontimeout/purge 180/EntirePool)
2649 (testConnection/inteval false/0, stuck timer/time/threshold 0/0/0, surge time/connections 0/-1)
2650 Shared Connection information (shared partitions 200)
2651 com.ibm.ws.Transaction.JTA.TransactionImpl@13e02ac#tid=3699 MCWrapper id 441dab Managed connection WSRdbManagedConnectionImpl@75a7cf State:STATE_TRAN_WRAPPER_INUSE Thread Id: 122925 Thread Name: PAYMCreateUpdateCustomerAccount - 60ebf310cc270d95:2611a6:111ffb6fd0f:-718b Handle count 1 Start time inuse Mon Apr 23 12:14:19 BST 2007 Time inuse 23 (seconds)
2652 com.ibm.ws.Transaction.JTA.TransactionImpl@12010cf#tid=3698 MCWrapper id f2961a Managed connection WSRdbManagedConnectionImpl@12a5b4c State:STATE_TRAN_WRAPPER_INUSE Thread Id: 1520385 Thread Name: PAYMCreateUpdateCustomerAccount - 60ebf310cc270d95:2611a6:111ffb6fd0f:-718c Handle count 0 Start time inuse Mon Apr 23 12:13:11 BST 2007 Time inuse 90 (seconds)
2653 Total number of connection in shared pool: 2
2654 Free Connection information (free distribution table/partitions 12/1)
2655
2656 No free connections
2657
2658 UnShared Connection information
2659 No unshared connections
2660
2661 Connection Leak Logic Information:
2662 MCWrapper id 441dab Managed connection WSRdbManagedConnectionImpl@75a7cf State:STATE_TRAN_WRAPPER_INUSE Thread Id: 122925 Thread Name: PAYMCreateUpdateCustomerAccount - 60ebf310cc270d95:2611a6:111ffb6fd0f:-718b Handle count 1
2663 Start time inuse Mon Apr 23 12:14:19 BST 2007 Time inuse 23 (seconds)
2664 Last allocation time Mon Apr 23 12:14:42 BST 2007
2665 getConnection stack trace information:
2666 com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:744)
2667 com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:402)
2668 com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:371)
2669 net.sf.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:59)
2670 net.sf.hibernate.impl.BatcherImpl.openConnection(BatcherImpl.java:292)
2671 net.sf.hibernate.impl.SessionImpl.connect(SessionImpl.java:3373)
2672 net.sf.hibernate.impl.SessionImpl.connection(SessionImpl.java:3333)[/u]