the error did not appear for the first two tables, but after defining the third table, the error keep displaying in my browser...

anyone can enlighten me on this...

thanks in advance...

myes,]]>myesther ghee2012-07-02T02:05:12-00:00Re: JPA error https://www.eclipse.org/forums/index.php/mv/msg/366704/893292/#msg_893292
It appears you are using Hibernate as your JPA provider - this forum is for EclipseLink, an alternate JPA provider, so you may want to post your problem on a more appropriate forum or try EclipseLink.

That said, my guess would be that the problem is due to the Comments->Post ManyToOne mapping specifying the defaults. For some reason, it thinks the Post entity has two or more id fields as a composite ID. This could be due to putting the @ID and @GeneratedValue on the ManyToOne 'author' relationship, though this could be a hibernate issue. I don't think a sequence should be used for a relationship field so a validation exception should be thrown, or it just ignored since the field should be set from the User object instead of a generator.

More likely, you meant to put the @ID and generator on the id string defined below the relationship?

Best Regards,
Chris]]>Chris Delahunt2012-07-03T13:20:59-00:00Re: JPA error https://www.eclipse.org/forums/index.php/mv/msg/366704/894664/#msg_894664
thank you for the reply... yes, i figured it out why i got the error and your right it just i was not able to comeback here.

thank you also for acknowledging my post even though it is not fitted here.