Re: Transactions with Oracle and JDBC Thin - Driver

From: Andreas Michler <Andreas.Michler_at_adicom.de>
Date: Wed, 02 Feb 2000 15:37:14 +0100
Message-ID: <3898411A.C6B0CF12@adicom.de>

"create table" is a dba command and is automatically commited if successfull.
there is no chance to "rollback" a successfull dba statement.

Dirk Poppke wrote:

> Hi!
>
> I would like to make a transaction with JDBC and Oracle 8.1.5.
> The Problem: Rollback doesn't work. The code is like this:
>
> conn.commit();
> conn.setAutoCommit(false);
>
> Statement stmt = conn.getStatement();
>
> stmt.execute("create table testtable (test int)");
>
> conn.rollback();
>
> stmt.close();
>
> After running this code, the testtable is created, though it should be
> rolled back!
>
> Does anyone have got a clue?
>
> Thanks in advance,
> Dirk

--

---

ADICOM Informatik GmbH
Andreas Michler
Wiesfleckenstr. 34
72336 Balingen
Tel: 07433/9977-57,Fax: -90
E-Mail: Andreas.Michler_at_adicom.de
http:\\www.adicom.de

---

Received on Wed Feb 02 2000 - 08:37:14 CST