db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ma...@apache.org
Subject svn commit: r767584 [2/3] - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting: functionTests/tests/lang/OrderByAndSortAvoidance.java junit/RuntimeStatisticsParser.java
Date Wed, 22 Apr 2009 16:26:42 GMT

Added: 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=767584&view=auto
==============================================================================
--- db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/OrderByAndSortAvoidance.java (added)
+++ db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/OrderByAndSortAvoidance.java Wed Apr 22 16:26:42 2009
@@ -0,0 +1,10109 @@
+/*
+ * Class org.apache.derbyTesting.functionTests.tests.lang.OrderByAndSortAvoidance
+ *
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *   http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing,
+ * software distributed under the License is distributed on an
+ * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ * KIND, either express or implied.  See the License for the
+ * specific language governing permissions and limitations
+ * under the License.
+ */
+
+package org.apache.derbyTesting.functionTests.tests.lang;
+
+import java.sql.SQLException;
+import java.sql.Statement;
+import java.sql.ResultSet;
+import junit.framework.Test;
+import org.apache.derbyTesting.junit.BaseJDBCTestCase;
+import org.apache.derbyTesting.junit.JDBC;
+import org.apache.derbyTesting.junit.TestConfiguration;
+import org.apache.derbyTesting.junit.RuntimeStatisticsParser;
+import org.apache.derbyTesting.junit.SQLUtilities;
+
+/**
+ * Tests for DERBY-3926. Optimizer is choosing to avoid sort which is
+ * causing the results to be returned in wrong order.
+ */
+public class OrderByAndSortAvoidance extends BaseJDBCTestCase {
+
+    public OrderByAndSortAvoidance(String name) {
+        super(name);
+    }
+
+    public static Test suite() {
+        return TestConfiguration.defaultSuite(OrderByAndSortAvoidance.class);
+    }
+
+    protected void setUp() throws SQLException {
+        getConnection().setAutoCommit(false);
+        Statement st = createStatement();
+
+        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 UNIQUE INDEX key2 ON table2(id, name)");
+        
+        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', "+
+        		"'Boulevard du Souverain, 23')");
+            
+        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___________Boulevard "
+                + "du Souverain, 23____')");
+        
+        st.executeUpdate(
+        		"INSERT INTO table2 VALUES (2147483649, 'GroupedWith', '')");
+            
+        st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483649, 'AddressG2', "
+                + "'Boulevard du Souverain, 23')");
+        
+        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', "
+                + "'Boulevard du Souverain, 23')");
+        
+        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"+
+        		"___________Boulevard du Souverain, 23____')");
+            
+        st.executeUpdate(
+        "INSERT INTO table2 VALUES (2147483650, 'GroupedWith', '')");
+        
+        st.executeUpdate(
+        		"INSERT INTO table2 VALUES (2147483650, 'AddressG2', "+
+        		"'Boulevard du Souverain, 23')");
+            
+        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', "+
+        		"'Boulevard du Souverain, 23')");
+            
+        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___________Boulevard "
+                + "du Souverain, 23____')");
+        
+        st.executeUpdate(
+        		"INSERT INTO table2 VALUES (2147483651, 'GroupedWith', '')");
+            
+        st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483651, 'AddressG2', "
+                + "'Boulevard du Souverain, 23')");
+        
+        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', "
+                + "'Boulevard du Souverain, 23')");
+        
+        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___________Boulevard du Souverain, 23____')");
+            
+        st.executeUpdate(
+        "INSERT INTO table2 VALUES (2147483652, 'GroupedWith', '')");
+        
+        st.executeUpdate(
+        		"INSERT INTO table2 VALUES (2147483652, 'AddressG2', 'Boulevard du Souverain, 23')");
+            
+        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 été 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', "+
+            		"'Boulevard du Souverain, 23')");
+            
+            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___________Boulevard "
+                + "du Souverain, 23____')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483653, 'GroupedWith', '')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483653, 'AddressG2', "
+                + "'Boulevard du Souverain, 23')");
+            
+            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 été 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', "
+                + "'Boulevard du Souverain, 23')");
+            
+            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___________Boulevard du Souverain, 23____')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483654, 'GroupedWith', '')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483654, 'AddressG2', "+
+            		"'Boulevard du Souverain, 23')");
+            
+            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 été 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', "+
+            		"'Boulevard du Souverain, 23')");
+            
+            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___________Boulevard "
+                + "du Souverain, 23____')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483655, 'GroupedWith', '')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483655, 'AddressG2', "
+                + "'Boulevard du Souverain, 23')");
+            
+            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 "+
+            		"été 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', "
+                + "'Boulevard du Souverain, 23')");
+            
+            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(
+            		"INSERT INTO table1 VALUES (2147483661)");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, 'SC2', "
+                + "'LaPosteSortPlan=B-W3-S2')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'AddressG4', 'BELGIQUE')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, "
+                + "'IsIdenticalToDocumentAddress', 'true')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'AddressG3', '1180, Bruxelles')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, "
+                + "'DocumentSortingValues', '______21861__1__1')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'ItemSeq', '1')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, "
+                + "'BatchTypeInstructions', '')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'Plex', 'S')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, 'SC3', '=')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'has_address', 'true')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, "
+                + "'SubBatchSortingValue', 'BE_B-W3-S2___')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'Language', 'FR')");
+
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, 'logo', 'false')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'SC4', '=')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, "
+                + "'InternalAddress', '')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'AddressG6', '')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, "
+                + "'InternalAddressBringer', 'false')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'AddresseeSeq', '1')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, 'SC1', 'Country=BE')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'CommunicationOrderId', '21871')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, "
+                + "'BatchTypeId', 'Paper')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'location', 'Boulevard du Souverain, 23')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, 'SortPlan', "
+                + "'B-W3-S2')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'Enveloping', 'C')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, "
+                + "'PostComponentId', '21861')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'BatchTypeLabel', 'Paper')");
+
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, 'city', 'Bruxelles')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'AddressG7', '')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, 'CopyMention', '')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'AddressG8', '')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, 'StapleNbr', '')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'TLEBundle', 'Niveau2')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, 'AddressG5', '')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'header', 'true')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, "
+                + "'EnvelopSortingValue', "
+                + "'BE1180___testOlivier004-0007___________Boulevard "
+                + "du Souverain, 23____')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'GroupedWith', '')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, 'AddressG2', "
+                + "'Boulevard du Souverain, 23')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'DiversionReason', '')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, 'Pliable', 'true')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'TLEBinder', 'Niveau1')");
+
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, 'country', 'BE')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'AddressG1', 'testOlivier004-0007')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, 'MentionCode', '')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'postCode', '1180')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483661, 'SC5', '=')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483661, 'Branding', '1C')");
+            
+            st.executeUpdate(
+                "INSERT INTO table1 VALUES (2147483662)");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'SC2', 'LaPosteSortPlan=B-W3-S2')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, 'AddressG4', "
+                + "'BELGIQUE')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'IsIdenticalToDocumentAddress', 'true')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, 'AddressG3', "
+                + "'1180, Bruxelles')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'DocumentSortingValues', '______21861__1__1')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, 'ItemSeq', '1')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'BatchTypeInstructions', '')");
+
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, 'Plex', 'S')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'SC3', '=')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, "
+                + "'has_address', 'true')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'SubBatchSortingValue', 'BE_B-W3-S2___')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, 'Language', 'FR')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'logo', 'false')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, 'SC4', '=')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'InternalAddress', '')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, 'AddressG6', '')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'InternalAddressBringer', 'false')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, 'AddresseeSeq', '1')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'SC1', 'Country=BE')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, "
+                + "'CommunicationOrderId', '21871')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'BatchTypeId', 'Paper')");
+
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, 'location', "
+                + "'Boulevard du Souverain, 23')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'SortPlan', 'B-W3-S2')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, 'Enveloping', 'C')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'PostComponentId', '21861')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, "
+                + "'BatchTypeLabel', 'Paper')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'city', 'Bruxelles')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, 'AddressG7', '')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'CopyMention', '')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, 'AddressG8', '')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'StapleNbr', '')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, 'TLEBundle', "
+                + "'Niveau2')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'AddressG5', '')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, 'header', 'true')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'EnvelopSorting"+
+            		"Value', 'BE1180___testOlivier004-0007___________Boulev"+
+            		"ard du Souverain, 23____')");
+
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, 'GroupedWith', '')");
+            
+            st.executeUpdate(
+            		"INSERT INTO table2 VALUES (2147483662, 'AddressG2', 'Boulevard du Souverain, 23')");
+            
+            st.executeUpdate(
+                "INSERT INTO table2 VALUES (2147483662, "

[... 7858 lines stripped ...]


Mime
View raw message