Xref: alice comp.databases.oracle.misc:52330
Path: alice!news-feed.fnsi.net!newspump.monmouth.com!newspeer.monmouth.com!news.ruhrgebiet.individual.net!Informatik.Uni-Dortmund.DE!news
From: "Dirk Poppke" <poppke@iug.cs.uni-dortmund.de>
Newsgroups: comp.databases.oracle.misc
Subject: Transactions with Oracle and JDBC Thin - Driver
Date: Wed, 2 Feb 2000 14:00:34 +0100
Organization: CS Department, University of Dortmund, Germany
Lines: 25
Message-ID: <8799pj$atp$1@fbi-news.cs.uni-dortmund.de>
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300

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