semicolon in a comment gives java.lang.NullPointerException
a
anonymous
started a topic
over 10 years ago
[This topic is migrated from our old forums. The original author name has been removed]
When I have a semicolon in a comment, DbVisualizer gives an NPE. E.g.
-- ;asdfasdfasdf
SELECT * FROM ODS.MANIFEST;
Gives
14:41:55 [ERROR ExecutorRunner-pool-3-thread-53 C.?] Internal error while executing: --
java.lang.NullPointerException
at oracle.jdbc.driver.T4C8Oall.getNumRows(T4C8Oall.java:1153)
at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:948)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)
at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:299)
at sun.reflect.GeneratedMethodAccessor69.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.onseven.dbvis.g.B.B.?(Z:104)
at com.onseven.dbvis.g.B.F$A.call(Z:1474)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
I have run the same in SQL Developer, and it works OK - so I believe this is a DbVisualizer issue. Once I remove the semicolon, DbVis is OK with it.. but in my case the comments are showing a snippet of Java code.. so there are plenty of semi colons.
Rob
:)
Re: semicolon in a comment gives java.lang.NullPointerException
Robert,
I suspect you need to turn on Strip Comments Before Executing. Check the following for more information:
http://confluence.dbvis.com/display/UG91/Sending+Comments+to+the+Database+with+Statements
Regards
Roger
a
anonymous
said
over 10 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: semicolon in a comment gives java.lang.NullPointerException
anonymous