Start a new topic

semicolon in a comment gives java.lang.NullPointerException

[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 :)

[This reply is migrated from our old forums.]

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
[This reply is migrated from our old forums. The original author name has been removed]

Re: semicolon in a comment gives java.lang.NullPointerException
Thanks. That worked. :)