RE: Middlegen and Hsqldb - compound keys
Eivind Waaler <[email protected]>
| Newsgroups | gmane.comp.java.ejb.middlegen.user |
|---|---|
| Message-ID | <[email protected]> |
Doesn't the standard Middlegen sample (persons, reservations, flights) use
compound primary key for the reservations table? It does something like
this in the create script:
PRIMARY KEY ("reservation_id","person_id_fk","flight_id_fk")
Seems to work fine. Middlegen reads it as a compound primary key.
.eivind
On Wed, 19 May 2004, Darren Hartford wrote:
> In case anyone else may be interested, I have not found a work-around, and instead have switched to McKoi database :-)
> -D
> -----Original Message-----
> From: Darren Hartford
> Sent: Tuesday, May 18, 2004 10:12 AM
> To: [email protected]
> Subject: [Middlegen-user] Middlegen and Hsqldb - compound keys
>
>
> Hey all,
> Has anyone had success using Middlegen with Hsql/Hypersonic where the database contains compound primary keys? It seems Hsql creates compound PK's only through Unique and not through a 'Primary Key' constraint, and as such Middlegen doesn't recognize the compound primary key.
>
> Does anyone have some info/feedback on this? I'm a little stuck as I was hoping to do code-gen from a Hypersonic DB schema.
>
> -D
>
>
> -------------------------------------------------------
> This SF.Net email is sponsored by: SourceForge.net Broadband
> Sign-up now for SourceForge Broadband and get the fastest
> 6.0/768 connection for only $19.95/mo for the first 3 months!
> http:
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click