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

Summary: Database explorer module wrongly assumes catalog separator to .
Product: db Reporter: matthias42
Component: Show DataAssignee: Jiri Rechtacek <jrechtacek>
Status: RESOLVED FIXED    
Severity: normal    
Priority: P3    
Version: 7.1   
Hardware: PC   
OS: Linux   
Issue Type: ENHANCEMENT Exception Reporter:
Attachments: propesed patch

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