no "natural" primary key

agugel Jun 28, 2002 5:44 AM

hi,

I have two entity beans A and B with a 1:n relation between them. While A have a "natural" primary key --- specified in the ebj-jar.xml as primary-key-field, B has non. The primary key class for B is therefore java.lang.Object.

It works find with the application server shipped with sun`s J2EE but it seems that JBoss 3.0 can't handle it. The generated SQL statements are invalid, e.g.

CREATE TABLE .... PRIMARY KEY ())

and postgres says ")" is not what it wants.

Maybe this is an unsupported feature??

1. Re: no "natural" primary key

dsundstrom Jun 30, 2002 2:18 PM (in response to agugel)

Unknown primary keys are not currently supported, but they are at the top of the todo list for 3.1.
Actions
2. Re: no "natural" primary key

arthursdw Jul 4, 2002 1:17 PM (in response to agugel)

Can you tell me when jboss3.1 will be available?
Thanks
Actions
3. Re: no "natural" primary key

dsundstrom Jul 4, 2002 4:54 PM (in response to agugel)

Nope.
Actions
4. Re: no "natural" primary key

dsundstrom Jul 4, 2002 4:55 PM (in response to agugel)

Sorry. That was a little short. I don't know. I'm not in charge of builds. I can say it hasn't been coded yet.
Actions

Go to original post