Re: Opening view that uses a function - empty column

Поиск
Список
Период
Сортировка
Искать
От
Brady Mathis
Тема
Re: Opening view that uses a function - empty column
Дата
Msg-id
d3ee6832-c364-45a9-9d20-d7dd003a53bd@googlegroups.com
Ответ на
Список
Дерево обсуждения
Opening view that uses a function - empty column Brady Mathis <bmathis@r-hsoftware.com>
Re: Opening view that uses a function - empty column Brady Mathis <bmathis@r-hsoftware.com>
Re: Opening view that uses a function - empty column "David Johnston" <polobo@yahoo.com>
Re: Opening view that uses a function - empty column Brady Mathis <bmathis@r-hsoftware.com>
Re: Opening view that uses a function - empty column Brady Mathis <bmathis@r-hsoftware.com>
Re: Opening view that uses a function - empty column Dave Cramer <pg@fastcrypt.com>
Re: Opening view that uses a function - empty column Brady Mathis <bmathis@r-hsoftware.com>
Re: Opening view that uses a function - empty column David Johnston <polobo@yahoo.com>
I am actually using Jasper reports to access the view.  I created the data source and specified the following:

Driver:  org.postgresql.Driver
URL:  jdbc:postgresql://localhost:5432/postgres
UID and PW

I made sure to update to postgresql-9.1-902.jdbc4.jar (PG version is 9.1.2)

Then I defined a query simply as:  

select * from encounter;

I also tried the same query using a SquirrelSQL client (just to eliminate a problem in Jasper) and got the same result.  The column filled by the function is empty.

If I select * from encounter directly in postgres, the column is filled.

My apologies if I haven't included the implementation details that you need.

Thanks!
В списке pgsql-jdbc по дате отправления
От: Dave Cramer
Дата:
От: David Johnston
Дата:
FAQ