SQLite with 4.6.0

[RIchardC]

I downloaded the latest .jar here

Added it as shown below and I get console errors:

ERROR DBDriverRegistry                Database driver wrapper creation failed for driver (SQLite_v33603) "SQLite_v33603".
ERROR DBDriverRegistry                Failed to register driver (SQLite_v33603) "SQLite_v33603".

Same thing happens if I try to use my previous driver version.

Any ideas appreciated.

[mlauber71]

@RIchardC maybe you check again the source and the settings for the driver

SQLITE and Window Functions

@tobias.koetter thank you for this hint this opens up the whole world of window functions. I downloaded the latest JAR file from the Maven site and told KNIME where to find the driver. [image] [image] @khatuaani now you can benefit from the latest developments with H2 (and SQLite).

[RIchardC]

Thank you. It’s working now, although I’m not sure why. Also, I see there is a built-in up-to-date SQLite driver which wasn’t there last time I updated the driver. Cheers.

[mlauber71]

@RIchardC

built-in up-to-date SQLite driver

Indeed there are several database drivers that have been updated

https://www.knime.com/changelog-v46

AP-16434: SQLite driver updated to version 3.36.0.3