db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "ErandaSooriyabandara" by ErandaSooriyabandara
Date Mon, 17 Aug 2009 08:04:23 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by ErandaSooriyabandara:
http://wiki.apache.org/db-derby/ErandaSooriyabandara

------------------------------------------------------------------------------
  
  pSt.setObject(i, rs.getObject(i), Types.INTEGER);.
  
+ To solve the problem(1st) we were faced in the test was solved,
+ 
+ We change the code, 
+ 
+ TestSuite suite = new TestSuite("InbetweenTest Test");
+         suite.addTest(DatabasePropertyTestSetup.singleProperty(
+                 TestConfiguration.defaultSuite(InbetweenTest.class),
+                 "derby.language.statementCacheSize", "0"));
+ 
+ to
+ 
+ TestSuite suite = new TestSuite("InbetweenTest Test");
+         suite.addTest(DatabasePropertyTestSetup.singleProperty(
+                 TestConfiguration.defaultSuite(InbetweenTest.class),
+                 "derby.language.statementCacheSize", "0",true));.
+ 
+ After that we get 16 dependencies and no open scans as a result of the function ConsistencyChecker().
There are 16 dependencies when run as embedded and only two found when run in ij.The reason
for the changes when the ij runs the onsistencyChecker() method does not show the actual no
of dependencies. It shows the dependencies changed when ij runs. So the total no of dependencies
when the ij runs is 18. When ij runs it shows the no of dependencies as 2(18-16). 
+ 
+ Now the code look likes,
+ 
+ if(usingEmbedded()){
+             rs = st.executeQuery(
+                 "values ConsistencyChecker()");
+ 
+             expColNames = new String [] {"1"};
+             JDBC.assertColumnNames(rs, expColNames);
+ 
+             expRS = new String [][]
+             {
+                 {"No open scans, etc"},
+                 {"16 dependencies found"}
+             };
+ 
+             JDBC.assertFullResultSet(rs, expRS, true);
+         }
+ 
  I break the long test_inbetween() into several methods. Those methods are,
  
     1.testBetween()
@@ -283, +319 @@

  
     8.testReproductionBeetle5135()
  
+ I compare the test with the output of test file and change the code with adding some comments
and removing repeated codings.
+ I think now the test is clean and can commit as a revision.
  
  ==== DERBY-4256 ====
  ==== allow alter table to increase the maximum size of a blob and a clob ====

Mime
View raw message