How to connect to a Sqlite database ?



I have a Sqlite database, I would like to connect to with iReport.

As the jdbc drivers'list doesn't show any Sqlite jdbc driver, I've dowloaded it via the Tool -> Plugin menu -> Sqlite jdbc driver.

But after this installation, the jdbc drivers list doesn't show any jdbc SQLite driver.

Is this normal ? What is the way to install a SQLite jdbc driver and to make it appear in the combo box of the drivers'list ?


Thanks in advance.




Post Edited by farida at 06/10/2010 08:18
farida's picture
Joined: Jun 9 2010 - 6:45am
Last seen: 10 years 1 month ago

4 Answers:

I've the same problem. Did you solve it?
morok's picture
Joined: Sep 6 2012 - 1:24pm
Last seen: 7 years 11 months ago

Here we are almost to the end of 2012 and I still cannot connect JasperSoft to my SQLite database on OpenSuSE Linux. I have been trying for... almost 4 years now... really frustrating to say the least.

glockg20's picture
Joined: Sep 11 2012 - 4:50pm
Last seen: 7 years 10 months ago
Hello, for those who continue to have this problem as I want to say solve, maybe it's useful for someone else. 
My problem was the connector used, which was not correct, if you open the *.jar contains classes you will see that the original jar contains very few classes, what I did was download another connector and ready. 
I leave the link where to download it:
ardanjela_ale's picture
Joined: May 29 2012 - 5:30pm
Last seen: 6 months 4 weeks ago

Hello Everyone I have solution for your sqlite jdbc driver. I am working with netbeans.

First download sqlitejdbc.jar

You have to go in iReport   Tools - > Options - > Classpath then click add jar and add downloaded sqlitejdbc.jar file.

Now to connect to database. First select Jdbc connection. Still after that you didn't see sqlite driver in JDBC driver combobox. So wirte in that " org.sqlite.JDBC" and in JDBC url type "  jdbc:sqlite:sqlite file location" For example  "jdbc:sqlite:E:\\Workplace\\Db_test\\project2.sqlite".

then click test if you given any password then type password else leave it blank.smiley



vijay.s.vankhede's picture
Joined: Jul 2 2014 - 10:15pm
Last seen: 6 years 1 month ago