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.
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)
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 {
MySingleThr ead(Connection conn) {
this.conn = conn;
}
public void run() { createStatement ();
stmt. execute( "get tables");
stmt. close() ;
conn. close() ;
Statement stmt = this.conn.
}
}
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. SQLException: *** ERROR[2055] The specified value 'OFF' for DEFAULTS attribute ACCEPTABLE_ INPUTESTLOGPROP _ERROR is not valid. jdbc.t2. SQLMXStatement. executeDirect( Native Method) jdbc.t2. SQLMXStatement. execute( SQLMXStatement. java:143) run(TestMultiTh reads.java: 79) Thread. run(Thread. java:745)
java.sql.
at org.trafodion.
at org.trafodion.
at MySingleThread.
at java.lang.