Hibernate Community • View topic

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

order by UserType

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

domurtag

Post subject: order by UserType

Posted: Mon Nov 05, 2007 1:53 pm

Newbie

Joined: Mon Sep 17, 2007 7:04 pm
Posts: 3

Hi,

I've created a UserType for the replicationOperation property of one of my mapped classes (ReplicationAudit). The relevant part of the mapping file is shown below:

Code:

    <class name="ReplicationAudit" table="REPLICATION_AUDIT">          
        <property name="replicationOperation" column="REPLICATION_OPERATION_ID" type="com.example.replication.model.personalization.ReplicationOperationUserType" not-null="true" />  
        
    </class>

The UserType has a name property, but when I try to order by this property I get an exception containing the following message

Quote:

could not resolve property: name of: com.example.replication.model.personalization.ReplicationAudit

I've tried writing the query in two ways:

Code:

                
                "from ReplicationAudit ra " +
                "where ra.id > :afterId " +
                "and ra.id <= :uptoId " +
                "order by ra.replicationOperation.name asc"

and:

Code:

       
                "from ReplicationAudit ra " +
                "inner join ra.replicationOperation as raOp " +
                "where ra.id > :afterId " +
                "and ra.id <= :uptoId " +               
                "order by raOp.name asc"

But the result is the same in both cases. From the error message, it seems like Hibernate is trying to order by ReplicationAudit.name, rather than ReplicationAudit.replicationOperation.name.

Thanks in Advance,
DM

Top

kid1125

Post subject:

Posted: Mon Nov 05, 2007 6:28 pm

Newbie

Joined: Wed Oct 31, 2007 5:36 pm
Posts: 13

You can have your ReplicationOperationUserType implement Comparable
and implement the compareTo method:

Code:

public int compareTo(ReplicationOperationUserType other) {
  return this.name.compareTo(other.name);
}

Then your queries can order by replicationOperation instead of replicationOperation.name

Top

domurtag

Post subject:

Posted: Tue Nov 06, 2007 1:19 pm

Newbie

Joined: Mon Sep 17, 2007 7:04 pm
Posts: 3

I did wonder if that would work......I'll try it out - thanks very much!

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