[jboss-user] [JBoss Seam] - inserting into associations..

[minamti]

How should I insert into associations. 

Let's say I have the following tables..

create table user (
user_id bigint unsigned NOT NULL, 
user_name varchar(255) NOT NULL,
PRIMARY KEY(user_id)
);

create table actions (
action_id tinyint unsigned not null, 
action_name varchar(255) NOT NULL, 
PRIMARY KEY(action_id));

create table user_actions (
user_id bigint unsigned not null, 
action_id tinyint unsigned NOT NULL, 
session_id varchar(255),
action_time TIMESTAMP NOT NULL,
PRIMARY KEY (user_id, action_id, session_id, action_timestamp)
FOREIGN KEY(user_id) REFERENCES user(user_id) ON UPDATE CASCADE ON DELETE RESTRICT, 
FOREIGN KEY(action_id) REFERENCES actions(action_id) ON UPDATE CASCADE ON DELETE RESTRICT);

Lets say the user record exists and the action record exists. What is the  way to insert a record into user_actions. 

If I try to persist a UseractionsAssocHome object obtained from Component.getInstance, I get a EntityNotFound exception.  

Caused by: org.jboss.seam.framework.EntityNotFoundException: entity not found: c
om.foo.entity.UserActionAssoc#com.foo.entity.UserActionAssocId at 6bca1c13
        at org.jboss.seam.framework.Home.handleNotFound(Home.java:109)
        at org.jboss.seam.framework.EntityHome.find(EntityHome.java:75)
        at org.jboss.seam.framework.Home.initInstance(Home.java:91)
        at org.jboss.seam.framework.Home.getInstance(Home.java:71)
        at org.jboss.seam.framework.EntityHome.persist(EntityHome.java:50)
        at com.foo.entity.UserActionAssocHome.persist(UserActionAssocHome.jav
a:29)

Thanks, 

M

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4093647#4093647

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4093647