TopLink: sorting entities by boolean value

Thread view:

k.adamczyk - 29 Aug 2007 07:56 GMT

Hi,

I have a problem when I want to sort entities (order by) by
a boolean field.
TopLink throws following exception:
...
Caused by: Exception [TOPLINK-8021] (Oracle TopLink Essentials - 2006.8
(Build 060830)): oracle.toplink.essentials.exceptions.EJBQLException
Exception Description: Invalid ORDER BY item [e.active] of type
[java.lang.Boolean], expected expression of an orderable type.

Thoes it mean that TopLink can't sort by booleans?
Is there any workaround?
As far as I remember Hibernate had no problems doing this.

I will be grateful for any help.
Best regards,
Chris

Reply to this Message

GArlington - 29 Aug 2007 14:38 GMT

> Hi,
>
[quoted text clipped - 14 lines]
> Best regards,
> Chris

It may be to do with the fact that different systems use different
values for boolean True and False. You can use CASE() inside your SQL
to convert boolean to something sortable...

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...