How to add the JDBC driver for Hadoop Hive to Jasper Report Server 6.3.0 community version.

[wz]

We installed Jasper Report Server 6.3.0 community version and the JDBC driver for Hadoop Hive does not show up.

How to add the JDBC driver for Hadoop Hive to Jasper Report Server 6.3.0 community version?

[jake2009]

in studio it worl.but it donot work in server~

I add this jars

/sites/default/files/images/index(25).png

It exceptions :

com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection Arguments: atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:64) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.BaseJdbcDataSource.setReportParameterValues(BaseJdbcDataSource.java:49) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.setReportParameterValues(JdbcDataSourceService.java:69) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1823) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1169) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1051) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:946) atjava.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) atjava.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) atjava.lang.Thread.run(Thread.java:745) Caused by:org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error Could not create a validated object, cause: Method not supported atorg.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.TibcoDriverManagerImpl.unlockConnection(TibcoDriverManagerImpl.java:68) atcom.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:56)... 9 more Caused by: java.util.NoSuchElementException: Could not create a validated object, cause: Method not supported atorg.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1233) atorg.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)... 11 more[/code]

[jake2009]

I solved this problem by using jasperServer6.1.1 。

 It has the impala connector.