[udig-devel] [jira] Created: (UDIG-754) PostGIS connection wizard autofill broken

[Michael Brasser (JIRA)]

PostGIS connection wizard autofill broken
-----------------------------------------

         Key: UDIG-754
         URL: http://jira.codehaus.org/browse/UDIG-754
     Project: uDIG
        Type: Bug

  Components: ui  
    Versions: UDIG 1.1.M8    
 Environment: Win 2000, JRE 1.5
    Reporter: Michael Brasser
    Priority: Trivial
 Attachments: patch.txt

When adding a PostGIS layer, the database dropbox is no longer autofilled (like it was in version 1.0 of uDig) after the connection parameters are entered. The issue is with the latest drivers for PostgreSQL. The uDig wizard uses:

rs = con.getMetaData().getCatalogs(); (DataBaseRegistryWizardPage, line 402)

to get the list of databases, but the getCatalogs function has been  (purposefully) changed in the newer versions of the PostgreSQL drivers to only return the "current" database. Driver note was:

"Postgresql does not support multiple catalogs from a single connection, so to reduce confusion we only return the current catalog."

This could be fixed by giving PostGisWizardPage its own populateDB() function that uses a select statement to get the database names (see attached patch). However, the function is almost entirely redundant (only one difference with the version in DataBaseRegistryWizardPage).

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://jira.codehaus.org/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira