ODBC : "Driver not capable" error

One Star

ODBC : "Driver not capable" error

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.
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.

Cloud Free Trial

Try Talend Cloud free for 30 days.


Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.