This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 191567 - Allow code completion for more than one schema without needing to reference schema name.
Summary: Allow code completion for more than one schema without needing to reference s...
Status: REOPENED
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 7.0
Hardware: All All
: P3 normal (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-11-02 16:18 UTC by rptmaestro
Modified: 2013-08-01 12:52 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description rptmaestro 2010-11-02 16:18:27 UTC 
Example Scenario

I have 2 oracle database schemas; MASTER and PROJECT. My default schema is PROJECT, but my account is set up such that I can run queries against tables in the MASTER schema *without* referencing the schema name The actual schema name might even change from one environment to another (e.g. dev, test, stage, prod), so I actually don't want to reference the schema name as it might introduce errors when run against other environments.

The annoying problem is that the NetBeans SQL editor will only provide code completion for tables in my non-default schema tables if I reference them *with* the schema name, which means I have to remember to take the schema names out before I insert the query into my app.

I would like the ability to specify on the connection properties either multiple default schemas, or additional schema names for which code completion will be provided *without* having to reference the schema name.
Comment 1 Jiri Rechtacek 2011-02-18 11:04:34 UTC 
Please, describe in detail (a script creating both schemas and other configuration to make it as similar as possible to your configuration will the best). I haven't understood the problem yet. Thank you
Comment 2 rptmaestro 2011-02-22 21:41:10 UTC 
Say I have 2 schemas in my database, "SHARED_SCHEMA" and "MY_SCHEMA"

Suppose "SHARED_SCHEMA" has three tables
"EMPLOYEES"
"ORGANIZATIONS"
"POSITIONS"

And suppose "MY_SCHEMA" has two tables:
"EMPLOYEE_BILLING"
"PROJECTS"

If I've selected "MY_SCHEMA" as the default schema when I create the IDE's database connection, the SQL editor's code completion requires that I reference tables in the "SHARED_SCHEMA" by the schema name, even though the database doesn't require me to do so. (I think the database administrator created some synonyms to those tables, which NetBeans does not recognize.)

My request is that I be able to identify on the connection which schemas I can get code completion on without having to fully write out the schema name. This has a practical application, because the "SHARED_SCHEMA" will often have a different name on the production system than it does on the development or test systems.