Prepared Statement creation / data truncation

[aetherflux]

I have parameterized the query that I use for a report. I use this parameter called "valueList" that is either a specific entry (like "ABC") or a percent sign ('%').

 

The query works fine when the parameter is a percent sign, but if I submit it with anything other than that, I get this error:

 

Code:

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

(query left out for privacy purposes.)

at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:192)
	at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:123)
	at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:683)
	at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:615)
	at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1203)
	at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:842)
	at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:795)
	at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)
	at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:402)
	at Smart2K.Printing.ProduceReportWithJasper.setupMainPane(ProduceReportWithJasper.java:83)
	at Smart2K.Printing.ReportProducer.<init>(ReportProducer.java:79)
	at Smart2K.Printing.ProduceReportWithJasper.<init>(ProduceReportWithJasper.java:61)
	at Smart2K.Printing.PrintReport.<init>(PrintReport.java:202)
	at Smart2K.Printing.ReportParameterPanel.printReport(ReportParameterPanel.java:443)
	at Smart2K.Printing.ReportParameterPanel.checkDates(ReportParameterPanel.java:484)
	at Smart2K.Printing.ReportParameterPanel.access$2(ReportParameterPanel.java:446)
	at Smart2K.Printing.ReportParameterPanel$2.perform(ReportParameterPanel.java:286)
	at Smart2K.GUI.PrintButton.perform(PrintButton.java:157)
	at Smart2K.Util.UtilityThread.run(UtilityThread.java:50)
Caused by: java.sql.DataTruncation: Data truncation
	at interbase.interclient.PreparedStatement.setString(Unknown Source)
	at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.setStatementParameter(JRJdbcQueryExecuter.java:363)
	at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.setStatementParameter(JRJdbcQueryExecuter.java:209)
	at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createStatement(JRJdbcQueryExecuter.java:184)
	... 18 more

 

What am I doing wrong?