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/[email protected]/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]
