Hey,
I need to load entities by set of attributes values.
I can do it with query like this:
select from supplier where ( (name ="name1" and address="address1" and city="city1") OR (name="name1" and address="address2" and city="city2") .... )
Queries like this suffer from performance issues, so i do this by creating temp table in the DB before run the query. (the input for the query and the number of criterion set are changed for each input).
In hibernate i can do it by criteria or by HQL (any idea if i can do any tricky name-query here?).
Just want to hear from you about your implementation for this.
do you do it in hibernate at all?
Thank you
I need to load entities by set of attributes values.
I can do it with query like this:
select from supplier where ( (name ="name1" and address="address1" and city="city1") OR (name="name1" and address="address2" and city="city2") .... )
Queries like this suffer from performance issues, so i do this by creating temp table in the DB before run the query. (the input for the query and the number of criterion set are changed for each input).
In hibernate i can do it by criteria or by HQL (any idea if i can do any tricky name-query here?).
Just want to hear from you about your implementation for this.
do you do it in hibernate at all?
Thank you