You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by da...@apache.org on 2009/10/16 00:19:20 UTC
svn commit: r825682 [2/2] -
/db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/OrderByAndSortAvoidance.java
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 ...]