Hi Werner Guttmann, Thanks a lot for the reply.
I have one question on the following code. oql = _db.getOQLQuery( "CALL proc_check_permissions($,$) AS jdo.TestObject" ); I understand that here we are calling the proc_check_permissions stored procedure and the return value we are getting in jdo.TestObject. And we have the mapping of jdo.TestObject to a table test_table in the mapping.xml. I my case I do pass in the values to the stored procedure and stp returns 2 values which are just some status value and not a part of any table in db. So in my case jdo.TestObject class will have state1 and state2 as fields and I am not sure to which table shall I map it in the mapping.xml. And without mapping I get an exception : org.exolab.castor.jdo.QueryException: Could not find an engine supporting class Please suggest.Any help is appreciated Thanks in advance. Mad --- Werner Guttmann <[EMAIL PROTECTED]> wrote: > Hi Mad, > > the following link > > http://cvs.castor.codehaus.org/viewrep/castor/castor/src/tests/jdo/StoredProcedure.java?r=1.5 > > shows you a working example on how to call a stored > procedure. This > code, by the way, is taken from one of the existing > Castor JDO > functional tests in the src/tests directory. > > Regards > Werner Guttmann > > madhavi latha wrote: > > Hello All, > > > > I want to call the Stored Procedure from Castor > JDO > > but didn't find much help anywhere for the same. > > Please let me know if there is any documentation > or > > examples available.. > > > > In the castor site it says to use: > > oql = db.getOQLQuery("CALL sp_something($) AS > > myapp.Product"); > > > > Now I have IN and OUT parameters, do I need to > send > > all the IN parameters at ($) with comma... > > and receive the OUT parameters from myapp.Product > (or > > equivalent pojo file)... > > > > Any help is greatly Appreciated ... > > > > Thanks in advance!!! > > Mad > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > protection around > > http://mail.yahoo.com > > > > ------------------------------------------------- > > If you wish to unsubscribe from this list, please > > send an empty message to the following address: > > > > [EMAIL PROTECTED] > > ------------------------------------------------- > > > > > > > ------------------------------------------------- > If you wish to unsubscribe from this list, please > send an empty message to the following address: > > [EMAIL PROTECTED] > ------------------------------------------------- > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
