Re: [jrf-user] JRFWriteTransaction

[Tom M. <tm...@li...>]

This fix did not compile, as getAutoCommit() is not a method of "c" a
JRFConnection. getAutoCommit() is a method of SimplePooledConnection.

What to do? I have learned the mySQL defaults to autocommit being on. That
can be turned off with a SQL statement, but is that the thing to do, or
some other fix?

Thanks
Tom Miller

Jay wrote:

> I will eventually check the JDBC specification to see if it is
> appropriate for a driver to throw an exception for calling commit on an
> auto-commit connection.
>
> Please change the following at line 132 in JRFWriteTransaction.java:
>
> Replace:
>
>  if (!c.isConnectionOpen())
>
> with
>  if (!c.isConnectionOpen() || !c.getAutoCommit())
>
> This will stop commit() from being called.
> If this fix works, let me know and I will check in the change.
>
> Thank you,
> J Evans
>
> -------------------------------------------------------
> This sf.net email is sponsored by: See the NEW Palm
> Tungsten T handheld. Power & Color in a compact size!
> http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0001en
> _______________________________________________
> jrf-user mailing list
> jrf...@li...
> https://lists.sourceforge.net/lists/listinfo/jrf-user

--
Tom Miller
Miller Associates, Inc.
tm...@li...
641.469.3535 Phone
413.581.6326 FAX