I'm rewriting a codebase to use Spring and Hibernate 3. But there's a certain module of code that does a huge amount of database access, and I'm a little wary of migrating that module. That's because it's possible that code will be run in production as an Oracle stored procedure. (Oracle
version is 9i. JDK is 1.4.1.)


I know Oracle stored procedures require a public static method to kick them off, and I'm not worried about writing a simple wrapper to handle that. But I'm not sure how to get Spring/Hibernate code to find the connection provided by Oracle, and I'm not sure how the Oracle resolver will find the mapping files.

I don't want anyone to waste their time providing detailed instructions. I'm really just curious to know if anyone has tried to run Hibernate code in a stored procedure, and if the results were good.

-Chuck