Transaction not Active excetion

bentins May 26, 2006 7:21 PM

I have a weird situation.

I get this nestedSqlException: Transaction is not active when I do a select. The weird thing is that the select is done when struts calls on a form to get some value and all I do is open a connection by doing getConnection on my datasource and then I do the select using JDBC. There shouldn't be a Transaction here at all.

Any ideas?

1. Re: Transaction not Active excetion

bentins May 27, 2006 9:21 AM (in response to bentins)

Problem was in my own code. I had an exception on the transaction that was not rolledback so the connection had an uncleaned transaction on it.

Since my other select was running on the same thread it got the same uncleaned connection with the transaction.
Actions
2. Re: Transaction not Active excetion

sumonwai Jun 20, 2006 5:05 AM (in response to bentins)

I got the excately the same problem with you. But still can't solve it. Could you please explain me in detail with your code.
Many Thanks,
Actions

Go to original post