Jaspersoft Studio upgrade sqlite driver

[tmorgan_1]

Hello

I am a new user.  I have a view in the DB that uses INSTR and that gets an error when trying to select.  I believe that I have an older version od the sqlite driver.

How do i upgrade the driver so that Studio will yse the new version

Thanks

[mahadiosb]

Check this link. Here showed how to use an external DataBase Driver. 
https://jasperreporter.blogspot.com/2022/12/how-to-use-external-microsoft-jdbc.html

If you can't solve comment again. I'll try to help you with details 

[tmorgan_1]

Thank you, that did it

[mahadiosb]

Ohh great. Congrats :) Vote for this answer. It will help people.

[mahadiosb]

Check this link. Here showed how to use an external DataBase Driver. 
https://jasperreporter.blogspot.com/2022/12/how-to-use-external-microsoft-jdbc.html