ASKER
ASKER
ASKER
Java Enterprise Edition (Java EE) is a specification defining a collection of Java-based server and client technologies and how they interoperate. Java EE specifies server and client architectures and uses profiles to define technology sets targeted at specific classes of applications. All Java EE profiles share a set of common features, such as naming and resource injection, packaging rules and security requirements.
TRUSTED BY
ASKER
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.jasperserve
com.jaspersoft.jasperserve
{
Truncated Part
}
Caused by: java.sql.SQLException: Bad format for BigDecimal ' != "" ORDER BY
' at line 3ýýýýýýýýýýýýýýýýýýýýýýýýý
at com.mysql.jdbc.ResultSet.g
at com.mysql.jdbc.ResultSet.g
at com.mysql.jdbc.ResultSet.g
at com.mysql.jdbc.ResultSet.g
at org.apache.commons.dbcp.De
at net.sf.jasperreports.engin
... 99 more
{
Truncated Part
}
net.sf.jasperreports.engin
Caused by: java.sql.SQLException: Bad format for BigDecimal ' != "" ORDER BY
' at line 3ýýýýýýýýýýýýýýýýýýýýýýýýý
at com.mysql.jdbc.ResultSet.g
at com.mysql.jdbc.ResultSet.g
at com.mysql.jdbc.ResultSet.g
at com.mysql.jdbc.ResultSet.g
at org.apache.commons.dbcp.De
at net.sf.jasperreports.engin
... 99 more
{
Truncated Part
}
java.sql.SQLException: Bad format for BigDecimal ' != "" ORDER BY ' at line 3ýýýýýýýýýýýýýýýýýýýýýýýýý