From: | David Johnston <polobo(at)yahoo(dot)com> |
---|---|
To: | Brady Mathis <bmathis(at)r-hsoftware(dot)com> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: Opening view that uses a function - empty column |
Date: | 2012-07-28 00:50:10 |
Message-ID: | CCB39283-1502-4391-A3E6-D9329C007132@yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Jul 27, 2012, at 17:21, Brady Mathis <bmathis(at)r-hsoftware(dot)com> wrote:
> 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!
>
Is the same user being used in both cases and are there any other functions with the same name but in other schemas?
David J.
From | Date | Subject | |
---|---|---|---|
Next Message | Radim Kolar | 2012-07-29 13:55:42 | Re: not fetching all query results |
Previous Message | Brady Mathis | 2012-07-27 21:21:24 | Re: Opening view that uses a function - empty column |