Thread: 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.

> 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".

But you are connecting to a database called "data_gen":

> DriverManager.getConnection("jdbc:postgresql://sampel.db:5432/data_gen", "postgres"

Also: what exactly does "it fails" mean? Do you get an exception? If yes, what is the exception?

Thomas

Tried passing schema pattern also null, still resultset is empty.



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

Works with following change.

ResultSet resultSet = metaData.getColumns(null, null, "employee", null);

Thanks



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