Getting classnot found exception while connecting to database adapter in Jaspersoft

[reena.b.rathod]

net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: tibcosoftware.jdbc.oracle.OracleDriver

at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:172)

at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:127)

at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:128)

at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.run(AbstractDataAdapterWizard.java:157)

at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)

Caused by: java.lang.ClassNotFoundException: tibcosoftware.jdbc.oracle.OracleDriver

at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:501)

at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:421)

at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:412)

at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)

at java.lang.ClassLoader.loadClass(Unknown Source)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Unknown Source)

at net.sf.jasperreports.engine.util.JRClassLoader.loadClassForRealName(JRClassLoader.java:174)

at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:144)

... 4 more

 

[hozawa]

You didn't specify the oracle jdbc driver. When you define your data adapter, there's a tab at the bottom named "Driver Classpath". Select that and specify your oracle jdbc jar file.

[Massimo Rabbi]

Hi,
the TIBCO is supposed to be used within Jaspersoft Studio Professional.
If you are running JSS Community Edition please select the standard JDBC driver "oracle.jdbc.driver.OracleDriver".

Moreover as hozawa said you need to specify the additional information inside the "Driver Classpath" tab. You will have to download the driver by yourself from the Oracle website. This is not necessary if you are using the Professional version.

Regards,
Massimo.

[reena.b.rathod]

Thank you for your response. I did add the classpath but it didn't work..

 

[ahmed.shaker]

that's what i'm looking for .. thanks a lot

[cekebui]

Hozawa, you answer solved my problem. Arigatou.