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
6 REPLIES
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.
Twelve Stars

Re: Talend can't connection to SQLite

Leo,
You can use solution from Your other topic
-----------
Twelve 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
-----------