zbiszko wrote on 15.11.2007 23:59:

Try DatabaseMetaData.getCatalogs()

http://java.sun.com/j2se/1.5.0/docs/api/java/sql/DatabaseMetaData.html#getCatalogs()

Btw: when using executeQuery() the statement may not be terminated with a
semicolon. So probably running st.executeQuery("show databases"); would work as
well.

Thomas

Now you've got the list in your result set, you need to read through it
a row at a time:

    while (rs.next())
    {
       /* Retrieve and print the columns in this row */
    }

Code:

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class ShowDatabases {
    public static void main(String[] args) throws Exception {
        Class.forName("com.mysql.jdbc.Driver");
        Connection con =
DriverManager.getConnection("jdbc:mysql://localhost/Test", "root", "");
        Statement stmt = con.createStatement();
        ResultSet rs1 = stmt.executeQuery("SHOW DATABASES");
        while(rs1.next()) {
            System.out.println(rs1.getString(1));
        }
        rs1.close();
        ResultSet rs2 = stmt.executeQuery("SELECT SCHEMA_NAME FROM
INFORMATION_SCHEMA.SCHEMATA");
        while(rs2.next()) {
            System.out.println(rs2.getString(1));
        }
        rs2.close();
        ResultSet rs3 = con.getMetaData().getCatalogs();
        while(rs3.next()) {
            System.out.println(rs3.getString(1));
        }
        rs3.close();
        con.close();
    }
}

Arne