How to configure a data adapter for Oracle

[carlota_vina]

I have a report and I want to configure a data adapter for oracle.

I attach the data adapter configuration

When I test the connection, I get the error

net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver cannot be found by net.sf.jasperreports_6.3.1.final
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:173)
    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:128)
    at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:122)
    at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.runOperations(AbstractDataAdapterWizard.java:162)
    at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:59)
    at java.lang.Thread.run(Thread.java:745)
Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver cannot be found by net.sf.jasperreports_6.3.1.final
    at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:439)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:352)
    at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:344)
    at org.eclipse.osgi.internal.loader.ModuleClassLoader.loadClass(ModuleClassLoader.java:160)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Class.java:348)

 

How do I have to configure a Oracle data adapter?

 

 

[Paul Jimenez]

Hello,

I assume this is in Jaspersoft Studio. From that error, it looks like it cannot see the Oracle Driver. Are you using your own Oracle Driver? Information on how to configure a data adapter can be found here:

https://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v630/creating-and-editing-data-adapters

Regards,

Paul

[carlota_vina]

I attached the jar to the classpath. But I get the following error

 

net.sf.jasperreports.engine.JRException: java.sql.SQLRecoverableException: Error de E/S: The Network Adapter could not establish the connection    at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:130)    at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:122)    at com.jaspersoft.studio.data.DataAdapterEditorPart$1.widgetSelected(DataAdapterEditorPart.java:170)    at org.eclipse.swt.widgets.TypedListener.handleEvent(TypedListener.java:248)    at org.eclipse.swt.widgets.EventTable.sendEvent(EventTable.java:84)    at org.eclipse.swt.widgets.Display.sendEvent(Display.java:4362)    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.java:1113)    at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4180)    at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3769)    at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$4.run(PartRenderingEngine.java:1127)    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)    at org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(PartRenderingEngine.java:1018)    at org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(E4Workbench.java:156)    at org.eclipse.ui.internal.Workbench$5.run(Workbench.java:694)    at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:337)    at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:606)    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:150)    at com.jaspersoft.studio.rcp.intro.Application.start(Application.java:99)    at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:134)    at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:104)    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:380)    at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:235)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)    at java.lang.reflect.Method.invoke(Method.java:498)    at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:669)    at org.eclipse.equinox.launcher.Main.basicRun(Main.java:608)    at org.eclipse.equinox.launcher.Main.run(Main.java:1515)

Do I need more configurations for connecting with a Oracle Database?

[pawankumar.singh]

Make sure you are able to telnet oracle database and try to login to database using sqlplus

Thanks

Pawan