From: | Giuseppe Sacco <giuseppe(at)eppesuigoccas(dot)homedns(dot)org> |
---|---|
To: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | DDL in transactions? |
Date: | 2005-03-31 07:32:14 |
Message-ID: | 1112254334.3881.8.camel@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi,
I have a question about 7.4 jdbc driver. I am executing this code:
--------------------
conn=datasource.getPooledConnection().getConnection();
conn.setAutoCommit(false);
stmt=conn.createStatement();
stmt.executeUpdate("CREATE TABLE X (X VARCHAR(100))");
//stmt.commit(); // <= Look at this line
stmt.executeUpdate("INSERT INTO X VALUES ('string')");
stmt.commit();
stmt.close();
conn.close();
--------------------
And I found that, using postgresql jdbc driver, I need to add the
commit() call that is commented out, otherwise I get an error like
'relation X does not exists'.
My question is: why? Shouldn't DDL be executed immediately?
Thank you for your response,
Giuseppe Sacco
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2005-03-31 16:09:34 | Re: DDL in transactions? |
Previous Message | fake | 2005-03-30 18:51:36 | Re: jdbc/callable statment error] |