Talend can't connection to SQLite

One Star

Talend can't connection to SQLite

Hello, 
I have a problem with access to the table of SQLite base. I have successfully created and verified DBConnection to SQLite base file. But when I try to get the table with tSQLiteInput, I got the error:
Exception in component tSQLiteInput_1
java.sql.SQLException: file is encrypted or is not a database
at org.sqlite.DB.throwex(DB.java:288)
at org.sqlite.NativeDB.prepare(Native Method)
at org.sqlite.DB.prepare(DB.java:114)
at org.sqlite.Stmt.executeQuery(Stmt.java:89)
at local_project.testjob_0_1.TestJob.tSQLiteInput_1Process(TestJob.java:997)
at local_project.testjob_0_1.TestJob.runJobInTOS(TestJob.java:1718)
at local_project.testjob_0_1.TestJob.main(TestJob.java:1575)

Now in Talend installed jdbc driver this version: sqlite-jdbc-3.8.11.1.jar.
And I tried to change for previous version, but it was the same error.
How I can resolve this problem?
Thanks in advance.
Olga
Moderator

Re: Talend can't connection to SQLite

Hi,
What's your SQLite database version?Is there a mismatch between sqlite-jdbc-3.8.11.1.jar and your current SQLite database?
Have you already checked document about:TalendHelpCenterSmiley Frustratedupported systems%2C databases and business applications by Talend components?

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Talend can't connection to SQLite

My SQLite database version is 3.7.16. I have checked this document, thank you, and also tried to use all these drivers https://bitbucket.org/xerial/sqlite-jdbc/downloads . Maybe are there another drivers? 
One Star

Re: Talend can't connection to SQLite

I have the same issue. My SQLite database is 3.16.2. How can i still connect to it using Talend open studio ? 
Moderator

Re: Talend can't connection to SQLite

Hi Le0Heart,
We have replied to your another topic:https://www.talendforge.org/forum/viewtopic.php?id=56014. Could you please take a look at it?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Forteen Stars

Re: Talend can't connection to SQLite

Leo,
You can use solution from Your other topic
-----------
Forteen Stars

Re: Talend can't connection to SQLite

My SQLite database version is 3.7.16. I have checked this document, thank you, and also tried to use all these drivers https://bitbucket.org/xerial/sqlite-jdbc/downloads . Maybe are there another drivers? 

as variant - https://mvnrepository.com/artifact/org.xerial/sqlite-jdbc/3.16.1
-----------

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads