SQLITE driver

[geoHeil]

How can I use a SQLite database with the neo4j-ETL tool?

When using JDBC type and specifying a valid SQLite JDBC connection string testing the connection fails as a driver is not found.

[conker84]

hi @geoHeil are you using a SQLite JDBC driver?

[geoHeil]

I was using the SQLite JBC URL which works fine in i.e a SQL tool such as datagrip. But I did not figure out how to properly specify an additional JDBC driver for neo4j-etl.

[crazyyanchao]

I've encountered the same problem, the schema doesn't mapping!
My Url: jdbc:sqlite:C:\Users\zzbwa\AppData\Roaming\DBeaverData\workspace6.metadata\sample-database-sqlite-1\Chinook.db
Driver: sqlite-jdbc-3.36.0.3.jar

[neopaf]

Took the driver from auto-downloaded by DataGrip:

DataGrip2022.3/jdbc-drivers/Xerial SQLiteJDBC/3.39.2/sqlite-jdbc-3.39.2.jar
Opened a connection (had to specify dummy user/pass), getting strange message:

• Command failed due to error (IllegalArgumentException: Table name does not include schema: FEATURE). Rerun with --debug flag for detailed diagnostic information.

Meaning etl could find table, but couldn't find it's schema in the name!?
Did it expect to have tables to have dots?

Obvious hack didn't give any happiness:

• Command failed due to error (IllegalArgumentException: Table name does not include schema: "S1.FEATURE"). Rerun with --debug flag for detailed diagnostic information.