xcdemon
-
Posts
4 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Security Advisories
Downloads
Posts posted by xcdemon
-
-
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>
EJBQL connections with iReport 3.7.3
in Products
Posted
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