Sagewire Logo

TopLink: sorting entities by boolean value

2 Message(s) by 2 Author(s) originally posted in java databases


From: k.adamczyk Date:   Wednesday, August 29, 2007
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 not sort by booleans?
Is there any workaround?
As far as I remember Hibernate had no problems doing this.

I'll be grateful for any help.
Best regards,
Chris


From: GArlington Date:   Wednesday, August 29, 2007
wrote in message:
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 not sort by booleans?
Is there any workaround?
As far as I remember Hibernate had no problems doing this.
I'll be grateful for any help.
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...



Next Message: Query caching issue



Programming | Sports | Autos

copyright 2006
Valid XHTML 1.0 Transitional