Hi i have :

i can't get it to work , i've tried mappedby and join column allso when i use it like above it says that referer can't be null but it's not null it holds a valid user (i inserted one into db manualy) .
and when try to use other ways it says unknow on userName on refererr_username ... what am i doing wrong ?
allso tried @onetoone with nothing else still no luck ...
thanks

Hi Amnon,

What are you trying to achieve.

Please describe you DB table with the data you have and what you want to get back when u perform your query

i have a table called user which has a PK on column usernmae (varchar) and a colum referer (varchar) that is a FK pointing to username (same table)
i want to add a new user entity (DB row) and make sure the referer is not null and pointing to an existing user PK (username)


solved , but i have another q. can i make hibernate validate that the @Id is unique and not fail on constraint violation ?

@UniqueConstraint(columnNames="col1") maybe

thanks !