aspose file tools
The moose likes EJB and other Java EE Technologies and the fly likes EJB in DB  World ( specifically Oracle) Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Reply Bookmark "EJB in DB  World ( specifically Oracle)" Watch "EJB in DB  World ( specifically Oracle)" New topic
Author

EJB in DB World ( specifically Oracle)

Ram Gokul
Ranch Hand

Joined: Oct 07, 2005
Posts: 85
Dear Authors,

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 .

What approach will be best for us?

Thanks
Mike Keith
author
Ranch Hand

Joined: Jul 14, 2005
Posts: 304
Ram,

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.

-Mike


-Mike
Pro JPA 2: Mastering the Java Persistence API
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: EJB in DB World ( specifically Oracle)
 
Similar Threads
Can we call java program from a Oracle stored procedure?
How to store PPT in Server on Save instead of local machine ??
ejb's for multiple db
Business Logic in EJB3 SessionBean?
to stop unlocking an account from if failed attempts is more than 5 within 24hrs