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 78895 - sql create table generated from db explorer ain't valid
Summary: sql create table generated from db explorer ain't valid
Status: RESOLVED DUPLICATE of bug 65762
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 5.x
Hardware: All All
: P4 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-06-22 11:11 UTC by Pavel Rehak
Modified: 2006-06-22 16:13 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
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 Pavel Rehak 2006-06-22 11:11:31 UTC 
i've tried to create new table on oracle
url:   jdbc:oracle:thin:@qa-linux-s3:1521:newdb
login :     scott
password:    luke
encoding - AL32UTF8
invoked Create Table on Tables
typed new table name (my_table) renamed
1st column to ID - selected VARCHAR as type and tried generate table.

IDE generated following SQL 
create table "my_table" {
 ÏD" varchar2
} 
which is not valid - there must be (number) behind varchar2
implicit value 0 is not taken into account.
Comment 1 Andrei Badea 2006-06-22 16:13:17 UTC 

*** This issue has been marked as a duplicate of 65762 ***