jdbc commit issue - JDBC JAVA

Arti wrote:
> I'm facing some problems with the JDBC connection commit.
> I'm using an Oracle8i client and server.
> The jdbc library is classes12.jar
>
> My application uses eclipse3.1 as an IDE and the jdk version is
> jdk1.5.0_01
>
> The flow of logic is such that I acquire 2 to 3 connections to my
> database repository. On each of these connections some update/insert
> statements
> are executed (through jdbc PrepareStatement->executeUpdate())
> After the update statements I issue a connection.commit() on each of
> the connections where update statements are fired.
>
> I have noticed sometimes that although connection.commit has been
> issued, my DB does not have any data.

1) It sounds very weird that you do not get an exception and data
are not there.

You are not eating exceptions ?

2) Sounds as if you could use a transaction manager.

Arne