Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Labels (4)
6 Replies
Anonymous
Not applicable
Author

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:TalendHelpCenter0683p000009M9p6.pngupported systems%2C databases and business applications by Talend components?

Best regards
Sabrina
Anonymous
Not applicable
Author

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? 
Anonymous
Not applicable
Author

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

Hi  Le0Heart,
We have replied to your another topic: https://community.talend.com/t5/Design-and-Development/Metadata-Retreive-Schema-from-SQLite-does-not.... Could you please take a look at it?
Best regards
Sabrina
vapukov
Master II
Master II

Leo,
You can use solution from Your other topic
vapukov
Master II
Master II

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