Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Collection or CSV

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

adcworks

Post subject: Collection or CSV

Posted: Fri Jul 09, 2004 9:42 am

Senior

Joined: Fri Jun 18, 2004 10:17 am
Posts: 140

Hi Guys

I have a property called owners which is a comma-separated list of Strings representing users.

I wish to load a set of objects from the datbase where a passed username is in this comma separated list.

I can't see anything in the HQL reference for this and I thought a Collection was a bit heavy-handed for this or not?

Top

michael

Post subject:

Posted: Fri Jul 09, 2004 10:46 am

Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany

You can probably use some database-specific function in HQL like "select u from Something u where indexof(:username, u.usernames) != -1" - might probably work.

Top

adcworks

Post subject:

Posted: Fri Jul 09, 2004 10:47 am

Senior

Joined: Fri Jun 18, 2004 10:17 am
Posts: 140

thanks .. i ended up using a Set of strings which worked out really well. Hibernate rocks.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum