With T2 jdbc driver, autocommit off is not effective, when its set before statement handle is allocated.

Bug #1369847 reported by Aruna Sadashiva
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
Fix Committed
High
Arvind Narain

Bug Description

With JDBC T2 driver, autocommit off is not working with the performance OE test. It works ok when setAutoCommit(false) is called after creating statement handle.
Error returned: ERROR[8605] Committing a transaction which has not started.

summary: - With T2 jdbc driver, autocommit off is not effective
+ With T2 jdbc driver, autocommit off is not effective, when its set
+ before statement handle is allocated.
description: updated
Jian Jin (jian-jin)
Changed in trafodion:
assignee: Selvaganesan Govindarajan (selva-ganesan) → Arvind Narain (arvind-narain)
Changed in trafodion:
status: New → In Progress
Revision history for this message
Arvind Narain (arvind-narain) wrote :

Coded the fix for the bug. Cleaning up the code related to transactions.

Output from the test program:

/designs/seaquest/narain/t2>java -Dprop=t2prop bug
Auto Commit is : false
Data : 12

Earlier:
/designs/seaquest/narain/t2>java -Dprop=t2prop bug
Auto Commit is : false
Exception...*** ERROR[8605] Committing a transaction which has not started.

Revision history for this message
Pavani Puppala (pavani-puppala) wrote :

Lowered priority to high since T2 is not for 0.9 release.

Changed in trafodion:
importance: Critical → High
Changed in trafodion:
milestone: r0.9 → r1.0
Revision history for this message
Arvind Narain (arvind-narain) wrote :

Fix for auto commit got merged from another branch. Will deliver code cleanup separately.

Changed in trafodion:
status: In Progress → Fix Committed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.