Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

#101 SQLInsert fails under mySQL

v6.5.2
closed
Michael Kay
5
2014-07-11
2002-11-08
Michael Kay
No

SQLInsert attempts to do commit() even if autocommit is
switched on. This can cause it to fail.

See <a
href="http://sourceforge.net/forum/forum.php?thread_id=758787&forum_id=94027">forum</a>

Present in 6.5.2, 7.2, and all earlier releases.

Source code fixed. Tested by the user reporting the
problem.

Specifically, in module SQLInsert.java, change

    connection.commit();

to

if (!connection.getAutoCommit()) { 
                connection.commit();
    }

Michael Kay

Discussion

  • Michael Kay
    Michael Kay
    2002-11-18

    Logged In: YES
    user_id=251681

    Fixed in 7.3

     
  • Michael Kay
    Michael Kay
    2003-08-07

    Logged In: YES
    user_id=251681

    For the record, the source code is fixed in both branches.