Sébastien Jelsch created KYLIN-945:
--------------------------------------

             Summary: 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: v0.7.3
            Reporter: Sébastien Jelsch


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)

Reply via email to