[jira] [Comment Edited] (KYLIN-1494) JDBC throws NPE when connect to SQL workbench

["Norbert Burger (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-1494?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15197899#comment-15197899 ] 

Norbert Burger edited comment on KYLIN-1494 at 3/16/16 6:42 PM:
----------------------------------------------------------------

In this specific case, the root cause appears to be that Calcite throws java.sql.SQLFeatureNotSupportedException from getMoreResults():

https://github.com/apache/calcite/blob/master/avatica/core/src/main/java/org/apache/calcite/avatica/AvaticaStatement.java#L333

This seems reasonable, except that the default constructor SQLFeatureNotSupportedException creates a null message, and then Workbench NPEs trying to log that message.

Overriding getMoreResults() at the KylinStatement level to return false may be a safer work-around.  There are several other passthrough statements that also fall into the SQLFeatureNotSupportedException hole, but they don't seem to NPE.

I believe the SQL Workbench team is also fixing up their code:
https://groups.google.com/d/msg/sql-workbench/KpruyF80--c/MPSZ4PHVCgAJ


was (Author: nburger9):
In this specific case, the root cause appears to be that Calcite throws java.sql.SQLFeatureNotSupportedException from getMoreResults():

https://github.com/apache/calcite/blob/master/avatica/core/src/main/java/org/apache/calcite/avatica/AvaticaStatement.java#L333

This seems reasonable, except that the default constructor SQLFeatureNotSupportedException creates a null message, and then Workbench NPEs try logging to message.

Overriding getMoreResults() at the KylinStatement level to return false may be a safer work-around.

> JDBC throws NPE when connect to SQL workbench 
> ----------------------------------------------
>
>                 Key: KYLIN-1494
>                 URL: https://issues.apache.org/jira/browse/KYLIN-1494
>             Project: Kylin
>          Issue Type: Bug
>            Reporter: liyang
>            Assignee: Dong Li
>
> SQL Workbench seems not to play well with the Kylin JDBC driver (every query throws an NPE at workbench.sql.SqlCommand.processResults).



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