Hi, I guess what I have not mentioned so far is that you cannot use stored procedures for create/update statements with Castor JDO, only for load statements. I guess I should have mentioned this earlier.
Regards Werner Guttmann madhavi latha wrote: > 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] > ------------------------------------------------- > > ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
