0
     DatabaseMetaData data = connection.getMetaData();
     resultSet =  data.getCatalogs();
     while (resultSet.next()) {
      System.out.println(resultSet.getString("TABLE_CAT"));
    }

above code gives me name of all the database of the sql server but i need only default database that configured in DSN

Pravin
  • 1,137
  • 12
  • 20

1 Answers1

1
Statement statement = connection.createStatement();
    ResultSet resultSet1 = statement.executeQuery("select db_name()");
    while (resultSet1.next()) {
        System.out.println(resultSet1.getString(1));
    }
Pravin
  • 1,137
  • 12
  • 20