3 answers
- 10-1
Hi, I believe there are security restrictions in shared plans on the cloud. Instead of using a custom database connection, you can try selecting Default Datasource in the JasperReports configuration.
Here are some similar questions I found
Problem connecting external Database in Joget onDemand
Joget cloud edition and database access via jdbc plugins
- Anas Misbah Shami
Hey, I am not using a custom or external datasource, I have configured my jasper for default datasource, it works fine if there is just 1 dataset in my jasper report. but when i use a table to get the relevant information to the parent dataset, I create a child datasource and set its configuration to "use same jdbc connection as master report "it gives me this error shown above. and The master report is configured for Default datasource
- Anders
I am not familiar with how JasperReports handles child datasources, but it would seem it is attempting to make a separate connection. To overcome these security restrictions you might need to either use the Dedicated plan or deploy an on-premise installation.
Add your comment... - 10-1
So, I started debugging, i built the report step by step and checked it... This is what i have noticed. If I select this option fig-> "Red box", in the table dataset. I get the error shown above. if i change it to empty dataset then it works fine. Any one with the fix??, or is it a bug that nested datasets are inaccessible in joget cloud?
Add your comment... - 10-1
Do download and try the demonstration Joget app with Jasper Report and compare with your app, in JasperReports Menu#DownloadDemoApp.
- Anas Misbah Shami
Hey I checked the app, couldn't find the problem. When i import my app and run it on local server, jasper works just fine but it isn't working on the cloud. Maybe I'm doing some db connection wrong?
- Anas Misbah Shami
This demo app is also running fine on the cloud
- Anders
In your app, try to configure the JasperReports to use the Default Datasource instead of a custom DB connection.
Add your comment...
ERROR 22 Apr 2021 19:53:57 net.sf.jasperreports.engine.fill.JRFillSubreport - Fill 1: exception
2390
java.lang.SecurityException: Unauthorized access to jdbc:mysql://jogetdb:3306/jwc_acoservice?characterEncoding=UTF-8&ts=202104130828&useSSL=false&allowPublicKeyRetrieval=true&ts=1618302506315 from default
2391
at org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery_aroundBody7$advice(ClientSidePreparedStatement.java:39)
2392
at org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:1)
2393
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:312)
2394
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1257)
2395
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:726)
2396
at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:457)
2397
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:584)
2398
at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414)
2399
at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:826)
2400
at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61)
2401
at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221)
2402
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
2403
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
2404
at java.base/java.lang.Thread.run(Thread.java:834)
2405
ERROR 22 Apr 2021 19:53:57 org.joget.plugin.enterprise.JasperReportsMenu - jwc_acoservice : java.lang.SecurityException: Unauthorized access to jdbc:mysql://jogetdb:3306/jwc_acoservice?characterEncoding=UTF-8&ts=202104130828&useSSL=false&allowPublicKeyRetrieval=true&ts=1618302506315 from default
2406
java.lang.SecurityException: Unauthorized access to jdbc:mysql://jogetdb:3306/jwc_acoservice?characterEncoding=UTF-8&ts=202104130828&useSSL=false&allowPublicKeyRetrieval=true&ts=1618302506315 from default
2407
at org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery_aroundBody7$advice(ClientSidePreparedStatement.java:39)
2408
at org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:1)
2409
at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:312)
2410
at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:1257)
2411
at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:726)
2412
at net.sf.jasperreports.engine.fill.BaseReportFiller.setParameters(BaseReportFiller.java:457)
2413
at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:584)
2414
at net.sf.jasperreports.engine.fill.BaseReportFiller.fill(BaseReportFiller.java:414)
2415
at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:826)
2416
at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:61)
2417
at net.sf.jasperreports.engine.fill.AbstractThreadSubreportRunner.run(AbstractThreadSubreportRunner.java:221)
2418
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
2419
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
2420
at java.base/java.lang.Thread.run(Thread.java:834)