Re: Error while using JDBCR4 Service Program

[Gary Thompson <GThompson@xxxxxxxxxxx>]

Scott wrote:

> There's also a setAutoCommit() method in the java.sql.Connection class 
> that you could (potentially) prototype and use to turn auto commit on 
> and off.
> I haven't tested it, but off the top of my head, the prototype would 
> look like this:

>      D JDBC_setAutoCommit...
>      D                 PR                  ExtProc(*JAVA:
>      D                                     'java.sql.Connection':
>      D                                     'setAutoCommit')
>      D    autoCommit                  1n   value

> and you call it like:
>       // code to make new connection
>
>     JDBC_setAutoCommit(conn: *off);


Thank you, your code works as you described and the test program now 
        does commit and rollback as needed.