Jasper Reports + IRIS JDBC connection

Primary tabs

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?

 

Answers

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.