topic Re: exception in tMysqlOutBulkExec "Can't call commit when autocommit=true in Talend Studio

exception in tMysqlOutBulkExec "Can't call commit when autocommit=true

izumisawaa — Sat, 16 Nov 2024 13:32:37 GMT

hi
I am using tMysqlOutBulkExec. And, "clear table" action is chosen.
The exception thow
before LOAD DATA is executed
after DELETE is executed.
######################
Exception in component tMysqlOutputBulkExec_1_tMBE
java.sql.SQLException: Can't call commit when autocommit=true
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931)
at com.mysql.jdbc.Connection.commit(Connection.java:1472)
######################
I cannot choose off of "auto commit" with tMysqlOutBulkExec.
and
I cannot choose on of "Use an exisiting connection" with tMysqlOutBulkExec.

In this problem, could you help me?

Regards

Re: exception in tMysqlOutBulkExec "Can't call commit when autocommit=true

alevy — Thu, 04 Mar 2010 06:05:31 GMT

What version are you using? A fix was made in v3.2.3 (see bug 10001)...

Re: exception in tMysqlOutBulkExec "Can't call commit when autocommit=true

izumisawaa — Tue, 09 Mar 2010 07:28:44 GMT

hi alevy
Thank you ;
I am using v3.2.2
I confirm v3.2.3

Re: exception in tMysqlOutBulkExec "Can't call commit when autocommit=true

izumisawaa — Mon, 22 Mar 2010 02:36:51 GMT

Thank you ;
Problem resolved in v3.2.3