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