Retrieving primary key information with UCanAccess

Question

I'm trying to get all database metadata from an Access database using the UCanAccess JDBC driver but I need to change my resultset type to navigate in the resultset but how to set the good type when my resultset are created with method from the interface databasemetadata ? code here

 v_resultPrimaryKey = p_metadata.getPrimaryKeys(null, Tools.getDBName(), p_table);

        ResultSet v_resultColumn = p_metadata.getColumns(null, Tools.getDBName(), p_table, null);

        v_resultPrimaryKey.first();

        String v_pkName = v_resultPrimaryKey.getString("COLUMN_NAME");

You think you need to change the type why? What is the underlying problem? — user207421, Apr 25 '17 at 12:32
when i wan't to use ".first" it says to me feature not supported — kazor02x, Apr 25 '17 at 12:32
because the resultset with ucanacess is in forwardonly mode how can i change it — kazor02x, Apr 25 '17 at 12:34
Why? Do you really need to go backwards? Why not just `next()` through it like everybody else? — user207421, Apr 25 '17 at 12:40
one question if i do only one ".next" on a result set does it do the same effect as a ".first"? — kazor02x, Apr 25 '17 at 12:44
Of course. You start before the beginning, then one `next()` gives you the first, another one the second, and so on. This is rather basic. — user207421, Apr 25 '17 at 12:56

Gord Thompson · Answer 1 · 2017-04-26T00:46:23.483

You don't need to change the ResultSet type in order to retrieve the primary key information. All you need to do is something like this ...

try (Connection conn = DriverManager.getConnection(connUrl)) {
    try (ResultSet rs = conn.getMetaData().getPrimaryKeys(null, null, "InvoiceDetail")) {
        while (rs.next()) {
            System.out.printf("%s (%d)%n", 
                    rs.getString("COLUMN_NAME"), 
                    rs.getInt("KEY_SEQ"));
        }
    }
}

... which for a table like this ...

... will produce output like this:

InvoiceNumber (1)
LineItemNumber (2)

Retrieving primary key information with UCanAccess

1 Answers1