I just find out that I cannot continue using a connection when I use autocommit=false and that an sql insert failed.
In pseudo code this is what I'd like to do:
1) create connection 2) set autocommit = false 3) do an insert that succeed 4) do an insert that fails 5) catch the SQLException (I don't do a rollback on purpose) 6) do a select with the same connection 7) do another insert 8) commit
Everything goes well until step (6). where I receive the following error:
ERROR: current transaction is aborted, commands ignored until end of transaction block Exception: org.postgresql.util.PSQLException org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525) org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309) org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188) org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452) org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354) org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
Can I do something is step (5) so that I don't get the error in step (6) ? I need to continue using the same connection.
Thanks you your help.
_________________________________________________________________ Vælg selv hvordan du vil kommunikere - skrift, tale, video eller billeder med MSN Messenger: http://messenger.msn.dk/ - her kan du det hele
---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match