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

Posted on August 1, 2016 at 7:30pm

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?

wz's picture
wz
3
Joined: Jul 25 2016 - 11:47am
Last seen: 5 years 8 months ago

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

I add this jars

It exceptions :

com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection Arguments: at
com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.JdbcDataSourceService.createConnection(JdbcDataSourceService.java:64) 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:69) at
com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1823) at
com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1169) at
com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1051) at
com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:946) at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at
java.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 at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:114) at
com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.TibcoDriverManagerImpl.unlockConnection(TibcoDriverManagerImpl.java:68) at
com.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 at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:1233) at
org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106)
... 11 more
jake2009 - 6 years 8 months ago

I solved this problem by using jasperServer6.1.1 。

 It has the impala connector.

jake2009 - 6 years 8 months ago
add comment

0 Answers:

No answers yet
Feedback
randomness