Hibernate Community • View topic - entities order by dynamic attribute

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

entities order by dynamic attribute

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

ottrich

Post subject: entities order by dynamic attribute

Posted: Mon Sep 24, 2007 5:39 am

Newbie

Joined: Mon Sep 10, 2007 9:30 am
Posts: 12

Hello,

I use a dynamic-map-entity which has a map of attributes stored in a second table. Accessing the entities works fine with an own tupelizer.

Now I want to use queries with "order by" on the dynamic attributes. I tried this, but it does not work:

String query = "FROM " + entity + " AS entity" + " JOIN entity.attributes AS attributes"
+ " WHERE INDEX(attributes) = :attributeName"
+ " ORDER BY attributes.ATTRIBUTE1";

is this sort of ordering possible? And if so, how?

regards

Top

Page 1 of 1

[ 1 post ]

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