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.
Is the same user being used in both cases and are there any other functions with the same name but in other schemas?
In response to
pgsql-jdbc by date
|Next:||From: Radim Kolar||Date: 2012-07-29 13:55:42|
|Subject: Re: not fetching all query results|
|Previous:||From: Brady Mathis||Date: 2012-07-27 21:21:24|
|Subject: Re: Opening view that uses a function - empty column|