SQLException: ODBC Engine Interface - Access denied to a READ-ONLY data source

0
Hi Forum & community members, I'm writing a report using table component against pervasive database with plsql stored procedure calls. I'm getting below error message. I set plsql query executor for jasper server by following link http://community.jaspersoft.com/wiki/no-query-executer-factory-registere... Did anyone experience the same error before ? Is it the jasper server level problem or is it the problem of pervasive READ only access deny ? (I'm connecting to VPN and connected to client db). Thank you in Advance :-) Sadakar Pochampalli The server has encountered an error. Please excuse the inconvenience. Error Message net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : report2_subreport1_Grid32Results_Grid32Results_1428775360889_647133 Error Trace net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : report2_subreport1_Grid32Results_Grid32Results_1428775360889_647133 at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:848) at net.sf.jasperreports.components.table.fill.FillTableSubreport.prepareSubreport(FillTableSubreport.java:167) at net.sf.jasperreports.components.table.fill.FillTable.prepare(FillTable.java:414) at net.sf.jasperreports.engine.fill.JRFillComponentElement.prepare(JRFillComponentElement.java:151) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:331) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:383) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:358) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummaryNoLastFooterSamePage(JRVerticalFiller.java:1072) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillSummary(JRVerticalFiller.java:1031) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportEnd(JRVerticalFiller.java:295) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:131) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:540) at net.sf.jasperreports.engine.fill.BaseFillHandle$ReportFill.run(BaseFillHandle.java:120) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$SynchronousExecutor.execute(EngineServiceImpl.java:882) at net.sf.jasperreports.engine.fill.BaseFillHandle.startFill(BaseFillHandle.java:165) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$AsynchronousReportFiller.fillReport(EngineServiceImpl.java:838) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1727) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1082) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1011) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:904) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : report2_subreport1_Grid32Results_Grid32Results_1428775360889_647133 at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:143) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1119) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:508) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:393) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:704) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:203) ... 3 more Caused by: java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager][SPEng][Pervasive][ODBC Engine Interface]Access denied to a READ-ONLY data source. at com.pervasive.jdbc.lna.LNAObject.getErrors(LNAObject.java:213) at com.pervasive.jdbc.lna.LNAStatement.getErrors(LNAStatement.java:937) at com.pervasive.jdbc.lna.LNAObject.checkError(LNAObject.java:256) at com.pervasive.jdbc.lna.LNAStatement.execute(LNAStatement.java:310) at com.pervasive.jdbc.v2.PreparedStatement.execute(PreparedStatement.java:466) at com.pervasive.jdbc.v2.PreparedStatement.executeQuery(PreparedStatement.java:65) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:136) ... 11 more Error Message net.sf.jasperreports.engine.JRException: Error executing SQL statement for : report2_subreport1_Grid32Results_Grid32Results_1428775360889_647133 Error Trace net.sf.jasperreports.engine.JRException: Error executing SQL statement for : report2_subreport1_Grid32Results_Grid32Results_1428775360889_647133 at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:143) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1119) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:508) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:393) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:704) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:203) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager][SPEng][Pervasive][ODBC Engine Interface]Access denied to a READ-ONLY data source. at com.pervasive.jdbc.lna.LNAObject.getErrors(LNAObject.java:213) at com.pervasive.jdbc.lna.LNAStatement.getErrors(LNAStatement.java:937) at com.pervasive.jdbc.lna.LNAObject.checkError(LNAObject.java:256) at com.pervasive.jdbc.lna.LNAStatement.execute(LNAStatement.java:310) at com.pervasive.jdbc.v2.PreparedStatement.execute(PreparedStatement.java:466) at com.pervasive.jdbc.v2.PreparedStatement.executeQuery(PreparedStatement.java:65) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:136) ... 11 more Error Message java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager][SPEng][Pervasive][ODBC Engine Interface]Access denied to a READ-ONLY data source. Error Trace java.sql.SQLException: [LNA][Pervasive][ODBC Engine Interface][Data Record Manager][SPEng][Pervasive][ODBC Engine Interface]Access denied to a READ-ONLY data source. at com.pervasive.jdbc.lna.LNAObject.getErrors(LNAObject.java:213) at com.pervasive.jdbc.lna.LNAStatement.getErrors(LNAStatement.java:937) at com.pervasive.jdbc.lna.LNAObject.checkError(LNAObject.java:256) at com.pervasive.jdbc.lna.LNAStatement.execute(LNAStatement.java:310) at com.pervasive.jdbc.v2.PreparedStatement.execute(PreparedStatement.java:466) at com.pervasive.jdbc.v2.PreparedStatement.executeQuery(PreparedStatement.java:65) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92) at com.jaspersoft.jrx.query.PlSqlQueryExecuter.createDatasource(PlSqlQueryExecuter.java:136) at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1119) at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:691) at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:434) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:508) at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:393) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:704) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:59) at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:203) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745)
sadakar's picture
627
Joined: Aug 14 2012 - 3:57am
Last seen: 2 weeks 1 day ago

1 Answer:

0
Seems like you're experiencing something similar to this http://community.jaspersoft.com/questions/525672/postgresql-jasper-repor... Maybe try setting read only off in context.xml or using JNDI connection instead
ernestoo's picture
8974
Joined: Nov 29 2010 - 11:59am
Last seen: 2 years 1 month ago
Feedback
randomness