Jdbc Oracle Exception

[immkhan]

Hi I am new to Jasper forge, I am facing a problem when I am going to use Oracle as database. I have a new system where I have installed iReports and jdk1.6.0_18. I download the Oracle JDBC driver (Classes12.jar) and placed it into the directory C:\Program Files\Jaspersoft\iReport-3.7.1\ide10\modules\ext. But when I am going to create a report databasource, the system is not picking up the Oracle JDBC connection and mark that connection in red and giving exception "classnotfound".

Please let me know what I need to install further or what parameter or file setting I have to do.

Required ASAP response.

Thanks & Regards

[thangalin]

Please post the entire exception.

[mattashaw]

I am getting the same error.

I have added the oracle jar to the classpath via the tools/options menu in ireport. I have been stuck on this for a few days now, do I need to log a bug?

 

Any assistance would be greatly appreciated. 

Code:

Exception Message:    java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriverLevel:    SEVEREStack Trace:oracle.jdbc.driver.OracleDriver    com.jaspersoft.ireport.designer.connection.JDBCConnection.loadDriver(JDBCConnection.java:63)    com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:126)    com.jaspersoft.ireport.designer.connection.JDBCConnection.test(JDBCConnection.java:447)    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:335)    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:43)    com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:290)    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)    javax.swing.DefaultButtonModel.setPressed(Unknown Source)    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)    java.awt.Component.processMouseEvent(Unknown Source)    javax.swing.JComponent.processMouseEvent(Unknown Source)    java.awt.Component.processEvent(Unknown Source)    java.awt.Container.processEvent(Unknown Source)    java.awt.Component.dispatchEventImpl(Unknown Source)    java.awt.Container.dispatchEventImpl(Unknown Source)    java.awt.Component.dispatchEvent(Unknown Source)    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)    java.awt.Container.dispatchEventImpl(Unknown Source)    java.awt.Window.dispatchEventImpl(Unknown Source)    java.awt.Component.dispatchEvent(Unknown Source)    java.awt.EventQueue.dispatchEvent(Unknown Source)    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)    java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)    java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)    java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)    java.awt.Dialog$1.run(Unknown Source)    java.awt.Dialog$2.run(Unknown Source)    java.security.AccessController.doPrivileged(Native Method)    java.awt.Dialog.show(Unknown Source)    java.awt.Component.show(Unknown Source)    java.awt.Component.setVisible(Unknown Source)    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.jButtonNewParameterActionPerformed(ConnectionsDialog.java:578)    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.access$400(ConnectionsDialog.java:47)    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog$7.actionPerformed(ConnectionsDialog.java:221)    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)    javax.swing.DefaultButtonModel.setPressed(Unknown Source)    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)    java.awt.Component.processMouseEvent(Unknown Source)    javax.swing.JComponent.processMouseEvent(Unknown Source)    java.awt.Component.processEvent(Unknown Source)    java.awt.Container.processEvent(Unknown Source)    java.awt.Component.dispatchEventImpl(Unknown Source)    java.awt.Container.dispatchEventImpl(Unknown Source)    java.awt.Component.dispatchEvent(Unknown Source)    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)    java.awt.Container.dispatchEventImpl(Unknown Source)    java.awt.Window.dispatchEventImpl(Unknown Source)    java.awt.Component.dispatchEvent(Unknown Source)    java.awt.EventQueue.dispatchEvent(Unknown Source)    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)    java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)    java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)    java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)    java.awt.Dialog$1.run(Unknown Source)    java.awt.Dialog$2.run(Unknown Source)    java.security.AccessController.doPrivileged(Native Method)    java.awt.Dialog.show(Unknown Source)    java.awt.Component.show(Unknown Source)    java.awt.Component.setVisible(Unknown Source)    com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.setVisible(ConnectionsDialog.java:651)    com.jaspersoft.ireport.designer.menu.DatasourcesAction.performAction(DatasourcesAction.java:46)    org.openide.util.actions.CallableSystemAction$1.run(CallableSystemAction.java:118)    org.netbeans.modules.openide.util.ActionsBridge.doPerformAction(ActionsBridge.java:77)    org.openide.util.actions.CallableSystemAction.actionPerformed(CallableSystemAction.java:114)    javax.swing.AbstractButton.fireActionPerformed(Unknown Source)    javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source)    javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source)    javax.swing.DefaultButtonModel.setPressed(Unknown Source)    javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source)    java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)    java.awt.AWTEventMulticaster.mouseReleased(Unknown Source)    java.awt.Component.processMouseEvent(Unknown Source)    javax.swing.JComponent.processMouseEvent(Unknown Source)    org.openide.awt.ToolbarButton.processMouseEvent(ToolbarButton.java:61)    java.awt.Component.processEvent(Unknown Source)    java.awt.Container.processEvent(Unknown Source)    java.awt.Component.dispatchEventImpl(Unknown Source)    java.awt.Container.dispatchEventImpl(Unknown Source)    java.awt.Component.dispatchEvent(Unknown Source)    java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source)    java.awt.LightweightDispatcher.processMouseEvent(Unknown Source)    java.awt.LightweightDispatcher.dispatchEvent(Unknown Source)    java.awt.Container.dispatchEventImpl(Unknown Source)    java.awt.Window.dispatchEventImpl(Unknown Source)    java.awt.Component.dispatchEvent(Unknown Source)    java.awt.EventQueue.dispatchEvent(Unknown Source)    org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104)    java.awt.EventDispatchThread.pumpOneEventForHierarchy(Unknown Source)    java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)    java.awt.EventDispatchThread.pumpEvents(Unknown Source)    java.awt.EventDispatchThread.pumpEvents(Unknown Source)    java.awt.EventDispatchThread.run(Unknown Source)

[mattashaw]

 I solved it. I have version 3.7.1 of ireport. I was using the oracle6 driver that ships with weblogic 10.3.2. I switched to older version of the jar oracle14.jar and it worked.

 

The confusing part was ireport kept reporting a class not found exception, even though it was related to using the incorrect version. Perhaps this should be logged as a bug.

[vispi_3]

i am  using ireport 3.7.0 and i am getting the same jdbc exception as shown above......

can u please help me in this

 

[slow]

have you tried to add the Oracle JDBC jar to the classpath?

(Tools-->Option-->Classpath-->Add JAR)

 

 

 

 

____________________________________
if it works... give me KARMA points please!    : ) 

[immkhan]

Add the jar file in the lib directory and also place the old oracle jar file as well. The old file is required to work on.

[vispi_3]

I have included ojdbc14.jar in tools->options->classpath location and it worked fine

[it_vidhya]

Yeah it works for me

 

Thanks

vidhya

[it_vidhya]

slow
Wrote:

have you tried to add the Oracle JDBC jar to the classpath? (Tools-->Option-->Classpath-->Add JAR)         ____________________________________ if it works... give me KARMA points please!    : )

 

This works for me..

 

Thanks

vidhya