File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
Author

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.
Prashanth
Lasse Koskela
author
Sheriff

Joined: Jan 23, 2002
Posts: 11962
    
    5
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: 8919

You will have to use BMP for using stored procedure.


Groovy
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Callling Stored Procedures from CMP