Skip site navigation (1) Skip section navigation (2)

Re: DatabaseMetaData.getCatalogs()

From: Altaf Malik <mmalik_altaf(at)yahoo(dot)com>
To: Peter Futaro <peterfutaro(at)gmail(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: DatabaseMetaData.getCatalogs()
Date: 2007-02-21 15:33:23
Message-ID: 848835.23875.qm@web39103.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
JDBC does not allow to collect an information for the database you are not conected to. The method getCatalogs does not return databases, instead it returns the catalogs in current database. To list down the available databases, you need to query the catalog tables. For example, on postgres you can use :
   
  select datname from pg_catalog.pg_database where datname not in('template0','template1')
   
  This will populate all the databases.
   
  --Altaf Malik
  EnterpriseDB
  www.enterprisedb.com

Peter Futaro <peterfutaro(at)gmail(dot)com> wrote:
  Dear all,

I have a remote machine, which is ushing Postgres v.7.4.11.
This machine has 2 database :
Database A & Database B

I have a task to list out the available database inside that machine in a combo box. I have tried to using :

public String getDBList()
    {
        String s = "";
        
        try
        {
            Class.forName(sDriver);
            connection_this = DriverManager.getConnection(sURL, sUser, sPassword);
            dbMetaData_this = connection_this.getMetaData();
            resultSet_this = dbMetaData_this.getCatalogs();

            while(resultSet_this.next())
            {
                if(!resultSet_this.isFirst())
                    s += ",";
                
                s += resultSet_this.getString(1);
            }
        
            return s;
        }
        
        catch(SQLException e)
        {
            return "error";
        }
    }

This will only return the database, that I state inside the URL
(e.g. String sURL = "jdbc:postgresql://<<ip>>:5432/databaseA"  ---> will return "databaseA" only).

I try to connect without stating any database inside the URL, also cannot.
Can you guys please help me ?

Thank you.

Peter Futaro


 
---------------------------------
Don't get soaked.  Take a quick peak at the forecast 
 with theYahoo! Search weather shortcut.

In response to

pgsql-jdbc by date

Next:From: Julius StroffekDate: 2007-02-21 15:47:33
Subject: JDBC object factory
Previous:From: Dave CramerDate: 2007-02-21 12:40:09
Subject: Re: I have questions

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group