I have the code as follows:

DatabaseMetaData dmd = connection.getMetaData();
ResultSet rs = dmd.getPrimaryKeys(null, null, tableName);

while(rs.next()){
    primaryKey = rs.getString("COLUMN_NAME");
}

rs is not null while rs.next() always return false, anyone has idea about it? Thanks.

java jdbc
Edit
Report