Hibernate Community • View topic - Updating list-like indices

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Updating list-like indices

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

Will_Gayther

Post subject: Updating list-like indices

Posted: Wed Nov 26, 2003 2:30 am

Beginner

Joined: Mon Sep 15, 2003 6:55 pm
Posts: 29

I have a collection which is a bag, however each item in the collection has a displayIndex much like an index in a list. Is is possible to write a statement in hql like "add 1 to every displayIndex that is greater than 17"? I know I can retrieve them and update them myself, but I'm worried about what will happen when the collection gets a lot of stuff in it.

Top

gavin

Post subject:

Posted: Wed Nov 26, 2003 2:31 am

Hibernate Team

Joined: Tue Aug 26, 2003 12:50 pm
Posts: 5130
Location: Melbourne, Australia

I think this is a good case for direct SQL/JDBC

Top

Will_Gayther

Post subject:

Posted: Wed Nov 26, 2003 2:33 am

Beginner

Joined: Mon Sep 15, 2003 6:55 pm
Posts: 29

I've learned hql, but I'm pretty fuzzy with sql. Do you know if it's possible with sql? (I've already tried searching, but can't find much)

Top

gavin

Post subject:

Posted: Wed Nov 26, 2003 2:35 am

Hibernate Team

Joined: Tue Aug 26, 2003 12:50 pm
Posts: 5130
Location: Melbourne, Australia

Code:

PreparedStatement ps = session.connection().prepareStatement("update foo set display_index = display_index +1 where display_index > 17 and id = ?");
etc...

Top

Page 1 of 1

[ 4 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