HQL IN Clause with Array from DB + JOIN

Question

i have a Table where an ArrayList of prices is saved via Hibernate as a Blob. Now i will get access to that list via IN clause. Is this possible? All with a JOIN of two tables

i.e. with:

SELECT * FROM products as p, prices as pr WHERE pr.id IN p.prices

p.prices contains an ArrayList with the id of the prices

joostschouten · Accepted Answer · 2011-06-17 09:39:03Z

1

No that is not possible. If you do wish to do anything like this you should store a string of price_id's as a CLOB (TEXT) and use LIKE '%yourID%' OR LIKE '%anotherId%'. But watch out though, this is ugly and you need to make sure you cater for situations so that looking up id 5 is not matched by id 15.

It sounds like you are taking some shortcuts you should seriously reconsider.

edited Jun 17, 2011 at 9:39

answered Jun 17, 2011 at 9:33

joostschouten

3,9131 gold badge20 silver badges33 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

HQL IN Clause with Array from DB + JOIN

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related