Hello.
I'm gonna write an internet shop, and currently i'm thinking about its Model layer.
If it's gonna be an abstract Entity, then users should be able to add arbitrary types of Entities to the shop.
For example, they might want to add a Vehicle, or a Flower, or a Pig.
Each such entity has different properties, for example a Vehicle has its speed, a Flower has its sort, and a Pig has its farm, where it has been breeded.

So, how can I implement all these infinite properties in Hibernate, so that it be fast and lightweight?

I could, for example, create a column named "additional properties" with some sort of XML such as:



But how would I then be able to get all the Juices with "strawberry" flavour?
There would be no query such as "from Entity entity where additionalProperties.flavour = "strawberry", would it?

What solution can you propose me to address this cusiom entity issue?

*As you've already understood, I'm unable to create the Juice class and map it in Hibernate - that's the user who creates new types of Entities.

maybe you give me any hints on this topic?
anyone?

This one is rather design decision you are asking about rather than hibernate query. Anyways I would rather go with having an entity called attribute type and attribute map, attribute type contains all the types we need and mapper contains the properties of that attribute. should be done with 2 table.

You mean this?





That's an interesting solution...
It projects nicely onto an HQL query:



Did i get you correct?

Yes you got me correctly, and I think we can hence it more ;)

thanks : )