Can I map a one to one bi-directional relationship where the owning entity has a string for a primary key rather than an id field? If so, can someone show me an example? I keep getting an Oracle invalid number error (I'm using Hibernate as the provider).

Thanks,
mort

Hi, did you ever manage to solve this problem? I have a similar issue

I think what you are looking for here is the referencedColumnName property of the JoinColumn annotation ...
But I'm not really sure I understood your problem so I might be wrong. Can you elabore with an example?

Check out the post I wrote, titled "Invalid number error when loading related entity". I have a detailed example and explanation in there including various solutions I've tried. It should be similar to the issue outlined here.