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 107173 - Error parsing mysql query within project
Summary: Error parsing mysql query within project
Status: RESOLVED FIXED
Alias: None
Product: obsolete
Classification: Unclassified
Component: visualweb (show other bugs)
Version: 6.x
Hardware: All All
: P1 blocker (vote)
Assignee: _ jimdavidson
URL:
Keywords:
Depends on:
Blocks: 106402
  Show dependency tree
 
Reported: 2007-06-19 12:03 UTC by Alexey Butenko
Modified: 2008-11-18 13:18 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

Attachments
error (219.39 KB, image/jpeg)
2007-06-19 12:06 UTC, Alexey Butenko 		Details
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 Alexey Butenko 2007-06-19 12:03:27 UTC 
Netbeans IDE Dev 070618

I created new issue because it differ from 106822

- Create VW project
- Add mysql person table on designer
- Open it in Query Editor by double click on personRowSet under SessionBean1 node in Navigator window
- Run Query
Query processing error occured (see attached)
Comment 1 Alexey Butenko 2007-06-19 12:06:06 UTC 
Created attachment 43949 [details]
error
Comment 2 _ jimdavidson 2007-06-20 22:06:11 UTC 
Probably a duplicate of 106822, but I'll leave it separate for now.
Comment 3 _ jimdavidson 2007-06-22 20:43:53 UTC 
Extended the VisualSQLEditorMetaData api to provide information about the quote character used for SQL delimited
identifiers.

Modified the Query Editor to use that information when generating a delimited identifier.

Note that another workaround is to run the MySQL server in ANSI_QUOTES mode, so that it complies with the #$%^&* standard.
Comment 4 Peter Pis 2007-06-26 08:16:20 UTC 
To Reporter: Could you please verify this issue? Thanks.
Comment 5 Petr Blaha 2008-11-18 13:18:53 UTC 
Move visualsqleditor subcomponents below visualweb