Re: autocommit and stored procedures

On 16 Aug 2007, at 17:44, Oliver Jowett wrote:

> roehm(at)it(dot)usyd(dot)edu(dot)au wrote:
>
>>> See the javadoc for Connection.setAutoCommit():
>>>
>> That's your documentation and not necessarily the JDBC
>> specification ;-)
>
> Err I am talking about:
>
> http://java.sun.com/j2se/1.5.0/docs/api/java/sql/
> Connection.html#setAutoCommit()
>
> which certainly is part of the JDBC specification.
>
> -O

Thanks, that's better - the documentation of Sun's reference
implementation.

Btw: The actual JDBC specification can be downlaoded from here:
http://java.sun.com/products/jdbc/download.html#corespec30

In Chapter 10.1, it seems to define the autocommit behaviour as
discussed so far
(commit outside the stored procedure after all of its results have
been received).

Uwe