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 207866 - Database explorer module wrongly assumes catalog separator to .
Summary: Database explorer module wrongly assumes catalog separator to .
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 7.1
Hardware: PC Linux
: P3 normal (vote)
Assignee: Jiri Rechtacek
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-01-28 11:17 UTC by matthias42
Modified: 2012-02-10 18:01 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:

Attachments
propesed patch (3.92 KB, patch)
2012-01-28 11:17 UTC, matthias42 		Details | Diff
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 matthias42 2012-01-28 11:17:44 UTC 
Created attachment 115341 [details]
propesed patch

The QueryAction of the database explorer module builds a qualified name for doing a query. This works only if the database uses '.' as the catalog seperator. The attached fix fixes this by using the DatabaseMetaData to get the separator. This fixes the modules for queries against informix databases, which use ":" as catalog seperator.
A feeling tells me some vendors also choose to use a different seperator for the schema part, but there is no such config for this in the DatabaseMetaData, so this falls back to the default.
Comment 1 Jiri Rechtacek 2012-02-10 18:00:58 UTC 
Thanks. Applied in core-main/rev/754606a7d290