pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Nuno D. Leitao <ndl@coeusconsulting.net>
To: pgsql-interfaces@postgresql.org
Subject: Connecting from Java to PostgreSQL
Date: Fri, 25 Apr 2003 00:35:42 +0200
Message-ID: <OIEPKMHOOGPJABHPNBNAAEDMCCAA.ndl@coeusconsulting.net> (raw)

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




Message-ID: <OIEPKMHOOGPJABHPNBNAAEDMCCAA.ndl@coeusconsulting.net>
Permalink:  ../OIEPKMHOOGPJABHPNBNAAEDMCCAA.ndl@coeusconsulting.net/
Also on:    postgresql.org/message-id/OIEPKMHOOGPJABHPNBNAAEDMCCAA.ndl@coeusconsulting.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: ndl@coeusconsulting.net
  Subject: Re: Connecting from Java to PostgreSQL
  In-Reply-To: <OIEPKMHOOGPJABHPNBNAAEDMCCAA.ndl@coeusconsulting.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox