java.sql.SQLException: While closing connection

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Apache's JIRA Issue Tracker by Victoria Markman, 1 year ago
While closing connection
via Google Groups by Sanjay Mhaske, 1 year ago
while executing SQL: SELECT EMP_ID, EMP_NAME,MGR_ID FROM OPTIQ_EMPLOYEE CONNECT BY EMP_ID = MGR_ID
via GitHub by Yancey1989
, 1 year ago
error while executing SQL "select * from (select t2.brand from (select brand,count(1) from DEMO group by brand having count(1) >=2) t1 join (select brand from DEMO ) t2 on t1.brand = t2.brand group by t2.brand) t3 LIMIT 50000": null
via Google Groups by kunal mahale, 1 year ago
via GitHub by corndolly
, 2 years ago
exception while executing query: java.lang.String cannot be cast to java.lang.Integer
via apache.org by Unknown author, 2 years ago
error while executing SQL "select "empid" from "hr"."emps" -- select": parse failed: Lexical error at line 2, column 10. Encountered: <EOF> after : ""
java.lang.IllegalStateException: Failure while closing accountor. Expected private and shared pools to be set to initial values. However, one or more were not. Stats are zone init allocated delta private 0 0 0 shared 8589934592 8589934115 477.
at org.apache.drill.exec.memory.AtomicRemainder.close(AtomicRemainder.java:200)
at org.apache.drill.exec.memory.Accountor.close(Accountor.java:390)
at org.apache.drill.exec.memory.TopLevelAllocator.close(TopLevelAllocator.java:185)
at org.apache.drill.exec.client.DrillClient.close(DrillClient.java:261)
at org.apache.drill.jdbc.impl.DrillConnectionImpl.cleanup(DrillConnectionImpl.java:376)
at org.apache.drill.jdbc.impl.DrillHandler.onConnectionClose(DrillHandler.java:36)
at net.hydromatic.avatica.AvaticaConnection.close(AvaticaConnection.java:135)
at sqlline.Commands.close(Commands.java:929)
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:734)
at sqlline.SqlLine.initArgs(SqlLine.java:548)
at sqlline.SqlLine.begin(SqlLine.java:587)
at sqlline.SqlLine.start(SqlLine.java:366)
at sqlline.SqlLine.main(SqlLine.java:259)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.