Jasper Server & iReport: How to access a datasource in a remote server to create reports

Hello,

I have been trying to find a way to create reports in my windows computer (using iReport 5) for a Jasperserver (community edition) that I have set up in a linux box. Jasperserver works fine and it is able to access my datasource (using JDBC connection to a mysql database, more especifically a infobright sql database).

Now, I want to design reports for that server from my windows computer using that datasource; however, I don't seem to find a way to connect to the datasource from my computer. I have already modyfied the my.cnf file to listen to the address of my windows computer and it is working fine.

My main concern is that I want to be able to design my reports in iReport and then load them to my Jasperserver.

The following is the information I use for the datasource:

driver: com.mysql.jdbc.Driver

URL:  jdbc:mysql://Jasperserver_IP:Port/database

(The database was setup in the jasper server)

username and password were also added

When I try to connect to this datasource I get the following error:

 

net.sf.jasperreports.engine.JRException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
 
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
 
at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:129)
 
at net.sf.jasperreports.data.AbstractDataAdapterService.test(AbstractDataAdapterService.java:128)
 
at com.jaspersoft.studio.data.wizard.AbstractDataAdapterWizard$3.run(Unknown Source)
 
at org.eclipse.jface.operation.ModalContext$ModalContextThread.run(ModalContext.java:121)
 
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
 
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
 
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
 
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
 
at java.lang.reflect.Constructor.newInstance(Unknown Source)
 
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
 
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)
 
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:350)
 
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2408)
 
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2445)
 
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2230)
 
at com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.java:813)
 
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:47)
 
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
 
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
 
at java.lang.reflect.Constructor.newInstance(Unknown Source)
 
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
 
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
 
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)
 
at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.getConnection(JdbcDataAdapterService.java:167)
 
at net.sf.jasperreports.data.jdbc.JdbcDataAdapterService.contributeParameters(JdbcDataAdapterService.java:127)
 
... 3 more
 
Caused by: java.net.ConnectException: Connection refused: connect
 
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
 
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
 
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
 
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
 
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
 
at java.net.PlainSocketImpl.connect(Unknown Source)
 
at java.net.SocksSocketImpl.connect(Unknown Source)
 
at java.net.Socket.connect(Unknown Source)
 
at java.net.Socket.connect(Unknown Source)
 
at java.net.Socket.(Unknown Source)
 
at java.net.Socket.(Unknown Source)
 
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:259)
 
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:300)
 
... 17 more
 
Any ideas on how to solve this?
 
Thank you
sebastian_2's picture
Joined: Jan 31 2013 - 3:17pm
Last seen: 9 years 3 months ago
I'm facing same problem. Did you able to manage to solve this problem by any chance??
brave.net2006 - 9 years 1 month ago

0 Answers:

No answers yet
Feedback