[An error (java.lang.reflect.InvocationTargetException) when using Hibernate as a data adapter]

Hi All,

I am having a problem when trying to use the Hibernate data adapter (which works in other settings). This is the error when I test the connection:

---

net.sf.jasperreports.engine.JRException: java.lang.reflect.InvocationTargetException

at net.sf.jasperreports.data.hibernate.HibernateDataAdapterService.contributeParameters(HibernateDataAdapterService.java:138)

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

at com.jaspersoft.studio.data.DataAdapterEditorPart$1.widgetSelected(DataAdapterEditorPart.java:175)

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.Widget.sendEvent(Widget.java:1053)

at org.eclipse.swt.widgets.Display.runDeferredEvents(Display.java:4169)

at org.eclipse.swt.widgets.Display.readAndDispatch(Display.java:3758)

at org.eclipse.ui.internal.Workbench.runEventLoop(Workbench.java:2701)

at org.eclipse.ui.internal.Workbench.runUI(Workbench.java:2665)

at org.eclipse.ui.internal.Workbench.access$4(Workbench.java:2499)

at org.eclipse.ui.internal.Workbench$7.run(Workbench.java:679)

at org.eclipse.core.databinding.observable.Realm.runWithDefault(Realm.java:332)

at org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Workbench.java:668)

at org.eclipse.ui.PlatformUI.createAndRunWorkbench(PlatformUI.java:149)

at com.jaspersoft.studio.rcp.intro.Application.start(Application.java:96)

at org.eclipse.equinox.internal.app.EclipseAppHandle.run(EclipseAppHandle.java:196)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(EclipseAppLauncher.java:110)

at org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(EclipseAppLauncher.java:79)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:353)

at org.eclipse.core.runtime.adaptor.EclipseStarter.run(EclipseStarter.java:180)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at org.eclipse.equinox.launcher.Main.invokeFramework(Main.java:629)

at org.eclipse.equinox.launcher.Main.basicRun(Main.java:584)

at org.eclipse.equinox.launcher.Main.run(Main.java:1438)

Caused by: java.lang.reflect.InvocationTargetException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

at java.lang.reflect.Method.invoke(Unknown Source)

at net.sf.jasperreports.data.hibernate.HibernateDataAdapterService.contributeParameters(HibernateDataAdapterService.java:94)

... 27 more

Caused by: org.hibernate.MappingException: Unable to load class declared as <mapping class="com.pam.diapro2.hibernate.pojo.Allocation"/> in the configuration:

at org.hibernate.cfg.AnnotationConfiguration.parseMappingElement(AnnotationConfiguration.java:545)

at org.hibernate.cfg.Configuration.parseSessionFactory(Configuration.java:1479)

at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1458)

at org.hibernate.cfg.Configuration.doConfigure(Configuration.java:1432)

at org.hibernate.cfg.Configuration.configure(Configuration.java:1386)

... 32 more

Caused by: java.lang.ClassNotFoundException: com.pam.diapro2.hibernate.pojo.Allocation

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 org.hibernate.util.ReflectHelper.classForName(ReflectHelper.java:100)

at org.hibernate.cfg.AnnotationConfiguration.parseMappingElement(AnnotationConfiguration.java:542)

... 36 more

---

The stated problem is that there is a class not found: com.pam.diapro2.hibernate.pojo.Allocation

The thing is, that class DOES exist and I can access it by other means. How should I proceed?

If it helps any, I have copied all relevant .jars into the Jaspersoft/.../lib/ext folder and I have unpacked the .jar that contains the hibernate config (which is also where the missing class is found).

[How can I create complex variables?]

Hello Jaspersoft Community,

I am a new user of Jaspersoft and I am trying to create variables that can help me analyze financial data. For example, how can I go about recreating the Sharpe ratio calculation given a set of historical data and a daily PL (or cumulative) of a set of trades? (ROR_Portfolio - ROR_{Risk Free}) / STD_Portfolio. If I am unable to do this, I can imagine a function doing this separately and passing it in, but how/where would I enact this function?

I am trying to find detailed documentation for how to use Jaspersoft but I have been unable to find what I am looking for.

Help would be greatly appreciated. Thank you in advance!