[#3130] - [JasperReports Library] Selecting from a VIEW error

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.

v5.0
andrius.versockas's picture
Joined: Mar 22 2013 - 7:16am
Last seen: 8 years 8 months ago

1 Comment:

#1
  • Priority:High» Normal
  • Severity:Major» Tweak

System Message

Feedback