db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kahat...@apache.org
Subject svn commit: r1328328 [2/2] - /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/OrderByAndSortAvoidance.java
Date Fri, 20 Apr 2012 11:29:20 GMT

Modified: db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/OrderByAndSortAvoidance.java
URL: http://svn.apache.org/viewvc/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/OrderByAndSortAvoidance.java?rev=1328328&r1=1328327&r2=1328328&view=diff
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/OrderByAndSortAvoidance.java (original)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/OrderByAndSortAvoidance.java Fri Apr 20 11:29:20 2012
@@ -21,6 +21,8 @@
 
 package org.apache.derbyTesting.functionTests.tests.lang;
 
+import java.sql.Connection;
+import java.sql.PreparedStatement;
 import java.sql.SQLException;
 import java.sql.Statement;
 import java.sql.ResultSet;
@@ -71,7 +73,6 @@ public class OrderByAndSortAvoidance ext
             new TestSuite(OrderByAndSortAvoidance.class)) {
                 protected void decorateSQL(Statement st)
                         throws SQLException {
-                    getConnection().setAutoCommit(false);
                     st.executeUpdate("create table a(col1 int, col2 int)");
                     st.executeUpdate("insert into a values(1,1),(1,1)");
                     st.executeUpdate("create table b(col1 int, col2 int)");
@@ -95,9934 +96,9 @@ public class OrderByAndSortAvoidance ext
         
                     st.executeUpdate(
                         "CREATE INDEX key3 ON table2(value)");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table1 VALUES (2147483649)");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'SC2', "
-                        + "'LaPosteSortPlan=B-W3-S2')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, "+
-                        "'AddressG4', 'BELGIQUE')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, "
-                        + "'IsIdenticalToDocumentAddress', 'true')");
-
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, "+
-                        "'AddressG3', '1180, Bruxelles')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, "
-                        + "'DocumentSortingValues', '______21855__1__1')");
-
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'ItemSeq', '1')");
-
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, "
-                        + "'BatchTypeInstructions', '')");
-
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'Plex', 'S')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'SC3', '=')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'has_address', "+
-                        "'true')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, "
-                        + "'SubBatchSortingValue', 'BE_B-W3-S2___')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'Language', 'FR')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'logo', 'false')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'SC4', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, "
-                        + "'InternalAddress', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'AddressG6', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, "
-                        + "'InternalAddressBringer', 'false')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'AddresseeSeq', '1')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'SC1', 'Country=BE')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, "+
-                        "'CommunicationOrderId', '21865')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, "
-                        + "'BatchTypeId', 'Paper')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'location', "+
-                        "'Bla bla bla bla bla bla 99')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'SortPlan', "
-                        + "'B-W3-S2')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'Enveloping', 'C')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, "
-                        + "'PostComponentId', '21855')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'BatchTypeLabel', "+
-                        "'Paper')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'city', 'Bruxelles')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'AddressG7', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'CopyMention', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'AddressG8', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'StapleNbr', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'TLEBundle', "+
-                        "'Niveau2')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'AddressG5', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'header', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, "
-                        + "'EnvelopSortingValue', "
-                        + "'BE1180___testOlivier001-0001___________Bla bla bla bla "
-                        + "bla bla 99____')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'GroupedWith', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'AddressG2', "
-                        + "'Bla bla bla bla bla bla 99')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, "+
-                        "'DiversionReason', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'Pliable', 'true')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'TLEBinder', "+
-                        "'Niveau1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'country', 'BE')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'AddressG1', "+
-                        "'testOlivier001-0001')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'MentionCode', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'postCode', '1180')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'SC5', '=')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483649, 'Branding', '1C')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table1 VALUES (2147483650)");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'SC2', "+
-                        "'LaPosteSortPlan=B-W3-S2')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'AddressG4', "
-                        + "'BELGIQUE')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, "+
-                        "'IsIdenticalToDocumentAddress', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'AddressG3', "
-                        + "'1180, Bruxelles')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, "+
-                        "'DocumentSortingValues', '______21855__1__1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'ItemSeq', '1')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, "+
-                        "'BatchTypeInstructions', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'Plex', 'S')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'SC3', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, "
-                        + "'has_address', 'true')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, " +
-                        "'SubBatchSortingValue', 'BE_B-W3-S2___')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'Language', 'FR')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'logo', 'false')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'SC4', '=')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, "+
-                        "'InternalAddress', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'AddressG6', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, "+
-                        "'InternalAddressBringer', 'false')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'AddresseeSeq', '1')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'SC1', 'Country=BE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, "
-                        + "'CommunicationOrderId', '21865')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'BatchTypeId', 'Paper')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'location', "
-                        + "'Bla bla bla bla bla bla 99')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'SortPlan', 'B-W3-S2')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'Enveloping', 'C')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'PostComponentId', "+
-                        "'21855')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, "
-                        + "'BatchTypeLabel', 'Paper')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'city', 'Bruxelles')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'AddressG7', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'CopyMention', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'AddressG8', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'StapleNbr', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'TLEBundle', "
-                        + "'Niveau2')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'AddressG5', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'header', 'true')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, "+
-                        "'EnvelopSortingValue', 'BE1180___testOlivier001-0001"+
-                        "___________Bla bla bla bla bla bla 99____')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'GroupedWith', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'AddressG2', "+
-                        "'Bla bla bla bla bla bla 99')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, "
-                        + "'DiversionReason', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'Pliable', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'TLEBinder', "
-                        + "'Niveau1')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'country', 'BE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'AddressG1', "
-                        + "'testOlivier001-0001')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'MentionCode', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'postCode', '1180')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'SC5', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483650, 'Branding', '1C')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table1 VALUES (2147483651)");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'SC2', "
-                        + "'LaPosteSortPlan=B-W3-S2')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'AddressG4', "+
-                        "'BELGIQUE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, "
-                        + "'IsIdenticalToDocumentAddress', 'true')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'AddressG3', "+
-                        "'1180, Bruxelles')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, "
-                        + "'DocumentSortingValues', '______21856__1__1')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'ItemSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, "
-                        + "'BatchTypeInstructions', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'Plex', 'S')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'SC3', '=')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'has_address', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, "
-                        + "'SubBatchSortingValue', 'BE_B-W3-S2___')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'Language', 'FR')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'logo', 'false')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'SC4', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, "
-                        + "'InternalAddress', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'AddressG6', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, "
-                        + "'InternalAddressBringer', 'false')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'AddresseeSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'SC1', 'Country=BE')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, "+
-                        "'CommunicationOrderId', '21866')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, "
-                        + "'BatchTypeId', 'Paper')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'location', "+
-                        "'Bla bla bla bla bla bla 99')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'SortPlan', "
-                        + "'B-W3-S2')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'Enveloping', 'C')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, "
-                        + "'PostComponentId', '21856')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'BatchTypeLabel', 'Paper')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'city', 'Bruxelles')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'AddressG7', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'CopyMention', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'AddressG8', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'StapleNbr', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'TLEBundle', 'Niveau2')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'AddressG5', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'header', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, "
-                        + "'EnvelopSortingValue', "
-                        + "'BE1180___testOlivier001-0002___________Bla bla bla bla "
-                        + "bla bla 99____')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'GroupedWith', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'AddressG2', "
-                        + "'Bla bla bla bla bla bla 99')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'DiversionReason', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'Pliable', 'true')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'TLEBinder', 'Niveau1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'country', 'BE')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'AddressG1', "+
-                        "'testOlivier001-0002')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'MentionCode', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'postCode', '1180')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'SC5', '=')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483651, 'Branding', '1C')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table1 VALUES (2147483652)");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'SC2', 'LaPosteSortPlan=B-W3-S2')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'AddressG4', "
-                        + "'BELGIQUE')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, "+
-                        "'IsIdenticalToDocumentAddress', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'AddressG3', "
-                        + "'1180, Bruxelles')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, "+
-                        "'DocumentSortingValues', '______21856__1__1')");
-
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'ItemSeq', '1')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'BatchTypeInstructions', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'Plex', 'S')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'SC3', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, "
-                        + "'has_address', 'true')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'SubBatchSortingValue', 'BE_B-W3-S2___')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'Language', 'FR')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'logo', 'false')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'SC4', '=')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'InternalAddress', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'AddressG6', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'InternalAddressBringer', 'false')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'AddresseeSeq', '1')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'SC1', 'Country=BE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, "
-                        + "'CommunicationOrderId', '21866')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'BatchTypeId', 'Paper')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'location', "
-                        + "'Bla bla bla bla bla bla 99')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'SortPlan', 'B-W3-S2')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'Enveloping', 'C')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'PostComponentId', '21856')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, "
-                        + "'BatchTypeLabel', 'Paper')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'city', 'Bruxelles')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'AddressG7', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'CopyMention', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'AddressG8', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'StapleNbr', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'TLEBundle', "
-                        + "'Niveau2')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'AddressG5', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'header', 'true')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'EnvelopSortingValue',"
-                        + "'BE1180___testOlivier001-0002___________Bla bla bla bla bl,"
-                        + "a bla 99____')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'GroupedWith', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'AddressG2', 'Bla bla bla bla bla bla 99')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, "
-                        + "'DiversionReason', '')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'Pliable', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'TLEBinder', "
-                        + "'Niveau1')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'country', 'BE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'AddressG1', "
-                        + "'testOlivier001-0002')");
-        
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'MentionCode', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'postCode', '1180')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'SC5', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483652, 'Branding', '1C')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table1 VALUES (2147483653)");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'SC2', "
-                        + "'PostCode=1180')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'AddressG4', 'BELGIQUE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, "
-                        + "'IsIdenticalToDocumentAddress', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'AddressG3', '1180 Bruxelles')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, "
-                        + "'DocumentSortingValues', '______21857__1__1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'ItemSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, "
-                        + "'BatchTypeInstructions', 'Ne pas jeter ces "
-                        + "documents.  Ils ont \u00e9t\u00e9 faits pour quelque chose.')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'Plex', 'S')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'SC3', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'has_address', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, "
-                        + "'SubBatchSortingValue', 'ddch257___1180______')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'Language', 'FR')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'logo', 'false')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'SC4', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, "
-                        + "'InternalAddress', '233/621')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'AddressG6', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, "
-                        + "'InternalAddressBringer', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'AddresseeSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'SC1', "
-                        + "'Requester=ddch257')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, "+
-                        "'CommunicationOrderId', '21867')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, "
-                        + "'BatchTypeId', '233-621-001')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'location', "+
-                        "'Bla bla bla bla bla bla 99')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'SortPlan', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'Enveloping', 'N')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, "
-                        + "'PostComponentId', '21857')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, "+
-                        "'BatchTypeLabel', 'Diversion pour test')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'city', 'Bruxelles')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'AddressG7', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'CopyMention', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'AddressG8', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'StapleNbr', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'TLEBundle', "+
-                        "'Niveau2')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'AddressG5', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'header', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, "
-                        + "'EnvelopSortingValue', "
-                        + "'BE1180___testOlivier002-0003___________Bla bla bla bla "
-                        + "bla bla 99')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'GroupedWith', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'AddressG2', "
-                        + "'Bla bla bla bla bla bla 99')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, "+
-                        "'DiversionReason', '001')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'Pliable', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'TLEBinder', "+
-                        "'Niveau1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'country', 'BE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'AddressG1', "+
-                        "'testOlivier002-0003')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'MentionCode', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'postCode', '1180')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'SC5', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483653, 'Branding', '1C')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table1 VALUES (2147483654)");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'SC2', 'PostCode=1180')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'AddressG4', "
-                        + "'BELGIQUE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, "+
-                        "'IsIdenticalToDocumentAddress', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'AddressG3', "
-                        + "'1180 Bruxelles')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, "+
-                        "'DocumentSortingValues', '______21857__1__1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'ItemSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, "+
-                        "'BatchTypeInstructions', 'Ne pas jeter ces documents.  Ils ont \u00e9t\u00e9 faits pour quelque chose.')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'Plex', 'S')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'SC3', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, "
-                        + "'has_address', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, "+
-                        "'SubBatchSortingValue', 'ddch257___1180______')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'Language', 'FR')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'logo', 'false')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'SC4', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'InternalAddress',"+
-                        "'233/621')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'AddressG6', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, "+
-                        "'InternalAddressBringer', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'AddresseeSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'SC1', 'Requester=ddch257')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, "
-                        + "'CommunicationOrderId', '21867')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'BatchTypeId', '233-621-001')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'location', "
-                        + "'Bla bla bla bla bla bla 99')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'SortPlan', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'Enveloping', 'N')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'PostComponentId', '21857')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, "
-                        + "'BatchTypeLabel', 'Diversion pour test')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'city', 'Bruxelles')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'AddressG7', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'CopyMention', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'AddressG8', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'StapleNbr', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'TLEBundle', "
-                        + "'Niveau2')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'AddressG5', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'header', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, "+
-                        "'EnvelopSortingValue', "+
-                        "'BE1180___testOlivier002-0003___________Bla bla bla bla bla bla 99____')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'GroupedWith', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'AddressG2', "+
-                        "'Bla bla bla bla bla bla 99')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, "
-                        + "'DiversionReason', '001')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'Pliable', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'TLEBinder', "
-                        + "'Niveau1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'country', 'BE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'AddressG1', "
-                        + "'testOlivier002-0003')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'MentionCode', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'postCode', '1180')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'SC5', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483654, 'Branding', '1C')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table1 VALUES (2147483655)");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'SC2', "
-                        + "'PostCode=1180')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'AddressG4', 'BELGIQUE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, "
-                        + "'IsIdenticalToDocumentAddress', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'AddressG3', '1180 Bruxelles')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, "
-                        + "'DocumentSortingValues', '______21858__1__1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'ItemSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, "
-                        + "'BatchTypeInstructions', 'Ne pas jeter ces "
-                        + "documents.  Ils ont \u00e9t\u00e9 faits pour quelque chose.')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'Plex', 'S')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'SC3', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'has_address', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, "
-                        + "'SubBatchSortingValue', 'ddch257___1180______')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'Language', 'FR')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'logo', 'false')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'SC4', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, "
-                        + "'InternalAddress', '233/621')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'AddressG6', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, "
-                        + "'InternalAddressBringer', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'AddresseeSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'SC1', "
-                        + "'Requester=ddch257')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, "+
-                        "'CommunicationOrderId', '21868')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, "
-                        + "'BatchTypeId', '233-621-001')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'location', "+
-                        "'Bla bla bla bla bla bla 99')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'SortPlan', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'Enveloping', 'N')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, "
-                        + "'PostComponentId', '21858')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, "+
-                        "'BatchTypeLabel', 'Diversion pour test')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'city', 'Bruxelles')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'AddressG7', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'CopyMention', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'AddressG8', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'StapleNbr', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'TLEBundle', 'Niveau2')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'AddressG5', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'header', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, "
-                        + "'EnvelopSortingValue', "
-                        + "'BE1180___testOlivier002-0004___________Bla bla bla bla bla bla 99____')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'GroupedWith', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'AddressG2', "
-                        + "'Bla bla bla bla bla bla 99')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'DiversionReason', '001')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'Pliable', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'TLEBinder', 'Niveau1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'country', 'BE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'AddressG1', "+
-                        "'testOlivier002-0004')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'MentionCode', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'postCode', '1180')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'SC5', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483655, 'Branding', '1C')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table1 VALUES (2147483656)");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'SC2', 'PostCode=1180')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'AddressG4', "
-                        + "'BELGIQUE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, "+
-                        "'IsIdenticalToDocumentAddress', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'AddressG3', "
-                        + "'1180 Bruxelles')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'DocumentSorting"+
-                        "Values', '______21858__1__1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'ItemSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'BatchTypeIn"+
-                        "structions', 'Ne pas jeter ces documents.  Ils ont "+
-                        "\u00e9t\u00e9 faits pour quelque chose.')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'Plex', 'S')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'SC3', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, "
-                        + "'has_address', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'SubBatchSortin"+
-                        "gValue', 'ddch257___1180______')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'Language', 'FR')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'logo', 'false')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'SC4', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'InternalAddres"+
-                        "s', '233/621')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'AddressG6', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'InternalAddressB"+
-                        "ringer', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'AddresseeSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'SC1', 'Request"+
-                        "er=ddch257')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, "
-                        + "'CommunicationOrderId', '21868')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'BatchTypeId', "+
-                        "'233-621-001')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'location', "
-                        + "'Bla bla bla bla bla bla 99')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'SortPlan', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'Enveloping', 'N')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'PostComponentI"+
-                        "d', '21858')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, "
-                        + "'BatchTypeLabel', 'Diversion pour test')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'city', 'Bruxel"+
-                        "les')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'AddressG7', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'CopyMention', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'AddressG8', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'StapleNbr', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'TLEBundle', "
-                        + "'Niveau2')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'AddressG5', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'header', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'EnvelopSorting"+
-                        "Value', 'BE1180___testOlivier002-0004___________Boulev"+
-                        "ard du Souverain, 23____')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'GroupedWith', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'AddressG2', 'B"+
-                        "oulevard du Souverain, 23')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, "
-                        + "'DiversionReason', '001')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'Pliable', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'TLEBinder', "
-                        + "'Niveau1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'country', 'BE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'AddressG1', "
-                        + "'testOlivier002-0004')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'MentionCode', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'postCode', '1180')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'SC5', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483656, 'Branding', '1C')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table1 VALUES (2147483657)");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'SC2', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'AddressG4', 'BELGIQUE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, "
-                        + "'IsIdenticalToDocumentAddress', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'AddressG3', 'Broker ville')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, "
-                        + "'DocumentSortingValues', '______21859__1__1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'ItemSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, "
-                        + "'BatchTypeInstructions', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'Plex', 'S')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'SC3', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'has_address', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, "
-                        + "'SubBatchSortingValue', 'Une info b')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'Language', 'FR')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'logo', 'false')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'SC4', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, "
-                        + "'InternalAddress', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'AddressG6', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, "
-                        + "'InternalAddressBringer', 'false')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'AddresseeSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'SC1', "
-                        + "'DeliveryInformation=Une info bidon')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'CommunicationOrderId', '21869')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, "
-                        + "'BatchTypeId', 'BROKER NET')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'location', 'rue du broker')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'SortPlan', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'Enveloping', 'C')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, "
-                        + "'PostComponentId', '21859')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'BatchTypeLabel', 'BROKER NET')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'city', "
-                        + "'Broker ville')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'AddressG7', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'CopyMention', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'AddressG8', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'StapleNbr', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'TLEBundle', 'Niveau2')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'AddressG5', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'header', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, "
-                        + "'EnvelopSortingValue', "
-                        + "'BE1000___testOlivier003-0005___________rue du "
-                        + "broker_________________')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'GroupedWith', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'AddressG2', "
-                        + "'rue du broker')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'DiversionReason', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'Pliable', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'TLEBinder', 'Niveau1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'country', 'BE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'AddressG1', 'testOlivier003-0005')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'MentionCode', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'postCode', '1000')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'SC5', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483657, 'Branding', '1C')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table1 VALUES (2147483658)");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'SC2', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'AddressG4', "
-                        + "'BELGIQUE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'IsIdenticalToDocumentAddress', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'AddressG3', "
-                        + "'Broker ville')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'DocumentSortingValues', '______21859__1__1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'ItemSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'BatchTypeInstructions', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'Plex', 'S')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'SC3', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, "
-                        + "'has_address', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'SubBatchSortingValue', 'Une info b')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'Language', 'FR')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'logo', 'false')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'SC4', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'InternalAddress', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'AddressG6', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'InternalAddressBringer', 'false')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'AddresseeSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'SC1', 'DeliveryInformation=Une info bidon')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, "
-                        + "'CommunicationOrderId', '21869')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'BatchTypeId', 'BROKER NET')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'location', "
-                        + "'rue du broker')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'SortPlan', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'Enveloping', 'C')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'PostComponentId', '21859')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, "
-                        + "'BatchTypeLabel', 'BROKER NET')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'city', 'Broker ville')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'AddressG7', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'CopyMention', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'AddressG8', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'StapleNbr', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'TLEBundle', "
-                        + "'Niveau2')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'AddressG5', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'header', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'EnvelopSorting"+
-                        "Value', 'BE1000___testOlivier003-0005___________rue du"+
-                        "broker_________________')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'GroupedWith', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'AddressG2', 'rue du broker')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, "
-                        + "'DiversionReason', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'Pliable', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'TLEBinder', "
-                        + "'Niveau1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'country', 'BE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'AddressG1', "
-                        + "'testOlivier003-0005')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'MentionCode', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'postCode', '1000')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'SC5', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483658, 'Branding', '1C')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table1 VALUES (2147483659)");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'SC2', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'AddressG4', 'BELGIQUE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, "
-                        + "'IsIdenticalToDocumentAddress', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'AddressG3', 'Broker ville')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, "
-                        + "'DocumentSortingValues', '______21860__1__1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'ItemSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, "
-                        + "'BatchTypeInstructions', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'Plex', 'S')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'SC3', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'has_address', 'true')");
-
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, "
-                        + "'SubBatchSortingValue', 'Une info b')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'Language', 'FR')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'logo', 'false')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'SC4', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, "
-                        + "'InternalAddress', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'AddressG6', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, "
-                        + "'InternalAddressBringer', 'false')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'AddresseeSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'SC1', "
-                        + "'DeliveryInformation=Une info bidon')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'CommunicationOrderId', '21870')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, "
-                        + "'BatchTypeId', 'BROKER NET')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'location', 'rue du broker')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'SortPlan', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'Enveloping', 'C')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, "
-                        + "'PostComponentId', '21860')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'BatchTypeLabel', 'BROKER NET')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'city', "
-                        + "'Broker ville')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'AddressG7', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'CopyMention', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'AddressG8', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'StapleNbr', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'TLEBundle', 'Niveau2')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'AddressG5', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'header', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, "
-                        + "'EnvelopSortingValue', "
-                        + "'BE1000___testOlivier003-0006___________rue du "
-                        + "broker_________________')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'GroupedWith', '')");
-
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'AddressG2', "
-                        + "'rue du broker')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'DiversionReason', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'Pliable', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'TLEBinder', 'Niveau1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'country', 'BE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'AddressG1', 'testOlivier003-0006')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'MentionCode', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'postCode', '1000')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'SC5', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483659, 'Branding', '1C')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table1 VALUES (2147483660)");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'SC2', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'AddressG4', "
-                        + "'BELGIQUE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'IsIdenticalToDocumentAddress', 'true')");
-
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'AddressG3', "
-                        + "'Broker ville')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'DocumentSortingValues', '______21860__1__1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'ItemSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'BatchTypeInstructions', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'Plex', 'S')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'SC3', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, "
-                        + "'has_address', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'SubBatchSortingValue', 'Une info b')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'Language', 'FR')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'logo', 'false')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'SC4', '=')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'InternalAddress', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'AddressG6', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'InternalAddressBringer', 'false')");
-
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'AddresseeSeq', '1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'SC1', 'DeliveryInformation=Une info bidon')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, "
-                        + "'CommunicationOrderId', '21870')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'BatchTypeId', 'BROKER NET')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'location', "
-                        + "'rue du broker')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'SortPlan', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'Enveloping', 'C')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'PostComponentId', '21860')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, "
-                        + "'BatchTypeLabel', 'BROKER NET')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'city', 'Broker ville')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'AddressG7', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'CopyMention', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'AddressG8', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'StapleNbr', '')");
-
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'TLEBundle', "
-                        + "'Niveau2')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'AddressG5', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'header', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'EnvelopSorting"+
-                        "Value', 'BE1000___testOlivier003-0006___________rue du"+
-                        "broker_________________')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'GroupedWith', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'AddressG2', 'rue du broker')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, "
-                        + "'DiversionReason', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'Pliable', 'true')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'TLEBinder', "
-                        + "'Niveau1')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'country', 'BE')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'AddressG1', "
-                        + "'testOlivier003-0006')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'MentionCode', '')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'postCode', '1000')");
-            
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'SC5', '=')");
-
-                    st.executeUpdate(
-                        "INSERT INTO table2 VALUES (2147483660, 'Branding', '1C')");
-            
-                    st.executeUpdate(

[... 11106 lines stripped ...]


Mime
View raw message