[Bug 1449940] [NEW] 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]

Public bug reported:

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[]) {

        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;
    }

    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)

** Affects: mailman
     Importance: Undecided
         Status: New


** Tags: client-jdbc-t2

** Tags added: client-jdbc-t2

-- 
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