Hello,
I am designing a 3-tier, web-based intranet application for my client. It's going to be a WebSphere portal app with
Struts, running on Oracle 8.1.7.
One of the requirements is to implement the business logic in the back-end (PL/SQL), not in
Java (although that is what I'm used to do). The reason probably has something to do with fear of performance issues ("the more code runs in Oracle, the faster") and resource planning ("more people here know Oracle better than Java").
This unusual (?) choice in my humble opinion leaves me with two major issues; how to cache database results and how to perform the O/R mapping.
I know how to use CallableStatements and
JDBC, but I'd really like to avoid such a solution now we have
EJB 2.1 and Hibernate and everything. And without caching as done by any sensible app server I fear performance issues.
Does anyone know a tool that can perhaps generate Java code and performs the O/R mapping? Or a tool that avoids me having to implement up to a hundred (!) CallableStements and ResultSet-To-JavaBean mappings. I've seen Apache's commons-dbutils that seems to do this.
Does anyone have experience with business logic in PL/SQL and calling procedures from Java? Is performance really an issue here?
Thanks in advance for any input,
regards,
Bram Rooijmans