topic Talend can't connection to SQLite in Talend Studio

Talend can't connection to SQLite

Anonymous — Wed, 19 Aug 2015 15:51:05 GMT

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

Re: Talend can't connection to SQLite

Anonymous — Thu, 20 Aug 2015 09:49:33 GMT

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

Best regards
Sabrina

Re: Talend can't connection to SQLite

Anonymous — Thu, 20 Aug 2015 12:40:42 GMT

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?

Re: Talend can't connection to SQLite

Anonymous — Tue, 28 Feb 2017 13:00:27 GMT

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

Re: Talend can't connection to SQLite

Anonymous — Wed, 01 Mar 2017 09:50:35 GMT

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

Re: Talend can't connection to SQLite

vapukov — Wed, 01 Mar 2017 10:49:55 GMT

Leo,
You can use solution from Your other topic

Re: Talend can't connection to SQLite

vapukov — Wed, 01 Mar 2017 10:51:51 GMT

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