Comment by HaraldWeber on HaraldWeber's answer

HaraldWeber — Wed, 02 Apr 2014 12:37:37 -0400

Now I set the reference of User ins Option myself and it is working now.

Answer by HaraldWeber

HaraldWeber — Mon, 31 Mar 2014 09:19:48 -0400

I used a script step and called ivy.persistence.persistence.persist(in.user);

My database looks like this: CREATE TABLE [dbo].users ON [PRIMARY] GO


CREATE TABLE [dbo].opts ON [PRIMARY]
GO

ALTER TABLE [dbo].[opts] WITH CHECK ADD CONSTRAINT [FK34282079933D49] FOREIGN KEY([user_fk_id]) REFERENCES [dbo].[users] ([id]) GO

I think the problem is how I create new Items for the opts list in the user class. In the view i have a selectManyCheckbox: <p:selectManyCheckbox id="select" value="#{data.user.opts}" > <f:selectItem itemLabel="Option 1" itemValue="Option 1" /> <f:selectItem itemLabel="Option 2" itemValue="Option 2" /> <f:converter converterId="conv.OptionConverter" /> </p:selectManyCheckbox>

The con.OptionConverter creates one option object from the given string. @Override public Object getAsObject(FacesContext arg0, UIComponent arg1, String arg2) throws ConverterException { Option option = new Option(); option.setOption(arg2); return option; }

There should also be something like option.setUser_fk(user); so the reference from User to Option is set. This is not possible in the converter because there is no reference to the User object. The only way to set the reference of User in Option is in the User Entity Class where the list is set (or built up). But the generated code only sets the list with empty references to User. So the persistence api can't know their connection. Maybe I'm thinking wrong and build the example wrong but without the references set the persistence api will never set the keys.

Best Regards Harald

Answer by roland

roland — Thu, 27 Mar 2014 20:13:09 -0400

Hi Harald,

did you try to persist the dataclass? ivy.persistence.xyz.persist(User);

as i know the keys are set within the database server.

in our case we used MSSQL and the keys are set by MSSQL table settings.

Best regards Roland

Answers to: Persistence Api - Foreign Key is always null

Comment by HaraldWeber on HaraldWeber's answer

Answer by HaraldWeber

Answer by roland