Error trying to Connect Jasper Reports Server to Metamatrix 5.5.4
Issue
- We are trying to connect Jasper Reports Server to Metamatrix 5.5.4. We are able to successfully connect and run queries when using Jasper iReports which is a stand alone desktop application, but when trying to use Jasper Server, we get the following error.
2010-05-21 14:02:08,015 ERROR JSErrorPage_jsp,http-8080-Processor21:327 - java.util.NoSuchElementException: Could not create a validated object, cause: Call to method setReadOnly(true) not valid during a transaction. at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:806) at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:55) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:49) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:64)
- It looks like jasper server attempts to setup a connection pool for connections to metamatrix and the driver (or the jasper server) is trying to call setReadOnly on the connection but it's part of a transaction so it's failing.
Environment
- MetaMatrix Enterprise Server 5.5.x
- Jasper Reports Server
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.