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 171579

Summary:	"Create database..." makes almost unusable database
Product:	db	Reporter:	err <err>
Component:	Code	Assignee:	Libor Fischmeistr <lfischmeistr>
Status:	NEW ---
Severity:	blocker
Priority:	P3
Version:	6.x
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Exception Reporter:
Attachments:	Services-Databases

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.