Bug 171579 - "Create database..." makes almost unusable database
"Create database..." makes almost unusable database
Status: NEW
Product: db
Classification: Unclassified
Component: Code
6.x
All All
: P3 (vote)
: TBD
Assigned To: Libor Fischmeistr
issues@db
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-09-06 22:26 UTC by err
Modified: 2013-08-01 12:53 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
:


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

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
  test1/user/password
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]
Services-Databases
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. © 2012, Oracle Corporation and/or its affiliates. Sponsored by Oracle logo