Subject | Re: [Firebird-Java] Re: Strange problem: inserts failing |
---|---|
Author | DataCom - Diego Moreira da Rosa |
Post date | 2003-08-15T14:01:58Z |
Thanx very much for the help Roman, lets see if I can be more specific,
call database.connect(), it is created an auto-committed Connection. The
method used for updates is called execUpdate and is synchorinzed. So, I
create an Database object, call the method connect and start the threads.
Each thread will then call the execUpdate method.
you said. The connection is auto-committed, as I said before. Do you know if
an auto-committed transaction can be rolled back? If yes, is there any way
of discovering if it occurred and why?
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
> Do you synchronize on Connection object? What about transaction control?I built a class called Database wich encapsulates a JBird Connection. When I
call database.connect(), it is created an auto-committed Connection. The
method used for updates is called execUpdate and is synchorinzed. So, I
create an Database object, call the method connect and start the threads.
Each thread will then call the execUpdate method.
> Check the output of executeUpdate() method (it returns you informationI made a step-by-step execution and the output of executeUpdate is 1 just as
> about affected rows, in your case it should be 1). If it is correct,
> check the transaction management, maybe you rolled the transaction back.
you said. The connection is auto-committed, as I said before. Do you know if
an auto-committed transaction can be rolled back? If yes, is there any way
of discovering if it occurred and why?
>Regards,
> Best regards,
> Roman
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