Subject | Strange problem: inserts failing |
---|---|
Author | DataCom - Diego Moreira da Rosa |
Post date | 2003-08-15T12:47:32Z |
Hi all,
I am facing a strange problem using JBird. I have a program that launch a
couple of threads wich, among other things, make some inserts in the
database using JBird. After all the threads have executed, some of the
inserts were really done, but other not (this can be seen looking at the
database). The strange thing is that the call to the method executeUpdate of
the java.sql.Statement is in fact executed, however there is no changes in
the database. BTW, the method that calls executeUpdate is synchronized.
Also, no exceptions were risen. Another strange thing is that copying the
SQL statement and executing it in a IBConsole, for example, correctly
inserts the records in the database.
Do you know any situation that could make a calling of the executeUpdate
method make no effect in the database and, at the same time, rise no
exception?
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
I am facing a strange problem using JBird. I have a program that launch a
couple of threads wich, among other things, make some inserts in the
database using JBird. After all the threads have executed, some of the
inserts were really done, but other not (this can be seen looking at the
database). The strange thing is that the call to the method executeUpdate of
the java.sql.Statement is in fact executed, however there is no changes in
the database. BTW, the method that calls executeUpdate is synchronized.
Also, no exceptions were risen. Another strange thing is that copying the
SQL statement and executing it in a IBConsole, for example, correctly
inserts the records in the database.
Do you know any situation that could make a calling of the executeUpdate
method make no effect in the database and, at the same time, rise no
exception?
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