Get Column Metadata from Synonym Table

SynonymAccessor.java

import java.sql.*;
 
public class Main {
 
    public static void main(String[] args) {
        Connection con;
        DatabaseMetaData metaData;
        try {
            Class.forName("oracle.jdbc.driver.OracleDriver");
            con = DriverManager.
                    getConnection("jdbc:oracle:thin:@localhost:1521:sid"
                            , "USER", "PASSWORD");
 
            ( (oracle.jdbc.driver.OracleConnection)con ).setIncludeSynonyms(true);
            metaData = con.getMetaData();
            ResultSet columns = metaData.getColumns(null, "[SHEME NAME]", "[TABLE NAME]", "%");
                while (columns.next()) {
                    String name = columns.getString("COLUMN_NAME");
                    String type = columns.getString("TYPE_NAME");
                    System.out.println(name + "\t" + type);
                }
            Statement stmt = con.createStatement();
            System.out.println("Created DB Connection....");
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
    }
}