From: | Dave Cramer <Dave(at)micro-automation(dot)net> |
---|---|
To: | Nuno Duarte Leitao <nunomdl(at)eml(dot)cc> |
Cc: | "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Re: JDBC and primary Key missing |
Date: | 2003-04-23 15:13:42 |
Message-ID: | 1051110821.24929.182.camel@inspiron.cramers |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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(at)postgresql(dot)org)
--
Dave Cramer <Dave(at)micro-automation(dot)net>
From | Date | Subject | |
---|---|---|---|
Next Message | Roberto Bouza | 2003-04-23 15:39:16 | An I/O error has occured while flushing the output |
Previous Message | Nuno Duarte Leitao | 2003-04-23 14:52:06 | JDBC and primary Key missing |