Hibernate Community • View topic - Upper function in indexed columns

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Upper function in indexed columns

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

alexgv

Post subject: Upper function in indexed columns

Posted: Fri May 21, 2004 5:44 pm

Newbie

Joined: Fri May 21, 2004 5:33 pm
Posts: 4

Hello all...

When I use LIKE in a sql statement, the Hibernate create a query like this:
select <fields> from <table> where UPPER(<string field>) LIKE "string comparison";

When the string field is an indexed field, I lost the advantages of index, since changed field is not an indexed field.

Anyone can help me??? I need that DB2 work in Insensitve Case, and Hibernate do not generate that UPPER function.

Top

michael

Post subject:

Posted: Fri May 21, 2004 6:02 pm

Hibernate Team

Joined: Tue Sep 09, 2003 2:10 pm
Posts: 3246
Location: Passau, Germany

What is the code you use to generate that query?

Top

alexgv

Post subject:

Posted: Sat May 22, 2004 10:28 am

Newbie

Joined: Fri May 21, 2004 5:33 pm
Posts: 4

The code is generated by Hibernate when I add a filter like "name like 'Alex'", for example...

I found the my question's answer at IBM site...
http://www-106.ibm.com/developerworks/d ... mache.html

Thanks for your interesting.

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