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 17744 - Create column bug using any driver to MSSQL Server 2000
Summary: Create column bug using any driver to MSSQL Server 2000
Status: CLOSED DUPLICATE of bug 17254
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 3.x
Hardware: PC Windows ME/2000
: P3 blocker (vote)
Assignee: Radko Najman
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2001-11-16 02:16 UTC by Geoff Sharp
Modified: 2003-06-30 17:17 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments
Displays the Create Table form with defined columns prior to submit. (141.10 KB, image/jpeg)
2001-11-16 02:23 UTC, Geoff Sharp
Details
Displays error message after submit (and tail fields in col definitions) (144.84 KB, image/jpeg)
2001-11-16 02:24 UTC, Geoff Sharp
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Geoff Sharp 2001-11-16 02:16:34 UTC
Try the following from the Database Browser in Runtime tab:

1. Use any driver for MS SQL Server 2000. I used the JDBC-ODBC bridge and the 
Merant-Microsoft JDBC driver. Results were the same.

2. Add connection to a local SQL Server 2000 DB (haven't tried remote). I am 
using MSDE (the 2GB database/5 process limited version). If ODBC, obviously you 
need to set up an ODBC connection.

3. Assuming all went well, you will get the database conenction requested. All 
OK so far for me.

4. Create table. Call it Customer. 

5. Add an ID field (say ID). Set it to INT, pk and unique.

6. Add a second field called Description, not unique, VARCHAR 255, no scale, no 
default value, no index and no constraints.

7. Submit - the following error is displayed.

    Unable to format a command
    create table [{object.owner}.]{object.name}
    {
        {columns}
    }
    null

8. Go back to the default value for Description, and enter a space or other 
string.

9. Submit - saves OK but with a default value.

10. This behaviour is repeated for the separate Add Column option (obviously 
subclassed from the same base, or uses same class).

Is this something modifiable in a config file somewhere? This seriously 
degrades the value of an otherwise excellent addition to the tools.
Comment 1 Geoff Sharp 2001-11-16 02:23:05 UTC
Created attachment 3438 [details]
Displays the Create Table form with defined columns prior to submit.
Comment 2 Geoff Sharp 2001-11-16 02:24:52 UTC
Created attachment 3439 [details]
Displays error message after submit (and tail fields in col definitions)
Comment 3 Radko Najman 2001-11-16 08:12:14 UTC
Workaroud: use "Execute Command" action, write the command and execute 
it.
Comment 4 Radko Najman 2001-11-16 08:20:35 UTC

*** This issue has been marked as a duplicate of 17254 ***
Comment 5 Martin Schovanek 2003-03-12 14:30:12 UTC
VERIFIED
Comment 6 Quality Engineering 2003-06-30 17:17:32 UTC
Resolved for 3.3.x or earlier, no new info since then -> closing.