jQuery in Action, 3rd edition
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

Win a copy of REST with Spring (video course) this week in the Spring forum!
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: http://aspose.com/file-tools
subject: Callling Stored Procedures from CMP
It's not a secret anymore!