Error preparing statement in Jasper
- by Augusto
Hi,
I'm trying to create a report with Jasper, but I keep getting this exception when running from my app (runs ok from IReport):
net.sf.jasperreports.engine.JRException: Error preparing statement for executing the report query
Here's the query I'm using:
SELECT
produtos.`Descricao` AS produtos_Descricao,
saidas.`Quantidade` AS saidas_Quantidade,
saidas.`Data` AS saidas_Data,
motivossaidas.`Motivo` AS motivossaidas_Motivo
FROM
`produtos` produtos INNER JOIN `saidas` saidas ON produtos.`Id` = saidas.`Id_Produto`
INNER JOIN `motivossaidas` motivossaidas ON saidas.`Id_MotivoSaida` = motivossaidas.`id` WHERE
motivossaidas.`motivo` = $P{MOTIVO}
and the parameter definition:
<parameter name="MOTIVO" class="java.lang.String"/>
The exception occurs when I do
JasperPrint jasperPrint = JasperFillManager.fillReport(relatorio, parametros);
where relatorio is a JasperReport object loaded with JRLoader.loadObject(URL) and parametros is a HashMap with the following key/values:
REPORT_CONNECTION = MySQL JDBC connection,
MOTIVO = "Venda"
I really don't know what to do here. I keep getting the exception event if I use a query without any parameters.
Why do I get this exception? What should I do here?
Thanks!
