edmundhaley

I was actually able to resolve the issue. In going through the JasperForge Forum and cross referencing mutlitple Mongo and Jasper Forums and Tutorials. It turned out to be how the Mongo Database Query String was composed. Here is the original query string from my JRXML Template File: <queryString> <![CDATA[{ 'collectionName':'LabOrder', 'findFields':{'pat':1, 'oNum':1, 'oDate':1, 'stat':1, 'resStat':1, 'crit':1, 'pri':1}, 'sort':{'oDate':1}, 'findQuery':{'pat':'$P!{PatientId}'} }]]> </queryString> And here is how I resolved the matter: <queryString> <![CDATA[{ 'collectionName':'LabOrder', 'findFields':{'pat':1, 'oNum':1, 'oDate':1, 'stat':1, 'resStat':1, 'crit':1, 'pri':1}, 'sort':{'oDate':1}, 'findQuery':{'pat':{'$oid':'$P!{PatientId}'}} }]]> </queryString> I had to introduce the use of the $oid for the Mongo Query Builder and the Query Executer to recognize the use of the BSON ObjectId being passed as a paramter via String...... Hopefully my find will assist others....this was kind of a pain to figure out......just not enough documenation really on Mongo and Jaser Reports. Maurice

Our company is presently attempting to inject Japser Reports into our Cloud Application. Having utilized Jasper Reports in the past with relational databases, I did not believe this to be a problem; however the database being utilized by the company is a NOSQL, or in other words MONGO. Having found the required Mongo Datasource Interface, Version 0.9, I downloaded and installed the plugin as instructed. The MONGO Queries appear to work fine as long as ObjectId's are not a field of the data query. More specifically I am unable to utilze the MONGO ObjectId Field within the "findQuery" parameter of the query being passed to the JasperReport .JRXML Template. Presently I am receiving a JSON Parsing Error and the stacktrace is suggesting it does not understand the MONGO ObjectId.......Are there any suggestions or helpful tips to overcome this obstacle. Looking forward to your response. Maurice Johnson

I initially had trouble with this error as well. This is how I resolved the issue; I am presently using the JasperSoft iReport-Professional-4.0. I navigated to the following path; "C:\Program Files\Jaspersoft\iReport-Professional-4.0\ireport\modules\ext" Copied the delivered Jar Files; "iText-2.1.7.jar" and "iTextAsian.jar" to the "lib" Folder of my Web Application Project. Add both JARS to my Project Classpath. Recompiled the Project into a WAR File. And it worked successfully. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ NOTE: I initially atttemped adding the lastest iText JAR File to my project classpath, iText-5.0.6.jar, and I receieved the same error as before. So this is what made me think to look at the jars being utilized by JasperReports and iText.

This Is the Specific Error Being Thrown when clicking on the Add Jar Command Button: java.lang.ArrayIndexOutOfBoundsException: 3184 at sun.awt.shell.Win32ShellFolder2.getFileChooserIcon(Win32ShellFolder2.java:748) at sun.awt.shell.Win32ShellFolderManager2.get(Win32ShellFolderManager2.java:248) at sun.awt.shell.ShellFolder.get(ShellFolder.java:221) at com.sun.java.swing.plaf.windows.WindowsLookAndFeel$LazyWindowsIcon.createValue(WindowsLookAndFeel.java:1873) at javax.swing.UIDefaults.getFromHashtable(UIDefaults.java:185) at javax.swing.UIDefaults.get(UIDefaults.java:130) at javax.swing.MultiUIDefaults.get(MultiUIDefaults.java:44) at javax.swing.UIDefaults.getIcon(UIDefaults.java:411) at javax.swing.UIManager.getIcon(UIManager.java:613) at javax.swing.plaf.basic.BasicFileChooserUI.installIcons(BasicFileChooserUI.java:237) at javax.swing.plaf.basic.BasicFileChooserUI.installDefaults(BasicFileChooserUI.java:219) at javax.swing.plaf.basic.BasicFileChooserUI.installUI(BasicFileChooserUI.java:135) at com.sun.java.swing.plaf.windows.WindowsFileChooserUI.installUI(WindowsFileChooserUI.java:126) at javax.swing.JComponent.setUI(JComponent.java:653) at javax.swing.JFileChooser.updateUI(JFileChooser.java:1755) at javax.swing.JFileChooser.setup(JFileChooser.java:366) at javax.swing.JFileChooser.<init>(JFileChooser.java:341) at javax.swing.JFileChooser.<init>(JFileChooser.java:300) at com.jaspersoft.ireport.designer.options.IReportPanel.jButtonAddClasspathItemActionPerformed(IReportPanel.java:2173) at com.jaspersoft.ireport.designer.options.IReportPanel.access$1800(IReportPanel.java:84) at com.jaspersoft.ireport.designer.options.IReportPanel$25.actionPerformed(IReportPanel.java:906) 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:5501) at javax.swing.JComponent.processMouseEvent(JComponent.java:3135) at java.awt.Component.processEvent(Component.java:5266) at java.awt.Container.processEvent(Container.java:1966) at java.awt.Component.dispatchEventImpl(Component.java:3968) at java.awt.Container.dispatchEventImpl(Container.java:2024) at java.awt.Component.dispatchEvent(Component.java:3803) 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:1778) at java.awt.Component.dispatchEvent(Component.java:3803) [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)

I just downloaded iReport 4.01. I am attempting to establish my Database Connection with an Oracle Thin Driver. I am presently unable to add the correct Oracle JDBC Jar to the Classpath so that I can create this Database Connection. Why?