Re: getMetaData().getTables() behaviour with JDBC3 8.3 & 8.4 drivers on windows

>
>
>The PostgreSQL driver appears to be causing some unexpected behaviour for the OpenNMS installer on Windows.
>
>In the following code snippet, the table row set returned includes TABLEs, SEQUENCEs, and INDEXes. Shouldn't getTables be filtering out and returning only tables and views?
>
> public void databaseSetUser() throws SQLException {
> Connection adminConn = getAdminConnection();
> ResultSet rs = adminConn.getMetaData().getTables(null, "public", "%", null);
>

In your argument for getTables(catalog, schemaPattern, tableNamePattern,
tableTypes) you
have specified a null for the tableTypes. That I believe does not place
any restrictions on
the returned table, so VIEW and other types will be returned.

types - A list of table types, which must be from the list of table
types returned from getTableTypes(), to include; null returns
all types.

danap