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.
Hi ,I find some problem in Database Explorer when Create a new Table. I read the Help content : "To create a new table: Navigate under a connected database. The Explorer displays icons for Tables, Views, and Procedures. Open the Create Table dialog box using either: The contextual menu for the Tables The contextual menus for an existing table Type the table name............." I test it, but When my column's type is char or varchar, it don't work. and show a error dialog " Unable to format a command: create table [{object.owner}.]{object.name} ( {columns} ) null " I test it on MS SQLServer2000 and Oracle8.1.7., and test columns's type is [char, varchar, int], only my column's type is int, It worked.
It is probably DB module problem.
You can download patch from: http://db.netbeans.org/servlets/ProjectDownloadList (patch17254.jar) *** This issue has been marked as a duplicate of 17254 ***
I download the patch and then test again, it seems to work well on MS SQLServer. But it still has some problem on Oracle. Although it can create table which datatype use char or varchar2. Example when i create a table named test, then I execute SELECT * FROM TEST by Command Editor. An error occur, it says the table doesn't exist. So, I change My Command like SELECT * FROM "TEST" , it worked. I find i have to add " on columns or table. And it doesn't need to add " , only if table are not created by Dialog.
You are right. The problem is that all tables created by create table dialog are case sensitive. I agree that it is a serious problem. I filed a new bug (#23287) for this issue.
VERIFIED
Resolved for 3.3.x or earlier, no new info since then -> closing.