Hi Luciano, I have now created https://issues.apache.org/jira/browse/TUSCANY-904 and have same attachments with proper license option selected. Thanks for pointing this out.
I am not using the JIRA-876 for this work as its name is misleading. Went through the patch at JIRA-898 and could see lot of common places where we can work together or I can get your suggestions for the work items. Have a few comments for the code in JIRA-898- -update command support using DAS is a bit different than for other commands where it uses SDO and not Command. -Also, a stored procedure can have IN and OUT params, so it may be essential to supply position and value of any param (like a Map, instead of Vector) Will you please review the attachment in JIRA-904 and give me your comments? Also, would like to know what timezone you are in and what time/date will be best for you to have an IRC chat. Please let me know so we can discuss together. Also, would like to get a view from Kevin Williams. If we three can chat together, it will be really very helpful. Regards, Amita On 11/6/06, Luciano Resende <[EMAIL PROTECTED]> wrote:
Also, I noticed your attachments does not grant ASF license to use the code, you need to check when uploading the attachments in order for us to be able to use that in Apache. - Luciano On 11/6/06, Luciano Resende <[EMAIL PROTECTED]> wrote: > > I tought you were going to use the JIRA you created for this ? > - https://issues.apache.org/jira/browse/TUSCANY-876 > > I was planning to introduce a sample das service and a client using > - https://issues.apache.org/jira/browse/TUSCANY-898 > > Do you want to post your patches back to Tuscany-876 ? > > - Luciano > > On 11/6/06, Amita Vadhavkar <[EMAIL PROTECTED]> wrote: > > > > Hi , > > I have attached code jar and doc today to > > https://issues.apache.org/jira/browse/TUSCANY-898 > > Here I am trying to follow the approach of implementing SCA container > > for DAS. > > > > Please go through same and provide feedback. > > > > Regards, > > Amita > > > > On 10/23/06, Amita Vadhavkar <[EMAIL PROTECTED]> wrote: > > > Yes, posting the question about spec as a separate mail. > > > > > > I am out of town for 4-5 days for some urgent personal work. > > > Will continue working on this after I return. > > > > > > Regards, > > > Amita > > > > > > On 10/21/06, Luciano Resende < [EMAIL PROTECTED]> wrote: > > > > You could probably also post your questions about the SCA specs on > > this > > > > forum, as couple people here participate on the SCA spec group. > > > > > > > > - Luciano > > > > > > > > On 10/21/06, Amita Vadhavkar <[EMAIL PROTECTED]> wrote: > > > > > > > > > > Hi, > > > > > I am working actively on the container part. Apart from that have > > > > > developed > > > > > a sample > > > > > based on the discussion going on in thread > > > > > http://www.mail-archive.com/tuscany-dev@ws.apache.org/msg09999.html > > . and > > > > > have asked for feedback using the same > > > > > thread(sample attached). In this DAS is exposed as a service with > > > support > > > > > for > > > > > execute(), but can be extended.Please have a look and give > > feedback. > > > > > > > > > > Also, for reaching the spec people to find out what are the > > existing > > > > > things > > > > > for the > > > > > binding support for refering to stored procedure using SCA, have > > asked > > > > > questions > > > > > in feedback on OSOA site. Is there any other way? > > > > > > > > > > Regards, > > > > > Amita > > > > > > > > > > On 10/19/06, Amita Vadhavkar < [EMAIL PROTECTED]> wrote: > > > > > > > > > > > > Hi Kevin, > > > > > > Yes, I did go through that discussion. > > > > > > As the first step, I am trying for the stored procedure > > > implementation. > > > > > > But definitely the bigger goal is the complete clean > > integration. > > > > > > Have created > > JIRAhttps://issues.apache.org/jira/browse/TUSCANY-876 > > > > > > for this specific item. We can link it to the wish list JIRA > > > > > > http://issues.apache.org/jira/browse/TUSCANY-864. > > > > > > > > > > > > Will check with you for any specifics on DAS, as and when I > > come > > > across > > > > > > any problems. > > > > > > > > > > > > Thank you. > > > > > > Amita > > > > > > > > > > > > On 10/18/06, Kevin Williams < [EMAIL PROTECTED] > wrote: > > > > > > > > > > > > > > Hello Amita, > > > > > > > > > > > > > > A clean integration between RDB DAS and SCA is a very > > important and > > > > > the > > > > > > > DAS team is ready to help. I want to make sure you have seen > > this > > > > > > > discussion: > > > > > > > > > > > > > > > > > > > > > > > > > > http://mail-archives.apache.org/mod_mbox/ws-tuscany-dev/200610.mbox/[EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > Thanks. > > > > > > > > > > > > > > --Kevin > > > > > > > > > > > > > > > > > > > > > Amita Vadhavkar wrote: > > > > > > > > > > > > > > > Thanks a lot Ant. I am going through this and also have a > > few > > > > > > > quesitons. > > > > > > > > > > > > > > > > There is a JIRA > > > > http://issues.apache.org/jira/browse/TUSCANY-864which > > > > > > > is > > > > > > > > in wish list for DAS and SCA integration. Shall we use the > > same > > > for > > > > > > > > any work > > > > > > > > on the > > > > > > > > current topic or have a specific JIRA for the JDBC stored > > > procedure > > > > > > > > container using DAS. > > > > > > > > > > > > > > > > Also, > > > > > > > > The SCA assembly model spec talks about > > > > > > > > A composite reference can be used to access db stored > > procedure - > > > > > will > > > > > > > > you > > > > > > > > please provide some details. > > > > > > > > > > > > > > > > And, > > > > > > > > How extensibility mechanism is supported in SCA, some > > pointers for > > > > > > > this. > > > > > > > > > > > > > > > > Regards, > > > > > > > > Amita > > > > > > > > > > > > > > > > On 10/18/06, ant elder < [EMAIL PROTECTED]> wrote: > > > > > > > > > > > > > > > >> > > > > > > > >> Thats really great you'd like to look at this Amita. I > > don't know > > > > > how > > > > > > > >> much > > > > > > > >> you've already looked at this or Tuscany so I'm going to > > give > > > some > > > > > > > >> pointers > > > > > > > >> about how I'd approach this. > > > > > > > >> > > > > > > > >> There's two parts you need to do, how to use DAS to call > > stored > > > > > > > >> procedures, > > > > > > > >> and how to plug that DAS code into Tuscany. > > > > > > > >> > > > > > > > >> The DAS function is described at > > > > > > > >> > > http://wiki.apache.org/ws/WorkingWithStoredProcedures#preview > > > > > > > >> > > > > > > > >> There's a DAS testcase that uses stored procedures: > > > > > > > >> > > > > > > > >> > > > > > > > > > > > > > > > > > > > > > https://svn.apache.org/repos/asf/incubator/tuscany/java/das/rdb/src/test/java/org/apache/tuscany/das/rdb/test/StoredProcs.java > > > > > > > >> > > > > > > > >> > > > > > > > >> Based on that I guess you should try to write a simple > > function > > > > > that > > > > > > > >> invokes > > > > > > > >> a stored procedure using DAS so you learn whats required to > > set > > > > > > > >> things up > > > > > > > >> and do the invoke, how to configure DAS pragmatically, and > > all > > > the > > > > > > > >> dependencies it requires etc. > > > > > > > >> > > > > > > > >> Early on I'd make a sample to use as a functional test so > > you > > > know > > > > > > > what > > > > > > > >> you're trying to get to work, something like: > > > > > > > >> > > > > > > > >> > > > > > > > > > > > > > > > > > > > https://svn.apache.org/repos/asf/incubator/tuscany/java/samples/sca/helloworldJavaScript/ > > > > > > > > > >> > > > > > > > >> , > > > > > > > >> or any of the other samples in java/samples/sca. Based on > > that > > > you > > > > > > > >> need to > > > > > > > >> come up with a new SCDL implementation element for > > describing the > > > > > > > stored > > > > > > > >> procedure. We use helloworld or calculator samples for a > > lot of > > > > > > > things, > > > > > > > >> initially it may be easiest to do something close to what > > the DAS > > > > > > > >> tests do > > > > > > > >> eg, GETNAMEDCOMPANY. The Javascript helloworld sample is > > here: > > > > > > > >> > > > > > > > >> > > > > > > > > > > > > > > > > > > > > > https://svn.apache.org/repos/asf/incubator/tuscany/java/samples/sca/helloworldJavaScript/src/main/resources/META-INF/sca/default.scdl > > > > > > > >> > > > > > > > >> > > > > > > > >> I wouldn't worry to much about the details of the scdl yet, > > just > > > > > get > > > > > > > >> something going and the final form can be discussed on the > > > mailing > > > > > > > list. > > > > > > > >> > > > > > > > >> To plug that into Tuscany you need to write a container, > > there's > > > > > some > > > > > > > >> existing ones at: > > > > > > > >> > > > > > > > >> > > > > > > > > > > > > > > https://svn.apache.org/repos/asf/incubator/tuscany/java/sca/services/containers/ > > > > > > > > > > > > > > >> > > > > > > > >> > > > > > > > >> (don't use the spring one as its a bit different to what > > you > > > want). > > > > > > > The > > > > > > > >> vast > > > > > > > >> majority of the code is boiler plate stuff you can just > > copy > > > > > > > unchanged > > > > > > > >> > > > > > > > >> So to start, copy one of those existing container projects, > > and > > > one > > > > > > > of > > > > > > > >> those > > > > > > > >> existing sample projects, rename everything so the names > > include > > > > > > > >> something > > > > > > > >> about das or rdb or stored procedures, don't worry about > > the > > > names > > > > > as > > > > > > > it > > > > > > > >> can > > > > > > > >> easily be refactored later, and then start trying to fit in > > your > > > > > DAS > > > > > > > >> code. > > > > > > > >> > > > > > > > >> Hope this is of some help, let us know how you get on or if > > you > > > get > > > > > > > >> stuck > > > > > > > >> anywhere. If you want to keep this in our svn as you > > develop it > > > > > open > > > > > > > a > > > > > > > >> JIRA > > > > > > > >> and attach files to it and we can put them in the sandbox. > > > > > > > >> > > > > > > > >> ...ant > > > > > > > >> > > > > > > > >> On 10/16/06, Amita Vadhavkar < [EMAIL PROTECTED]> > > wrote: > > > > > > > >> > > > > > > > > >> > Hi, > > > > > > > >> > > > > > > > > >> > I am new to Tuscany but am interested in looking into > > this > > > > > > > >> rightaway as > > > > > > > >> I > > > > > > > >> > have some time. I hope to be bugging you folks soon for > > help as > > > I > > > > > > > >> get to > > > > > > > >> > understand and do this. > > > > > > > >> > > > > > > > > >> > Regards, > > > > > > > >> > Amita > > > > > > > >> > > > > > > > > >> > On 10/16/06, ant elder < [EMAIL PROTECTED] > wrote: > > > > > > > >> > > > > > > > > > >> > > I was reviewing the DAS user guide and reading the > > section > > > > > about > > > > > > > >> using > > > > > > > >> > DAS > > > > > > > >> > > with stored procedures: > > > > > > > >> > > > > http://wiki.apache.org/ws/WorkingWithStoredProcedures#preview > > > , > > > > > > > and > > > > > > > >> > > wondered > > > > > > > >> > > wouldn't it be useful to have an SCA component > > implemented by > > > a > > > > > > > >> stored > > > > > > > >> > > procedure? How about implementing a container for this > > (not > > > for > > > > > > > >> M2 of > > > > > > > >> > > course). Using the DAS stored procedure capabilities > > would > > > make > > > > > > > >> > > implementing > > > > > > > >> > > this quite easy, and it would help get a bit more > > interaction > > > > > > > going > > > > > > > >> > > between > > > > > > > >> > > the SCA and DAS people. > > > > > > > >> > > > > > > > > > >> > > Any one interested in having a look at this? > > > > > > > >> > > > > > > > > > >> > > ...ant > > > > > > > >> > > > > > > > > > >> > > > > > > > > > >> > > > > > > > > >> > > > > > > > > >> > > > > > > > >> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > > > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > > > > For additional commands, e-mail: > > [EMAIL PROTECTED] > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > >
