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 187729 - Use of # in SQL command Editor throws an exception
Summary: Use of # in SQL command Editor throws an exception
Status: NEW
Alias: None
Product: serverplugins
Classification: Unclassified
Component: OC4J (show other bugs)
Version: 6.x
Hardware: All Windows XP
: P1 normal (vote)
Assignee: Michal Mocnak
URL:
Keywords: PLATFORM
Depends on:
Blocks:
 
Reported: 2010-06-17 13:19 UTC by sandy1264
Modified: 2011-11-16 16:34 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 sandy1264 2010-06-17 13:19:11 UTC 
I have setup my database connection for oracle and logged in to database server.

Now if i try to fetch the data from a table using a column name which has '#' character in it. It throws an exception as given below

Error code 923, SQL state 42000: ORA-00923: FROM keyword not found where expected
Line 1, column 1
Execution finished after 0 s, 1 error(s) occurred.

Looks like its considering the rest of the statement after '#' as comment.

Let me know if you need any more details to reproduce the issue.