Error preparing statement executing report

[2004 IR Help]

By: Chris - supermonkey

Error preparing statement executing report

2005-06-06 05:53

net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query :

 

SELECT

t1.PRSSID AS CAC, t1.MONID AS MONEDA, t1.PRSNRO AS NRO_PRESTAMO, t1.PRSNID AS DOCUMENTO, t2.CLIEDENO AS DENOMINACION, t1.PRSFAL AS FECHA_ALTA, t1.PRSMTO AS MONTO_PRESTAMO

FROM

PROTDB.PRMPRS AS t1, PROTDB.CLM001 AS t2, PROTDB.gnm001 AS t3

WHERE

t1.PRSSID >= ?

AND t1.PRSSID <= ?

AND t1.PRSFAL >= ?

AND t1.PRSFAL <= ?

AND t1.PRSNID = t2.CLIEDOC

AND t1.PRSSAL > 0

AND t1.PRSFAL >= 20040722

and t3.ASMCOD=t1.PRSGER

AND t1.PRSNRO NOT IN ( SELECT t4.PRSNRO FROM PROTDB.CTDPAG AS t4 )

ORDER BY PRSSID ASC

 

I'm using iReport 0.4.1 and there I can see the results.

The field PRSSID is of type Double and PRSFAL is a String, the variables are defined as Strings.

 

Can anybody help me please.

 

Thanks in advance.

 

 

 

 

By: jorge - sirion_oef

RE: Error preparing statement executing report

2005-06-06 17:03

in your application, do you pass a connection to the report?

 

for execute the query ireport creates a connection to the db, thats problably is the reason that you can see the report only in ireport

[senthil_teen]

Hi,

Is the exception ("ERROR IN PREPARING STATEMENT") is solved????

 

Even i get the same exception even when iam not using subreport.

 

Please reply....