Today, in a message to pgsql-interfaces, Peter Mount wrote:
>
> The problem JDBC has is that it's DatabaseMetaData methods can make
> several queries. While AutoCommit is off, if one of those fails, the
> users transaction will also fail.
If the JDBC driver under the hood performs several queries in response to
a single 'user command' and one of these fails it can still report that
command's failure without aborting the whole transaction (assuming the
backend supports statement-level aborts, of course).
Joachim
--
work: joachima@realtimeint.com (http://www.realtimeint.com)
private: joachim@kraut.ca (http://www.kraut.ca)