You are viewing a plain text version of this content. The canonical link for it is here.
Posted to ojb-user@db.apache.org by abo <ab...@online.de> on 2003/05/05 11:14:54 UTC
mysql: still not recognizing useAutoCommit!!
hi,
i already posted this some days ago, but maybe i wasn't clear enough:
since i switched from ojb 0.9.9 to rc2/rc3 i have the following
exception, when i try to commit my updates/inserts:
[org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] ERROR: Commit
on underlying connection failed, try to rollback
Can't call commit when autocommit=true
java.sql.SQLException: Can't call commit when autocommit=true at
org.gjt.mm.mysql.Connection.commit(Unknown Source)
but in my repository_database.xml i have set
useAutoCommit="0" !!!
boot-info from ojb says:
useAutoCommit=AUTO_COMMIT_IGNORE_STATE
thanks in advance!
andreas
AW: mysql: still not recognizing useAutoCommit!!
Posted by abo <ab...@online.de>.
thank you!
andreas
-----Ursprüngliche Nachricht-----
Von: Armin Waibel [mailto:armin.waibel@code-au-lait.de]
Gesendet: Montag, 05. Mai 2003 11:58
An: OJB Users List
Betreff: Re: mysql: still not recognizing useAutoCommit!!
Hi Andreas,
----- Original Message -----
From: "abo" <ab...@online.de>
To: "'OJB Users List'" <oj...@db.apache.org>
Sent: Monday, May 05, 2003 11:14 AM
Subject: mysql: still not recognizing useAutoCommit!!
> hi,
>
> i already posted this some days ago, but maybe i wasn't clear enough:
>
> since i switched from ojb 0.9.9 to rc2/rc3 i have the following
> exception, when i try to commit my updates/inserts:
>
> [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] ERROR:
Commit
> on underlying connection failed, try to rollback
> Can't call commit when autocommit=true
> java.sql.SQLException: Can't call commit when autocommit=true at
> org.gjt.mm.mysql.Connection.commit(Unknown Source)
>
>
> but in my repository_database.xml i have set
>
> useAutoCommit="0" !!!
when set AutoCommit=0 OJB does not change the autocommit
state of your connection, thus when your mysql database deliver
connections with autocommit=true (default state for most databases I
think), you will get this exception when try to do a commit call on the
connection (because OJB doesn't set autocommit to false). Change
configuration of mysql to deliver connections with autocommit=false by
default, or use useAutoCommit="1".
regards,
Armin
>
> boot-info from ojb says:
> useAutoCommit=AUTO_COMMIT_IGNORE_STATE
>
>
> thanks in advance!
> andreas
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
For additional commands, e-mail: ojb-user-help@db.apache.org
Re: mysql: still not recognizing useAutoCommit!!
Posted by Armin Waibel <ar...@code-au-lait.de>.
Hi Andreas,
----- Original Message -----
From: "abo" <ab...@online.de>
To: "'OJB Users List'" <oj...@db.apache.org>
Sent: Monday, May 05, 2003 11:14 AM
Subject: mysql: still not recognizing useAutoCommit!!
> hi,
>
> i already posted this some days ago, but maybe i wasn't clear enough:
>
> since i switched from ojb 0.9.9 to rc2/rc3 i have the following
> exception, when i try to commit my updates/inserts:
>
> [org.apache.ojb.broker.accesslayer.ConnectionManagerImpl] ERROR:
Commit
> on underlying connection failed, try to rollback
> Can't call commit when autocommit=true
> java.sql.SQLException: Can't call commit when autocommit=true at
> org.gjt.mm.mysql.Connection.commit(Unknown Source)
>
>
> but in my repository_database.xml i have set
>
> useAutoCommit="0" !!!
when set AutoCommit=0 OJB does not change the autocommit
state of your connection, thus when your mysql database deliver
connections with autocommit=true (default state for most
databases I think), you will get this exception when try to do
a commit call on the connection (because OJB doesn't set
autocommit to false).
Change configuration of mysql to deliver connections
with autocommit=false by default, or use useAutoCommit="1".
regards,
Armin
>
> boot-info from ojb says:
> useAutoCommit=AUTO_COMMIT_IGNORE_STATE
>
>
> thanks in advance!
> andreas
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ojb-user-unsubscribe@db.apache.org
> For additional commands, e-mail: ojb-user-help@db.apache.org
>
>
>