[Is it possible to be using datasource from server to make report?]

Thanks for you answer Sherman.

I've been reading about subreports and was wondering if they could be used.

Do you think it would be possible to make a main report for the user that's on the server, and then the user would make subreports of that using the same connection?

[Is it possible to be using datasource from server to make report?]

Hello,

I've made a jaspersoft server that's running on a docker host, it has access to a database running on the same docker host, which it can connect to when you're on the jaspersoft server.

My user,  has access to the website but not the database directly. He is to  make reports using jaspersoft studio.

So I want him to be able to use the datasource that I have made on the website, since he can't use an data adapter that he has made on his end.

I've tried importing the datasource from the server as a local data adapter but then jaspersoft studio is stuck getting metadata

Is this possible?

 

my solution is based on the github project: https://github.com/TIBCOSoftware/js-docker

[Changing content of zip causes a permission failed]

I had a working version of this project, but whenver I try to change the contents of the zip file (the jasperreport server zip file) I get the error:

/entrypoint.sh: line 57: ./js-ant: Permission denied the first time and /entrypoint.sh: line 66: ./js-ant: Permission denied the second.[/code]

(the lines being "init-source-paths " and "./js-ant $i " respectively)

I want to change the js.quartz.properties file like in: https://community.jaspersoft.com/wiki/configuring-report-scheduler so that the dockerised server can send emails.

doing that or just any change, like adding an empty .txt file or deleting a file in the zip folder will start making permission denied errors.

I'm thinking editing the zip file, somehow changes its rights, but I made sure to give all files execution rights with chmod -R 777

I've added the RUN chmod +x /entrypoint.sh from the readme, but it didn't help.

I work on windows, with version jasperreports-server-cp-6.3.0-bin of the server .

github link to jaspersoft for docker: https://github.com/TIBCOSoftware/js-docker

[Reports works in Studio, but not on Server]

Hello and thanks for your accurate answer @hozawa (I wasn't aware of being able to add data sources so this helped me a lot)

it indeed seems like on my dockerized jaspersoft server I can't get a connection to my dockerized datasource. However if I run the standard jasperreport server service (from https://community.jaspersoft.com/project/jasperreports-server/releases ) and use the same parameters I can get a connection to my dockerised data source. So the problem must be in how I've made my dockerised jasperreport server.

Do you have any idea what it might possibly be?

[Reports works in Studio, but not on Server]

@miwagada Thanks for your answer, I have the report on the server connected to the correct database (since it works on jaspersoft studio) my problem is that when I run the report on the server I get the mentioned error trace.

 edited original post for more clear language. 

[Reports works in Studio, but not on Server]

When running a report in jaspersoft studio it succesfully generates a report, with data adapted from a container of a postgres database on a ssh. the server is running as a jaspersoft for docker server on the same ssh.

however, after publishing the report to the jasperserver, when running the report on the server I get the following error trace:

com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection Arguments: atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:64) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:49) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:69) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1823) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1169) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1051) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:946) atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) atjava.lang.Thread.run(Thread.java:748) Caused by: org.postgresql.util.PSQLException:    Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. atorg.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:207) atorg.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:64) atorg.postgresql.jdbc2.AbstractJdbc2Connection.<init>(AbstractJdbc2Connection.java:136) atorg.postgresql.jdbc3.AbstractJdbc3Connection.<init>(AbstractJdbc3Connection.java:29) atorg.postgresql.jdbc3g.AbstractJdbc3gConnection.<init>(AbstractJdbc3gConnection.java:21) atorg.postgresql.jdbc4.AbstractJdbc4Connection.<init>(AbstractJdbc4Connection.java:31) atorg.postgresql.jdbc4.Jdbc4Connection.<init>(Jdbc4Connection.java:24) atorg.postgresql.Driver.makeConnection(Driver.java:393) atorg.postgresql.Driver.connect(Driver.java:267) atjava.sql.DriverManager.getConnection(DriverManager.java:664) atjava.sql.DriverManager.getConnection(DriverManager.java:247) atorg.apache.commons.dbcp.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:75) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDriverManagerConnectionFactory.createConnection(JdbcDriverManagerConnectionFactory.java:36) atorg.apache.commons.dbcp.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:582) atorg.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1148) atorg.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.TibcoDriverManagerImpl.unlockConnection(TibcoDriverManagerImpl.java:68) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:56) ... 9 more Caused by: java.net.ConnectException: Connection refused (Connection refused) atjava.net.PlainSocketImpl.socketConnect(Native Method) atjava.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) atjava.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) atjava.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) atjava.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) atjava.net.Socket.connect(Socket.java:589) atjava.net.Socket.connect(Socket.java:538) atorg.postgresql.core.PGStream.<init>(PGStream.java:60) atorg.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:101) ... 26 more[/code]

any ideas what the problem is? and is there a way to see what the remaining 26 errors are?

I've used the jaspersoft for docker from https://github.com/TIBCOSoftware/JS-Docker
and the datasource is from: https://github.com/docker-library/postgres

the connection of the containers in the ssh: