SQLite Connector

Q&A
1

Hi All,
From the list of database connectors, does anybody know what one should be used (if any) to connect to an
SQLite database?

I am trying to query the data held in the Spiceworks SQLite database…

Thank you for any help,
Jim

2

I think you can use the default JDBC 4 database connector, so you can connect to any Database. You can find it in the list of default available connectors in 6.0.4, please look at this picture:

3

Hello ttoine,

I’ve just tried to achieve an insert and I get a “SQLite only supports TYPE_FORWARD_ONLY cursors” error in engine logs.

Sources show that the connector is using methods of resultset that are not allowed when querrying a sqlite database (as explained here)

That is making the generic driver not so generic in fact

cheers