Hi Roy,
Since you’re using kylin 1.5 as server end. Please use kylin-jdbc-1.5.jar instead of kylin-jdbc-1.2.jar. It’s located under $KYLIN_HOME/lib Thanks, Dong Li Original Message Sender:[email protected] Recipient:[email protected] Date:Thursday, Apr 7, 2016 16:25 Subject:JDBC Connection to FireReport Hi guy, we use FireReport to develop report use database is sql. now we want to try FR use JDBC connection to Kylin. first i download the kylin-jdbc-1.2.jar and config FR DataBase. like below image. when is was click test connection, Always throw error : com.fr.third.org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (error while executing SQL "select count(*) from DB_KYLIN.DCMEMBERORDER where 1 = 2": java.sql.SQLException: com.fasterxml.jackson.databind.exc.UnrecognizedPropertyException: Unrecognized field "hitExceptionCache" (class org.apache.kylin.jdbc.json.SQLResponseStub), not marked as ignorable (10 known properties: , "partial", "isException", "affectedRowCount", "totalScanCount", "hitCache", "duration", "cube", "results", "columnMetas", "exceptionMessage"]) at [Source: org.apache.commons.httpclient.AutoCloseInputStream@153618b; line: 1, column: 506] (through reference chain: org.apache.kylin.jdbc.json.SQLResponseStub["hitExceptionCache"])) if i direct access Ip:7070/kylin/query, executing SQL "select count(*) from DB_KYLIN.DCMEMBERORDER where 1 = 2" the ststus is success. So guy any ideas , is kylin can't support FR or is kylin v 1.5 isuues? Best Regards Roy He
