0003581: java.lang.IllegalStateException: Transactions must have a commit() or rollback() in a finally block

Notes
(0004088) alex 06-26-09 10:52	Aarthi email-subject: Rolling back dangling transaction ? OS (Solaris 10) ? JDK Version and build number (can be usually seen in resin's logs, but just in case) (1.5.0_16; build 1.5.0_16-b02) ? Database and JDBC Driver version, configuration that's used to acquire connection (Oracle 10g ? 10.2.0.4.0; OCI driver) ? How transactions are started (is it user managed transactions or container managed) (Container managed ? starts off a stateless session bean) ? EJB's participants if any, and what they are (can be as simple as a stateless session bean calls to another session bean which inserts / updates 2 Entity Beans) (stateless session bean calls the container managed entity bean. The entity bean is mapped to the table that gets 4 of its columns updated (table1), and does a SQL to insert into another table (table2). Please note that the SQL insert that happens in a private method in the bean is within a try/catch/finally block and the connection that the application code opens, does get closed.) ? Resource Participants in the transaction, if there are more then one participant (more then one DB, a JMS or a JCA resource) (none)

(0004090) alex 06-30-09 15:02	[10:57:11.606] Rolling back dangling transaction. All transactions must have a commit() or rollback() in a fi nally block. [10:57:11.606] begin-local-XA: com.caucho.sql.ManagedConnectionImpl$LocalTransactionImpl@296836a8 [10:57:11.606] allocate PoolItem[OracleDS,895046,com.caucho.sql.ManagedConnectionImpl@763dda0b] [10:57:11.607] idle PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee] [10:57:11.607] allocate PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee] [10:57:11.608] connection pool rollback XA: PoolItem[OracleDS,850031,com.caucho.sql.ManagedConnectionImpl@1f27d605] [10:57:11.608] connection pool rollback XA: PoolItem[OracleDS,895046,com.caucho.sql.ManagedConnectionImpl@763dda0b] [10:57:11.609] idle PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee] [10:57:11.609] allocate PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee] [10:57:11.610] idle PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee] [10:57:11.610] allocate PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee] [10:57:11.611] idle PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee] [10:57:11.612] allocate PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee] [10:57:11.613] idle PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee] [10:57:11.613] allocate PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee] [10:57:11.615] idle PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee] [10:57:11.615] JNDI lookup `java:comp/UserTransaction' -> UserTransactionProxy[] [10:57:11.616] begin-local-XA: com.caucho.sql.ManagedConnectionImpl$LocalTransactionImpl@5114fa96 [10:57:11.616] allocate PoolItem[OracleDS,879249,com.caucho.sql.ManagedConnectionImpl@19fd7cee] [10:57:11.618] idle PoolItem[OracleDS,895046,com.caucho.sql.ManagedConnectionImpl@763dda0b] [10:57:11.618] idle PoolItem[OracleDS,850031,com.caucho.sql.ManagedConnectionImpl@1f27d605] [10:57:11.618] java.lang.IllegalStateException: Transactions must have a commit() or rollback() in a finally block. [10:57:11.618] at com.caucho.jca.UserTransactionImpl.abortTransaction(UserTransactionImpl.java:456) [10:57:11.618] at com.caucho.jca.UserTransactionProxy.abortTransaction(UserTransactionProxy.java:184) [10:57:11.618] at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:193) [10:57:11.618] at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:229) [10:57:11.618] at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:274) [10:57:11.618] at com.caucho.server.port.TcpConnection.run(TcpConnection.java:514) [10:57:11.618] at com.caucho.util.ThreadPool.runTasks(ThreadPool.java:520) [10:57:11.618] at com.caucho.util.ThreadPool.run(ThreadPool.java:442) [10:57:11.618] at java.lang.Thread.run(Thread.java:595) [10:57:11.618] [31] no-keepalive [10:57:11.618] closing connection TcpConnection[id=resin-tcp-connection-*:8001-63,socket=JniSocketImpl$2070585933[27032400],port=Port[null:8001]], total=134 [10:57:11.619] commit-local: com.caucho.sql

(0004992) ferg 01-21-11 15:33	4.0.14

Issue History
Date Modified	Username	Field	Change
06-26-09 10:42	alex	New Issue
06-26-09 10:52	alex	Note Added: 0004088
06-30-09 15:02	alex	Note Added: 0004090
06-30-09 15:23	alex	Note Added: 0004091
06-30-09 15:36	alex	Note Deleted: 0004091
01-21-11 15:33	ferg	Note Added: 0004992
01-21-11 15:33	ferg	Assigned To	=> ferg
01-21-11 15:33	ferg	Status	new => closed
01-21-11 15:33	ferg	Resolution	open => fixed

Relationships