Hello Hibernate gurus,

I was wondering if Hibernate offers any support for regular expressions when performing database queries. Specifically, I would like to perform the following...

I have a table in my database that stores contact information and contains a field for a phone number (among other things). Say a user of the system would like to look up the information for a contact using a supplied phone number as the search criteria (e.g. 123-4567, 123.4567, 1234567). I would like to perform a query similar to the following using Hibernate but I am unsure of how to proceed (other than using a direct SQL query):

select * from contacts where phone_number regex '123[^0-9]*4567';

Direct support for regular expressions notwithstanding, is there a way to mimic regular expression support using either the Criteria or Query classes?

Thanks in advance,

Rodney

what is your database ?
hibernate support regex if your database support it - if database have exotic operators/functions
(similar oracle's regex_like) then hibernate doesn't support it, but you can add function in dialect

MySQL 5.0 is the database that will be used for this particular project.

i think taht mysql use regex in like clause

Actually, MySQL supports regex in the form of the example listed in the first post (or at least that's the form I'm familiar with if there happens to be more than one).

However, I'm gathering by the responses that Hibernate does not support them nor does it suggest a recommended approach to implement them outside of retrieving a java.sql.Connection and performing a database-specific query.

If I am incorrect in this assumption I would appreciate if someone could point me to a reference that would help clear things up.

Rod