Have you checked to see if the:

conn.rollback();

is raising an exception? Your example is catching it but not doing anything
with it.

----- Original Message -----
From: "lapc2000br" <leofree@...>
To: <IB-Java@yahoogroups.com>
Sent: Wednesday, January 23, 2002 7:32 PM
Subject: [IB-Java] Newbie Question: How do I create a transaction using
JAVA+IB?


> Hi,
>
> I'm trying to create a transaction using JAVA+IB but I'm not having
> any success. I've tried:
>
> //BEGIN TRANS
> try {
> conn.setAutoCommit(false);
> conn.commit();
> } catch (SQLException e) {}
>
> //THE TRANS ITSELF
> try {
> Statement stmt1, stmt2;
>
> stmt1 = conn.createStatement();
> stmt1.executeUpdate("UPDATE..."));
> stmt1.close();
>
> stmt2 = conn.createStatement();
> stmt2.executeUpdate("UPDATE..."));
> stmt2.close();
> } catch (SQLException e)
> {
> try {
> conn.rollback();
> } catch (SQLException e2) {
> }
> }
>
> //END TRANS
> try {
> conn.commit();
> conn.setAutoCommit(true);
> } catch (SQLException e) {}
>
> The problem occurs when the stmt1 is successful but stmt2 is NOT.
> The transaction is NOT rolled back!
>
> Can u help me?
>
> Leo Cavalcanti.
>
>
>
> To unsubscribe from this group, send an email to:
> IB-Java-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>