topic Re: SQLITE - not implemented by SQLite JDBC driver in Talend Studio

SQLITE - not implemented by SQLite JDBC driver

Anonymous — Sat, 16 Nov 2024 03:37:29 GMT

SQLITE Connection successfully established, but got below error while job execution

Exception in component tDBOutput_1 (POC_SQLITE)

java.sql.SQLException: not implemented by SQLite JDBC driver

at org.sqlite.Unused.unused(Unused.java:29)

at org.sqlite.Unused.setBigDecimal(Unused.java:56)

at poc_projects.poc_sqlite_0_1.POC_SQLITE.tDBInput_1Process(POC_SQLITE.java:1025)

at poc_projects.poc_sqlite_0_1.POC_SQLITE.tDBConnection_1Process(POC_SQLITE.java:420)

at poc_projects.poc_sqlite_0_1.POC_SQLITE.runJobInTOS(POC_SQLITE.java:1529)

at poc_projects.poc_sqlite_0_1.POC_SQLITE.main(POC_SQLITE.java:1379)

Re: SQLITE - not implemented by SQLite JDBC driver

Anonymous — Sun, 12 Jan 2020 02:42:53 GMT

Hi
It is not a connection issue, the original error means exactly what it says. The datasource invoked a method that is not implemented by the driver.
So, we need more details to locate the problem.
Which version of studio are you using? We will see which version of SQLite driver are using by the studio.
What action do you select in the action on table and action on Data list?
Can you please share a screenshot of the schema of tDBOutput?

Regards
Shong

Re: SQLITE - not implemented by SQLite JDBC driver

Anonymous — Wed, 17 Jun 2020 23:36:14 GMT

I am having the same issue, any idea how to resolve. Just trying to read from salesforce and insert into sqlite.

[statistics] connecting to socket on port 3394

[statistics] connected

Exception in component tDBOutput_1 (DataMigrationSqlLite)

java.sql.SQLException: not implemented by SQLite JDBC driver

at org.sqlite.Unused.unused(Unused.java:29)

at org.sqlite.Unused.setBigDecimal(Unused.java:56)

at sfdc.datamigrationsqllite_0_1.DataMigrationSqlLite.tSalesforceInput_1Process(DataMigrationSqlLite.java:3537)

at sfdc.datamigrationsqllite_0_1.DataMigrationSqlLite.runJobInTOS(DataMigrationSqlLite.java:13443)

at sfdc.datamigrationsqllite_0_1.DataMigrationSqlLite.main(DataMigrationSqlLite.java:13257)

[statistics] disconnected