sql exception

By: naveen - naveen_bensily
sql exception
2003-12-11 05:34
sir i am getting a problem when i am trying to fill the report using JasperFillManager.it says invalid sql statement.the compiling is working fine,but when it is trying to fill it comes with the exception.The query works fine.it works fine when i am not using any web server.

the exception is as follows
java.sql.SQLException: ORA-00900: invalid SQL statement

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java)
at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:375)
at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:142)
at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:423)
at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119)
at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219)
at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:140)
at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:108)
at com.sysarris.report.CreateReport.buildReport(CreateReport.java:171)
at com.sysarris.report.CreateReport.doPost(CreateReport.java:53)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

NESTED BY :
java.sql.SQLException: ORA-00900: invalid SQL statement

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java)
at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:375)
at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:142)
at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:423)
at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119)
at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219)
at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:140)
at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:108)
at com.sysarris.report.CreateReport.buildReport(CreateReport.java:171)
at com.sysarris.report.CreateReport.doPost(CreateReport.java:53)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)

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

null


at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:379)
at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:142)
at dori.jasper.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:423)
at dori.jasper.engine.fill.JRFiller.fillReport(JRFiller.java:119)
at dori.jasper.engine.JasperFillManager.fillReport(JasperFillManager.java:219)
at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:140)
at dori.jasper.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:108)
at com.sysarris.report.CreateReport.buildReport(CreateReport.java:171)
at com.sysarris.report.CreateReport.doPost(CreateReport.java:53)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:241)
at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:527)
at jrun.servlet.http.WebService.invokeRunnable(WebService.java:172)
at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:348)
at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:451)
at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:294)
at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
Caused by: java.sql.SQLException: ORA-00900: invalid SQL statement

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java)
at dori.jasper.engine.util.JRQueryExecuter.executeQuery(JRQueryExecuter.java:375)
... 19 more







By: Andy Deighton - andyxr
RE: sql exception
2003-12-11 05:50
What's the query? How are you passing it to the report?

Andy
UK




By: Teodor Danciu - teodord
RE: sql exception
2003-12-11 08:59

Hi,

It looks like the report query is missing.
The stack trace says:

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

null

...

I hope this helps.
Teodor