db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From d..@apache.org
Subject svn commit: r825682 [2/2] - /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/OrderByAndSortAvoidance.java
Date Thu, 15 Oct 2009 22:19: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=825682&r1=825681&r2=825682&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 Thu Oct 15 22:19:19 2009
@@ -25,6 +25,8 @@
 import java.sql.Statement;
 import java.sql.ResultSet;
 import junit.framework.Test;
+import junit.framework.TestSuite;
+import org.apache.derbyTesting.junit.CleanDatabaseTestSetup;
 import org.apache.derbyTesting.junit.BaseJDBCTestCase;
 import org.apache.derbyTesting.junit.JDBC;
 import org.apache.derbyTesting.junit.TestConfiguration;
@@ -41,10081 +43,10082 @@
         super(name);
     }
 
-    public static Test suite() {
-        return TestConfiguration.defaultSuite(OrderByAndSortAvoidance.class);
-    }
+    /**
+     * Construct top level suite in this JUnit test
+     *
+     * @return A suite containing embedded and client suites.
+     */
+    public static Test suite()
+    {
+        TestSuite suite = new TestSuite("OrderByAndSortAvoidance");
 
-    protected void setUp() throws SQLException {
-        getConnection().setAutoCommit(false);
-        Statement st = createStatement();
+        suite.addTest(makeSuite());
 
-        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)");
-        st.executeUpdate("insert into b values(2,2),(2,2)");
-        st.executeUpdate("create table c(col1 int, col2 int)");
-        st.executeUpdate("insert into c values(3,3),(3,3)");
+        suite.addTest(
+             TestConfiguration.clientServerDecorator(makeSuite()));
 
-        st.executeUpdate(
-                "create TABLE table1 (id BIGINT NOT NULL, PRIMARY KEY(id))");
+        return suite;
+    }
+
+    /**
+     * Construct suite of tests
+     *
+     * @return A suite containing the test cases.
+     */
+    private static Test makeSuite()
+    {
+        return new CleanDatabaseTestSetup(
+            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)");
+                    st.executeUpdate("insert into b values(2,2),(2,2)");
+                    st.executeUpdate("create table c(col1 int, col2 int)");
+                    st.executeUpdate("insert into c values(3,3),(3,3)");
 
-        st.executeUpdate(
-        		"CREATE INDEX key1 ON table1(id)");
+                    st.executeUpdate(
+                        "create TABLE table1 (id BIGINT NOT NULL, PRIMARY KEY(id))");
+
+                    st.executeUpdate(
+                        "CREATE INDEX key1 ON table1(id)");
         
-        st.executeUpdate(
-                "CREATE TABLE table2 (id BIGINT NOT NULL, name "
-                + "VARCHAR(40) NOT NULL, value VARCHAR(1024), PRIMARY "
-                + "KEY(id, name))");
+                    st.executeUpdate(
+                        "CREATE TABLE table2 (id BIGINT NOT NULL, name "
+                        + "VARCHAR(40) NOT NULL, value VARCHAR(1024), PRIMARY "
+                        + "KEY(id, name))");
             
-        st.executeUpdate(
-        		"CREATE UNIQUE INDEX key2 ON table2(id, name)");
+                    st.executeUpdate(
+                        "CREATE UNIQUE INDEX key2 ON table2(id, name)");
         
-        st.executeUpdate(
-        "CREATE INDEX key3 ON table2(value)");
+                    st.executeUpdate(
+                        "CREATE INDEX key3 ON table2(value)");
             
-        st.executeUpdate(
-        		"INSERT INTO table1 VALUES (2147483649)");
+                    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, 'SC2', "
+                        + "'LaPosteSortPlan=B-W3-S2')");
             
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483649, "+
-        		"'AddressG4', 'BELGIQUE')");
+                    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, "
+                        + "'IsIdenticalToDocumentAddress', 'true')");
 
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483649, "+
-        		"'AddressG3', '1180, Bruxelles')");
+                    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, "
+                        + "'DocumentSortingValues', '______21855__1__1')");
 
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483649, 'ItemSeq', '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, "
+                        + "'BatchTypeInstructions', '')");
 
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483649, 'Plex', 'S')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483649, 'Plex', 'S')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483649, 'SC3', '=')");
+                    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, 'has_address', "+
+                        "'true')");
         
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483649, "
-                + "'SubBatchSortingValue', 'BE_B-W3-S2___')");
+                    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, 'Language', 'FR')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483649, 'logo', 'false')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483649, 'logo', 'false')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483649, 'SC4', '=')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483649, 'SC4', '=')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483649, "
-                + "'InternalAddress', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483649, "
+                        + "'InternalAddress', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483649, 'AddressG6', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483649, 'AddressG6', '')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483649, "
-                + "'InternalAddressBringer', 'false')");
+                    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, 'AddresseeSeq', '1')");
         
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483649, 'SC1', 'Country=BE')");
+                    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, "+
+                        "'CommunicationOrderId', '21865')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483649, "
-                + "'BatchTypeId', 'Paper')");
+                    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, '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, 'SortPlan', "
+                        + "'B-W3-S2')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483649, 'Enveloping', 'C')");
+                    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, "
+                        + "'PostComponentId', '21855')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483649, 'BatchTypeLabel', "+
-        		"'Paper')");
+                    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, 'city', 'Bruxelles')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483649, 'AddressG7', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483649, 'AddressG7', '')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483649, 'CopyMention', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483649, 'CopyMention', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483649, 'AddressG8', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483649, 'AddressG8', '')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483649, 'StapleNbr', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483649, 'StapleNbr', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483649, 'TLEBundle', "+
-        		"'Niveau2')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483649, 'TLEBundle', "+
+                        "'Niveau2')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483649, 'AddressG5', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483649, 'AddressG5', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483649, 'header', 'true')");
+                    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, "
+                        + "'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, 'GroupedWith', '')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483649, 'AddressG2', "
-                + "'Bla bla bla bla bla bla 99')");
+                    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, "+
+                        "'DiversionReason', '')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483649, 'Pliable', 'true')");
+                    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, 'TLEBinder', "+
+                        "'Niveau1')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483649, 'country', 'BE')");
+                    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, 'AddressG1', "+
+                        "'testOlivier001-0001')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483649, 'MentionCode', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483649, 'MentionCode', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483649, 'postCode', '1180')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483649, 'postCode', '1180')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483649, 'SC5', '=')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483649, 'SC5', '=')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483649, 'Branding', '1C')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483649, 'Branding', '1C')");
             
-        st.executeUpdate(
-        "INSERT INTO table1 VALUES (2147483650)");
+                    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, 'SC2', "+
+                        "'LaPosteSortPlan=B-W3-S2')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483650, 'AddressG4', "
-                + "'BELGIQUE')");
+                    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, "+
+                        "'IsIdenticalToDocumentAddress', 'true')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483650, 'AddressG3', "
-                + "'1180, Bruxelles')");
+                    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, "+
+                        "'DocumentSortingValues', '______21855__1__1')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483650, 'ItemSeq', '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, "+
+                        "'BatchTypeInstructions', '')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483650, 'Plex', 'S')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483650, 'Plex', 'S')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483650, 'SC3', '=')");
+                    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, "
+                        + "'has_address', 'true')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483650, " +
-        		"'SubBatchSortingValue', 'BE_B-W3-S2___')");
+                    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, 'Language', 'FR')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483650, 'logo', 'false')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483650, 'logo', 'false')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483650, 'SC4', '=')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483650, 'SC4', '=')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483650, "+
-        		"'InternalAddress', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483650, "+
+                        "'InternalAddress', '')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483650, 'AddressG6', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483650, 'AddressG6', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483650, "+
-        		"'InternalAddressBringer', 'false')");
+                    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, 'AddresseeSeq', '1')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483650, 'SC1', 'Country=BE')");
+                    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, "
+                        + "'CommunicationOrderId', '21865')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483650, 'BatchTypeId', 'Paper')");
+                    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, '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, 'SortPlan', 'B-W3-S2')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483650, 'Enveloping', 'C')");
+                    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, 'PostComponentId', "+
+                        "'21855')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483650, "
-                + "'BatchTypeLabel', 'Paper')");
+                    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, 'city', 'Bruxelles')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483650, 'AddressG7', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483650, 'AddressG7', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483650, 'CopyMention', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483650, 'CopyMention', '')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483650, 'AddressG8', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483650, 'AddressG8', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483650, 'StapleNbr', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483650, 'StapleNbr', '')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483650, 'TLEBundle', "
-                + "'Niveau2')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483650, 'TLEBundle', "
+                        + "'Niveau2')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483650, 'AddressG5', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483650, 'AddressG5', '')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483650, 'header', 'true')");
+                    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, "+
+                        "'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, 'GroupedWith', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483650, 'AddressG2', "+
-        		"'Bla bla bla bla bla bla 99')");
+                    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, "
+                        + "'DiversionReason', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483650, 'Pliable', 'true')");
+                    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, 'TLEBinder', "
+                        + "'Niveau1')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483650, 'country', 'BE')");
+                    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, 'AddressG1', "
+                        + "'testOlivier001-0001')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483650, 'MentionCode', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483650, 'MentionCode', '')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483650, 'postCode', '1180')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483650, 'postCode', '1180')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483650, 'SC5', '=')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483650, 'SC5', '=')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483650, 'Branding', '1C')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483650, 'Branding', '1C')");
         
-        st.executeUpdate(
-        		"INSERT INTO table1 VALUES (2147483651)");
+                    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, 'SC2', "
+                        + "'LaPosteSortPlan=B-W3-S2')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483651, 'AddressG4', "+
-        		"'BELGIQUE')");
+                    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, "
+                        + "'IsIdenticalToDocumentAddress', 'true')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483651, 'AddressG3', "+
-        		"'1180, Bruxelles')");
+                    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, "
+                        + "'DocumentSortingValues', '______21856__1__1')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483651, 'ItemSeq', '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, "
+                        + "'BatchTypeInstructions', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483651, 'Plex', 'S')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483651, 'Plex', 'S')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483651, 'SC3', '=')");
+                    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, 'has_address', 'true')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483651, "
-                + "'SubBatchSortingValue', 'BE_B-W3-S2___')");
+                    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, 'Language', 'FR')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483651, 'logo', 'false')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483651, 'logo', 'false')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483651, 'SC4', '=')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483651, 'SC4', '=')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483651, "
-                + "'InternalAddress', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483651, "
+                        + "'InternalAddress', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483651, 'AddressG6', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483651, 'AddressG6', '')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483651, "
-                + "'InternalAddressBringer', 'false')");
+                    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, 'AddresseeSeq', '1')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483651, 'SC1', 'Country=BE')");
+                    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, "+
+                        "'CommunicationOrderId', '21866')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483651, "
-                + "'BatchTypeId', 'Paper')");
+                    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, '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, 'SortPlan', "
+                        + "'B-W3-S2')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483651, 'Enveloping', 'C')");
+                    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, "
+                        + "'PostComponentId', '21856')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483651, 'BatchTypeLabel', 'Paper')");
+                    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, 'city', 'Bruxelles')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483651, 'AddressG7', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483651, 'AddressG7', '')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483651, 'CopyMention', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483651, 'CopyMention', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483651, 'AddressG8', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483651, 'AddressG8', '')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483651, 'StapleNbr', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483651, 'StapleNbr', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483651, 'TLEBundle', 'Niveau2')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483651, 'TLEBundle', 'Niveau2')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483651, 'AddressG5', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483651, 'AddressG5', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483651, 'header', 'true')");
+                    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, "
+                        + "'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, 'GroupedWith', '')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483651, 'AddressG2', "
-                + "'Bla bla bla bla bla bla 99')");
+                    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, 'DiversionReason', '')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483651, 'Pliable', 'true')");
+                    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, 'TLEBinder', 'Niveau1')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483651, 'country', 'BE')");
+                    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, 'AddressG1', "+
+                        "'testOlivier001-0002')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483651, 'MentionCode', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483651, 'MentionCode', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483651, 'postCode', '1180')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483651, 'postCode', '1180')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483651, 'SC5', '=')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483651, 'SC5', '=')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483651, 'Branding', '1C')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483651, 'Branding', '1C')");
             
-        st.executeUpdate(
-        "INSERT INTO table1 VALUES (2147483652)");
+                    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, 'SC2', 'LaPosteSortPlan=B-W3-S2')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483652, 'AddressG4', "
-                + "'BELGIQUE')");
+                    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, "+
+                        "'IsIdenticalToDocumentAddress', 'true')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483652, 'AddressG3', "
-                + "'1180, Bruxelles')");
+                    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, "+
+                        "'DocumentSortingValues', '______21856__1__1')");
 
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483652, 'ItemSeq', '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, 'BatchTypeInstructions', '')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483652, 'Plex', 'S')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483652, 'Plex', 'S')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483652, 'SC3', '=')");
+                    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, "
+                        + "'has_address', 'true')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483652, 'SubBatchSortingValue', 'BE_B-W3-S2___')");
+                    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, 'Language', 'FR')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483652, 'logo', 'false')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483652, 'logo', 'false')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483652, 'SC4', '=')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483652, 'SC4', '=')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483652, 'InternalAddress', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483652, 'InternalAddress', '')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483652, 'AddressG6', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483652, 'AddressG6', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483652, 'InternalAddressBringer', 'false')");
+                    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, 'AddresseeSeq', '1')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483652, 'SC1', 'Country=BE')");
+                    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, "
+                        + "'CommunicationOrderId', '21866')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483652, 'BatchTypeId', 'Paper')");
+                    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, '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, 'SortPlan', 'B-W3-S2')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483652, 'Enveloping', 'C')");
+                    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, 'PostComponentId', '21856')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483652, "
-                + "'BatchTypeLabel', 'Paper')");
+                    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, 'city', 'Bruxelles')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483652, 'AddressG7', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483652, 'AddressG7', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483652, 'CopyMention', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483652, 'CopyMention', '')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483652, 'AddressG8', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483652, 'AddressG8', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483652, 'StapleNbr', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483652, 'StapleNbr', '')");
             
-        st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483652, 'TLEBundle', "
-                + "'Niveau2')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483652, 'TLEBundle', "
+                        + "'Niveau2')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483652, 'AddressG5', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483652, 'AddressG5', '')");
             
-        st.executeUpdate(
-        "INSERT INTO table2 VALUES (2147483652, 'header', 'true')");
+                    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, '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, 'GroupedWith', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483652, 'AddressG2', 'Bla bla bla bla bla bla 99')");
+                    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, "
+                        + "'DiversionReason', '')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483652, 'Pliable', 'true')");
+                    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, 'TLEBinder', "
+                        + "'Niveau1')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483652, 'country', 'BE')");
+                    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, 'AddressG1', "
+                        + "'testOlivier001-0002')");
         
-        st.executeUpdate(
-        		"INSERT INTO table2 VALUES (2147483652, 'MentionCode', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483652, 'MentionCode', '')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483652, 'postCode', '1180')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483652, 'postCode', '1180')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483652, 'SC5', '=')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483652, 'SC5', '=')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483652, 'Branding', '1C')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483652, 'Branding', '1C')");
             
-            st.executeUpdate(
-            		"INSERT INTO table1 VALUES (2147483653)");
+                    st.executeUpdate(
+                        "INSERT INTO table1 VALUES (2147483653)");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, 'SC2', "
-                + "'PostCode=1180')");
+                    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, 'AddressG4', 'BELGIQUE')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, "
-                + "'IsIdenticalToDocumentAddress', 'true')");
+                    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, 'AddressG3', '1180 Bruxelles')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, "
-                + "'DocumentSortingValues', '______21857__1__1')");
+                    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, '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, "
+                        + "'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, 'Plex', 'S')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, 'SC3', '=')");
+                    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, 'has_address', 'true')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, "
-                + "'SubBatchSortingValue', 'ddch257___1180______')");
+                    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, 'Language', 'FR')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, 'logo', 'false')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483653, 'logo', 'false')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483653, 'SC4', '=')");
+                    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, "
+                        + "'InternalAddress', '233/621')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483653, 'AddressG6', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483653, 'AddressG6', '')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, "
-                + "'InternalAddressBringer', 'true')");
+                    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, 'AddresseeSeq', '1')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, 'SC1', "
-                + "'Requester=ddch257')");
+                    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, "+
+                        "'CommunicationOrderId', '21867')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, "
-                + "'BatchTypeId', '233-621-001')");
+                    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, 'location', "+
+                        "'Bla bla bla bla bla bla 99')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, 'SortPlan', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483653, 'SortPlan', '')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483653, 'Enveloping', 'N')");
+                    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, "
+                        + "'PostComponentId', '21857')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483653, "+
-            		"'BatchTypeLabel', 'Diversion pour test')");
+                    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, 'city', 'Bruxelles')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483653, 'AddressG7', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483653, 'AddressG7', '')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, 'CopyMention', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483653, 'CopyMention', '')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483653, 'AddressG8', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483653, 'AddressG8', '')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, 'StapleNbr', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483653, 'StapleNbr', '')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483653, 'TLEBundle', "+
-            		"'Niveau2')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483653, 'TLEBundle', "+
+                        "'Niveau2')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, 'AddressG5', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483653, 'AddressG5', '')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483653, 'header', 'true')");
+                    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, "
+                        + "'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, 'GroupedWith', '')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, 'AddressG2', "
-                + "'Bla bla bla bla bla bla 99')");
+                    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, "+
+                        "'DiversionReason', '001')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, 'Pliable', 'true')");
+                    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, 'TLEBinder', "+
+                        "'Niveau1')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, 'country', 'BE')");
+                    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, 'AddressG1', "+
+                        "'testOlivier002-0003')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, 'MentionCode', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483653, 'MentionCode', '')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483653, 'postCode', '1180')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483653, 'postCode', '1180')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483653, 'SC5', '=')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483653, 'SC5', '=')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483653, 'Branding', '1C')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483653, 'Branding', '1C')");
             
-            st.executeUpdate(
-                "INSERT INTO table1 VALUES (2147483654)");
+                    st.executeUpdate(
+                        "INSERT INTO table1 VALUES (2147483654)");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, 'SC2', 'PostCode=1180')");
+                    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, 'AddressG4', "
+                        + "'BELGIQUE')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, "+
-            		"'IsIdenticalToDocumentAddress', 'true')");
+                    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, 'AddressG3', "
+                        + "'1180 Bruxelles')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, "+
-            		"'DocumentSortingValues', '______21857__1__1')");
+                    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, '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, "+
+                        "'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, 'Plex', 'S')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, 'SC3', '=')");
+                    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, "
+                        + "'has_address', 'true')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, "+
-            		"'SubBatchSortingValue', 'ddch257___1180______')");
+                    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, 'Language', 'FR')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, 'logo', 'false')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483654, 'logo', 'false')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483654, 'SC4', '=')");
+                    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, 'InternalAddress',"+
+                        "'233/621')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483654, 'AddressG6', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483654, 'AddressG6', '')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, "+
-            		"'InternalAddressBringer', 'true')");
+                    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, 'AddresseeSeq', '1')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, 'SC1', 'Requester=ddch257')");
+                    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, "
+                        + "'CommunicationOrderId', '21867')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, 'BatchTypeId', '233-621-001')");
+                    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, 'location', "
+                        + "'Bla bla bla bla bla bla 99')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, 'SortPlan', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483654, 'SortPlan', '')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483654, 'Enveloping', 'N')");
+                    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, 'PostComponentId', '21857')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483654, "
-                + "'BatchTypeLabel', 'Diversion pour test')");
+                    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, 'city', 'Bruxelles')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483654, 'AddressG7', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483654, 'AddressG7', '')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, 'CopyMention', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483654, 'CopyMention', '')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483654, 'AddressG8', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483654, 'AddressG8', '')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, 'StapleNbr', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483654, 'StapleNbr', '')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483654, 'TLEBundle', "
-                + "'Niveau2')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483654, 'TLEBundle', "
+                        + "'Niveau2')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, 'AddressG5', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483654, 'AddressG5', '')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483654, 'header', 'true')");
+                    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, "+
+                        "'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, 'GroupedWith', '')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, 'AddressG2', "+
-            		"'Bla bla bla bla bla bla 99')");
+                    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, "
+                        + "'DiversionReason', '001')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, 'Pliable', 'true')");
+                    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, 'TLEBinder', "
+                        + "'Niveau1')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, 'country', 'BE')");
+                    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, 'AddressG1', "
+                        + "'testOlivier002-0003')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, 'MentionCode', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483654, 'MentionCode', '')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483654, 'postCode', '1180')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483654, 'postCode', '1180')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483654, 'SC5', '=')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483654, 'SC5', '=')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483654, 'Branding', '1C')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483654, 'Branding', '1C')");
             
-            st.executeUpdate(
-            		"INSERT INTO table1 VALUES (2147483655)");
+                    st.executeUpdate(
+                        "INSERT INTO table1 VALUES (2147483655)");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483655, 'SC2', "
-                + "'PostCode=1180')");
+                    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, 'AddressG4', 'BELGIQUE')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483655, "
-                + "'IsIdenticalToDocumentAddress', 'true')");
+                    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, 'AddressG3', '1180 Bruxelles')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483655, "
-                + "'DocumentSortingValues', '______21858__1__1')");
+                    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, '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, "
+                        + "'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, 'Plex', 'S')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483655, 'SC3', '=')");
+                    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, 'has_address', 'true')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483655, "
-                + "'SubBatchSortingValue', 'ddch257___1180______')");
+                    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, 'Language', 'FR')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483655, 'logo', 'false')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483655, 'logo', 'false')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483655, 'SC4', '=')");
+                    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, "
+                        + "'InternalAddress', '233/621')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483655, 'AddressG6', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483655, 'AddressG6', '')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483655, "
-                + "'InternalAddressBringer', 'true')");
+                    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, 'AddresseeSeq', '1')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483655, 'SC1', "
-                + "'Requester=ddch257')");
+                    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, "+
+                        "'CommunicationOrderId', '21868')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483655, "
-                + "'BatchTypeId', '233-621-001')");
+                    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, 'location', "+
+                        "'Bla bla bla bla bla bla 99')");
             
-            st.executeUpdate(
-                "INSERT INTO table2 VALUES (2147483655, 'SortPlan', '')");
+                    st.executeUpdate(
+                        "INSERT INTO table2 VALUES (2147483655, 'SortPlan', '')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483655, 'Enveloping', 'N')");
+                    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, "
+                        + "'PostComponentId', '21858')");
             
-            st.executeUpdate(
-            		"INSERT INTO table2 VALUES (2147483655, "+
-            		"'BatchTypeLabel', 'Diversion pour test')");
+                    st.executeUpdate(

[... 15269 lines stripped ...]


Mime
View raw message