Eclipse Community Forums: EclipseLink » case insensitive "order by"

Home » Eclipse Projects » EclipseLink » case insensitive "order by"(case insensitive "order by")

case insensitive "order by" [message #496212]

Mon, 09 November 2009 06:34

Eclipse User

Hello,

I am using eclipse link 1.1.2 version.
I have to perform case insensitive sorting. I sql I can write query like:
select * from tenant order by upper(name) asc;

but we I try to write euivalent JPQL query:
select tenant from TenantEntity tenant order by upper(tenant .name) asc;

i got exception:
java.lang.IllegalArgumentException: An exception occurred while creating a query in EntityManager
"syntax error at [upper]."

but upper is working for where claue.

So I can write query like:
select tenant from TenantEntity tenant where upper(tenant.name) like 'G%"

but not with order by.

My question is: Does "order by" not supporting upper\lower function? If not how can I achieve it?

Thanks in advance.
Ashish

Re: case insensitive "order by" [message #496290 is a reply to message #496212]

Mon, 09 November 2009 10:51

Eclipse User

This is a limitation of JPQL.

See,

https://bugs.eclipse.org/bugs/show_bug.cgi?id=219814

As a workaround you can use a EclipseLink Expression query, or a native SQL query.

Re: case insensitive "order by" [message #496444 is a reply to message #496290]

Tue, 10 November 2009 01:52

Eclipse User

Hello James,

Thank you very much for your response.

But I have doubt, when we can achieve it through Expression api, why we can't achieve it through JPQL. I believe JPQL implementation for EclipseLink is developed by EclipseLink only and API development is also done by same.

So, when we have some implementation, why we can't reuse it for JPQL.

This question is just for curiosity. I definitely feel, there will be some constraints in doing it. I just want to know about those constraints.

Ashish

Re: case insensitive "order by" [message #497134 is a reply to message #496212]

Thu, 12 November 2009 10:24

Eclipse User

There is no reason why this could not be supported in JPQL, please vote for the bug.

Previous Topic:	EclipseLink persistance.xml Tomcat OSGI
Next Topic:	@ReturnInsert(returnOnly=true) not working with PostgreSQL

Goto Forum:

-=] Back to Top [=-

Current Time: Wed Jul 23 01:43:43 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter