JasperServer Issues..

Well I gave up on trying the fancy stuff.    So I moved the Select Statement to a stored procedure on MYSQL 5.0.45.  SO I rebuilt the report from the ground up and tested with the stored procedure.  All is good when I run the report in the IReport viewer using the stored procedure. When I uploaded to the jasper server it bombs with an error, this will be posted after the details on the report config and the server config.

 

The report has three input parameters Start_Date_Time (TimeStamp), End_Date_Time (TimeStamp), Table_Selection(Text)

The server has report unit with three input controls:

 

Start_Date_Time:  This input control has local defined Data Type configured as Date/Time.

End_Date_Time: This input control has local defined Data Type configured as Date/Time.

Table_Selection: This input control has local defined Data Type configured as Text.

 

When I run the report on the server I am prompted for my three inputs Start Date, End Date, and Table_Selection.  I enter the exact information that i had tested with in Ireport.  And I get the following error:

 

In the error log I see :

Caused by: java.sql.SQLException: Bad format for BigDecimal ' != "" ORDER BY


This tells me that i have a bad format, but I dont know what part  on the jasperserver to troubleshoot this any further.

Any and all help is greatly appreciated.

Chrobi

 

Error Log from server:


com.jaspersoft.jasperserver.api.JSExceptionWrapper: Unable to get value for field 'value_num' of class 'java.math.BigDecimal'

com.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Unable to get value for field 'value_num' of class 'java.math.BigDecimal'

{

Truncated Part

}

Caused by: java.sql.SQLException: Bad format for BigDecimal ' != "" ORDER BY
  ' at line 3ýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýý' in column 8.
    at com.mysql.jdbc.ResultSet.getBigDecimalFromString(ResultSet.java:1333)
    at com.mysql.jdbc.ResultSet.getNativeBigDecimal(ResultSet.java:2889)
    at com.mysql.jdbc.ResultSet.getNativeBigDecimal(ResultSet.java:2846)
    at com.mysql.jdbc.ResultSet.getBigDecimal(ResultSet.java:1151)
    at org.apache.commons.dbcp.DelegatingResultSet.getBigDecimal(DelegatingResultSet.java:301)
    at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:215)
    ... 99 more

{

Truncated Part

}


net.sf.jasperreports.engine.JRException: Unable to get value for field 'value_num' of class 'java.math.BigDecimal'
Caused by: java.sql.SQLException: Bad format for BigDecimal ' != "" ORDER BY
  ' at line 3ýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýý' in column 8.
    at com.mysql.jdbc.ResultSet.getBigDecimalFromString(ResultSet.java:1333)
    at com.mysql.jdbc.ResultSet.getNativeBigDecimal(ResultSet.java:2889)
    at com.mysql.jdbc.ResultSet.getNativeBigDecimal(ResultSet.java:2846)
    at com.mysql.jdbc.ResultSet.getBigDecimal(ResultSet.java:1151)
    at org.apache.commons.dbcp.DelegatingResultSet.getBigDecimal(DelegatingResultSet.java:301)
    at net.sf.jasperreports.engine.JRResultSetDataSource.getFieldValue(JRResultSetDataSource.java:215)
    ... 99 more

{

Truncated Part

}


java.sql.SQLException: Bad format for BigDecimal ' != "" ORDER BY ' at line 3ýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýýý' in column 8.

check the types of your report columns

Objects....the report worked just fine in the Ireports IDE.  What would change between the Ireport IDE and the server?

Thanks...

nothing 'should' :)
are the same versions of jars being used by both?

Umm forgive me for asking how can i tell which jars are being use on the Ireporter and the Jasperserver?

I have checked all the jar files and the all got the same filesizes and names....  I am not sure what i am looking for to say the files are the same...