[jira] [Created] (TRAFODION-787) LP Bug: 1395212 - With multiple statements, all statement handles seem to get closed on commit

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-787:
------------------------------------

             Summary: LP Bug: 1395212 - With multiple statements, all statement handles seem to get closed on commit
                 Key: TRAFODION-787
                 URL: https://issues.apache.org/jira/browse/TRAFODION-787
             Project: Apache Trafodion
          Issue Type: Bug
          Components: client-jdbc-t2
            Reporter: Aruna Sadashiva
            Assignee: Zhang, Xiu-Zhu
            Priority: Critical
             Fix For: 1.1 (pre-incubation)


The following sequence fails with T2 driver:

trafodion@n013 multi]$ java SimpleMultiConn Test with 2 connections...
Connected.
Created test tables.
Auto Commit off.
Insert 1 using stmt1.
[Selva] Select from conn1
Fetch one row

Insert 1 using stmt 2.
[Selva] Select from conn2
Fetch one row

Insert 2 using stmt1.
Insert 2 using stmt2.
[Selva] Fetch second row from conn1
Fetch Second row from conn2
Commit 1 for conn 1.
Commit 2 for conn 2.
Committed.
Select from conn1
1     Moe                      100
2     Larry                    -100
3     Curly                    100
4     Moe                      100
5     Larry                    -100
6     Curly                    100
6 rows fetched from SampleTable1
Select from conn2
1     Moe                      100
2     Larry                    -100
3     Curly                    100
4     Moe                      100
5     Larry                    -100
6     Curly                    100
6 rows fetched from SampleTable2
Now trying updates with prepared statements...
Update 1 using pstmt1.
Update 1 using pstmt2.
Update 2 using pstmt1.
Update 2 using pstmt2.
Updates done with prepared statements.
Commit 1 for conn 1.
Commit 2 for conn 2.
Committed.
Select from conn1
SQLException:
*** ERROR[8813] Trying to fetch from a statement that is in the closed state.
SQLState   24000
Error Code -8813
Done.
[trafodion@n013 multi]$

Please contact me if you want the java source for this test. The test name is SimpleMultiConn.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)