2015-04-29 10:14:51 |
Yu Bo |
description |
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) |
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) |
|