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.
