Jump to content
Changes to the Jaspersoft community edition download ×

PLS any can Look on this Problem(veryUrjent)


Recommended Posts

By: ramesh - dramesh

PLS any can Look on this Problem(veryUrjent)

2006-01-19 18:47

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: Lucian Chirita - lucianc

RE: PLS any can Look on this Problem(veryUrj

2006-01-20 00:52

Hi

 

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

 

HTH,

Lucian

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...