[ psqlodbc-Bugs-1000455 ] Autocommit, Cancel and DateStyle

Bugs item #1000455, was opened at 2005-11-29 13:29
You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000455&group_id=1000125

Category: None
Group: None
>Status: Closed
Resolution: None
Priority: 3
Submitted By: Nobody (None)
Assigned to: Nobody (None)
Summary: Autocommit, Cancel and DateStyle

Initial Comment:
In our application we use autocommit mode.
Right after connection is on, driver issuing BEGIN and several SETs.
We're interesting in: SET DateStyle TO 'ISO'.
After that we're issuing several SELECT statements from application, so transaction is still open.
In parallel application thread we're cancelling one of our SELECTs, after that driver issuing ROLLBACK to the open
transaction.
So, we've lost drivers DateStyle. Our default database style is European,SQL. From this point current connection
continueworking with default style. So, driver couldn't deliver timestamp fields value correctly. 

----------------------------------------------------------------------

>Comment By: Dave Page  (dpage)
Date: 2005-11-30 13:49

Message:
The 08.00 version of the driver is no longer supported as the architecture has changed significantly. Please report any
bugsin the latest 08.01 version with appropriate mylog output and we will try to help. 

----------------------------------------------------------------------

Comment By: Ludek Finstrle (luf)
Date: 2005-11-30 13:36

Message:
Which version of psqlodbc do you use?
Could you post mylog output?

----------------------------------------------------------------------

Comment By: Nobody (None)
Date: 2005-11-29 14:29

Message:
This description is for 08.00 version.
In 08.01 version "cancel" doesn't work correctly, because it doesn't issuing ROLLBACK after cancel exception at all, so
I'mgetting open transaction with error state. 
Also, I want to say, that for "cancel" operation I'm using "Threading=0" in odbcinst.ini. Otherwise "cancel" will wait
untilstatement finish. 

----------------------------------------------------------------------

You can respond by visiting:
http://pgfoundry.org/tracker/?func=detail&atid=538&aid=1000455&group_id=1000125