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]

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 {

    Connection conn = null;

    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)

[Mark Sapiro (msapiro)]

How is this a Mailman bug?

[Yu Bo (byu)]

SQL Team is investigating on it.

[Chen-Yun Fan (chen-yun-fan)]

It was that alternate CQD being unilitialized issue. Reassign to SQL team after Sandhya's confirmation. I attached the related email for the reference.