Problem connecting to database in Netbeans for iReports
843859Jul 11 2008 — edited Jan 13 2010Hi,
I am using NetBeans6.0.1 and added iReports3.0 plugin.
while creating a report it is asking for the Database JDBC connection details to test the connection.
I provided the correct information(URL,username,password) and the oracle driver is also in the CLASSPATH.
But while testing, it is giving error like.
ClassNotFoundError!
Msg: oracle.jdbc.driver.OracleDriver
Possible not found class: oracle.jdbc.driver.OracleDriver
...
Details>>
Message:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
Level:
SEVERE
Stack Trace:
oracle.jdbc.driver.OracleDriver
com.jaspersoft.ireport.designer.connection.DriverPool.registerDriver(DriverPool.java:156)
com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:98)
com.jaspersoft.ireport.designer.connection.JDBCConnection.test(JDBCConnection.java:420)
com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:316)
com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:25)
com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:271)
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
java.awt.Component.processMouseEvent(Component.java:6038)
javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
java.awt.Component.processEvent(Component.java:5803)
java.awt.Container.processEvent(Container.java:2058)
java.awt.Component.dispatchEventImpl(Component.java:4410)
java.awt.Container.dispatchEventImpl(Container.java:2116)
java.awt.Component.dispatchEvent(Component.java:4240)
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
java.awt.Container.dispatchEventImpl(Container.java:2102)
java.awt.Window.dispatchEventImpl(Window.java:2429)
java.awt.Component.dispatchEvent(Component.java:4240)
java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:177)
java.awt.Dialog$1.run(Dialog.java:1039)
java.awt.Dialog$3.run(Dialog.java:1091)
java.security.AccessController.doPrivileged(Native Method)
java.awt.Dialog.show(Dialog.java:1089)
java.awt.Component.show(Component.java:1419)
java.awt.Component.setVisible(Component.java:1372)
java.awt.Window.setVisible(Window.java:801)
java.awt.Dialog.setVisible(Dialog.java:979)
com.jaspersoft.ireport.designer.wizards.ConnectionSelectionVisualPanel.jButton1ActionPerformed(ConnectionSelectionVisualPanel.java:284)
com.jaspersoft.ireport.designer.wizards.ConnectionSelectionVisualPanel.access$400(ConnectionSelectionVisualPanel.java:24)
com.jaspersoft.ireport.designer.wizards.ConnectionSelectionVisualPanel$6.actionPerformed(ConnectionSelectionVisualPanel.java:196)
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
java.awt.Component.processMouseEvent(Component.java:6038)
javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
java.awt.Component.processEvent(Component.java:5803)
java.awt.Container.processEvent(Container.java:2058)
java.awt.Component.dispatchEventImpl(Component.java:4410)
java.awt.Container.dispatchEventImpl(Container.java:2116)
java.awt.Component.dispatchEvent(Component.java:4240)
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
java.awt.Container.dispatchEventImpl(Container.java:2102)
java.awt.Window.dispatchEventImpl(Window.java:2429)
java.awt.Component.dispatchEvent(Component.java:4240)
java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:177)
java.awt.Dialog$1.run(Dialog.java:1039)
java.awt.Dialog$3.run(Dialog.java:1091)
java.security.AccessController.doPrivileged(Native Method)
java.awt.Dialog.show(Dialog.java:1089)
org.netbeans.core.windows.services.NbPresenter.superShow(NbPresenter.java:834)
org.netbeans.core.windows.services.NbPresenter.doShow(NbPresenter.java:868)
org.netbeans.core.windows.services.NbPresenter.run(NbPresenter.java:856)
org.netbeans.core.windows.services.NbPresenter.run(NbPresenter.java:104)
org.openide.util.Mutex.doEventAccess(Mutex.java:1223)
org.openide.util.Mutex.readAccess(Mutex.java:242)
org.netbeans.core.windows.services.NbPresenter.show(NbPresenter.java:841)
java.awt.Component.show(Component.java:1419)
java.awt.Component.setVisible(Component.java:1372)
java.awt.Window.setVisible(Window.java:801)
java.awt.Dialog.setVisible(Dialog.java:979)
org.openide.loaders.TemplateWizard.instantiateImpl(TemplateWizard.java:502)
org.openide.loaders.TemplateWizard.instantiate(TemplateWizard.java:369)
org.netbeans.modules.project.ui.actions.NewFile.doPerform(NewFile.java:147)
org.netbeans.modules.project.ui.actions.NewFile.access$200(NewFile.java:80)
org.netbeans.modules.project.ui.actions.NewFile$PopupListener.actionPerformed(NewFile.java:340)
javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
javax.swing.AbstractButton.doClick(AbstractButton.java:357)
javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1216)
javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:1257)
java.awt.Component.processMouseEvent(Component.java:6038)
javax.swing.JComponent.processMouseEvent(JComponent.java:3260)
java.awt.Component.processEvent(Component.java:5803)
java.awt.Container.processEvent(Container.java:2058)
java.awt.Component.dispatchEventImpl(Component.java:4410)
java.awt.Container.dispatchEventImpl(Container.java:2116)
java.awt.Component.dispatchEvent(Component.java:4240)
java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4322)
java.awt.LightweightDispatcher.processMouseEvent(Container.java:3986)
java.awt.LightweightDispatcher.dispatchEvent(Container.java:3916)
java.awt.Container.dispatchEventImpl(Container.java:2102)
java.awt.Window.dispatchEventImpl(Window.java:2429)
java.awt.Component.dispatchEvent(Component.java:4240)
java.awt.EventQueue.dispatchEvent(EventQueue.java:599)
java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:273)
java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:183)
java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:173)
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:168)
java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:160)
java.awt.EventDispatchThread.run(EventDispatchThread.java:121)