retrieving a list of databases

[Phaelax]

I've search everywhere, and nothing seems to answer the question. I don't need a list of tables on a database, but a list of databases on the sql server. At which point I can then choose one to connect to then list its tables.

[aniseed]

You could check the JDBC API for DatabaseMetaData. There is a method called getCatalogs().

[Phaelax]

thx, got it.

For anyone else who's wanted to know:

DatabaseMetaData dbmd = connection.getMetaData();
ResultSet result = dbmd.getCatalogs();
while(result.next())
{
     String tableName = result.getString(1);
     System.out.println(tableName);
}