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 171577 - query not using correct/default schema
Summary: query not using correct/default schema
Status: RESOLVED DUPLICATE of bug 170934
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 6.x
Hardware: All All
: P2 blocker (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-06 21:52 UTC by err
Modified: 2009-09-07 15:45 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
Services-Databases (14.33 KB, image/png)
2009-09-06 21:54 UTC, err 		Details
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 err 2009-09-06 21:52:13 UTC 
select * from ITEM_TABLE
==================================
Error code -1, SQL state 42Y07: Schema 'USER' does not exist
Line 1, column 1

Execution finished after 0 s, 1 error(s) occurred.
================================

I used create database, the connection I got was [user on USER] and it took a while to figure out what was going on and
I finally got [user on APP] to be listed in the connection, see screenshot.

Product Version: NetBeans IDE Dev (Build 200909040632)
Java: 1.6.0_12; Java HotSpot(TM) Client VM 11.2-b01
System: Windows XP version 5.1 running on x86; Cp1252; en_US (nb)
Userdir: C:\Documents and Settings\erra\.netbeans\dev
Comment 1 err 2009-09-06 21:54:14 UTC 
Created attachment 87177 [details]
Services-Databases
Comment 2 err 2009-09-06 22:00:29 UTC 
Forgot to say. The query and error generated by "View Data..." context menu item on ITEM_TABLE node.

BTW, the "..." is incorrect since it executes directly.
Comment 3 Jiri Rechtacek 2009-09-07 09:21:02 UTC 
It'a a known problem, will be fixed until NB6.8M2

*** This issue has been marked as a duplicate of 171079 ***
Comment 4 err 2009-09-07 15:44:15 UTC 
Reopen only to resolve against correct duplicate
Comment 5 err 2009-09-07 15:45:28 UTC 

*** This issue has been marked as a duplicate of 170934 ***