Thanks a lot for the reply Werner. I will work on it then. Thanks again Mad
--- Werner Guttmann <[EMAIL PROTECTED]> wrote: > Madhavi, > > Yes, you can, but for SELECT statements only. At the > moment, there's no support for using stored > procedures for insert/update statements (like > Hibernate does), but as far as I rememeber, there's > already a feature request asking for this feature to > be added to Castor JDO. Unfortunately, due to the > imminent 1.0 release (I'll be shipping 1.0M3 > tonight), this has been back-prioritized to some > degree. > > Having said that, you are always welcome to provide > us with a(n initial) patch as a donation .... ;-). > > I hope this clarifies some of your questions. > Thanks > Werner > > > -----Original Message----- > > From: madhavi latha [mailto:[EMAIL PROTECTED] > > Sent: Dienstag, 07. März 2006 15:28 > > To: dev@castor.codehaus.org > > Subject: Re: [castor-dev] Castor JDO & Stored > Procedures > > > > 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] > > > >> > ------------------------------------------------- > > > >> > === message truncated === __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com __________________________________________________ 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] -------------------------------------------------
