Sender: mdalphin@amgen.com
Message-ID: <38BB1FB0.ADC6E1DC@amgen.com>
Date: Mon, 28 Feb 2000 17:24:00 -0800
From: Mark Dalphin <mdalphin@amgen.com>
Organization: Amgen, Inc.
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: JDBC and IBM Visual Age for Java
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi,

We're working with IBM's Visual Age for Java, (Enteprise Edition, ver 3) and
trying to use it with Postgresql ver 6.5.3 (JVM 1.1). We can get VAJ to
recognise the DB and connect and return the tables present, however, we can't
get VAJ's "visual query builder" to permit us to make joins across tables.
Manual entry ot the SQL is fine, but there is no drag-a-key to make a join.

Am I missing some part of JDBC or VAJ? Is there some setup lacking or, perhaps,
does PostgreSQL not supply some metadata that VAJ requires?  Does anyone know
how to make this work?

Thanks,
Mark

--
Mark Dalphin                          email: mdalphin@amgen.com
Mail Stop: 29-2-A                     phone: +1-805-447-4951 (work)
One Amgen Center Drive                       +1-805-375-0680 (home)
Thousand Oaks, CA 91320                 fax: +1-805-499-9955 (work)