- on JavaDB node "create database" context menu
observe connection with "[user on USER]" but no USER schema (see screenshot)
and notice that there is no default schema.
This doesn't seem right for several things.
- if it wants to use USER schema it should create it
- probably better to set APP as default and use that
Then have the problems described in Issue 171577
BTW, tried "create schema USER;" and that produces:
Error code -1, SQL state 42X01: Syntax error: Encountered "USER" at line 1, column 15.
Line 1, column 1
Execution finished after 0 s, 1 error(s) occurred.
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
Created attachment 87179 [details]
Lowering from P2. (I'm new to db usage, reading create schema ....)
Maybe this is an enhancement request for a "create schema" checkbox with a text field for the create sql statement.
Changed to RFE by err's appreciation. Did you seen the problem in NetBeans 6.7 or older? Thanks, Btw. The 'current' in
issuezilla tracking system is worthless and should be removed at all, IMHO.
> problem in NetBeans 6.7 or older?
No idea. Working on first DB project; and using dailies.
Reassigned to new owner.