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.
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.
Created attachment 3438 [details] Displays the Create Table form with defined columns prior to submit.
Created attachment 3439 [details] Displays error message after submit (and tail fields in col definitions)
Workaroud: use "Execute Command" action, write the command and execute it.
*** This issue has been marked as a duplicate of 17254 ***
VERIFIED
Resolved for 3.3.x or earlier, no new info since then -> closing.