neo4j-etl icon indicating copy to clipboard operation
neo4j-etl copied to clipboard

Published 20 hours ago • verified publisher icon neo4j-contrib

SQLITE driver

Open geoHeil opened this issue 4 years ago • 4 comments

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.

geoHeil avatar Feb 05 '21 08:02 geoHeil

hi @geoHeil are you using a SQLite JDBC driver?

conker84 avatar Feb 05 '21 10:02 conker84

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.

geoHeil avatar Feb 08 '21 06:02 geoHeil

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

crazyyanchao avatar Apr 27 '22 06:04 crazyyanchao

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.

neopaf avatar Jan 16 '23 11:01 neopaf