Hello Andrus,
We've set the autocommit to true using a TransactionDelegate but
somehow, it appears the flag is later on reset automatically to false.
As you advised, the autocommit has been set to true in
willAddConnection, but when didRollback or didCommit is called, we
figured out the flag has been reset to false. So it seems the
setAutoCommit is not taken into account, and then of course our issue
still persists.
Please can you advise?
Thanks a lot
Marc
-----Original Message-----
From: Andrus Adamchik [mailto:andru..bjectstyle.org]
Sent: Monday, April 28, 2008 2:48 PM
To: use..ayenne.apache.org
Subject: Re: Stored proc returning result set (and output params) with
MS SQL server
On Apr 28, 2008, at 3:41 PM, Marc Gabriel-Willem wrote:
> Dear Andrus,
>
> Have you got a chance to work on the problem?
No, not yet.
> For a summary, our investigations show that using JDBC, the 'auto
> commit' attribute set to 'true' solve the problem. Is it possible to
> execute the stored procedure using that behavior? We already looked to
> set that flag to a particular connection within cayenne, but without
> any
> success...
You may try using a TransactionDelegate that sets autocommit to true
based on some ThreadLocal variable state from within
'willAddConnection':
http://cayenne.apache.org/doc/understanding-transactions.html
Andrus
------------------------------------------------------------------
CONFIDENTIALITY: This e-mail and any files transmitted with it are confidential and intended solely for the use of the recipient(s) only. Any review, retransmission, dissemination or other use of, or taking any action in reliance upon this information by persons or entities other than the intended recipient(s) is prohibited. If you have received this e-mail in error please notify the sender immediately and destroy the material whether stored on a computer or otherwise.
DISCLAIMER: Any views or opinions presented within this e-mail are solely those of the author and do not necessarily represent those of SIDE International S.A. - EastNets Group, unless otherwise specifically stated.
------------------------------------------------------------------
Please consider the environment before deciding to print this email.
This archive was generated by hypermail 2.0.0 : Tue Apr 29 2008 - 05:01:36 EDT