error when using 'where-clause' as parameter

[2001 JI Open Discussion]

By: elis - pelis

error when using 'where-clause' as parameter

2002-12-11 11:20

Hi Wolfgang,

 

I am using Jasper 0.3.3

 

I made the changes you suggested but I still get an error.

Here is what I did:

 

<parameter name="clause" class="java.lang.String"/>

 

<queryString>

select

pp.field_2 TRANSIT,

pp.field_3 ACCOUNT,

pp.field_4 CYCLE,

pp.field_20 GROUP_NO,

pp.field_21 GROUP_NAME,

pp.field_25 COURIER,

pp.field_29 FAX,

pp.field_31 FAX_NUMBER

 

from public_properties pp

$P!{clause}

group by pp.field_2, pp.field_3, pp.field_4, pp.field_20, pp.field_21, pp.field_25, pp.field_29,

pp.field_31

 

order by pp.field_2

<queryString>

 

The 'clause' that I build in my application now is:

String clause = " where 1=1";

I am not sure what do you mean with 'remove the

"where"-command in your parameter'.

 

The error I get now is:

java.sql.SQLException: [Microsoft][sqlServer 2000 Driver for JDBC]Unexpected end of escape, line 0 offset 0.

 

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

 

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

 

at com.microsoft.jdbc.base.BaseEscapeTranslator.parseEscape(Unknown Source)

 

at com.microsoft.jdbc.base.BaseEscapeTranslator.translateEscape(Unknown Source)

 

at com.microsoft.jdbc.base.BaseSQLEscapeProcessor.visit(Unknown Source)

 

at com.microsoft.jdbc.base.BaseSQLTreeTraverser.visit(Unknown Source)

 

at com.microsoft.jdbc.base.BaseSQLTreePreOrderTraverser.traverse(Unknown Source)

 

at com.microsoft.jdbc.base.BaseSQLTreePreOrderTraverser.traverse(Unknown Source)

 

at com.microsoft.jdbc.base.BaseSQLEscapeProcessor.processEscapes(Unknown Source)

 

at com.microsoft.jdbc.base.BaseSQL.translateEscapes(Unknown Source)

 

at com.microsoft.jdbc.base.BaseSQL.processSQL(Unknown Source)

 

at com.microsoft.jdbc.base.BaseSQL.<init>(Unknown Source)

 

at com.microsoft.jdbc.base.BaseStatement.preProcessSQL(Unknown Source)

 

at com.microsoft.jdbc.base.BasePreparedStatement.<init>(Unknown Source)

 

at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)

 

at com.microsoft.jdbc.base.BaseConnection.prepareStatement(Unknown Source)

 

at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:136)

 

at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:80)

 

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:275)

 

at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:67)

 

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:170)

 

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:110)

 

at dori.jasper.engine.JasperManager.fillReport(JasperManager.java:616)

 

at StListReportCompiler.<init>(StListReportCompiler.java:40)

 

at StListReportCompiler.main(StListReportCompiler.java:326)

 

 

NESTED BY :

 

dori.jasper.engine.JRException: Error executing report query :

 

select

pp.field_2 TRANSIT,

pp.field_3 ACCOUNT,

pp.field_4 CYCLE,

pp.field_20 GROUP_NO,

pp.field_21 GROUP_NAME,

pp.field_25 COURIER,

pp.field_29 FAX,

pp.field_31 FAX_NUMBER

 

from public_properties pp

 

$P!{clause}

 

group by pp.field_2, pp.field_3, pp.field_4, pp.field_20, pp.field_21, pp.field_25, pp.field_29,

 

pp.field_31

 

order by pp.field_2

 

at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:284)

 

at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:80)

 

at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:275)

 

at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:67)

 

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:170)

 

at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:110)

 

at dori.jasper.engine.JasperManager.fillReport(JasperManager.java:616)

 

at StListReportCompiler.<init>(StListReportCompiler.java:40)

 

at StListReportCompiler.main(StListReportCompiler.java:326)

 

 

Thanks,

Elis