-
Bug
-
Resolution: Done
-
Major
-
JBossAS-4.0.5.GA
-
None
TransactionIsolation is not being reset when the JDBC connection is returned to the pool. Bug is indicated in the code.
This was also reported in http://jira.jboss.com/jira/browse/JBAS-1123 and marked as closed but the bug is still there.
public void cleanup() throws ResourceException
{
synchronized (handles)
{
for (Iterator i = handles.iterator(); i.hasNext(); )
handles.clear();
}
//reset all the properties we know about to defaults.
synchronized (stateLock)
{
jdbcAutoCommit = true;
jdbcReadOnly = readOnly;
if (jdbcTransactionIsolation != transactionIsolation)
{
try
catch (SQLException e)
{ mcf.log.warn("Error resetting transaction isolation ", e); } }
}
}