[Bug 1449940] Re: java.sql.SQLException: *** ERROR[2055] The specified value 'OFF' for DEFAULTS attribute ACCEPTABLE_INPUTESTLOGPROP_ERROR is not valid.---*** ERROR[2055] The specified value 'OFF' for DEFAULTS attribute ACCEPTABLE_INPUTESTLOGPROP_ERROR is not valid.

[Yu Bo]

** Description changed:

  Defect Description: When transfer a connection object to the constructor
  of a Runnable interface, the Sql exception ERROR 2055 will be caught if
  execute a simple Sql stmt that is created by this connection object.
  
  Test Environment:
  
  sqws139.houston.hp.com, T2 driver.
  
  Test Steps:
  
  Step 1. Create a user connection object in static main function.
  
  for example:
  
  public class TestMultiThread {
  
-     public static void main(String args[]) {
+     public static void main(String args[]) {
  
-         Connection conn = MyConnection.initConnection(0);
-         ...
-    }
+         Connection conn = MyConnection.initConnection(0);
+         ...
+    }
  }
  
  Step 2. Implement a Runnable interface and Write a constructor with only
  1 parameter that is a Connection object.
  
  for example:
  
  class MySingleThread implemnts Runnable {
  
-     MySingleThread(Connection conn) {
-         this.conn = conn;
-     }
+     Connection conn = null;
  
-     public void run() {
-          Statement stmt = this.conn.createStatement();
-          stmt.execute("get tables");
-          stmt.close();
-          conn.close();
-     }
+     MySingleThread(Connection conn) {
+         this.conn = conn;
+     }
+ 
+     public void run() {
+          Statement stmt = this.conn.createStatement();
+          stmt.execute("get tables");
+          stmt.close();
+          conn.close();
+     }
  }
  
  Step 3. Start a thread to do test in static main function.
  
  for example:
  
  Thread t = new Thread(new MySingleThread(conn));
  t.start();
  t.join();
  
  In the above steps, the line 'stmt.execute("get tables")' will throw a
  Sql exception as below,
  
  java.sql.SQLException: *** ERROR[2055] The specified value 'OFF' for DEFAULTS attribute ACCEPTABLE_INPUTESTLOGPROP_ERROR is not valid.---*** ERROR[2055] The specified value 'OFF' for DEFAULTS attribute ACCEPTABLE_INPUTESTLOGPROP_ERROR is not valid.
  java.sql.SQLException: *** ERROR[2055] The specified value 'OFF' for DEFAULTS attribute ACCEPTABLE_INPUTESTLOGPROP_ERROR is not valid.
-         at org.trafodion.jdbc.t2.SQLMXStatement.executeDirect(Native Method)
-         at org.trafodion.jdbc.t2.SQLMXStatement.execute(SQLMXStatement.java:143)
-         at MySingleThread.run(TestMultiThreads.java:79)
-         at java.lang.Thread.run(Thread.java:745)
+         at org.trafodion.jdbc.t2.SQLMXStatement.executeDirect(Native Method)
+         at org.trafodion.jdbc.t2.SQLMXStatement.execute(SQLMXStatement.java:143)
+         at MySingleThread.run(TestMultiThreads.java:79)
+         at java.lang.Thread.run(Thread.java:745)

-- 
You received this bug notification because you are a member of Mailman
Coders, which is subscribed to GNU Mailman.
https://bugs.launchpad.net/bugs/1449940

Title:
  java.sql.SQLException: *** ERROR[2055] The specified value 'OFF' for
  DEFAULTS attribute ACCEPTABLE_INPUTESTLOGPROP_ERROR is not
  valid.---*** ERROR[2055] The specified value 'OFF' for DEFAULTS
  attribute ACCEPTABLE_INPUTESTLOGPROP_ERROR is not valid.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mailman/+bug/1449940/+subscriptions