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 214924 - Creating derby database with reserved word name fails
Summary: Creating derby database with reserved word name fails
Status: RESOLVED DUPLICATE of bug 204282
Alias: None
Product: db
Classification: Unclassified
Component: Derby (show other bugs)
Version: 7.1.2
Hardware: PC Windows 7
: P3 normal (vote)
Assignee: Jaroslav Havlin
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-06-28 14:35 UTC by catweasle
Modified: 2012-06-28 16:08 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 catweasle 2012-06-28 14:35:40 UTC 
If you create a derby database (right click Java DB in services>databases) with a name that is a reserved word (user,public...) creation fails with
SQLSyntaxexception: encountered user at line 1, column 15.
This was not a problem in netbeans 6.9.1.
The database is created in the derby directory on disk, but does not show up in the databases list in netbeans.
Comment 1 Jaroslav Havlin 2012-06-28 16:08:16 UTC 
Probably duplicate of bug 204282. It seems to be caused by some changes in Derby.
Please try to use double quotes around SQL keywords, e.g. "user".
Thanks for reporting.

*** This bug has been marked as a duplicate of bug 204282 ***