Mailing-List: contact user-help@geronimo.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@geronimo.apache.org
Received-SPF: error (idunn.apache.osuosl.org: domain freefarm.se from
 80.252.160.176 cause and error)
Message-Id: <6.2.1.2.0.20060922175631.02516a58@pop03.crystone.se>
Date: Fri, 22 Sep 2006 18:12:30 +0200
To: user@geronimo.apache.org
From: Mattias Malmgren <mattias@freefarm.se>
Subject: CMP EJB without primary key
In-Reply-To: <4513EA80.1090009@opensource.lk>
References: <4513EA80.1090009@opensource.lk>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed

Hi

This is perhaps out of topic, but I have a question about CMP and EJB and 
there seams to be some very experiensed EJB-programmers rading this list. 
Reading Suns j2ee tutorial it says that an EJB must have a primary key. I 
wonder if it is possible to have a EBJ that only have a foreign key. Eg a 
weight watchers system with person and weights att diffrent dates:

SQL:
create table person (id int primary key, name varchar(20))
create table weight(fk_person foreign key, date varchar(8), weight numeric)

Say that I have 2 entity EJBs, PersonEJB and WeightBean. The relationship 
is 1-n. Must the weight table also include a primary key to make CMP work, 
even though a primary key in this table from a SQL-point of view is 
unnessesary?

Best regards // Mattias
PS
I am proud to announce that I have got my first test case of a JSP page 
calling an EJB to work!
DS