Thanks Werner for the quick reply! Well I am working on a module which has a lot of existing stored procedures so I thought if I could call them then Castor-JDO would have been very neat aproach. So how can I solve this issue with castor JDO or do I have to use JDBC only. Could you please explain why we can't use castor for loading/update.Can I make any native calls using Castor JDO like the hibernate for using the existing stored procedure.. Please suggest.
Thanks in advance. Mad --- Werner Guttmann <[EMAIL PROTECTED]> wrote: > 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] > ------------------------------------------------- > > __________________________________________________ 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] -------------------------------------------------
