Hi,

Kind of new to Hibernate. Planning to use the latest HB3.

Here is the question:
I have a search form that searches the DB for people based on different information, including their last/first name. The user can specify last/first name % match, so that Oracle Soundex package can return names of people that "sound" the same to a certain % like the entry for first/last name. The data itself is very rarely changed. It's mostly there for users to browse. Occasionally, users do modify it though.

1) Can I use Hibernate to do this query even though it will be using an Oracle-specific package?

2) Does it make sense to use Hibernate for this? I was thinking to enable second-level cache for this to minimize hits to the database. (App requirements are for a pretty high load of users.)

Thanks,
Yaakov.