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
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:
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
Comments
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