Connecting from Java to PostgreSQL

From: "Nuno D(dot) Leitao" <ndl(at)coeusconsulting(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Connecting from Java to PostgreSQL
Date: 2003-04-24 22:28:04
Message-ID: OIEPKMHOOGPJABHPNBNAGEDLCCAA.ndl@coeusconsulting.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Having a strange problem with Sun studio 4 update 1 talking to postgreSQL
7.2. (Redhat version)

Using the latest Postgres JDBC driver (both latest stable and dev
releases)- in Sun studio I'm having problems mapping my container manager
persitence entity beans to postgres tables.

I make a database schema and entity bean from the postgres datasource
(everything's fine at this stage) but when I try to map
the ejb fields to tables in the postgres schema, for deployment, the
dialogue reports "Table 'x' has no primary keys defined"

I've checked my keys and indexes and I definitley have a primary key
defined. Is there something I'm missing?

I have the database in MySQL also and it works fine with Sun - but I'd much
rather have a postgres backend.

I've searched the web and newsgroups and can find hardly any information on
this topic, your help would be very much appreciated

regards
Nuno D. Leitao

Browse pgsql-general by date

  From Date Subject
Next Message ahoward 2003-04-24 22:35:31 Re: has_table_priviledge
Previous Message Tom Lane 2003-04-24 22:19:03 Re: C++ and v7.3.2