JDBC is not executing SHOW DATABASES command [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 6 years ago.

Improve this question

i want to get a list of databases stored in mysql and put in java table using command "show databases" via a resultset. but its not working.

DefaultTableModel model=(DefaultTableModel)dbTbl.getModel();
try{
    Class.forName("com.mysql.jdbc.Driver");
    Connection con=DriverManager.getConnection("jdbc:mysql//localhost/:3306","root","password");
    Statement stmt=con.createStatement();
    ResultSet rs=stmt.executeQuery("show databases;");
    while(rs.next())
   {
    String db=rs.getString(1);
    model.addRow(new Object[] {db});
   }
    rs.close();
    stmt.close();
    con.close();
}
catch(Exception e)
{
    JOptionPane.showMessageDialog(null,"nahi chalda");
}

What error you are getting? Also ; isnt necessary inside executeQuery — greatmajestics
– greatmajestics, Commented Oct 7, 2012 at 17:33

Philip Whitehouse · Accepted Answer · 2018-04-17 15:04:26Z

6

That's not the best way to get a list of Databases in JDBC. Here's the way it's done - using MetaData

Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost/:3306","root","password");
DatabaseMetaData meta = con.getMetaData();
ResultSet resultSet = meta.getCatalogs();
while (resultSet.next()) {
   String db = resultSet.getString("TABLE_CAT");
   model.addRow(new Object[] {db});
}
resultSet.close();
con.close();

See also: how to get list of Databases "Schema" names of MySql using java JDBC

edited Apr 17, 2018 at 15:04

answered Oct 7, 2012 at 17:42

Philip Whitehouse

4,1673 gold badges26 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mann · Accepted Answer · 2012-10-21 16:18:05Z

-1

I just forgot to add colon after "jdbc:mysql Correct code is:

Connection con=DriverManager.getConnection("jdbc:mysql://localhost/:3306","root","password");

It works ,......... !!!

answered Oct 21, 2012 at 16:18

Mann

351 silver badge3 bronze badges

Collectives™ on Stack Overflow

JDBC is not executing SHOW DATABASES command [closed]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related