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.
The problem appear when connecting to an oracle database under a username (say "SYSTEM") but browsing/viewing another schema (say "NAVIG" in my specific situation). Selecting a different schema is done through the "Advenced" pane of the "New Connection" dialog. Browsing the schema with the tree explorer works fine, but everything fails when trying to view table content, or such. What's appening is that THE SQL CODE GENERATED IS WRONG. In my case, I've a table called DEVICE into the NAVIG schema. I'm connected as the SYSTEM user. if I'm trying to see the content of the NAVIG table (right-clicking the node), netbeans generate the following request: select <column list> from DEVICE which is wrong because oracle will look at the DEVICE table into the SYSTEM schema instead of the NAVIG schema. netbeans should generate a "fully qualified" table specification in this case: select <column list> from NAVIG.DEVICE which then yields the correct results. Thanks, Cedric
Fixed. 'from' clause uses fully qualified name now.
Verified in main trunk
Resolved for 3.3.x or earlier, no new info since then -> closing.