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-864 which > 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] > >
