Question & Answer > View Question

Jasper Report Connection is failing (Unauthorized Access??), Below are the logs

Confluence User - 23 Apr, 2021

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)

userviews;server

8

Confluence User •

23 Apr, 2021 •

confluenceUser •

•

confluenceUser •

Do download and try the demonstration Joget app with Jasper Report and compare with your app, in JasperReports Menu#DownloadDemoApp.

Confluence User •

23 Apr, 2021 •

confluenceUser •

•

confluenceUser •

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?

Confluence User •

23 Apr, 2021 •

confluenceUser •

•

confluenceUser •

This demo app is also running fine on the cloud

Confluence User •

24 Apr, 2021 •

confluenceUser •

•

confluenceUser •

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?

Confluence User •

26 Apr, 2021 •

confluenceUser •

•

confluenceUser •

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

Confluence User •

26 Apr, 2021 •

confluenceUser •

•

confluenceUser •

In your app, try to configure the JasperReports to use the Default Datasource instead of a custom DB connection.

Confluence User •

26 Apr, 2021 •

confluenceUser •

•

confluenceUser •

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

Confluence User •

26 Apr, 2021 •

confluenceUser •

•

confluenceUser •

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.

1

CSV | Excel | XML | PDF

Your answer

Print

Jasper Report Connection is failing (Unauthorized Access??), Below are the logs

8

RELATED QUESTIONS

Your answer

To answer a question you'll need an account.

8.builder-style-3fcf3dcb-0cfc-4ec8-af11-92ebbb921cec{color:#008C60 !important;}

RELATED QUESTIONS

Your answer.builder-style-37ef77c0-e1b0-40ad-9983-c0045c3630bf{color:#008C60 !important; margin-left:10px !important;}

To answer a question you'll need an account.

8

Your answer