how to get list of Databases "Schema" names of MySql using java JDBC ?
See Question&Answers more detail:oshow to get list of Databases "Schema" names of MySql using java JDBC ?
See Question&Answers more detail:osThe getSchemas()
method of the DatabaseMetaData is the obvious but with MySQL you have to use getCatalogs()
http://download.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getSchemas() http://download.oracle.com/javase/7/docs/api/java/sql/DatabaseMetaData.html#getCatalogs()
Example:
Class.forName("com.mysql.jdbc.Driver");
// change user and password as you need it
Connection con = DriverManager.getConnection (connectionURL, "user", "password");
ResultSet rs = con.getMetaData().getCatalogs();
while (rs.next()) {
System.out.println("TABLE_CAT = " + rs.getString("TABLE_CAT") );
}