You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Luke Han (JIRA)" <ji...@apache.org> on 2015/09/06 13:47:46 UTC

[jira] [Closed] (KYLIN-945) Kylin JDBC - Get Connection from DataSource results in NullPointerException

     [ https://issues.apache.org/jira/browse/KYLIN-945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Luke Han closed KYLIN-945.
--------------------------
    Resolution: Fixed

> Kylin JDBC - Get Connection from DataSource results in NullPointerException
> ---------------------------------------------------------------------------
>
>                 Key: KYLIN-945
>                 URL: https://issues.apache.org/jira/browse/KYLIN-945
>             Project: Kylin
>          Issue Type: Bug
>          Components: Driver - JDBC
>    Affects Versions: v1.0
>            Reporter: Sébastien Jelsch
>            Assignee: Shaofeng SHI
>             Fix For: v1.0
>
>         Attachments: kylin-945.patch
>
>
> Trying to get JDBC Connection from DataSource results in NullPointerException after upgrading to Apache Calcite 1.3.0.
> It's necessary for Mondrian integration.
> *+Example:+*
> {code:title=KylinDataSourceConnection.java|borderStyle=solid}
> import java.sql.Connection;
> import java.sql.SQLException;
> import java.sql.Statement;
> import org.apache.commons.dbcp.BasicDataSource;
> public class KylinDataSourceConnection {
>   public static void main(String[] args) {
>     BasicDataSource basicDataSource = new BasicDataSource();
>     basicDataSource.setDriverClassName("org.apache.kylin.jdbc.Driver");
>     basicDataSource.setUrl("jdbc:kylin://localhost:7070/projectName");
>     basicDataSource.setUsername("admin");
>     basicDataSource.setPassword("KYLIN");
>     try {
>       Connection conn = basicDataSource.getConnection();
>       Statement stmt = conn.createStatement();
>       stmt.executeQuery("SELECT count(*) FROM FACTS"); 
>     } catch (SQLException e) {
>       e.printStackTrace();
>     }   
>   }
> }
> {code}
> *+Exception:+*
> {quote}
> Exception in thread "main" java.lang.NullPointerException
>   at org.apache.calcite.avatica.AvaticaConnection.getAutoCommit(AvaticaConnection.java:137)
>   at org.apache.commons.dbcp.DelegatingConnection.getAutoCommit(DelegatingConnection.java:337)
>   at org.apache.commons.dbcp.PoolableConnectionFactory.activateObject(PoolableConnectionFactory.java:703)
>   at org.apache.commons.dbcp.BasicDataSource.validateConnectionFactory(BasicDataSource.java:1557)
>   at org.apache.commons.dbcp.BasicDataSource.createPoolableConnectionFactory(BasicDataSource.java:1545)
>   at org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1388)
>   at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
>   at org.testsource.mondrianlagunitas.KylinDataSourceConnection.main(KylinDataSourceConnection.java:19)
> {quote}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)