Acquiring views

Поиск
Список
Период
Сортировка
От SERFIOTIs gewrgios
Тема Acquiring views
Дата
Msg-id Pine.GSU.4.44.0206121649080.2652-100000@tilos.csd.uch.gr
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Arthur & Kathy Yeo"
Дата:
Сообщение: Re: Getting ResultSet using JDBC when calling Stored-Procedures
Следующее
От: Tom Lane
Дата:
Сообщение: Shouldn't "aborted transaction" be an ERROR? (was Re: [NOVICE] Optimising inside transactions)