Gert, Unfortunately, there is no information about the jdbc lightweight component on servicemix webpage. This component missed. I have no idea how to specify the dynamically the driver and the url of the jdbc database.
regards, Erik Gert Vanthienen wrote: > > Erik, > > > You basically have to start a new MessageExchange with the lwcontainer > JDBC Component service from within your @WebMethod. Have a look at the > section 'Accessing the JBI Bus' on > http://incubator.apache.org/servicemix/servicemix-jsr181.html for more > information on this... > > > Gert > > > Erik Allais wrote: >> Gert, >> >> I prefer keep my logic and dont expose this lightweight component as a >> WS. >> I need to know how i can send XML to this component in my @webmethod >> >> Regards, >> Erik >> >> >> >> Gert Vanthienen wrote: >>> Erik, >>> >>> >>> You don't call this component from your @WebMethod... >>> >>> You have to send an XML message to the component which contains an >>> <sql>SELECT id, name, phone FROM accounts;</sql> element. It will >>> execute the query it's been given... >>> >>> In response, it will give you an XML message that looks like this: >>> <sqlResult> >>> <row id="1" name="Jefke" phone="555-1234"/> >>> <row ... /> >>> ... >>> </sqlResult> >>> >>> If you want to expose it as a web service >>> - create an HTTP consumer endpoint for it which specified the WSDL >>> - translate your SOAP message to the required format for this component >>> >>> >>> Gert >>> >>> >>> Erik Allais wrote: >>>> After deploying this lightweight component. >>>> How can i call this component in my @webmethod (jsr-181)? >>>> >>>> Regards, >>>> Erik >>>> >>>> >>>> rabi wrote: >>>>> You do not use this in your jsr181 component. Rather you deploy it in >>>>> the lwcontainer( you have to create a lwcontainer su). >>>>> >>>>> Regards, >>>>> Rabi Mishra, >>>>> http://rabisblog.blogspot.com/ >>>>> c++; /* this makes c bigger but returns the old value */ >>>>> -----Original Message----- >>>>> From: Erik Allais [mailto:[EMAIL PROTECTED] >>>>> Sent: Tuesday, July 24, 2007 3:16 PM >>>>> To: [email protected] >>>>> Subject: RE: JDBC component still exist? >>>>> >>>>> >>>>> How can i use this component inside my webmethod (jsr-181) ? >>>>> >>>>> Regards, >>>>> Erik >>>>> >>>>> rabi wrote: >>>>>> org.apache.servicemix.components.jdbc.JdbcComponent >>>>>> >>>>>> Regards, >>>>>> Rabi Mishra, >>>>>> http://rabisblog.blogspot.com/ >>>>>> c++; /* this makes c bigger but returns the old value */ >>>>>> -----Original Message----- >>>>>> From: Erik Allais [mailto:[EMAIL PROTECTED] >>>>>> Sent: Tuesday, July 24, 2007 2:49 PM >>>>>> To: [email protected] >>>>>> Subject: RE: JDBC component still exist? >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> rabi wrote: >>>>>>> 1.There is one jdbc lightweight component (only for queries) which >>>>>>> you >>>>>>> can use if it suffices your requirement. >>>>>>> >>>>>>> >>>>>> Where can i find this lightweight component ??? >>>>>> >>>>>> Regards, >>>>>> Erik >>>>>> -- >>>>>> View this message in context: >>>>>> http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html >>>>>> #a >>>>>> 11759480 >>>>>> Sent from the ServiceMix - User mailing list archive at Nabble.com. >>>>>> >>>>>> >>>>>> >>>>>> The information contained in this electronic message and any >>>>>> attachments to this message are intended for the exclusive use of the >>>>>> addressee(s) and may contain proprietary, confidential or privileged >>>>>> information. If you are not the intended recipient, you should not >>>>>> disseminate, distribute or copy this e-mail. Please notify the sender >>>>>> immediately and destroy all copies of this message and any >>>>> attachments. >>>>>> WARNING: Computer viruses can be transmitted via email. The recipient >>>>>> should check this email and any attachments for the presence of >>>>> viruses. >>>>>> The company accepts no liability for any damage caused by any virus >>>>>> transmitted by this email. >>>>>> >>>>>> www.wipro.com >>>>>> >>>>>> >>>>> -- >>>>> View this message in context: >>>>> http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a >>>>> 11759784 >>>>> Sent from the ServiceMix - User mailing list archive at Nabble.com. >>>>> >>>>> >>>>> >>>>> The information contained in this electronic message and any >>>>> attachments >>>>> to this message are intended for the exclusive use of the addressee(s) >>>>> and >>>>> may contain proprietary, confidential or privileged information. If >>>>> you >>>>> are not the intended recipient, you should not disseminate, distribute >>>>> or >>>>> copy this e-mail. Please notify the sender immediately and destroy all >>>>> copies of this message and any attachments. >>>>> >>>>> WARNING: Computer viruses can be transmitted via email. The recipient >>>>> should check this email and any attachments for the presence of >>>>> viruses. >>>>> The company accepts no liability for any damage caused by any virus >>>>> transmitted by this email. >>>>> >>>>> www.wipro.com >>>>> >>>>> >>> >> > > -- View this message in context: http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a11762893 Sent from the ServiceMix - User mailing list archive at Nabble.com.
