James Im wrote:
> I just find out that I cannot continue using a connection when I use
> autocommit=false and that an sql insert failed.
That's intended behavior in PostgreSQL. I just wrote this in another
thread last week:
If you have a statement in your transaction that you know might fail,
you can use savepoints to avoid having to restart the whole transaction:
Savepoint sp = conn.setSavepoint();
try {
stmt.executeQuery("SELECT 1 FROM table_that_might_not_exist");
} catch(SQLException ex)
{
sp.rollback(sp);
}
stmt.executeQuery("SELECT * FROM table_that_exists");
...
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com