javydreamercsw

Is there a documented approach to using JPA and iReports? I'm planning on use such approach in my project.

I've seen JPA datasources and related stuff but I'm missing an example of running a report provided a JPA EntityManager. Anyone has a link?

Version 3.0 still has its issues, which the beta testers are going thru, but there's always a data base script for it. If you 're using the installer it'll reset the database so you'll need to backup that one first, then recover from back up. If you're using the war file is easier to update IMO. Just replace the war in the web server and run the update db script before re-starting.

Found a rather critical error. See the next issued for details: http://jasperforge.org/sf/go/artf3188?nav=1 P.S. I'm assigning the bugs to you Marina, hope it's the right thing to do. Post edited by: javydreamercsw, at: 2008/04/23 05:23

Share your happiness. Sadly I've already filed a bug in the creation user window. Valid emails which nowadays might have more than one '.' are interpreted as invalid. Maybe the validation has the amount of '.' into account. Did the database changed at all?

I did a while ago, just forgot about posting here. http://jasperforge.org/sf/go/artf3156

Change info in: <tomcat>webappsjasperserverMETA-INFcontext.xml

Verify that the jasperadmin user is properly created, has grant access to the database and the password is correct.

Somewhere at the start of the command prompt (the one that says tomcat) its displayed the port being used. Use an URL like this one: http://localhost:<port i.e. 8080>/jasperserver. The command prompt you pasted info from should open another command prompt. If not the port (8080) must be being used by other application.

Any update on this? I'm impatiently waiting to get my hands on the new version.

Thanks for the ireport.jar pointer. It fixed all problems. I missed that one when upgrading jasper server to 2.0.5.

Does the Hierarchy name you mention have any format? I named them as the Dimension (i.e. Time) but now I guess the following error from the workbench: 10:33:58,606 ERROR [QueryPanel] Exception: null java.lang.NullPointerException at mondrian.rolap.HierarchyUsage.init(HierarchyUsage.java:364) at mondrian.rolap.HierarchyUsage.<init>(HierarchyUsage.java:199) at mondrian.rolap.RolapCube.createUsage(RolapCube.java:1242) at mondrian.rolap.RolapCube.createUsages(RolapCube.java:1194) at mondrian.rolap.RolapCube.<init>(RolapCube.java:153) at mondrian.rolap.RolapCube.<init>(RolapCube.java:168) at mondrian.rolap.RolapSchema.load(RolapSchema.java:402) at mondrian.rolap.RolapSchema.load(RolapSchema.java:301) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:214) at mondrian.rolap.RolapSchema.<init>(RolapSchema.java:207) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:845) at mondrian.rolap.RolapSchema$Pool.get(RolapSchema.java:660) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:149) at mondrian.rolap.RolapConnection.<init>(RolapConnection.java:80) at mondrian.olap.DriverManager.getConnection(DriverManager.java:190) at mondrian.olap.DriverManager.getConnection(DriverManager.java:131) at mondrian.olap.DriverManager.getConnection(DriverManager.java:55) at mondrian.gui.QueryPanel.connectButtonActionPerformed(QueryPanel.java: 276) at mondrian.gui.QueryPanel.access$000(QueryPanel.java:51) at mondrian.gui.QueryPanel$2.actionPerformed(QueryPanel.java:150) at javax.swing.AbstractButton.fireActionPerformed(Unknown Source) at javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) at javax.swing.DefaultButtonModel.setPressed(Unknown Source) at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Sour ce) at java.awt.Component.processMouseEvent(Unknown Source) at javax.swing.JComponent.processMouseEvent(Unknown Source) at java.awt.Component.processEvent(Unknown Source) at java.awt.Container.processEvent(Unknown Source) at java.awt.Component.dispatchEventImpl(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) at java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) at java.awt.Container.dispatchEventImpl(Unknown Source) at java.awt.Window.dispatchEventImpl(Unknown Source) at java.awt.Component.dispatchEvent(Unknown Source) at java.awt.EventQueue.dispatchEvent(Unknown Source) at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.pumpEvents(Unknown Source) at java.awt.EventDispatchThread.run(Unknown Source) This happens when opening a new MDX query. Attempting to connect from the windows creates the same error.

I'm preparing to test your suggestion. Besides that does the schema looks ok?

Following thread: http://www.jasperforge.org/index.php?option=com_joomlaboard&Itemid=215&func=view&catid=10&id=38598 Jasperserver is now running reports created/compiled with iReport 2.0.5. After the change I've noticed a different behavior with non mandatory fields in the report parameters. In the previous version when you didn't provide a value of a non-mandatory field (i.e. select the empty space in a drop down control) the report was ran against the report's default parameters, which I set to '%' using like statements. It worked perfectly. After the lib switch when you don't provide a value the same report returns an empty result/report message. My concussion: the jasperreports engine interprets the sent value (dunno what the control sends, a null or "" perhaps) and uses that as parameter causing a statement like mine (i.e. using like $P{parameter}) translate into something like "... like ''" which obviously gets an empty result. Is this a bug?

I'm basically learning in the process so please bear with me... I've been learning on my own about data warehouses and so on. Already have my draft of the structure and is partly being populated with Talend. I have the fact table and 3 dimensions already there so I wanted to go ahead and start testing with the workbench. I'm trying the following query: select {[Measures].[amount]} on columns,{[Product].[description]} on rows from [Quality] on this schema: <Cube name="Quality" caption="" cache="true" enabled="true"> <Table name="production_fact" schema="" alias=""> </Table> <Dimension type="StandardDimension" usagePrefix="" foreignKey="lot_id" name="Lot"> <Hierarchy name="New Hierarchy 0" hasAll="true" primaryKey="lot_id" primaryKeyTable="lot" caption=""> <Table name="lot" schema="" alias=""> </Table> </Hierarchy> </Dimension> <Dimension type="TimeDimension" usagePrefix="" foreignKey="Time_key" name="Time"> <Hierarchy name="New Hierarchy 0" hasAll="true" primaryKey="Time_key" primaryKeyTable="time" caption=""> <Table name="time" schema="" alias=""> </Table> </Hierarchy> </Dimension> <Dimension type="StandardDimension" usagePrefix="" foreignKey="product_key" name="Product"> <Hierarchy name="New Hierarchy 0" hasAll="true" allMemberName="" allMemberCaption="" allLevelName="" primaryKey="product_key" primaryKeyTable="product" defaultMember="" memberReaderClass=""> <Table name="product" schema="" alias=""> </Table> </Hierarchy> </Dimension> <Dimension type="StandardDimension" foreignKey="complaint_key" name="Complaint"> <Hierarchy name="New Hierarchy 0" hasAll="true"> <Table name="complaint" schema="" alias=""> </Table> </Hierarchy> </Dimension> <Dimension type="StandardDimension" foreignKey="defect_key" name="Defect" caption=""> <Hierarchy name="New Hierarchy 0" hasAll="true"> <Table name="defect" schema="" alias=""> </Table> </Hierarchy> </Dimension> <Dimension type="StandardDimension" foreignKey="exception_key" name="Exception" caption=""> <Hierarchy name="New Hierarchy 0" hasAll="true"> <Table name="exception" schema="" alias=""> </Table> </Hierarchy> </Dimension> <Dimension type="StandardDimension" foreignKey="loc_key" name="Location" caption=""> <Hierarchy name="New Hierarchy 0" hasAll="true"> <Table name="localization" schema="" alias=""> </Table> </Hierarchy> </Dimension> <Measure name="amount" column="amount" datatype="Numeric" formatString="" aggregator="sum" formatter="" caption="" visible="true"> </Measure> </Cube> And this is the error: Mondrian Error:Failed to parse query 'select {[Measures].[amount]} on columns,{[Product].[description]} on rows from [Quality]' Mondrian Error:Error while parsing MDX statement 'select {[Measures].[amount]} on columns,{[Product].[description]} on rows from [Quality]' Mondrian Error:MDX cube 'Quality' not found Any idea? Thanks in advance! P.S. I'm in the process of reading the Mondrian documentation tat ships with the workbench and IMO both the schema and the query are correct. But since these are my first steps I guess I'm wrong.