Please use the Apache issue tracking system for new NetBeans issues ( !!
Bug 171579 - "Create database..." makes almost unusable database
"Create database..." makes almost unusable database
Status: NEW
Product: db
Classification: Unclassified
Component: Code
All All
: P3 (vote)
Assigned To: Libor Fischmeistr
Depends on:
  Show dependency treegraph
Reported: 2009-09-06 22:26 UTC by err
Modified: 2013-08-01 12:53 UTC (History)
0 users

See Also:

Services-Databases (13.62 KB, image/png)
2009-09-06 22:26 UTC, err

Note You need to log in before you can comment on or make changes to this bug.
Description err 2009-09-06 22:26:03 UTC
- 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
Comment 1 err 2009-09-06 22:26:44 UTC
Created attachment 87179 [details]
Comment 2 err 2009-09-06 22:38:48 UTC
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.
Comment 3 Jiri Rechtacek 2009-10-02 12:57:10 UTC
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.
Comment 4 err 2009-10-02 15:21:12 UTC
> problem in NetBeans 6.7 or older?

No idea. Working on first DB project; and using dailies.
Comment 5 Jiri Rechtacek 2009-10-16 14:13:57 UTC
Reassigned to new owner.

By use of this website, you agree to the NetBeans Policies and Terms of Use. © 2014, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo