One Star

ODBC : "Driver not capable" error

Hi,
I have a problem on a job which writes data in an ODBC connection. When I execute the job, this error is displayed :
Exception in component tDBOutput_1
java.sql.SQLException: Driver not capable.
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLSetConnectOption(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcConnection.setAutoCommit(Unknown Source)
at codic.copy_of_f_banquet_0_1.Copy_of_F_BANQUET.tDBInput_1Process(Copy_of_F_BANQUET.java:1691)
at codic.copy_of_f_banquet_0_1.Copy_of_F_BANQUET.runJobInTOS(Copy_of_F_BANQUET.java:2677)
at codic.copy_of_f_banquet_0_1.Copy_of_F_BANQUET.main(Copy_of_F_BANQUET.java:2574)
It seems that the "conn_tDBOutput_1.setAutoCommit(false);" line is responsible for this error and I don't know how to correct this problem.
The ODBC connection seems OK. I can connect and read data through it.
Somebody can help me please ?
Thanks in advance for your help.
1 REPLY
One Star

Re: ODBC : "Driver not capable" error

The problem has been solved by using an old version of Talend. On Talend 2.4.4, the same job works correctly.