What is DatabaseMetaData?

DatabaseMetaData is used to know which type of driver we are using and whether is it compatable or JDBC complaint or not. It is used to know all details about database provider as well.Here is the example--

 

package com.rexofcyber.jdbc;

 

import java.sql.Connection;

import java.sql.DatabaseMetaData;

import java.sql.DriverManager;

import java.sql.SQLException;

 

public class MyDatabaseMetadata {

 

    public static void main(String a[]){

         

        Connection con = null;

        try {

            con = DriverManager.

                getConnection("jdbc:oracle:thin:@<hostname>:<port num>:<DB name>"

                        ,"user","password");

            DatabaseMetaData dm = con.getMetaData();

            System.out.println(dm.getDriverVersion());

            System.out.println(dm.getDriverName());

            System.out.println(dm.getDatabaseProductName());

            System.out.println(dm.getDatabaseProductVersion());

        } catch (SQLException e) {

         


            e.printStackTrace();

        } finally{

            if(con != null){}

                try {

                    con.close();

                } catch (SQLException e) {

            


                    e.printStackTrace();

                }

            }

        }

    }

}