From 88ce1f83951ad8e6c3741ead5960b7ad224ce6b7 Mon Sep 17 00:00:00 2001
From: fhanik <fhanik@13f79535-47bb-0310-9956-ffa450edef68>
Date: Wed, 12 Jan 2011 19:36:43 +0000
Subject: [PATCH] reset state when the connection is closed

git-svn-id: https://svn.apache.org/repos/asf/tomcat/trunk@1058286 13f79535-47bb-0310-9956-ffa450edef68
---
 .../org/apache/tomcat/jdbc/pool/interceptor/ConnectionState.java | 9 ++++++++-
 1 file changed, 8 insertions(+), 1 deletion(-)

diff --git a/modules/jdbc-pool/java/org/apache/tomcat/jdbc/pool/interceptor/ConnectionState.java b/modules/jdbc-pool/java/org/apache/tomcat/jdbc/pool/interceptor/ConnectionState.java
index a56d96968..6da8bd5e7 100644
--- a/modules/jdbc-pool/java/org/apache/tomcat/jdbc/pool/interceptor/ConnectionState.java
+++ b/modules/jdbc-pool/java/org/apache/tomcat/jdbc/pool/interceptor/ConnectionState.java
@@ -54,7 +54,14 @@ public class ConnectionState extends JdbcInterceptor  {
     
     @Override
     public void reset(ConnectionPool parent, PooledConnection con) {
-        if (parent==null || con==null) return;
+        if (parent==null || con==null) {
+            //we are resetting, reset our defaults
+            autoCommit = null;
+            transactionIsolation = null;
+            readOnly = null;
+            catalog = null;
+            return;
+        }
         PoolConfiguration poolProperties = parent.getPoolProperties();
         if (poolProperties.getDefaultTransactionIsolation()!=DataSourceFactory.UNKNOWN_TRANSACTIONISOLATION) {
             try {
-- 
2.11.0