leejay_bell

ok thank you,!

Thanks Mariano! i have created another report and I am still getting this : Parameter #1 (DateFrom of type java.util.Date): Wed Jan 01 00:03:00 CAT 2014 Parameter #2 (DateTo of type java.util.Date): Fri Jan 31 00:03:00 CAT 2014 The date value is wrong, i am selecting march not January? i have checked that my parameter and input control ID are identical. I'm not convinced that changing the locale will correct the wrong date being passed to the report?

ok. found the problem. very embrassing. the parameters had a trailing ':' after the name which didnt register with me at all. fixed! always something small!

Hi guys, I have been struggling with uploading and configuring reports to jasperserver recently. I have a report with 3 parameters namely : Country(text), DateFrom(Date) and DateTo(Date). I have configured the Input data types on the repository, and I have extended the jasperserver.log to write out the SQL query, I have asked a question before around the date parameter being the incorrect value and not being the selected date. but I think the problem goes a little deeper than that part as I am trying a different report now. below is the output of the log file, this gets inserted into the log just under the SQL query. does anyone have an idea why these parameters are null? I have simply added input controls with the same name as the parameter defined in iReport? do I need to do anything more here? Im I missing a step that links the parameters to the controls? Parameter #1 (DateFrom: of type java.util.Date): null Parameter #2 (DateTo: of type java.util.Date): null Parameter #3 (DateFrom: of type java.util.Date): null Parameter #4 (DateTo: of type java.util.Date): null Fill 1: no data Fill 1: no pages Fill 1: ended Fill 1: closing query executer any advice or insight here will be fantastic, I am spending way too much time around this. thank you

ok. but I would like to use the date picker tool to select a date? is there a way around that problem if i use a string instead? thank you!

Hello all, im new to Jasper and dont come from a java background and I am experiencing something strange I hope someone will be able to help me with diagnosing. I have added a date control input to a report and I have configured the jasperserver_config.properties file to use the yy/MM/dd (2014/03/01) format. the date picker display value is in the correct format that I need, I have extended the logging in the jasperserver.log file to try and capture the paramter and SQL values and I have found this line just below the SQL query : Parameter #1 (BillingDate of type java.util.Date): Tue Dec 31 22:03:00 CAT 2013. This format is incorrect and the date its wrong? I have selected the 2014/03/01 as the date? does anyone know where this date is coming from and why it isnt date pickers date? this date is not related to my hosting server or database date time so im baffled? and needless to say that my report is not returing the required data? Any help will be appreciated! thanks!

hi guys! i would really appreciate someones insight into how i can resolve this problem, my background is new to Jasper and Java so i have limited resources to get to the bottom of this. any tips would be very much appreciated!

so long and short of it is this, the parameter BillingDate is getting this date below : Parameter #1 (BillingDate of type java.util.Date): Tue Dec 31 22:03:00 CAT 2013 when in the date picker i am selecting 2014/03/01? is perhaps the JVM date wrong? but why is the parameter value showing not what i chose? the parameter should

n term of the jasperserver_config.properties the formatting is explained as below # Used for parsing and formatting dates by server date.format=yy/MM/dd datetime.format=yy/MM/dd HH:mm:ss time.format=HH:mm:ss # Used for parsing and formatting dates by calendar component (UI). # Pattern for date should match appropriated pattern from server properties. # The format for calendar component can be combinations of the following: # d - day of month (no leading zero) # dd - day of month (two digit) # o - day of year (no leading zeros) # oo - day of year (three digit) # D - day name short # DD - day name long # m - month of year (no leading zero) # mm - month of year (two digit) # M - month name short # MM - month name long # y - year (two digit) # yy - year (four digit) calendar.date.format=yy/MM/dd calendar.datetime.format=yy/MM/dd HH:mm:ss calendar.time.format=HH:mm:ss Changing the mm to MM will create this : 2014/March/01 the database format is this : 2014/03/01, so that doesn't work for me. I don't understand while all the formats (input control's) appear to follow the 2014/03/01 format but in the log file the parameter output is : Parameter #1 (BillingDate of type java.util.Date): Tue Dec 31 22:03:00 CAT 2013 this date isn't even relevant???? I choose 2014/03/01 in the date picker!!! This leads me to believe that the jasper server is submitting the parameters in the incorrect format with a strange date???

ok sorry, the problem is that on the server the query that works in ireport does not return any values from jasperserver and im trying to work out where the problem is. so i run the report in ireport preview and the correct rows get returned but when i upload it to the server nothing gets returned and im trying to diagnose why that is? its seems to be date related? as it only occurs when i search for a date range and i have run out of fresh ideas.

Hello, im pretty new to jasper reports and have developed i report in Ireport 5.5.0 with two date parameters namely DateFrom and DateTo, this works fine in iReport preview but does not work in jasper reports server? I have a number of reports and what is creating a problem for me is that some reports work yet some dont? or should i say i used TO_DATE function to fix some but other reports give me the same problems by just not returning any data. I have queried the data in source and in iReport preview so i know its there. I have also changed the date format in the jasperserver_config.properties file to this : # Used for parsing and formatting dates by server date.format=yy/mm/dd datetime.format=yy/mm/dd HH:mm:ss time.format=HH:mm:ss calendar.date.format=yy/mm/dd calendar.datetime.format=yy/mm/dd HH:mm:ss calendar.time.format=HH:mm:ss so the date picker values are appropriate and seem to be in line with what i expect. what i have done to try and work around this is added this to my SQL query in Ireport: bill_date = TO_DATE($P{BillingDate},'yyyy/mm/dd') So this in my mind resolves the date format issue right? not so straight forward I have extended the logging here to get a peak at what is acually going on and find this entry : Parameter #1 (BillingDate of type java.util.Date): Tue Dec 31 22:03:00 CAT 2013 Although the DATE_TO oracle function should not let this be a problem what else am i missing here? I could use some advice?

Unfortunately this is a client server so the luxury of changing it is not available. i have however managed to get a work around. i used ojdbc14.jar instead of ojdbc6/5.jar problem resolved.

ok the exact same problem persist in version 5.2. Exception Message: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found Level: SEVERE Stack Trace: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found do you have any suggests? as previously said in JasperSoft Studio I added a connection property : oracle.jdbc.timezoneAsRegion = GMT + 2 and that works. but i cannot find the options to add a connection property in iReport so i think this will need to be put in somewhere? a file config? any suggestion will be welcome

ok thanks!

Hello, I am having difficulties connecting to an Oracle database using : Product Version: Jaspersoft iReport Designer 5.5.0 Java: 1.7.0_25; Java HotSpot Client VM 23.25-b01 System: Windows 7 version 6.1 running on x86; Cp1252; en_ZA (ireport) I have managed to work around this in JasperStudio by adding oracle.jdbc.timezoneAsRegion = GMT+2 as a connection property, but cannot see a way to add a connection property in iReport? Does anyone have some insight into where i can set this correctly? I have tried to add this to JasperReport properties tab in Tools>Options>JasperReport properties without success? I get this exception : Exception Message: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found Level: SEVERE Stack Trace: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389) oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382) oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600) oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:445) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380) oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760) oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401) oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546) oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236) oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521) com.jaspersoft.ireport.designer.connection.JDBCConnection.getConnection(JDBCConnection.java:140) com.jaspersoft.ireport.designer.connection.JDBCConnection.test(JDBCConnection.java:449) com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.jButtonTestActionPerformed(ConnectionDialog.java:335) com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog.access$300(ConnectionDialog.java:43) com.jaspersoft.ireport.designer.connection.gui.ConnectionDialog$4.actionPerformed(ConnectionDialog.java:290) javax.swing.AbstractButton.fireActionPerformed(Unknown Source) javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) javax.swing.DefaultButtonModel.setPressed(Unknown Source) javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) java.awt.Component.processMouseEvent(Unknown Source) javax.swing.JComponent.processMouseEvent(Unknown Source) java.awt.Component.processEvent(Unknown Source) java.awt.Container.processEvent(Unknown Source) java.awt.Component.dispatchEventImpl(Unknown Source) java.awt.Container.dispatchEventImpl(Unknown Source) java.awt.Component.dispatchEvent(Unknown Source) java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) java.awt.Container.dispatchEventImpl(Unknown Source) java.awt.Window.dispatchEventImpl(Unknown Source) java.awt.Component.dispatchEvent(Unknown Source) java.awt.EventQueue.dispatchEventImpl(Unknown Source) java.awt.EventQueue.access$200(Unknown Source) java.awt.EventQueue$3.run(Unknown Source) java.awt.EventQueue$3.run(Unknown Source) java.security.AccessController.doPrivileged(Native Method) java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) java.awt.EventQueue$4.run(Unknown Source) java.awt.EventQueue$4.run(Unknown Source) java.security.AccessController.doPrivileged(Native Method) java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) java.awt.EventQueue.dispatchEvent(Unknown Source) org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104) java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) java.awt.WaitDispatchSupport$2.run(Unknown Source) java.awt.WaitDispatchSupport$4.run(Unknown Source) java.security.AccessController.doPrivileged(Native Method) java.awt.WaitDispatchSupport.enter(Unknown Source) java.awt.Dialog.show(Unknown Source) java.awt.Component.show(Unknown Source) java.awt.Component.setVisible(Unknown Source) java.awt.Window.setVisible(Unknown Source) java.awt.Dialog.setVisible(Unknown Source) com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.jButtonModifyParameterActionPerformed(ConnectionsDialog.java:540) com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.jTableParametersMouseClicked(ConnectionsDialog.java:461) com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.access$300(ConnectionsDialog.java:47) com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog$6.mouseClicked(ConnectionsDialog.java:202) java.awt.AWTEventMulticaster.mouseClicked(Unknown Source) java.awt.Component.processMouseEvent(Unknown Source) javax.swing.JComponent.processMouseEvent(Unknown Source) java.awt.Component.processEvent(Unknown Source) java.awt.Container.processEvent(Unknown Source) java.awt.Component.dispatchEventImpl(Unknown Source) java.awt.Container.dispatchEventImpl(Unknown Source) java.awt.Component.dispatchEvent(Unknown Source) java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) java.awt.Container.dispatchEventImpl(Unknown Source) java.awt.Window.dispatchEventImpl(Unknown Source) java.awt.Component.dispatchEvent(Unknown Source) java.awt.EventQueue.dispatchEventImpl(Unknown Source) java.awt.EventQueue.access$200(Unknown Source) java.awt.EventQueue$3.run(Unknown Source) java.awt.EventQueue$3.run(Unknown Source) java.security.AccessController.doPrivileged(Native Method) java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) java.awt.EventQueue$4.run(Unknown Source) java.awt.EventQueue$4.run(Unknown Source) java.security.AccessController.doPrivileged(Native Method) java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) java.awt.EventQueue.dispatchEvent(Unknown Source) org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104) java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) java.awt.WaitDispatchSupport$2.run(Unknown Source) java.awt.WaitDispatchSupport$4.run(Unknown Source) java.security.AccessController.doPrivileged(Native Method) java.awt.WaitDispatchSupport.enter(Unknown Source) java.awt.Dialog.show(Unknown Source) java.awt.Component.show(Unknown Source) java.awt.Component.setVisible(Unknown Source) java.awt.Window.setVisible(Unknown Source) java.awt.Dialog.setVisible(Unknown Source) com.jaspersoft.ireport.designer.connection.gui.ConnectionsDialog.setVisible(ConnectionsDialog.java:651) com.jaspersoft.ireport.designer.menu.DatasourcesAction.performAction(DatasourcesAction.java:46) org.openide.util.actions.CallableSystemAction$1.run(CallableSystemAction.java:118) org.netbeans.modules.openide.util.ActionsBridge.doPerformAction(ActionsBridge.java:77) org.openide.util.actions.CallableSystemAction.actionPerformed(CallableSystemAction.java:114) javax.swing.AbstractButton.fireActionPerformed(Unknown Source) javax.swing.AbstractButton$Handler.actionPerformed(Unknown Source) javax.swing.DefaultButtonModel.fireActionPerformed(Unknown Source) javax.swing.DefaultButtonModel.setPressed(Unknown Source) javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unknown Source) java.awt.AWTEventMulticaster.mouseReleased(Unknown Source) java.awt.AWTEventMulticaster.mouseReleased(Unknown Source) java.awt.Component.processMouseEvent(Unknown Source) javax.swing.JComponent.processMouseEvent(Unknown Source) org.openide.awt.ToolbarButton.processMouseEvent(ToolbarButton.java:61) java.awt.Component.processEvent(Unknown Source) java.awt.Container.processEvent(Unknown Source) java.awt.Component.dispatchEventImpl(Unknown Source) java.awt.Container.dispatchEventImpl(Unknown Source) java.awt.Component.dispatchEvent(Unknown Source) java.awt.LightweightDispatcher.retargetMouseEvent(Unknown Source) java.awt.LightweightDispatcher.processMouseEvent(Unknown Source) java.awt.LightweightDispatcher.dispatchEvent(Unknown Source) java.awt.Container.dispatchEventImpl(Unknown Source) java.awt.Window.dispatchEventImpl(Unknown Source) java.awt.Component.dispatchEvent(Unknown Source) java.awt.EventQueue.dispatchEventImpl(Unknown Source) java.awt.EventQueue.access$200(Unknown Source) java.awt.EventQueue$3.run(Unknown Source) java.awt.EventQueue$3.run(Unknown Source) java.security.AccessController.doPrivileged(Native Method) java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) java.awt.EventQueue$4.run(Unknown Source) java.awt.EventQueue$4.run(Unknown Source) java.security.AccessController.doPrivileged(Native Method) java.security.ProtectionDomain$1.doIntersectionPrivilege(Unknown Source) java.awt.EventQueue.dispatchEvent(Unknown Source) org.netbeans.core.TimableEventQueue.dispatchEvent(TimableEventQueue.java:104) java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source) java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source) java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source) java.awt.EventDispatchThread.pumpEvents(Unknown Source) java.awt.EventDispatchThread.pumpEvents(Unknown Source) java.awt.EventDispatchThread.run(Unknown Source)