@Parth Chandra <[email protected]>
> could you please give an example about
> {quote}
> While we are at it, we could fix the (very annoying) behavior of SQLLine
> where it tries to disconnect from the database even after the connect call
> failed.
> {quote}
>
>
Provide an invalid connect string to SQLLine. Then quit.
[1136][~/drill]$ sqlline -u "jdbc:drill:drillbit=localhost:31011" -n admin
-p admin --showNestedErrs=false
Error: Failure in connecting to Drill:
org.apache.drill.exec.rpc.ChannelClosedException: Channel closed /
127.0.0.1:51878 <--> localhost/127.0.0.1:31011. (state=,code=0)
java.sql.SQLNonTransientConnectionException: Failure in connecting to
Drill: org.apache.drill.exec.rpc.ChannelClosedException: Channel closed /
127.0.0.1:51878 <--> localhost/127.0.0.1:31011.
at
org.apache.drill.jdbc.impl.DrillConnectionImpl.<init>(DrillConnectionImpl.java:178)
at
org.apache.drill.jdbc.impl.DrillJdbc41Factory.newDrillConnection(DrillJdbc41Factory.java:72)
at
org.apache.drill.jdbc.impl.DrillFactory.newConnection(DrillFactory.java:68)
at
org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:138)
at org.apache.drill.jdbc.Driver.connect(Driver.java:72)
at sqlline.DatabaseConnection.connect(DatabaseConnection.java:168)
at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:214)
at sqlline.Commands.connect(Commands.java:1083)
at sqlline.Commands.connect(Commands.java:1015)
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
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
at sqlline.SqlLine.dispatch(SqlLine.java:742)
at sqlline.SqlLine.initArgs(SqlLine.java:528)
at sqlline.SqlLine.begin(SqlLine.java:596)
at sqlline.SqlLine.start(SqlLine.java:375)
at sqlline.SqlLine.main(SqlLine.java:268)
Caused by: org.apache.drill.exec.rpc.ChannelClosedException: Channel closed
/127.0.0.1:51878 <--> localhost/127.0.0.1:31011.
at
org.apache.drill.exec.rpc.RpcBus$ChannelClosedHandler.operationComplete(RpcBus.java:165)
at
org.apache.drill.exec.rpc.RpcBus$ChannelClosedHandler.operationComplete(RpcBus.java:144)
<snip/>
at
io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:131)
at java.lang.Thread.run(Thread.java:748)
apache drill 1.15.0-SNAPSHOT
"what ever the mind of man can conceive and believe, drill can query"
0: jdbc:drill:drillbit=localhost:31011>
0: jdbc:drill:drillbit=localhost:31011> !quit
Error: Failure in connecting to Drill:
org.apache.drill.exec.rpc.ChannelClosedException: Channel closed /
127.0.0.1:51879 <--> localhost/127.0.0.1:31011. (state=,code=0)
Error: Failure in connecting to Drill:
org.apache.drill.exec.rpc.ChannelClosedException: Channel closed /
127.0.0.1:51880 <--> localhost/127.0.0.1:31011. (state=,code=0)