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
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.