Subject | Re: [Firebird-Java] Migrating from Interclient to JayBird |
---|---|
Author | DataCom - Diego Moreira da Rosa |
Post date | 2003-06-24T19:27:38Z |
Thanks for your time and help people.
We took a look at the FAQ and other stuff, but the error messages continue.
What is happenning is the following. We create a connection using defaults
and, when we run it, an exception is thrown every SQL query. It says:
"commit called with AutoCommit true!". Interesting that we are not calling
any explicit commit; also this code used to work just fine with Interclient.
Despite the exception, the program seems to work ok.
To try to avoid this exception, we included a call to
Connection.setAutoCommit(false) before any transaction. The first exception
is not thrown anymore; however some other exceptions are thrown
("FBSQLException: GDS exception. Dynamic SQL Error", is an example) and the
application starts behaving strangely.
Do you know why would this happen? Does not JayBird support AutoCommit mode?
Thanks again,
Diego Moreira da Rosa
DataCom Telemática
Av França, 735 - Porto Alegre, RS - 90230-220
PBX: 51 3358 0100
DDR: 51 3358 01xx
Fax: 513358 0101
www.datacom-telematica.com.br
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.486 / Virus Database: 284 - Release Date: 29/5/2003
We took a look at the FAQ and other stuff, but the error messages continue.
What is happenning is the following. We create a connection using defaults
and, when we run it, an exception is thrown every SQL query. It says:
"commit called with AutoCommit true!". Interesting that we are not calling
any explicit commit; also this code used to work just fine with Interclient.
Despite the exception, the program seems to work ok.
To try to avoid this exception, we included a call to
Connection.setAutoCommit(false) before any transaction. The first exception
is not thrown anymore; however some other exceptions are thrown
("FBSQLException: GDS exception. Dynamic SQL Error", is an example) and the
application starts behaving strangely.
Do you know why would this happen? Does not JayBird support AutoCommit mode?
Thanks again,
Diego Moreira da Rosa
DataCom Telemática
Av França, 735 - Porto Alegre, RS - 90230-220
PBX: 51 3358 0100
DDR: 51 3358 01xx
Fax: 513358 0101
www.datacom-telematica.com.br
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.486 / Virus Database: 284 - Release Date: 29/5/2003