Acquiring views - Mailing list pgsql-jdbc

From SERFIOTIs gewrgios
Subject Acquiring views
Date
Msg-id Pine.GSU.4.44.0206121649080.2652-100000@tilos.csd.uch.gr
Whole thread Raw
List pgsql-jdbc
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.


pgsql-jdbc by date:

Previous
From: "Arthur & Kathy Yeo"
Date:
Subject: Re: Getting ResultSet using JDBC when calling Stored-Procedures
Next
From: Tom Lane
Date:
Subject: Shouldn't "aborted transaction" be an ERROR? (was Re: [NOVICE] Optimising inside transactions)