xcdemon

After trying to update to iReport 3.7.3, doing the same configuration steps to get iReport set up to use the EJBQL queries is throwing exceptions when trying to create a report. Testing the connection by setting up the Persistence Unit Name is successful. When then trying to create a new report, clicking on the query icon yields an exception. java.lang.NoClassDefFoundError: org/hibernate/Session at com.jaspersoft.ireport.designer.menu.OpenQueryDialogAction.performAction(OpenQueryDialogAction.java:54) at org.openide.util.actions.CallableSystemAction$1.run(CallableSystemAction.java:118) at org.netbeans.modules.openide.util.ActionsBridge.doPerformAction(ActionsBridge.java:77) at org.openide.util.actions.CallableSystemAction.actionPerformed(CallableSystemAction.java:114) at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849) at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169) at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420) at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236) at java.awt.Component.processMouseEvent(Component.java:5517) at javax.swing.JComponent.processMouseEvent(JComponent.java:3135) at java.awt.Component.processEvent(Component.java:5282) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3984) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3819) at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212) at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892) at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822) at java.awt.Container.dispatchEventImpl(Container.java:2010) at java.awt.Window.dispatchEventImpl(Window.java:1791) at java.awt.Component.dispatchEvent(Component.java:3819) [catch] at java.awt.EventQueue.dispatchEvent(EventQueue.java:463) at org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104) at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242) at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157) at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149) at java.awt.EventDispatchThread.run(EventDispatchThread.java:110) The same approach taken to get iReport 3.7.1 and 3.7.2 set up to use my ejbql setup was followed. Is there any difference in classloading or additional copies of hibernate jars hiding out somewhere in the 3.7.3 version? Thanks for any responses. -Drew

The connection now works and you are able to preview your reports with ejbql in iReport 3.7.1? Is your datasource set up with JNDI or just via the persistence.xml?

Thanks for this post. I've got a working test connection, but it doesn't appear to actually test the connection to the DB. Is your persistence.xml pointing at a jndi datasource, or does it define the db connection setting in it? Are you able to successfully preview a report, even with a simple query like select m from Account m. I keep getting an error "the user must supply a JDBC connection" but I'm not sure where and what needs to be present for iReport to find the connection since it's ignoring the db specific connection details in my persistence.xml.

I'm also having some issues. By following the steps above. I was able to get iReport to successfully test the connection. So I thought I was in the clear at that point. However whenever I try to either get Fields when building a report query, or if I try to preview a report that was essentially hand coded to work I get an error saying "The user must supply a JDBC connection" Does the Test Connection not get a JDBC connection, and if so why can't the same connection work when trying to preview the report etc? it seems like hibernate is lacking something to get the connection, but I think I have any relevant data in the persistence.xml. The following is my persistence.xml. I had to create it seperate from the Seam Project that it came from since that used JNDI etc. Any help/ideas would be appreciated. Not being able to use iReport with ejbql is really putting a damper on it's effectiveness for our purposes. Code:<properties> <property name="hibernate.show_sql" value="false" /> <property name="hibernate.cache.provider_class" value="net.sf.ehcache.hibernate.EhCacheProvider" /> <property name="hibernate.cache.use_second_level_cache" value="true" /> <property name="hibernate.dialect" value="org.hibernate.dialect.OracleDialect" /> <property name="hibernate.default_schema" value="OPS$USER" /> <property name="hibernate.jdbc.url" value="jdbc:oracle:thin@dbserv:1521/DBDEV" /> <property name="hibernate.jdbc.driver_class" value="oracle.jdbc.driver.OracleDriver" /> <property name="hibernate.jdbc.username" value="user" /> <property name="hibernate.jdbc.password" value="pwd" /> <property name="hibernate.search.autoregister_listeners" value="false"/> </properties>