File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes EJB and other Java EE Technologies and the fly likes Callling Stored Procedures from CMP Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "Callling Stored Procedures from CMP" Watch "Callling Stored Procedures from CMP" New topic

Callling Stored Procedures from CMP

Ram Pra
Ranch Hand

Joined: Feb 06, 2001
Posts: 37
Hello All,
We are facing a strange problem here in calling stored procedures from a CMP bean using TYPE $ drivers , the container throws an javax.ejb.ObjectNotFoundException.
We are using JRun3.1 and the same code works fine when used with JDBC-ODBC Bridge.
This happens only in the finder methods, the stored procedure calls from remove() and store() methods work fine.
Does anyone know the reason for this, i have tried using three type 4 drivers - JTurbo, INet Opta and Data Direct drivers.
All of these have the same problem.
Any insight on this would be much appreciated.
Thanks in advance.
Lasse Koskela

Joined: Jan 23, 2002
Posts: 11962
CMP stands for container managed persistence. You shouldn't be calling any stored procedures.

Author of Test Driven (2007) and Effective Unit Testing (2013) [Blog] [HowToAskQuestionsOnJavaRanch]
Pradeep bhatt
Ranch Hand

Joined: Feb 27, 2002
Posts: 8927

You will have to use BMP for using stored procedure.

I agree. Here's the link:
subject: Callling Stored Procedures from CMP
It's not a secret anymore!