AnsweredAssumed Answered

Enbale loading of SQLite modules

Question asked by Patrick Fleckenstein on Apr 10, 2019

Hello,

 

I need to connect to an SQLite DB.

To achieve this it is necessary to load a module i.e.

 

SELECT load_extension('my_extension.so');

 

By default remotely loading extensions is disabled in sqlite-jdbc.jar.

One solution could be to recompile sqlite-jdbc.jar with this option enabled.

 

But is it possible to enable extension loading within PDI?

Maybe by giving parameters for loading the included sqlite-jdbc.jar?

 

Any hint to solve this would be great!

 

Regards

Patrick

Outcomes