Re: Problem in getting column names from DatabaseMetadata Object

Hi,

I am using the following code to get the column names of my postgres table
but it fails. My database name is "employee" and table name is "employee".

Postgres version : 9.3
jdbc driver version : 9.3

public class DBTest {
        public static void main(String[] args) throws Throwable {
                Connection conn = getDBConnection();
                DatabaseMetaData metaData = conn.getMetaData();
                ResultSet resultSet = metaData.getColumns(null, "employee", "employee",
null);

                if (!resultSet.next())
                        System.out.println("No result set Entries!!");

                while (resultSet.next()) {
                        System.out.println(resultSet.getString("COLUMN_NAME"));
                }
                conn.close();
        }

        public static Connection getDBConnection() {
                Connection conn = null;
                try {
                        Class.forName("org.postgresql.Driver");

                        conn =
DriverManager.getConnection("jdbc:postgresql://sampel.db:5432/data_gen",
"postgres",
                                        "postgres");
                } catch (Throwable th) {
                        th.printStackTrace();
                }
                return conn;
        }

any ideas??

Thanks



--
View this message in context: http://postgresql.nabble.com/Problem-in-getting-column-names-from-DatabaseMetadata-Object-tp5872498.html
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.


--
Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-jdbc