SQLite connection

Hi there,

I am new to Knime, and am having problem connecting a SQLite base.

I use Knime 2.7.4, whose folder is located in my Home folder (Linux Ubuntu), I installed the SQLite driver sqlite-jdbc-3.7.2, and my database file is on my Desktop: 20130411ThymNoco.db

I enter my base URL in the Database Reader Dialog: jdbc:sqlite:/20130411ThymNoco.db  click apply, and get the following message: WARN Database Reader java.sql.SQLException: java.sql.SQLException: java.sql.SQLException: opening db: '/20130411ThymNoco.db': permission denied

Please note that this database can be opened and queried with Sqlitemanager.

If i modify the URL to: /Desktop/20130411ThymNoco.db, I get the message: WARN Database Reader java.sql.SQLException: java.sql.SQLException: java.sql.SQLException: path to: '/Desktop/20130411ThymNoco.db': '/Desktop' does not exist

What am I doing wrong?

Thanx in advance for your help!

 

I attache a screen shot of the error message with different assays

You must enter the full absolute path to the database, i.e.

jdbc:sqlite:/home/philippe/Desktop/20130411ThymNoco.db

If the path starts with "/" it's an absolute path, otherwise it's a relative path, but it is unclear relative to which directory.

blush

You made my day!