Hello All,

This a sort of a 'pre-sales' question. I am not using hibernate yet but am certainly considering it.

My Postgres db schema set-up is quite unique: for example, instead of having one table for user object i have 2 tables:

tb_user {
uid pk
app_id
name
email
}

tb_user_property {
uprop_id pk
uid fk
prop_name
prop_value
}

so, basically user will have just the most essential metadata for the user and the rest of user data is stored as properties (this is to enable using teh same db schema by multiple applications i am developing).


then i have a java object (User) which looks similar to this:

public class User {
int uid
int appid
String name
String email
List properties
}

now the question is: will i be able to utilize hibernate to perform CRUD operations on such db structure? (i. e. my finders should be able to collect user data from the two tables joined; the create should store data in the two tables, etc.). will the solution be elegant or more of a hack? Any pointers to some relevant reading material?

If my question is not entirely clear, please ask for clarification. I really appreciate your help.

James

I think that you have standard one to many realtion and it owkr perfect with hibernate

regards

That is hardly a unique schema design ;)

Yes Hibernate can handle what you describe. It's a simple fk association.

This can be mapped as either a list of entities or as a list of components (see the docs for meanings if you don't understand). In fact Hibernate will even let you do things like map the User.properties property as a Map of key/values... All kinds of options :)

Thanks a lot for your help, all! I'll get started with the manual then

James