Thanks for you quick reply.
i use kylin-jdbc-1.5.jar instead of kylin-jdbc-1.2.jar. Now APP is working. Best Regards Roy He At 2016-04-07 16:40:24, "Dong Li" <[email protected]> wrote: >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
