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.

Bug #1449940 reported by Yu Bo
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
In Progress
Medium
Selvaganesan Govindarajan

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

    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)

Yu Bo (byu)
tags: added: client-jdbc-t2
Yu Bo (byu)
description: updated
Revision history for this message
Mark Sapiro (msapiro) wrote :

How is this a Mailman bug?

Changed in mailman:
status: New → Incomplete
Yu Bo (byu)
affects: mailman → trafodion
Changed in trafodion:
status: Incomplete → New
Revision history for this message
Yu Bo (byu) wrote :

SQL Team is investigating on it.

Changed in trafodion:
assignee: nobody → Weiqing Xu (wei-qing-xu)
milestone: none → r2.0
Revision history for this message
Chen-Yun Fan (chen-yun-fan) wrote :

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

Changed in trafodion:
assignee: Weiqing Xu (wei-qing-xu) → Selvaganesan Govindarajan (selva-ganesan)
importance: Undecided → Medium
Yu Bo (byu)
Changed in trafodion:
status: New → In Progress
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers