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 - "Create database..." makes almost unusable database
Summary: "Create database..." makes almost unusable database
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-09-06 22:26 UTC by err
Modified: 2013-08-01 12:53 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
Services-Databases (13.62 KB, image/png)
2009-09-06 22:26 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 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.