Re: JDBC and primary Key missing

Nuno,

Can you send the table schema ? There are some peculiarities about what
our driver thinks is a primary key.

Dave
On Wed, 2003-04-23 at 10:52, Nuno Duarte 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 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--
Dave Cramer <Dave@micro-automation.net>