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 152233

Summary:	Dialogs that refer to DB identifiers should quote automatically
Product:	db	Reporter:	David Vancouvering <davidvc>
Component:	Code	Assignee:	Libor Fischmeistr <lfischmeistr>
Status:	NEW ---
Severity:	blocker	CC:	romanmostyka
Priority:	P2
Version:	6.x
Hardware:	All
OS:	All
Issue Type:	ENHANCEMENT	Exception Reporter:

Description David Vancouvering 2008-11-03 20:22:26 UTC

We have a very nice utility called org.netbeans.api.db.sql.support.SQLIdentifiers.Quoter that knows when a particular
identifier needs to be quoted, providing the method quoteIfNeeded().  

We are using this when we generate select statements internally (such as with "View Data" action), but we should use
this to automatically quote identifiers in our UI dialogs.  So for example, when the user wants to create a table, the
table name and column names should be quoted automatically if they contain characters (such as spaces or multibytes)
that need to be quoted.

Comment 1 Jiri Rechtacek 2009-10-16 14:03:21 UTC

Reassigned to new owner.