Written by

Question Luis-Ángel Pérez-Ramos · Aug 1, 2019

Jasper Reports + IRIS JDBC connection

Hi! I am creating a Jasper Report using IRIS like DB, I've created my Data Adapter to connect with my DB configuring the JDBC connector and it works perfectly:

But when I try to create a report connecting to my DB I am getting this error:

This is the error in detail:

java.sql.SQLException: Communication link failure: Socket closed
   at com.intersystems.jdbc.OutStream.send(OutStream.java:48)
   at com.intersystems.jdbc.IRISDatabaseMetaData.executeCatalogQuery(IRISDatabaseMetaData.java:865)
   at com.intersystems.jdbc.IRISDatabaseMetaData.getTableTypes(IRISDatabaseMetaData.java:679)
   at com.jaspersoft.studio.data.sql.ui.metadata.DBMetadata.readTableTypes(DBMetadata.java:549)
   at com.jaspersoft.studio.data.sql.ui.metadata.DBMetadata.updateMetadata(DBMetadata.java:261)
   at com.jaspersoft.studio.data.sql.SQLQueryDesigner$3.runOperations(SQLQueryDesigner.java:282)
   at com.jaspersoft.studio.utils.jobs.CheckedRunnableWithProgress$1.run(CheckedRunnableWithProgress.java:51)
   at java.lang.Thread.run(Thread.java:748)

Have I missed any configuration?

Discussion (1)0

Add reply

Comments

Alexander Koblov · Aug 9, 2019

Hi Luis-Ángel.

Generally, if you can connect successfully then configuration is fine.

Does this happen with every query? If you try some simple query, like 'select 1', will this work ?

If yes, does your query work from Management Portal ?

Also, try enabling Audit and event Protect and check if this event is logged into Audit when this happens.

0 0