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

Re: Opening view that uses a function - empty column

From: Brady Mathis <bmathis(at)r-hsoftware(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Opening view that uses a function - empty column
Date: 2012-07-27 21:21:24
Message-ID: d3ee6832-c364-45a9-9d20-d7dd003a53bd@googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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!

In response to

Responses

pgsql-jdbc by date

Next:From: David JohnstonDate: 2012-07-28 00:50:10
Subject: Re: Opening view that uses a function - empty column
Previous:From: Dave CramerDate: 2012-07-27 20:40:58
Subject: Re: Opening view that uses a function - empty column

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