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 of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
