Category: | Bug report |
Priority: | Normal |
Status: | New |
Project: | Severity: | Tweak |
Resolution: | Open |
|
Component: | Reproducibility: | Always |
Assigned to: |
I have created a simple SOAP Axis2 Web service with JasperReports Libraries. Using iReport designer I created simple report which selects fields from a VIEW in my database. It works perfectly in designer(select all the needed data), but when I try to compile it with libraries I get:
<soapenv:Envelope xmlns:soapenv="http://www.w3.org/2003/05/soap-envelope">
<soapenv:Body>
<soapenv:Fault>
<soapenv:Code>
<soapenv:Value>soapenv:Receiver</soapenv:Value>
</soapenv:Code>
<soapenv:Reason>
<soapenv:Text xml:lang="en-US">Error executing SQL statement for : Report1</soapenv:Text>
</soapenv:Reason>
<soapenv:Detail>
<ns:JasperServiceJRException xmlns:ns="http://jasplib.com">
<JRException xsi:type="ax21:JRException" xmlns="http://jasplib.com" xmlns:ax21="http://engine.jasperreports.sf.net/xsd" xmlns:ax25="http://sql.java/xsd" xmlns:ax23="http://io.java/xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
</ns:JasperServiceJRException>
</soapenv:Detail>
</soapenv:Fault>
</soapenv:Body>
</soapenv:Envelope>
This bug happens only with VIEW's. So it took me 1 day to figure this out. In my view select i used division and multiplication with varchar2 and i think iReport,pl/sql developer automatically casted it into number but the libraries couldn't.
1 Comment:
System Message