SQLITE - not implemented by SQLite JDBC driver

[Anonymous]

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)

[Anonymous]

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

[Anonymous]

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