I'm working on a project that uses Spring. Data access is sometimes though Hibernate and sometimes through jdbc, and we use an Oracle 9i database .
I have some code that does extensive database access, and I imagine performance would improve if I could run that code as a Java stored procedure in Oracle. But a quick glance at Java stored procedures makes me think that it would be impossible to do so without a significant rewrite. That's because my Spring/j2ee code relies on the concept of a DataSource (either explicitly or implicity, via a HibernateSessionFactory), and I don't see that concept expressed in the small amount of Oracle documentation I've read. Stored procedures seem to rely instead on the less abstract and less flexible notion of Connection.
I hope I've simply missed something obvious. So I ask the forum, has anyone successfully run Spring enabled code inside an Oracle stored procedure? If so, could you point me to some documentation that would help me do this?