Thread: JDBC and primary Key missing

JDBC and primary Key missing

From
"Nuno D. Leitao"
Date:
Having a strange problem with Sun studio 4 update 1 talking to postgreSQL
7.3. (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


Re: JDBC and primary Key missing

From
Dave Cramer
Date:
Nuno,

Did you solve this, is this an old message or a new one?

Dave
On Wed, 2003-04-23 at 06:32, Nuno D. Leitao wrote:
> Having a strange problem with Sun studio 4 update 1 talking to postgreSQL
> 7.3. (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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
--
Dave Cramer <Dave@micro-automation.net>