I am using iReports (3.7.0) with JasperServer (3.7.3) and Oracle (11.1). I added the JDBC data source just fine. I wrote a sample report using the data source, and it compiles and fills correctly. I published it to my server successfully. However, when I run the report unit from my repository navigator, I get an error in iReport:
1 - oracle.jdbc.driver.OracleDriver
java.lang.Exception: 1 - oracle.jdbc.driver.OracleDriver
Also, when I log into JasperServer and try to open that sample report, I get a different error stack trace, which is miles long (essentially restating the same ClassNotFoundException error).
I have already tried several things to fix this:
1. I added the Oracle drivers to the iReport classpath.
2. I registered the Oracle drivers in the service window.
3. I placed the Oracle drivers in the iReport\libs folder.
If I'm not mistaken, this is caused by the deprecation of oracle.jdbc.driver in favor of oracle.jdbc, so iReport and JasperServer are still searching for the old Oracle driver, but I am unsure of how to fix it. Any help is appreciated, thanks in advance.
Post Edited by oddpod11 at 06/09/2010 17:39
Figured it out thanks to JasperSoft support. The problem was that the OracleDrivers had not been placed in the server directory in addition to the iReport library. So, if anyone reading this encounters a similar issue, place the drivers in the jasper-server\\WEB-INF\\lib directory, restart the server, and try again.
I have issues with resolving this JDBC OracleDriver. I can run my report separately in the iReport but after deploying it in the server then if I choose Right Click then Run JaserServer Report then it throws this exception. I'm using the latest version Jaspersoft BI Suite 4.0.1. I tried copying the drvier zip files in the exact location and I tried in other folders too. But got struck with this issue.
Can someone please help me on this issue? Appreciate your help :)
error.java.lang.Exception: 1 - oracle.jdbc.driver.OracleDriver
After installing the Jaspersoft v4 Go To this folder "\\jasperreports-server-4.0.1\\buildomatic\\conf_source\\db\\oracle\\jdbc" copy the appropriate ojdbc jar file (Different version depends on your oracle database - For 11g I copied ojdbc5-11.2.0.jar files) and paste it in two different folders in order to get the iReport and JasperReport run without any java exception.
My problem: net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
I download from this site (oracle): http://www.oracle.com/technetwork/database/features/jdbc/jdbc-drivers-12... driver for oracle 12
and I write in Data adapter wizard (on tab Draver Classpath, path for my download file)