2014-11-21 22:13:06 |
Aruna Sadashiva |
bug |
|
|
added bug |
2014-11-22 00:27:26 |
Aruna Sadashiva |
description |
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 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. |
|
2014-11-24 13:55:26 |
Pavani Puppala |
trafodion: assignee |
|
Pavani Puppala (pavani-puppala) |
|
2014-11-24 13:55:33 |
Pavani Puppala |
trafodion: status |
New |
In Progress |
|
2014-11-25 12:48:38 |
Pavani Puppala |
trafodion: assignee |
Pavani Puppala (pavani-puppala) |
RuoYu Zuo (ruo-yu-zuo) |
|
2014-12-11 13:31:21 |
Pavani Puppala |
trafodion: assignee |
RuoYu Zuo (ruo-yu-zuo) |
Pavani Puppala (pavani-puppala) |
|
2014-12-17 06:45:27 |
Aruna Sadashiva |
summary |
With multiple connections and statements, all statement handles seem to get closed on commit |
With multiple statements, all statement handles seem to get closed on commit |
|
2015-01-15 00:49:30 |
Pavani Puppala |
trafodion: status |
In Progress |
Fix Committed |
|
2015-03-03 05:17:11 |
xiu-zhu.zhang |
trafodion: assignee |
Pavani Puppala (pavani-puppala) |
xiu-zhu.zhang (xiu-zhu-zhang) |
|
2015-03-03 05:21:36 |
xiu-zhu.zhang |
trafodion: assignee |
xiu-zhu.zhang (xiu-zhu-zhang) |
|
|
2015-03-03 05:21:41 |
xiu-zhu.zhang |
trafodion: assignee |
|
xiu-zhu.zhang (xiu-zhu-zhang) |
|
2015-03-03 05:21:51 |
xiu-zhu.zhang |
trafodion: status |
Fix Committed |
In Progress |
|
2015-03-05 01:34:33 |
xiu-zhu.zhang |
trafodion: status |
In Progress |
Fix Committed |
|
2015-03-05 14:58:26 |
Jian Jin |
trafodion: milestone |
r1.0 |
r1.1 |
|