In the welcome post , it says that you guys are from ORACLE . We have been using Oracle well over 10 years now using different UIs . As the company progressed over the years , most of our BusinessLogic become very complex and were/are being written in ORacle Stored procedures. Now we are planning to move to thin client . My question is : In EJB 3.0 , is there anything that can map directly to a Procedure / package in a DB. I hope I am making myself clear .We do not directly insert into a Table because of complexity involved .
The first version of JPA does not currently provide any built-in support for stored procs, although it does not prevent vendors from supporting them as value add. TopLink does provide advanced stored proc support, so you could use the JPA for lots of your code and then revert to TopLink APIs for the stored proc support.