Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (athena.apache.org: domain of contact@genux.fr designates
 88.191.42.248 as permitted sender)
Message-ID: <48EC72BD.4080406@genux.fr>
Date: Wed, 08 Oct 2008 10:43:41 +0200
From: Laurent Marchal <contact@genux.fr>
User-Agent: Thunderbird 2.0.0.17 (X11/20080925)
MIME-Version: 1.0
To: user@cayenne.apache.org
Subject: Re: commit() when autocommit is enabled
References: <8F798BFDA851B943B3A1B2510E92878509A21764@airmail>
In-Reply-To: <8F798BFDA851B943B3A1B2510E92878509A21764@airmail>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I had a similar error, i was never able to reproduce.
An exception saying a commit was attempted while autocommit is on.
Occured only 1 time with my application and SQL Server.

Scott Anderson wrote:
> I'm working on a path to add generated PK support to SQLite, but I've
> come across an issue with commit() - for some reason, autocommit is on,
> but Cayenne is still trying to call commit(), which causes an exception.
> An effective workaround is to re-check getAutoCommit() in
> ConnectionWrapper.commit() before calling connection.commit(), but I'm
> curious to know whether this behavior is actually even illegal to begin
> with, and if so, whether Cayenne already attempts to avoid this case.
>