Transactions with Oracle and JDBC Thin - Driver

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 Received on Wed Feb 02 2000 - 07:00:34 CST