Skip site navigation (1) Skip section navigation (2)

Re: Opening view that uses a function - empty column

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 (view raw or flat)
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.

In response to

pgsql-jdbc by date

Next:From: Radim KolarDate: 2012-07-29 13:55:42
Subject: Re: not fetching all query results
Previous:From: Brady MathisDate: 2012-07-27 21:21:24
Subject: Re: Opening view that uses a function - empty column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group