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 111324 - Improper Creation Of Database Elements
Summary: Improper Creation Of Database Elements
Status: RESOLVED DUPLICATE of bug 87920
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 5.x
Hardware: All All
: P2 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-07-29 23:59 UTC by digipixel
Modified: 2007-07-30 10:38 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:


Attachments
Hibernate Test (NetBeans Project) output (13.61 KB, application/octet-stream)
2007-07-30 00:03 UTC, digipixel
Details
Hibernate Test (NetBeans Project without libs) (16.55 KB, application/octet-stream)
2007-07-30 00:11 UTC, digipixel
Details
List of required libraries needed for Hibernate Test project (404 bytes, text/plain)
2007-07-30 00:12 UTC, digipixel
Details

Note You need to log in before you can comment on or make changes to this bug.
Description digipixel 2007-07-29 23:59:58 UTC
When a new database element like a table is created double quotes are used for the name of the element. For example:

    create table "Person"(columns....);

Using double quotes causes major problems for persistence providers such as Top Link and Hibernate. See the ODT file for
a more detailed description of the problem. This problem can be avoided by naming all elements in upper case so that the
persistence providers can construct a proper SQL query that can actually FIND the elements (eg tables, views). Also
provided is a 7-Zip file containing the NB 5.5.1 project which causes the problem to occur.

Do note that this problem may also occur with other databases as well since the devil is in the details (SQL query).
This is what should be happening when the table is created:

    create table Person(columns....);
Comment 1 digipixel 2007-07-30 00:03:28 UTC
Created attachment 45872 [details]
Hibernate Test (NetBeans Project) output
Comment 2 digipixel 2007-07-30 00:11:15 UTC
Created attachment 45873 [details]
Hibernate Test (NetBeans Project without libs)
Comment 3 digipixel 2007-07-30 00:12:27 UTC
Created attachment 45874 [details]
List of required libraries needed for Hibernate Test project
Comment 4 Andrei Badea 2007-07-30 10:38:12 UTC
Thanks. This is a known issue, we plan to fix it for 6.0.


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