Re: Acquiring views

What version of the driver are you using?  I am unable to reproduce the
problem with the latest driver.

--Barry

SERFIOTIs gewrgios wrote:
> Hi,
>     i'm using the function getTables() of interface DatabaseMetaData
> trying to obtain the names of the views which are defined in the database.
> However, although it works with an Oracle Database, it doesn't work in a
> Postgresql Database.
> The exact statement i'm using is the following:
> String types[] = new String[1];
> types[0] = new String("VIEW");
> ResultSet rs = this.dbmd.getTables(null, null, null, types);
>
> The result is that I get java.lang.NullPointerException at the last line,
> although I do have a view declared!
>
> When I'm using: types[0] = new String("TABLE") instead it works fine. Is
> there a problem between what PostgreSQL considers a view, and what JDBC
> considers a view?
>
> Thank you.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>