commit c7dcee5380df56b2e9ca732ec3aa5afda1f0297f
author sathwik <sathwik@apache.org> Mon Aug 03 15:01:33 2015 +0530
committer sathwik <sathwik@apache.org> Mon Aug 03 15:01:33 2015 +0530
tree dee58e6b113f775112834823fac7ec3a716ef14e
parent 74d9490384ee1a487df3e1e0d0edbba9879bbbe7

ODE-1034: JdbcExternalVariableEngineTest fixed

bpel-runtime/src/test/java/org/apache/ode/bpel/extvar/jdbc/JdbcExternalVariableEngineTest.java

diff --git a/bpel-runtime/src/test/java/org/apache/ode/bpel/extvar/jdbc/JdbcExternalVariableEngineTest.java b/bpel-runtime/src/test/java/org/apache/ode/bpel/extvar/jdbc/JdbcExternalVariableEngineTest.java
index 3f7c64a..ee2716e 100644
--- a/bpel-runtime/src/test/java/org/apache/ode/bpel/extvar/jdbc/JdbcExternalVariableEngineTest.java
+++ b/bpel-runtime/src/test/java/org/apache/ode/bpel/extvar/jdbc/JdbcExternalVariableEngineTest.java
@@ -63,17 +63,22 @@
         _ds.setDatabase("jdbc:hsqldb:mem:" + new GUID().toString());
         _ds.setUser("sa");
 
+        //this is to allow column names to start with underscores.
+        Properties prop = new Properties();
+        prop.setProperty("sql.regular_names", "false");
+        _ds.setProperties(prop);
+
         Connection conn = _ds.getConnection();
         Statement s = conn.createStatement();
         s.execute("create table extvartable1 (" +
-                "id1 VARCHAR PRIMARY KEY," +
-                "_id2_ VARCHAR," +
-                "pid VARCHAR, " +
+                "id1 VARCHAR(255) PRIMARY KEY," +
+                "_id2_ VARCHAR(255)," +
+                "pid VARCHAR(255), " +
                 "iid INT," +
                 "cts DATETIME," +
                 "uts DATETIME," +
-                "foo VARCHAR," +
-                "bar VARCHAR );");
+                "foo VARCHAR(255)," +
+                "bar VARCHAR(255));");
 
         _engine = new JdbcExternalVariableModule();
         _engine.registerDataSource("testds",_ds);