how to get list of Databases “Schema” names of MySql using java JDBC

by

The 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") );
}

More Related Contents:

  1. com.mysql.jdbc.PacketTooBigException
  2. SQL syntax error in "insert into 'keys'(a,b,c,d,e) values(?,?,?,?,?)" [closed]
  3. Hours and seconds are lost when storing a date in the database [closed]
  4. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  5. Solving a “communications link failure” with JDBC and MySQL [duplicate]
  6. Multiple queries executed in java in single statement
  7. Java: Insert multiple rows into MySQL with PreparedStatement
  8. Is it possible to specify the schema when connecting to postgres with JDBC?
  9. ClassCastException: java.math.BigInteger cannot be cast to java.lang.Long on connect to MySQL
  10. Cannot issue data manipulation statements with executeQuery()
  11. Handling MySQL datetimes and timestamps in Java
  12. No suitable driver found for ‘jdbc:mysql://localhost:3306/mysql [duplicate]
  13. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communications link failure [duplicate]
  14. Java JDBC Access denied for user [closed]
  15. How to get a value from the last inserted row? [duplicate]
  16. How is driver class located in JDBC4
  17. runtime error: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
  18. JDBC returning MySQLSyntaxError Exception with correct statement
  19. ‘0000-00-00 00:00:00’ can not be represented as java.sql.Timestamp error
  20. Problems reading/writing UTF-8 data in MySQL from Java using JDBC connector 5.1
  21. How to simulate a DB for testing (Java)?
  22. SQL Error: 0, SQLState: 08S01 Communications link failure [duplicate]
  23. MySQL connector error “The server time zone value Central European Time” [duplicate]
  24. How to correctly write UTF-8 strings into MySQL through JDBC interface
  25. How do I unit test jdbc code in java? [closed]
  26. java.sql.SQLException: Before start of result set [duplicate]
  27. Stumped SQL Exception for JDBC
  28. MySQL & Java – Get id of the last inserted value (JDBC) [duplicate]
  29. Performance of MySQL Insert statements in Java: Batch mode prepared statements vs single insert with multiple values
  30. java.sql.SQLException: No database selected – why?

Leave a Comment