PLS any one Look on this Problem(veryUrjent)

[2006 JR Open Discussion]

By: ramesh - dramesh

PLS any one Look on this Problem(veryUrjent)

2006-01-19 18:48

Hi All,

 

i'm new to JasperReports.

when i'm trying to give my query as parametr to the report i'm getting the following exception.

i done like this i have given the

<queryString><![CDATA[$P{RamQuery}]]</queryString>

 

i'm passing parameter like this

 

 

StringBuffer sb=new StringBuffer();

sb.append("select set_id,edu_inst_id from student_program_category where set_id='2' and edu_inst_id in ('UOL','SIM')");

Map parameters = new HashMap();

parameters.put("RamQuery",sb.toString());

 

WHEN I'M TRYING TO EXECUTE THIS I'M GETTING FOLLOWING EXCEPTION PLS ANY ONE CAN HELP

Thanks in Advance

Ram

 

java.sql.SQLException: Invalid SQL type at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:226) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:66) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:542) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1027) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2887) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2928) at net.sf.jasperreports.engine.fill.JRFillDataset.createDataSource(JRFillDataset.java:676) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:696) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:163) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:662) at java.lang.Thread.run(Unknown Source) NESTED BY : java.sql.SQLException: Invalid SQL type at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:226) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:66) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:542) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1027) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2887) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2928) at net.sf.jasperreports.engine.fill.JRFillDataset.createDataSource(JRFillDataset.java:676) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:696) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:163) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:662) at java.lang.Thread.run(Unknown Source) NESTED BY : net.sf.jasperreports.engine.JRException: Error executing SQL statement for report : Sample at net.sf.jasperreports.engine.fill.JRFillDataset.createDataSource(JRFillDataset.java:684) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:696) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:163) at it.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:662) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: Invalid SQL type at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:124) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:161) at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:226) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:66) at oracle.jdbc.driver.T4CPreparedStatement.execute_for_rows(T4CPreparedStatement.java:542) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1027) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2887) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:2928) at net.sf.jasperreports.engine.fill.JRFillDataset.createDataSource(JRFillDataset.java:676) ... 6 more

Print not filled. Try to use an EmptyDataSource...!

 

 

By: nsorochan - nsorochan

RE: PLS any one Look on this Problem(veryUrj

2006-01-20 07:03

I think the format you will need is <![CDATA[$P!{RamQuery}]]>

 

Notice the !