You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by Khurram Faraaz <kf...@mapr.com> on 2017/02/08 08:21:21 UTC
NPE when connecting to sqlline using username and password
We are seeing an NPE when connect to sqlline using username and password.
[root@centos-01 ~]# cd /opt/mapr/drill/drill-1.10.0/bin
[root@centos-01 bin]# ./sqlline -u "jdbc:drill:schema=dfs.tmp;drillbit=10.10.100.201" -u mapr -p mapr
...
...
No known driver to handle "mapr". Searching for known drivers...
java.lang.NullPointerException
apache drill 1.10.0-SNAPSHOT
"what ever the mind of man can conceive and believe, drill can query"
0: mapr> !q
No known driver to handle "mapr". Searching for known drivers...
java.lang.NullPointerException
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
at sqlline.Commands.close(Commands.java:925)
at sqlline.Commands.quit(Commands.java:889)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
at sqlline.SqlLine.dispatch(SqlLine.java:742)
at sqlline.SqlLine.begin(SqlLine.java:621)
at sqlline.SqlLine.start(SqlLine.java:375)
at sqlline.SqlLine.main(SqlLine.java:268)
No known driver to handle "mapr". Searching for known drivers...
java.lang.NullPointerException
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
at sqlline.Commands.close(Commands.java:925)
at sqlline.Commands.closeall(Commands.java:899)
at sqlline.SqlLine.begin(SqlLine.java:649)
at sqlline.SqlLine.start(SqlLine.java:375)
at sqlline.SqlLine.main(SqlLine.java:268)
Thanks,
Khurram
Re: NPE when connecting to sqlline using username and password
Posted by Julian Hyde <jh...@apache.org>.
If someone would like to fix https://github.com/julianhyde/sqlline/issues/55 <https://github.com/julianhyde/sqlline/issues/55> that would be awesome.
Julian
> On Feb 8, 2017, at 9:33 PM, Khurram Faraaz <kf...@mapr.com> wrote:
>
> Thanks Andries and Julian.
> I have created an issue to track this - https://github.com/julianhyde/sqlline/issues/55
>
>
> Regards,
> Khurram
> ________________________________
> From: Julian Hyde <jh...@apache.org>
> Sent: Thursday, February 9, 2017 1:28:28 AM
> To: dev@drill.apache.org
> Subject: Re: NPE when connecting to sqlline using username and password
>
> Agreed, you should use ’-n’.
>
> But also, please log a bug at https://github.com/julianhyde/sqlline <https://github.com/julianhyde/sqlline>. sqlline should give an error message, not throw a NullPointerException.
>
> Julian
>
>
>> On Feb 8, 2017, at 10:57 AM, Andries Engelbrecht <ae...@mapr.com> wrote:
>>
>> Use -n mapr instead of -u mapr (it is trying to load mapr as a driver instead of using it as the username).
>>
>>
>> --Andries
>>
>> ________________________________
>> From: Khurram Faraaz <kf...@mapr.com>
>> Sent: Wednesday, February 8, 2017 12:21:21 AM
>> To: dev@drill.apache.org
>> Subject: NPE when connecting to sqlline using username and password
>>
>> We are seeing an NPE when connect to sqlline using username and password.
>>
>>
>> [root@centos-01 ~]# cd /opt/mapr/drill/drill-1.10.0/bin
>> [root@centos-01 bin]# ./sqlline -u "jdbc:drill:schema=dfs.tmp;drillbit=10.10.100.201" -u mapr -p mapr
>> ...
>>
>> ...
>>
>> No known driver to handle "mapr". Searching for known drivers...
>> java.lang.NullPointerException
>> apache drill 1.10.0-SNAPSHOT
>> "what ever the mind of man can conceive and believe, drill can query"
>> 0: mapr> !q
>> No known driver to handle "mapr". Searching for known drivers...
>> java.lang.NullPointerException
>> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
>> at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
>> at sqlline.Commands.close(Commands.java:925)
>> at sqlline.Commands.quit(Commands.java:889)
>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> at java.lang.reflect.Method.invoke(Method.java:606)
>> at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
>> at sqlline.SqlLine.dispatch(SqlLine.java:742)
>> at sqlline.SqlLine.begin(SqlLine.java:621)
>> at sqlline.SqlLine.start(SqlLine.java:375)
>> at sqlline.SqlLine.main(SqlLine.java:268)
>> No known driver to handle "mapr". Searching for known drivers...
>> java.lang.NullPointerException
>> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
>> at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
>> at sqlline.Commands.close(Commands.java:925)
>> at sqlline.Commands.closeall(Commands.java:899)
>> at sqlline.SqlLine.begin(SqlLine.java:649)
>> at sqlline.SqlLine.start(SqlLine.java:375)
>> at sqlline.SqlLine.main(SqlLine.java:268)
>>
>>
>> Thanks,
>>
>> Khurram
>
Re: NPE when connecting to sqlline using username and password
Posted by Khurram Faraaz <kf...@mapr.com>.
Thanks Andries and Julian.
I have created an issue to track this - https://github.com/julianhyde/sqlline/issues/55
Regards,
Khurram
________________________________
From: Julian Hyde <jh...@apache.org>
Sent: Thursday, February 9, 2017 1:28:28 AM
To: dev@drill.apache.org
Subject: Re: NPE when connecting to sqlline using username and password
Agreed, you should use ’-n’.
But also, please log a bug at https://github.com/julianhyde/sqlline <https://github.com/julianhyde/sqlline>. sqlline should give an error message, not throw a NullPointerException.
Julian
> On Feb 8, 2017, at 10:57 AM, Andries Engelbrecht <ae...@mapr.com> wrote:
>
> Use -n mapr instead of -u mapr (it is trying to load mapr as a driver instead of using it as the username).
>
>
> --Andries
>
> ________________________________
> From: Khurram Faraaz <kf...@mapr.com>
> Sent: Wednesday, February 8, 2017 12:21:21 AM
> To: dev@drill.apache.org
> Subject: NPE when connecting to sqlline using username and password
>
> We are seeing an NPE when connect to sqlline using username and password.
>
>
> [root@centos-01 ~]# cd /opt/mapr/drill/drill-1.10.0/bin
> [root@centos-01 bin]# ./sqlline -u "jdbc:drill:schema=dfs.tmp;drillbit=10.10.100.201" -u mapr -p mapr
> ...
>
> ...
>
> No known driver to handle "mapr". Searching for known drivers...
> java.lang.NullPointerException
> apache drill 1.10.0-SNAPSHOT
> "what ever the mind of man can conceive and believe, drill can query"
> 0: mapr> !q
> No known driver to handle "mapr". Searching for known drivers...
> java.lang.NullPointerException
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
> at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
> at sqlline.Commands.close(Commands.java:925)
> at sqlline.Commands.quit(Commands.java:889)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
> at sqlline.SqlLine.dispatch(SqlLine.java:742)
> at sqlline.SqlLine.begin(SqlLine.java:621)
> at sqlline.SqlLine.start(SqlLine.java:375)
> at sqlline.SqlLine.main(SqlLine.java:268)
> No known driver to handle "mapr". Searching for known drivers...
> java.lang.NullPointerException
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
> at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
> at sqlline.Commands.close(Commands.java:925)
> at sqlline.Commands.closeall(Commands.java:899)
> at sqlline.SqlLine.begin(SqlLine.java:649)
> at sqlline.SqlLine.start(SqlLine.java:375)
> at sqlline.SqlLine.main(SqlLine.java:268)
>
>
> Thanks,
>
> Khurram
Re: NPE when connecting to sqlline using username and password
Posted by Julian Hyde <jh...@apache.org>.
Agreed, you should use ’-n’.
But also, please log a bug at https://github.com/julianhyde/sqlline <https://github.com/julianhyde/sqlline>. sqlline should give an error message, not throw a NullPointerException.
Julian
> On Feb 8, 2017, at 10:57 AM, Andries Engelbrecht <ae...@mapr.com> wrote:
>
> Use -n mapr instead of -u mapr (it is trying to load mapr as a driver instead of using it as the username).
>
>
> --Andries
>
> ________________________________
> From: Khurram Faraaz <kf...@mapr.com>
> Sent: Wednesday, February 8, 2017 12:21:21 AM
> To: dev@drill.apache.org
> Subject: NPE when connecting to sqlline using username and password
>
> We are seeing an NPE when connect to sqlline using username and password.
>
>
> [root@centos-01 ~]# cd /opt/mapr/drill/drill-1.10.0/bin
> [root@centos-01 bin]# ./sqlline -u "jdbc:drill:schema=dfs.tmp;drillbit=10.10.100.201" -u mapr -p mapr
> ...
>
> ...
>
> No known driver to handle "mapr". Searching for known drivers...
> java.lang.NullPointerException
> apache drill 1.10.0-SNAPSHOT
> "what ever the mind of man can conceive and believe, drill can query"
> 0: mapr> !q
> No known driver to handle "mapr". Searching for known drivers...
> java.lang.NullPointerException
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
> at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
> at sqlline.Commands.close(Commands.java:925)
> at sqlline.Commands.quit(Commands.java:889)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:606)
> at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
> at sqlline.SqlLine.dispatch(SqlLine.java:742)
> at sqlline.SqlLine.begin(SqlLine.java:621)
> at sqlline.SqlLine.start(SqlLine.java:375)
> at sqlline.SqlLine.main(SqlLine.java:268)
> No known driver to handle "mapr". Searching for known drivers...
> java.lang.NullPointerException
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
> at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
> at sqlline.Commands.close(Commands.java:925)
> at sqlline.Commands.closeall(Commands.java:899)
> at sqlline.SqlLine.begin(SqlLine.java:649)
> at sqlline.SqlLine.start(SqlLine.java:375)
> at sqlline.SqlLine.main(SqlLine.java:268)
>
>
> Thanks,
>
> Khurram
Re: NPE when connecting to sqlline using username and password
Posted by Andries Engelbrecht <ae...@mapr.com>.
Use -n mapr instead of -u mapr (it is trying to load mapr as a driver instead of using it as the username).
--Andries
________________________________
From: Khurram Faraaz <kf...@mapr.com>
Sent: Wednesday, February 8, 2017 12:21:21 AM
To: dev@drill.apache.org
Subject: NPE when connecting to sqlline using username and password
We are seeing an NPE when connect to sqlline using username and password.
[root@centos-01 ~]# cd /opt/mapr/drill/drill-1.10.0/bin
[root@centos-01 bin]# ./sqlline -u "jdbc:drill:schema=dfs.tmp;drillbit=10.10.100.201" -u mapr -p mapr
...
...
No known driver to handle "mapr". Searching for known drivers...
java.lang.NullPointerException
apache drill 1.10.0-SNAPSHOT
"what ever the mind of man can conceive and believe, drill can query"
0: mapr> !q
No known driver to handle "mapr". Searching for known drivers...
java.lang.NullPointerException
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
at sqlline.Commands.close(Commands.java:925)
at sqlline.Commands.quit(Commands.java:889)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
at sqlline.SqlLine.dispatch(SqlLine.java:742)
at sqlline.SqlLine.begin(SqlLine.java:621)
at sqlline.SqlLine.start(SqlLine.java:375)
at sqlline.SqlLine.main(SqlLine.java:268)
No known driver to handle "mapr". Searching for known drivers...
java.lang.NullPointerException
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:167)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:213)
at sqlline.Commands.close(Commands.java:925)
at sqlline.Commands.closeall(Commands.java:899)
at sqlline.SqlLine.begin(SqlLine.java:649)
at sqlline.SqlLine.start(SqlLine.java:375)
at sqlline.SqlLine.main(SqlLine.java:268)
Thanks,
Khurram