db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ma...@apache.org
Subject svn commit: r1298907 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/largedata: LobLimitsLiteTest.java LobLimitsTest.java
Date Fri, 09 Mar 2012 16:24:13 GMT
Author: mamta
Date: Fri Mar  9 16:24:12 2012
New Revision: 1298907

URL: http://svn.apache.org/viewvc?rev=1298907&view=rev
Log:
DERBY-5638 intermittent test failure in test_05_ClobNegative when running full largedata._Suite;
LobLimitsTestjava.sql.SQLException: Table/View 'BLOBTBL' already exists in Schema 'APP'.

The test fixture test_05_ClobNegative which runs into intermittent test failures does not
commit/rollback the transaction after doing a series of negative testing. This may be the
cause of left over locks which does not allow CleanDatabaseSetup to get the required locks
to drop the tables as part of it's cleanup. As part of this change, we are adding a rollback
at the end of test_05_ClobNegative method and see if that helps with the intermittent locking
issues.



Modified:
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/largedata/LobLimitsLiteTest.java
    db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/largedata/LobLimitsTest.java

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/largedata/LobLimitsLiteTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/largedata/LobLimitsLiteTest.java?rev=1298907&r1=1298906&r2=1298907&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/largedata/LobLimitsLiteTest.java
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/largedata/LobLimitsLiteTest.java
Fri Mar  9 16:24:12 2012
@@ -21,9 +21,12 @@ limitations under the License.
 
 package org.apache.derbyTesting.functionTests.tests.largedata;
 
+import java.util.Properties;
+
 import junit.framework.Test;
 import junit.framework.TestSuite;
 
+import org.apache.derbyTesting.junit.SystemPropertyTestSetup;
 import org.apache.derbyTesting.junit.TestConfiguration;
 
 

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/largedata/LobLimitsTest.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/largedata/LobLimitsTest.java?rev=1298907&r1=1298906&r2=1298907&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/largedata/LobLimitsTest.java
(original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/largedata/LobLimitsTest.java
Fri Mar  9 16:24:12 2012
@@ -422,6 +422,7 @@ public class LobLimitsTest extends BaseJ
                 assertSQLState("22003", sqle);
             }
         }
+        rollback();
 
         // ADD NEW TESTS HERE
     }



Mime
View raw message