Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query Builder error when using worksheet tabs

633274Feb 26 2013 — edited Feb 28 2013
Now and then, when I click on a worksheet tab to focus it, I get a pop-up dialoque with a Query Builder error:
Text is not a valid, single SELECT statement.
QB-ERROR: NullPointerException
Query Builder disabled.
----------------------------------------
at com.adbs.ast.AstNodeBase.getMyChildren(wc:166)
at com.adbs.ast.SQLSubQueryExpressions.getMyChildren(pn:132)
at com.adbs.ast.AstNodeBase.dispose(wc:98)
at com.adbs.ast.AstNode.dispose(nc:86)
at com.adbs.querybuilder.QueryBase.loadFromAST(fm:80)
at com.adbs.querybuilder.UnionGroup.loadFromAST(uh:1411)
at com.adbs.querybuilder.SubQuery.loadFromAST(zo:351)
at com.adbs.querybuilder.Query.loadFromAST(xf:30)
at com.adbs.querybuilder.QueryBuilder.e(uj:2579)
at com.adbs.querybuilder.QueryBuilder.e(uj:1347)
at com.adbs.querybuilder.QueryBuilder.setSQL(uj:1134)
at oracle.dbtools.raptor.controls.query.QueryBuilderEditPanel$6.construct(QueryBuilderEditPanel.java:636)
at oracle.dbtools.raptor.utils.NamedSwingWorker$2.run(NamedSwingWorker.java:115)
at java.lang.Thread.run(Thread.java:619)

----------------------------------------
Please note that I didn't click on the "Query Builder" tab, neither do I want to use the Query Builder at all. I can just close the message and get back to work, but the dialogue is annoying. Is there any way to stop it? Disabling Query Builder would be an option, but I couldn't find anything relevant in Preferences.

I'm using SQL Developer 3.0.04.

Comments

thatJeffSmith-Oracle
I believe this was a bug that was subsequently fixed in a later version, please see
9183660

You're several versions back already, can you upgrade?
633274
Yes, sure, I'll upgrade as soon as possible and report back. I haven't done so far because it's a shared computer.
thatJeffSmith-Oracle
You can preserve your existing installation and 'install' SQL Developer v3.2 to a separate directory and run both versions independently without any problems.
633274
No problems so far with 3.2.2. Thank you for your time.
1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 28 2013
Added on Feb 26 2013
4 comments
313 views