Adding New JDBC Driver

0

In iReport 3.0.0 I placed my sqlite JDBC driver jar file in the lib folder and it then appeared in the driver list in the data connection dialog.

 

How do I install that driver in version 3.5.2, I have tried placing it in various locations, I have also tried listing the jar file explicitly on the classpath but so far it never shows up as an avaiable driver?

 

Rod MacNeil

 

rjmacneil's picture
Joined: Sep 28 2006 - 12:31am
Last seen: 12 years 7 months ago

9 Answers:

4

Tools->Options->iReport->Classpath

Giulio

giulio's picture
19986
Joined: Jan 2 2007 - 4:15pm
Last seen: 2 months 2 weeks ago
0

I had to add the driver in the services window.

 

Rod MacNeil

rjmacneil's picture
Joined: Sep 28 2006 - 12:31am
Last seen: 12 years 7 months ago
0

Hello everybody,

Yes, is so easy to add a new jdbc driver to ireport, except SQLITE jdbc Driver!!!

I "googgled", searched the docs, the wiki and some manual, and all said that to add a new jdbc driver you have to add the jar file in the Classpath of ireport. By default, SQLite drivers is not present in the Select Datasource type window, so i add the driver to the classpath and nothing happens, the sqlite driver is still unavaliable. I tried MS SQL Server, i added the jar driver, i opened the datasource window again and works!!

Is ireport, SQLite compatible?

I use netbeans 6.5, ireport v3.5.2 as Netbeans plugin and SQLite jdbc V0.5.4 Driver

I tried ireport V3.5.2 stand-alone version and the same, but this time i added a new jdbc driver (SQLite) in Services, but when i tried to make the connection with the database file, don't work.

any help?  

Thanks

Cesar

cjdr's picture
2
Joined: Jul 3 2009 - 12:21am
Last seen: 9 years 9 months ago
0

I've added a FirebirdSQL driver to the classpath and to the serverices. I am able to connect successfully when setting up a datasource using it and I can setup a database under services that connects. But when I run the report query I get "Error:NoClassDefFoundError!!Check you classpath!"

I'm sort of at a loss for where to go as the classpath is there and the datasource test says connection successful. I am using iReport 3.5.2 as a stand-alone.



Post Edited by dnewsom at 07/07/2009 13:50
dnewsom's picture
25
Joined: Apr 2 2008 - 8:32am
Last seen: 6 years 6 months ago
0

Finally, I was able to resolv the question. The problem is that i have to add a new sqlite driver in Services windows.....

 

cjdr's picture
2
Joined: Jul 3 2009 - 12:21am
Last seen: 9 years 9 months ago
0

Does anybody knows how add a new JDBC driver? I need to connect via VJdbc, but after jar installation on classpath and services there's no VJDBC item in combobox. Any advice?

albertoagnetti's picture
Joined: Sep 1 2010 - 12:18am
Last seen: 8 years 7 months ago
-1
It will not appear in the combo box, just manually type in the driver name. I have also used the vjdbc driver. The driver name would be:
de.simplicit.vjdbc.VirtualDriver
pwd's picture
pwd
33
Joined: Feb 25 2010 - 11:47am
Last seen: 9 years 1 month ago
0

 I plan to use SQLite in a self contained Java Application using ireports as my reporting software.  I'm using Eclipse.  When you said that you added in the windows services window can you explain.  I'm new to this.

I've never used Java, JDBC, or iReports.

J'aime

rushtonjj's picture
Joined: Mar 23 2012 - 3:24pm
Last seen: 7 years 1 month ago
0

I tried that and it didn't work for me. I am running OpenSuSE Linux 12.2 x86_64.

glockg20's picture
Joined: Sep 11 2012 - 4:50pm
Last seen: 6 years 7 months ago
Feedback
randomness