[jira] [Created] (CALCITE-2060) connection.getMetaData().getTypeInfo();

["Sergio Sainz (JIRA)" <ji...@apache.org>]

Sergio Sainz created CALCITE-2060:
-------------------------------------

             Summary: connection.getMetaData().getTypeInfo();
                 Key: CALCITE-2060
                 URL: https://issues.apache.org/jira/browse/CALCITE-2060
             Project: Calcite
          Issue Type: Bug
          Components: avatica
    Affects Versions: 1.11.0
            Reporter: Sergio Sainz
            Priority: Minor


When running the following code we see the null pointer exception below:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Properties;

/**
 * Created by ssainz on 11/17/17.
 */

public class druid_jdbc {
  public static void main (String[] args) throws ClassNotFoundException, SQLException
  {

    //Class.forName("org.apache.calcite.jdbc.Driver");
    String url = "jdbc:avatica:remote:url=http://host:8082/druid/v2/sql/avatica/";
    Properties connectionProperties = new Properties();
    try (Connection connection = DriverManager.getConnection(url, connectionProperties)) {
      connection.getMetaData().getTypeInfo();
      try (ResultSet resultSet = connection.createStatement().executeQuery("SELECT COUNT(*) AS cnt FROM CUSTOMER")) {
        int i = 0;
        while (resultSet.next()) {
          int cnt = resultSet.getInt("cnt");
          System.out.println("It " + i + " count: " + cnt);
          i++;
        }
      }
    }
  }
}



Exception in thread "main" AvaticaClientRuntimeException: Remote driver error: NullPointerException: (null exception message). Error -1 (00000) UNKNOWN

java.lang.NullPointerException
	at org.apache.calcite.avatica.MetaImpl.createResultSet(MetaImpl.java:288)
	at org.apache.calcite.avatica.MetaImpl.createEmptyResultSet(MetaImpl.java:219)
	at org.apache.calcite.avatica.MetaImpl.getTypeInfo(MetaImpl.java:1380)
	at org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:188)
	at org.apache.calcite.avatica.remote.Service$TypeInfoRequest.accept(Service.java:701)
	at org.apache.calcite.avatica.remote.Service$TypeInfoRequest.accept(Service.java:686)
	at org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:95)
	at org.apache.calcite.avatica.remote.JsonHandler.apply(JsonHandler.java:52)
	at org.apache.calcite.avatica.server.AvaticaJsonHandler.handle(AvaticaJsonHandler.java:129)
	at io.druid.sql.avatica.DruidAvaticaHandler.handle(DruidAvaticaHandler.java:63)
	at org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
	at org.eclipse.jetty.server.Server.handle(Server.java:534)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:320)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:251)
	at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:283)
	at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:108)
	at org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
	at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
	at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
	at org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)
	at java.lang.Thread.run(Thread.java:748)


	at org.apache.calcite.avatica.remote.Service$ErrorResponse.toException(Service.java:2476)
	at org.apache.calcite.avatica.remote.JsonService.decode(JsonService.java:55)
	at org.apache.calcite.avatica.remote.JsonService.apply(JsonService.java:108)
	at org.apache.calcite.avatica.remote.RemoteMeta$10.call(RemoteMeta.java:213)
	at org.apache.calcite.avatica.remote.RemoteMeta$10.call(RemoteMeta.java:210)
	at org.apache.calcite.avatica.AvaticaConnection.invokeWithRetries(AvaticaConnection.java:756)
	at org.apache.calcite.avatica.remote.RemoteMeta.getTypeInfo(RemoteMeta.java:209)
	at org.apache.calcite.avatica.AvaticaDatabaseMetaData$22.call(AvaticaDatabaseMetaData.java:1010)
	at org.apache.calcite.avatica.AvaticaDatabaseMetaData$22.call(AvaticaDatabaseMetaData.java:1007)
	at org.apache.calcite.avatica.AvaticaConnection.invokeWithRetries(AvaticaConnection.java:756)
	at org.apache.calcite.avatica.AvaticaDatabaseMetaData.getTypeInfo(AvaticaDatabaseMetaData.java:1006)
	at druid_jdbc.main(druid_jdbc.java:19)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at com.intellij.rt.execution.application.AppMain.main(AppMain.java:144)

Process finished with exit code 1




--
This message was sent by Atlassian JIRA
(v6.4.14#64029)