You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@servicemix.apache.org by Erik Allais <er...@altervisions.com> on 2007/07/16 10:00:15 UTC
JDBC component still exist?
hi,
i want to send queries inside my webmethod (jsr181)
I dont see a component which could help me to access easily to my
database...
Must i implement myself the jdbc logic inside my webmethod or there a way
more elegant to do that.
Regards,
Erik
--
View this message in context: http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a11610682
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: JDBC component still exist?
Posted by Andrea Zoppello <zo...@tiscali.it>.
In spagic our open source integration platform based on servicemix
we've an adanced jdbc component where:
1) The query is a parameter of the endpoint, it's not in the message content
2) You can configure the endpoint with a parametric query and match the
query parameters on the input message with xpath expressions
3) Call stored procedure
You can find here:
http://forge.objectweb.org/projects/spagic/
Take a look at the spagic-components package.
Regards
Andrea Zoppello
Erik Allais ha scritto:
> hi,
> i want to send queries inside my webmethod (jsr181)
> I dont see a component which could help me to access easily to my
> database...
> Must i implement myself the jdbc logic inside my webmethod or there a way
> more elegant to do that.
>
> Regards,
>
> Erik
>
Re: JDBC component still exist?
Posted by Gert Vanthienen <ge...@skynet.be>.
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:erik.allais@altervisions.com]
>> Sent: Tuesday, July 24, 2007 3:16 PM
>> To: servicemix-users@geronimo.apache.org
>> 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:erik.allais@altervisions.com]
>>> Sent: Tuesday, July 24, 2007 2:49 PM
>>> To: servicemix-users@geronimo.apache.org
>>> 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
>>
>>
>
Re: JDBC component still exist?
Posted by Gert Vanthienen <ge...@skynet.be>.
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:erik.allais@altervisions.com]
>>>> Sent: Tuesday, July 24, 2007 3:16 PM
>>>> To: servicemix-users@geronimo.apache.org
>>>> 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:erik.allais@altervisions.com]
>>>>> Sent: Tuesday, July 24, 2007 2:49 PM
>>>>> To: servicemix-users@geronimo.apache.org
>>>>> 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
>>>>
>>>>
>>
>
Re: JDBC component still exist?
Posted by Erik Allais <er...@altervisions.com>.
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:erik.allais@altervisions.com]
>>>>> Sent: Tuesday, July 24, 2007 3:16 PM
>>>>> To: servicemix-users@geronimo.apache.org
>>>>> 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:erik.allais@altervisions.com]
>>>>>> Sent: Tuesday, July 24, 2007 2:49 PM
>>>>>> To: servicemix-users@geronimo.apache.org
>>>>>> 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.
Re: JDBC component still exist?
Posted by Erik Allais <er...@altervisions.com>.
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:erik.allais@altervisions.com]
>>> Sent: Tuesday, July 24, 2007 3:16 PM
>>> To: servicemix-users@geronimo.apache.org
>>> 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:erik.allais@altervisions.com]
>>>> Sent: Tuesday, July 24, 2007 2:49 PM
>>>> To: servicemix-users@geronimo.apache.org
>>>> 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#a11762462
Sent from the ServiceMix - User mailing list archive at Nabble.com.
RE: JDBC component still exist?
Posted by Erik Allais <er...@altervisions.com>.
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:erik.allais@altervisions.com]
> Sent: Tuesday, July 24, 2007 3:16 PM
> To: servicemix-users@geronimo.apache.org
> 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:erik.allais@altervisions.com]
>> Sent: Tuesday, July 24, 2007 2:49 PM
>> To: servicemix-users@geronimo.apache.org
>> 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#a11762133
Sent from the ServiceMix - User mailing list archive at Nabble.com.
RE: JDBC component still exist?
Posted by ra...@wipro.com.
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:erik.allais@altervisions.com]
Sent: Tuesday, July 24, 2007 3:16 PM
To: servicemix-users@geronimo.apache.org
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:erik.allais@altervisions.com]
> Sent: Tuesday, July 24, 2007 2:49 PM
> To: servicemix-users@geronimo.apache.org
> 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
RE: JDBC component still exist?
Posted by Erik Allais <er...@altervisions.com>.
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:erik.allais@altervisions.com]
> Sent: Tuesday, July 24, 2007 2:49 PM
> To: servicemix-users@geronimo.apache.org
> 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#a11759784
Sent from the ServiceMix - User mailing list archive at Nabble.com.
RE: JDBC component still exist?
Posted by ra...@wipro.com.
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:erik.allais@altervisions.com]
Sent: Tuesday, July 24, 2007 2:49 PM
To: servicemix-users@geronimo.apache.org
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
RE: JDBC component still exist?
Posted by Erik Allais <er...@altervisions.com>.
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#a11759480
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: JDBC component still exist?
Posted by Guillaume Nodet <gn...@gmail.com>.
On Dec 25, 2007 8:41 AM, Matteo Redaelli <ma...@libero.it> wrote:
>
> Ciao
>
> What to you think if IBM/IONA commiters of ServiceMix would put "their"
> new
> patches/components in a IBM/IONA repository instead of ServiceMix
> repository? Even if thery were LGPL, it would not be GOOD for ServiceMix
> project.
Note that the JDBC component that Andrea is talking about is not developped
(afaik) by IBM or IONA people but by Engineering, an Italian company.
Also, Apache projects must use the Apache License and LGPL is incompatible.
>
>
> I think that all projects that use ServiceMix and create some new (JBI)
> components (related to ServiceMix) that could be useful for everyone
> should
> donate/submit/commit the components to the parent project (ServiceMix)
> instead of sharing it in their own repository. THERE SHOULD BE ONLY ONE
> REPOSITORY FOR ALL JBI COMPONENTS FOR SERVICEMIX. It would be more
> useful/easier for USERS like me
It's not always possible, due to licensing problems (in addition to the IP
company / people may want to keep).
Anyway, for JDBC, you can also have a look at Camel support (
http://activemq.apache.org/camel/jdbc.html)
>
>
> Thanks
> Matteo
> http://www.redaelli.org/matteo/
>
>
>
>
> Andrea Zoppello-2 wrote:
> >
> >>Hi,
> >
> >>It's already released to community.
> >>It's open source licensed under LGPL. You can just take and use it.
> >
> >>Andrea Zoppello
> >
> >
> >>Andrea Zoppello
> > Erik Allais ha scritto:
> >> Why you dont released this BC to servicemix community directly?
> >> It might have some problem if servicemix change to a newer version
> >>
> >> Thanks for this informations, i will try to use this component.
> >>
> >> Regards,
> >> Erik
> >>
> >>
> >> Andrea Zoppello-2 wrote:
> >>
> >>> Hi,
> >>>
> >>> Spagic is composed of:
> >>>
> >>> 1) A service manager distribution. It's a full smx 3.1 distribution
> with
> >>> the following additions:
> >>>
> >>> - Some patches to existing component to propagate informations for
> >>> monitoring
> >>> - Some new components ( like "jdbc poller (BC)" and advanced jdbc
> >>> component ( Lightweight SE ) and others )
> >>> - Spagic Listeners preconfigured to monitor process
> >>>
> >>> 2) The metadb model. Where all static and dynaimc informations about
> >>> process and process execution will be
> >>> stored.
> >>>
> >>> 3) Spagic Studio. ( An enhanced and tottaly reviewed version of
> cimero
> >>> to visually compose SA ).
> >>>
> >>> If you want you can take only the components and install on a clean
> >>> servicemix distribution.
> >>>
> >>> Here the instructions:
> >>>
> >>> - For the JDBC poller just download
> spagic-service-manager1.0.0-RC1.zip
> >>> <
> http://forge.objectweb.org/project/download.php?group_id=298&file_id=8566>
> >>> and unzip it the jdbcpoller is in
> >>> /SMX_HOME/install/servicemix-jdbc-3.1-incubating-installer.zip
> >>>
> >>> - The jdbc advanced components is lightweight component so you need
> only
> >>> t get the jar:
> >>>
> >>> /SMX_HOME/lib/optional/spagic-advanced-jdbc-1.0.0-RC1.jar
> >>>
> >>> You need to get in the classpath also commons-dbutils and the
> >>> dependencies. You can find all this jar
> >>> in spagic servicemanger distribution.
> >>>
> >>> If you look at the documentations in the Spagic Studio Components
> Guide
> >>> it's expalined how to use this components.
> >>> Andrea Zoppello
> >>>
> >>> Erik Allais ha scritto:
> >>>
> >>>> hi Gianfranco,
> >>>>
> >>>> There is a jbi for spagic to do a hot deploy or i must install spagic
> >>>> in
> >>>> front of servicemix.
> >>>>
> >>>> Regards,
> >>>> Erik
> >>>>
> >>>>
> >>>> Gianfranco Boccalon-2 wrote:
> >>>>
> >>>>
> >>>>> In the Spagic platform (based on ServiceMix) released on
> >>>>> http://forge.objectweb.org/ we released two different JDBC binding
> >>>>> components:
> >>>>> 1. The first one is a JDBC poller able to perform polling on a
> >>>>> database
> >>>>> table.
> >>>>> 2. The other is an advanced JDBC component able to call also stored
> >>>>> procedures.
> >>>>>
> >>>>> In the Spagic documentation you'll find the configuration for these
> >>>>> components.
> >>>>>
> >>>>> Regards
> >>>>> Gianfranco Boccalon
> >>>>>
> >>>>> rabi.mishra@wipro.com ha scritto:
> >>>>>
> >>>>>
> >>>>>> 1.There is one jdbc lightweight component (only for queries) which
> >>>>>> you
> >>>>>> can use if it suffices your requirement.
> >>>>>> 2. you can also write your own DbHelper class as explained by
> >>>>>> Guillaume
> >>>>>> at
> >>>>>>
> http://gnodet.blogspot.com/2007/06/accessing-databases-in-servicemix.htm
> >>>>>> l
> >>>>>>
> >>>>>> 3. I am presently working on a JDBC BC using Spring JDBC. Not sure
> >>>>>> when
> >>>>>> I will be able to finish it..
> >>>>>>
> >>>>>>
> >>>>>> Regards,
> >>>>>> Rabi Mishra,
> >>>>>> http://rabisblog.blogspot.com/
> >>>>>> c++; /* this makes c bigger but returns the old value */
> >>>>>> -----Original Message-----
> >>>>>> From: Erik Allais [mailto:erik.allais@altervisions.com]
> >>>>>> Sent: Monday, July 16, 2007 1:30 PM
> >>>>>> To: servicemix-users@geronimo.apache.org
> >>>>>> Subject: JDBC component still exist?
> >>>>>>
> >>>>>>
> >>>>>> hi,
> >>>>>> i want to send queries inside my webmethod (jsr181) I dont see a
> >>>>>> component which could help me to access easily to my database...
> >>>>>> Must i implement myself the jdbc logic inside my webmethod or there
> a
> >>>>>> way more elegant to do that.
> >>>>>>
> >>>>>> Regards,
> >>>>>>
> >>>>>> Erik
> >>>>>> --
> >>>>>> View this message in context:
> >>>>>>
> http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a
> >>>>>> 11610682
> >>>>>> 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--tp11610682s12049p14493687.html
> Sent from the ServiceMix - User mailing list archive at Nabble.com.
>
>
--
Cheers,
Guillaume Nodet
------------------------
Blog: http://gnodet.blogspot.com/
Re: JDBC component still exist?
Posted by Matteo Redaelli <ma...@libero.it>.
Ciao
What to you think if IBM/IONA commiters of ServiceMix would put "their" new
patches/components in a IBM/IONA repository instead of ServiceMix
repository? Even if thery were LGPL, it would not be GOOD for ServiceMix
project.
I think that all projects that use ServiceMix and create some new (JBI)
components (related to ServiceMix) that could be useful for everyone should
donate/submit/commit the components to the parent project (ServiceMix)
instead of sharing it in their own repository. THERE SHOULD BE ONLY ONE
REPOSITORY FOR ALL JBI COMPONENTS FOR SERVICEMIX. It would be more
useful/easier for USERS like me
Thanks
Matteo
http://www.redaelli.org/matteo/
Andrea Zoppello-2 wrote:
>
>>Hi,
>
>>It's already released to community.
>>It's open source licensed under LGPL. You can just take and use it.
>
>>Andrea Zoppello
>
>
>>Andrea Zoppello
> Erik Allais ha scritto:
>> Why you dont released this BC to servicemix community directly?
>> It might have some problem if servicemix change to a newer version
>>
>> Thanks for this informations, i will try to use this component.
>>
>> Regards,
>> Erik
>>
>>
>> Andrea Zoppello-2 wrote:
>>
>>> Hi,
>>>
>>> Spagic is composed of:
>>>
>>> 1) A service manager distribution. It's a full smx 3.1 distribution with
>>> the following additions:
>>>
>>> - Some patches to existing component to propagate informations for
>>> monitoring
>>> - Some new components ( like "jdbc poller (BC)" and advanced jdbc
>>> component ( Lightweight SE ) and others )
>>> - Spagic Listeners preconfigured to monitor process
>>>
>>> 2) The metadb model. Where all static and dynaimc informations about
>>> process and process execution will be
>>> stored.
>>>
>>> 3) Spagic Studio. ( An enhanced and tottaly reviewed version of cimero
>>> to visually compose SA ).
>>>
>>> If you want you can take only the components and install on a clean
>>> servicemix distribution.
>>>
>>> Here the instructions:
>>>
>>> - For the JDBC poller just download spagic-service-manager1.0.0-RC1.zip
>>> <http://forge.objectweb.org/project/download.php?group_id=298&file_id=8566>
>>> and unzip it the jdbcpoller is in
>>> /SMX_HOME/install/servicemix-jdbc-3.1-incubating-installer.zip
>>>
>>> - The jdbc advanced components is lightweight component so you need only
>>> t get the jar:
>>>
>>> /SMX_HOME/lib/optional/spagic-advanced-jdbc-1.0.0-RC1.jar
>>>
>>> You need to get in the classpath also commons-dbutils and the
>>> dependencies. You can find all this jar
>>> in spagic servicemanger distribution.
>>>
>>> If you look at the documentations in the Spagic Studio Components Guide
>>> it's expalined how to use this components.
>>> Andrea Zoppello
>>>
>>> Erik Allais ha scritto:
>>>
>>>> hi Gianfranco,
>>>>
>>>> There is a jbi for spagic to do a hot deploy or i must install spagic
>>>> in
>>>> front of servicemix.
>>>>
>>>> Regards,
>>>> Erik
>>>>
>>>>
>>>> Gianfranco Boccalon-2 wrote:
>>>>
>>>>
>>>>> In the Spagic platform (based on ServiceMix) released on
>>>>> http://forge.objectweb.org/ we released two different JDBC binding
>>>>> components:
>>>>> 1. The first one is a JDBC poller able to perform polling on a
>>>>> database
>>>>> table.
>>>>> 2. The other is an advanced JDBC component able to call also stored
>>>>> procedures.
>>>>>
>>>>> In the Spagic documentation you'll find the configuration for these
>>>>> components.
>>>>>
>>>>> Regards
>>>>> Gianfranco Boccalon
>>>>>
>>>>> rabi.mishra@wipro.com ha scritto:
>>>>>
>>>>>
>>>>>> 1.There is one jdbc lightweight component (only for queries) which
>>>>>> you
>>>>>> can use if it suffices your requirement.
>>>>>> 2. you can also write your own DbHelper class as explained by
>>>>>> Guillaume
>>>>>> at
>>>>>> http://gnodet.blogspot.com/2007/06/accessing-databases-in-servicemix.htm
>>>>>> l
>>>>>>
>>>>>> 3. I am presently working on a JDBC BC using Spring JDBC. Not sure
>>>>>> when
>>>>>> I will be able to finish it..
>>>>>>
>>>>>>
>>>>>> Regards,
>>>>>> Rabi Mishra,
>>>>>> http://rabisblog.blogspot.com/
>>>>>> c++; /* this makes c bigger but returns the old value */
>>>>>> -----Original Message-----
>>>>>> From: Erik Allais [mailto:erik.allais@altervisions.com]
>>>>>> Sent: Monday, July 16, 2007 1:30 PM
>>>>>> To: servicemix-users@geronimo.apache.org
>>>>>> Subject: JDBC component still exist?
>>>>>>
>>>>>>
>>>>>> hi,
>>>>>> i want to send queries inside my webmethod (jsr181) I dont see a
>>>>>> component which could help me to access easily to my database...
>>>>>> Must i implement myself the jdbc logic inside my webmethod or there a
>>>>>> way more elegant to do that.
>>>>>>
>>>>>> Regards,
>>>>>>
>>>>>> Erik
>>>>>> --
>>>>>> View this message in context:
>>>>>> http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a
>>>>>> 11610682
>>>>>> 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--tp11610682s12049p14493687.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: JDBC component still exist?
Posted by Andrea Zoppello <zo...@tiscali.it>.
Hi,
It's already released to community.
It's open source licensed under LGPL. You can just take and use it.
Andrea Zoppello
Andrea Zoppello
Erik Allais ha scritto:
> Why you dont released this BC to servicemix community directly?
> It might have some problem if servicemix change to a newer version
>
> Thanks for this informations, i will try to use this component.
>
> Regards,
> Erik
>
>
> Andrea Zoppello-2 wrote:
>
>> Hi,
>>
>> Spagic is composed of:
>>
>> 1) A service manager distribution. It's a full smx 3.1 distribution with
>> the following additions:
>>
>> - Some patches to existing component to propagate informations for
>> monitoring
>> - Some new components ( like "jdbc poller (BC)" and advanced jdbc
>> component ( Lightweight SE ) and others )
>> - Spagic Listeners preconfigured to monitor process
>>
>> 2) The metadb model. Where all static and dynaimc informations about
>> process and process execution will be
>> stored.
>>
>> 3) Spagic Studio. ( An enhanced and tottaly reviewed version of cimero
>> to visually compose SA ).
>>
>> If you want you can take only the components and install on a clean
>> servicemix distribution.
>>
>> Here the instructions:
>>
>> - For the JDBC poller just download spagic-service-manager1.0.0-RC1.zip
>> <http://forge.objectweb.org/project/download.php?group_id=298&file_id=8566>
>> and unzip it the jdbcpoller is in
>> /SMX_HOME/install/servicemix-jdbc-3.1-incubating-installer.zip
>>
>> - The jdbc advanced components is lightweight component so you need only
>> t get the jar:
>>
>> /SMX_HOME/lib/optional/spagic-advanced-jdbc-1.0.0-RC1.jar
>>
>> You need to get in the classpath also commons-dbutils and the
>> dependencies. You can find all this jar
>> in spagic servicemanger distribution.
>>
>> If you look at the documentations in the Spagic Studio Components Guide
>> it's expalined how to use this components.
>> Andrea Zoppello
>>
>> Erik Allais ha scritto:
>>
>>> hi Gianfranco,
>>>
>>> There is a jbi for spagic to do a hot deploy or i must install spagic in
>>> front of servicemix.
>>>
>>> Regards,
>>> Erik
>>>
>>>
>>> Gianfranco Boccalon-2 wrote:
>>>
>>>
>>>> In the Spagic platform (based on ServiceMix) released on
>>>> http://forge.objectweb.org/ we released two different JDBC binding
>>>> components:
>>>> 1. The first one is a JDBC poller able to perform polling on a database
>>>> table.
>>>> 2. The other is an advanced JDBC component able to call also stored
>>>> procedures.
>>>>
>>>> In the Spagic documentation you'll find the configuration for these
>>>> components.
>>>>
>>>> Regards
>>>> Gianfranco Boccalon
>>>>
>>>> rabi.mishra@wipro.com ha scritto:
>>>>
>>>>
>>>>> 1.There is one jdbc lightweight component (only for queries) which you
>>>>> can use if it suffices your requirement.
>>>>> 2. you can also write your own DbHelper class as explained by Guillaume
>>>>> at
>>>>> http://gnodet.blogspot.com/2007/06/accessing-databases-in-servicemix.htm
>>>>> l
>>>>>
>>>>> 3. I am presently working on a JDBC BC using Spring JDBC. Not sure when
>>>>> I will be able to finish it..
>>>>>
>>>>>
>>>>> Regards,
>>>>> Rabi Mishra,
>>>>> http://rabisblog.blogspot.com/
>>>>> c++; /* this makes c bigger but returns the old value */
>>>>> -----Original Message-----
>>>>> From: Erik Allais [mailto:erik.allais@altervisions.com]
>>>>> Sent: Monday, July 16, 2007 1:30 PM
>>>>> To: servicemix-users@geronimo.apache.org
>>>>> Subject: JDBC component still exist?
>>>>>
>>>>>
>>>>> hi,
>>>>> i want to send queries inside my webmethod (jsr181) I dont see a
>>>>> component which could help me to access easily to my database...
>>>>> Must i implement myself the jdbc logic inside my webmethod or there a
>>>>> way more elegant to do that.
>>>>>
>>>>> Regards,
>>>>>
>>>>> Erik
>>>>> --
>>>>> View this message in context:
>>>>> http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a
>>>>> 11610682
>>>>> 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
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
Re: JDBC component still exist?
Posted by Erik Allais <er...@altervisions.com>.
Why you dont released this BC to servicemix community directly?
It might have some problem if servicemix change to a newer version
Thanks for this informations, i will try to use this component.
Regards,
Erik
Andrea Zoppello-2 wrote:
>
> Hi,
>
> Spagic is composed of:
>
> 1) A service manager distribution. It's a full smx 3.1 distribution with
> the following additions:
>
> - Some patches to existing component to propagate informations for
> monitoring
> - Some new components ( like "jdbc poller (BC)" and advanced jdbc
> component ( Lightweight SE ) and others )
> - Spagic Listeners preconfigured to monitor process
>
> 2) The metadb model. Where all static and dynaimc informations about
> process and process execution will be
> stored.
>
> 3) Spagic Studio. ( An enhanced and tottaly reviewed version of cimero
> to visually compose SA ).
>
> If you want you can take only the components and install on a clean
> servicemix distribution.
>
> Here the instructions:
>
> - For the JDBC poller just download spagic-service-manager1.0.0-RC1.zip
> <http://forge.objectweb.org/project/download.php?group_id=298&file_id=8566>
> and unzip it the jdbcpoller is in
> /SMX_HOME/install/servicemix-jdbc-3.1-incubating-installer.zip
>
> - The jdbc advanced components is lightweight component so you need only
> t get the jar:
>
> /SMX_HOME/lib/optional/spagic-advanced-jdbc-1.0.0-RC1.jar
>
> You need to get in the classpath also commons-dbutils and the
> dependencies. You can find all this jar
> in spagic servicemanger distribution.
>
> If you look at the documentations in the Spagic Studio Components Guide
> it's expalined how to use this components.
> Andrea Zoppello
>
> Erik Allais ha scritto:
>> hi Gianfranco,
>>
>> There is a jbi for spagic to do a hot deploy or i must install spagic in
>> front of servicemix.
>>
>> Regards,
>> Erik
>>
>>
>> Gianfranco Boccalon-2 wrote:
>>
>>> In the Spagic platform (based on ServiceMix) released on
>>> http://forge.objectweb.org/ we released two different JDBC binding
>>> components:
>>> 1. The first one is a JDBC poller able to perform polling on a database
>>> table.
>>> 2. The other is an advanced JDBC component able to call also stored
>>> procedures.
>>>
>>> In the Spagic documentation you'll find the configuration for these
>>> components.
>>>
>>> Regards
>>> Gianfranco Boccalon
>>>
>>> rabi.mishra@wipro.com ha scritto:
>>>
>>>> 1.There is one jdbc lightweight component (only for queries) which you
>>>> can use if it suffices your requirement.
>>>> 2. you can also write your own DbHelper class as explained by Guillaume
>>>> at
>>>> http://gnodet.blogspot.com/2007/06/accessing-databases-in-servicemix.htm
>>>> l
>>>>
>>>> 3. I am presently working on a JDBC BC using Spring JDBC. Not sure when
>>>> I will be able to finish it..
>>>>
>>>>
>>>> Regards,
>>>> Rabi Mishra,
>>>> http://rabisblog.blogspot.com/
>>>> c++; /* this makes c bigger but returns the old value */
>>>> -----Original Message-----
>>>> From: Erik Allais [mailto:erik.allais@altervisions.com]
>>>> Sent: Monday, July 16, 2007 1:30 PM
>>>> To: servicemix-users@geronimo.apache.org
>>>> Subject: JDBC component still exist?
>>>>
>>>>
>>>> hi,
>>>> i want to send queries inside my webmethod (jsr181) I dont see a
>>>> component which could help me to access easily to my database...
>>>> Must i implement myself the jdbc logic inside my webmethod or there a
>>>> way more elegant to do that.
>>>>
>>>> Regards,
>>>>
>>>> Erik
>>>> --
>>>> View this message in context:
>>>> http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a
>>>> 11610682
>>>> 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#a11621441
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: JDBC component still exist?
Posted by Andrea Zoppello <zo...@tiscali.it>.
Hi,
Try to take a look at the Spagic Components Guide??
there are some examples.
Andrea
Erik Allais ha scritto:
> hi,
> Where can i find some tutorial to make my own SA with jdbc support?
>
> Regards,
> Erik
>
>
> Andrea Zoppello-2 wrote:
>
>> Yes right,
>>
>> But this is referred to the JDBC Poller Binding component. If you need
>> the service engine
>> you must take the file spagic-advanced-jdbc-1.0.0-RC1.jar under
>> SMX_HOME/lib/optional.
>>
>> Andrea Zoppello
>> Erik Allais ha scritto:
>>
>>> Andrea Zoppello-2 wrote:
>>>
>>>
>>>> Here the instructions:
>>>>
>>>> - For the JDBC poller just download spagic-service-manager1.0.0-RC1.zip
>>>> <http://forge.objectweb.org/project/download.php?group_id=298&file_id=8566>
>>>> and unzip it the jdbcpoller is in
>>>> /SMX_HOME/install/servicemix-jdbc-3.1-incubating-installer.zip
>>>>
>>>>
>>>>
>>>>
>>> Do you mean spagic-jdbc-1.0.0-RC1-incubating-installer.zip file?
>>>
>>>
>>>
>>>
>>
>>
>
>
Re: JDBC component still exist?
Posted by Erik Allais <er...@altervisions.com>.
hi,
I read somewhere that a webservice which call another webservice isn't
loosing coupling.
I try to respect as much as possible the SOA principle
Regards,
Erik
Andrea Zoppello-2 wrote:
>
> There are not problem with your concept, but in my point of view it's
> not the
> right way to work with a great product like smx.
>
> If you need only to do a webservice that make a query and return a
> response maybe you
> must consider to write simple a java webservices with jdbc logic inside.
>
> You don't need smx to do that.
>
> For me the use of an "esb integration products" like smx, fits if you've
> need
> to define process as composition orchestration of reusable services.
>
> The power of binding components is to bound the same business logic to
> different protocols
> channels.
>
> Regards
> Andrea Zoppello
>
>
>
> Erik Allais ha scritto:
>> Hi andrea,
>>
>>
>> Andrea Zoppello-2 wrote:
>>
>>> By the way if you think to write db code inside webmethod this code will
>>> be only usable with
>>> webservices.
>>>
>>> If you think in term of reusable services, your jdbc services will be
>>> usable for example with a JMS input
>>> or other supported binding component
>>>
>>>
>>>
>>
>> I dont want to reuse the access to my DB, I only want to access with
>> webservice...
>> Do you think there is a problem in my conception?
>> Do you think is better to make a reuse component to access to my
>> database?
>>
>> Regards,
>> Erik
>>
>
>
>
--
View this message in context: http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a11664367
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: JDBC component still exist?
Posted by Andrea Zoppello <zo...@tiscali.it>.
There are not problem with your concept, but in my point of view it's
not the
right way to work with a great product like smx.
If you need only to do a webservice that make a query and return a
response maybe you
must consider to write simple a java webservices with jdbc logic inside.
You don't need smx to do that.
For me the use of an "esb integration products" like smx, fits if you've
need
to define process as composition orchestration of reusable services.
The power of binding components is to bound the same business logic to
different protocols
channels.
Regards
Andrea Zoppello
Erik Allais ha scritto:
> Hi andrea,
>
>
> Andrea Zoppello-2 wrote:
>
>> By the way if you think to write db code inside webmethod this code will
>> be only usable with
>> webservices.
>>
>> If you think in term of reusable services, your jdbc services will be
>> usable for example with a JMS input
>> or other supported binding component
>>
>>
>>
>
> I dont want to reuse the access to my DB, I only want to access with
> webservice...
> Do you think there is a problem in my conception?
> Do you think is better to make a reuse component to access to my database?
>
> Regards,
> Erik
>
Re: JDBC component still exist?
Posted by Erik Allais <er...@altervisions.com>.
Hi andrea,
Andrea Zoppello-2 wrote:
>
>
> By the way if you think to write db code inside webmethod this code will
> be only usable with
> webservices.
>
> If you think in term of reusable services, your jdbc services will be
> usable for example with a JMS input
> or other supported binding component
>
>
I dont want to reuse the access to my DB, I only want to access with
webservice...
Do you think there is a problem in my conception?
Do you think is better to make a reuse component to access to my database?
Regards,
Erik
--
View this message in context: http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a11649506
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: JDBC component still exist?
Posted by Andrea Zoppello <zo...@tiscali.it>.
Hi,
I don't understand why you think that spagic jdbc will not work in
feature???
If you look at the code:
- the jdbc poller component is a standard binding component
- the jdbc service engine is implemented using the lw-container but the
code can esailiy be ported to use
servicemix-bean.
By the way if you think to write db code inside webmethod this code will
be only usable with
webservices.
If you think in term of reusable services, your jdbc services will be
usable for example with a JMS input
or other supported binding component
Regards
Andrea Zoppello
Erik Allais ha scritto:
> Gert,
>
> My first idea was to add the necessary code to access the DB directly in my
> JSR-181 webmethod
> But i wonder if there is another way to do that...
> The JDBC component from spagic is great but i fear to use something that
> will not (maybe) work in the future...
>
> Regards,
> Erik
>
>
> Gert Vanthienen wrote:
>
>> Erik,
>>
>> Is your message flow something like...
>> HTTP/SOAP -> JSR-181 SU --> RDBMS
>>
>> If so, wouldn't it be an option to add the necessary code to access the
>> DB right there in your JSR-181 webmethod?
>>
>>
>> Gert
>>
>> Erik Allais wrote:
>>
>>> Gert,
>>>
>>> Can i use the logic implemented inside the servicemix-bean SU in my
>>> webmethod (jsr-181)
>>> My webservice must send query to my database
>>>
>>> Regards,
>>> Erik
>>>
>>>
>>> Gert Vanthienen wrote:
>>>
>>>> Erik,
>>>>
>>>>
>>>> If you just want to create a SA that is able to access a database with
>>>> JDBC, you can consider the use of a servicemix-bean SU, in which you can
>>>> just write Java code to handle a message exchange (using JDBC or
>>>> whatever Java technology you want). This would probably be the easiest
>>>> solution for you.
>>>>
>>>> You could also write your own JDBC SE, to add JDBC functionality to the
>>>> JBI container and afterwards build a SA that targets this new SE.
>>>> There is a tutorial on writing these on
>>>> http://incubator.apache.org/servicemix/hello-world-se.html, but be sure
>>>> to check out
>>>> http://incubator.apache.org/servicemix/should-i-create-my-own-jbi-components.html
>>>> first. BTW, this would be a very welcome addition to ServiceMix, so any
>>>> contributions would be appreciated...
>>>>
>>>>
>>>> Gert
>>>>
>>>>
>>>>
>>>> Erik Allais wrote:
>>>>
>>>>> hi,
>>>>> Where can i find some tutorial to make my own SA with jdbc support?
>>>>>
>>>>> Regards,
>>>>> Erik
>>>>>
>>>>>
>>>>> Andrea Zoppello-2 wrote:
>>>>>
>>>>>> Yes right,
>>>>>>
>>>>>> But this is referred to the JDBC Poller Binding component. If you need
>>>>>> the service engine
>>>>>> you must take the file spagic-advanced-jdbc-1.0.0-RC1.jar under
>>>>>> SMX_HOME/lib/optional.
>>>>>>
>>>>>> Andrea Zoppello
>>>>>> Erik Allais ha scritto:
>>>>>>
>>>>>>> Andrea Zoppello-2 wrote:
>>>>>>>
>>>>>>>
>>>>>>>> Here the instructions:
>>>>>>>>
>>>>>>>> - For the JDBC poller just download
>>>>>>>> spagic-service-manager1.0.0-RC1.zip
>>>>>>>> <http://forge.objectweb.org/project/download.php?group_id=298&file_id=8566>
>>>>>>>> and unzip it the jdbcpoller is in
>>>>>>>> /SMX_HOME/install/servicemix-jdbc-3.1-incubating-installer.zip
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>> Do you mean spagic-jdbc-1.0.0-RC1-incubating-installer.zip file?
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>
>
>
Re: JDBC component still exist?
Posted by Gert Vanthienen <ge...@skynet.be>.
Erik,
In theory, JBI was built for this: being able to use components from
different vendors together to build/integrate services. The source code
for the Spagic components is also available on-line.
On the other hand, if you want to avoid bringing in additional
components, it's perfectly fine to use your JSR-181 webmethod to access
the database. A POJO with JSR-181 annotations is available as a service
on the ESB, so you can always integrate it with other
transports/technologies if you need to. ServiceMix already has a fair
amount of JBI components and the list is growing with every release,
providing you with the flexibility that is required in business
application nowadays.
Gert
Erik Allais wrote:
> Gert,
>
> My first idea was to add the necessary code to access the DB directly in my
> JSR-181 webmethod
> But i wonder if there is another way to do that...
> The JDBC component from spagic is great but i fear to use something that
> will not (maybe) work in the future...
>
> Regards,
> Erik
>
>
> Gert Vanthienen wrote:
>
>> Erik,
>>
>> Is your message flow something like...
>> HTTP/SOAP -> JSR-181 SU --> RDBMS
>>
>> If so, wouldn't it be an option to add the necessary code to access the
>> DB right there in your JSR-181 webmethod?
>>
>>
>> Gert
>>
>> Erik Allais wrote:
>>
>>> Gert,
>>>
>>> Can i use the logic implemented inside the servicemix-bean SU in my
>>> webmethod (jsr-181)
>>> My webservice must send query to my database
>>>
>>> Regards,
>>> Erik
>>>
>>>
>>> Gert Vanthienen wrote:
>>>
>>>> Erik,
>>>>
>>>>
>>>> If you just want to create a SA that is able to access a database with
>>>> JDBC, you can consider the use of a servicemix-bean SU, in which you can
>>>> just write Java code to handle a message exchange (using JDBC or
>>>> whatever Java technology you want). This would probably be the easiest
>>>> solution for you.
>>>>
>>>> You could also write your own JDBC SE, to add JDBC functionality to the
>>>> JBI container and afterwards build a SA that targets this new SE.
>>>> There is a tutorial on writing these on
>>>> http://incubator.apache.org/servicemix/hello-world-se.html, but be sure
>>>> to check out
>>>> http://incubator.apache.org/servicemix/should-i-create-my-own-jbi-components.html
>>>> first. BTW, this would be a very welcome addition to ServiceMix, so any
>>>> contributions would be appreciated...
>>>>
>>>>
>>>> Gert
>>>>
>>>>
>>>>
>>>> Erik Allais wrote:
>>>>
>>>>> hi,
>>>>> Where can i find some tutorial to make my own SA with jdbc support?
>>>>>
>>>>> Regards,
>>>>> Erik
>>>>>
>>>>>
>>>>> Andrea Zoppello-2 wrote:
>>>>>
>>>>>> Yes right,
>>>>>>
>>>>>> But this is referred to the JDBC Poller Binding component. If you need
>>>>>> the service engine
>>>>>> you must take the file spagic-advanced-jdbc-1.0.0-RC1.jar under
>>>>>> SMX_HOME/lib/optional.
>>>>>>
>>>>>> Andrea Zoppello
>>>>>> Erik Allais ha scritto:
>>>>>>
>>>>>>> Andrea Zoppello-2 wrote:
>>>>>>>
>>>>>>>
>>>>>>>> Here the instructions:
>>>>>>>>
>>>>>>>> - For the JDBC poller just download
>>>>>>>> spagic-service-manager1.0.0-RC1.zip
>>>>>>>> <http://forge.objectweb.org/project/download.php?group_id=298&file_id=8566>
>>>>>>>> and unzip it the jdbcpoller is in
>>>>>>>> /SMX_HOME/install/servicemix-jdbc-3.1-incubating-installer.zip
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>> Do you mean spagic-jdbc-1.0.0-RC1-incubating-installer.zip file?
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>
>
>
Re: JDBC component still exist?
Posted by Erik Allais <er...@altervisions.com>.
Gert,
My first idea was to add the necessary code to access the DB directly in my
JSR-181 webmethod
But i wonder if there is another way to do that...
The JDBC component from spagic is great but i fear to use something that
will not (maybe) work in the future...
Regards,
Erik
Gert Vanthienen wrote:
>
> Erik,
>
> Is your message flow something like...
> HTTP/SOAP -> JSR-181 SU --> RDBMS
>
> If so, wouldn't it be an option to add the necessary code to access the
> DB right there in your JSR-181 webmethod?
>
>
> Gert
>
> Erik Allais wrote:
>> Gert,
>>
>> Can i use the logic implemented inside the servicemix-bean SU in my
>> webmethod (jsr-181)
>> My webservice must send query to my database
>>
>> Regards,
>> Erik
>>
>>
>> Gert Vanthienen wrote:
>>> Erik,
>>>
>>>
>>> If you just want to create a SA that is able to access a database with
>>> JDBC, you can consider the use of a servicemix-bean SU, in which you can
>>> just write Java code to handle a message exchange (using JDBC or
>>> whatever Java technology you want). This would probably be the easiest
>>> solution for you.
>>>
>>> You could also write your own JDBC SE, to add JDBC functionality to the
>>> JBI container and afterwards build a SA that targets this new SE.
>>> There is a tutorial on writing these on
>>> http://incubator.apache.org/servicemix/hello-world-se.html, but be sure
>>> to check out
>>> http://incubator.apache.org/servicemix/should-i-create-my-own-jbi-components.html
>>> first. BTW, this would be a very welcome addition to ServiceMix, so any
>>> contributions would be appreciated...
>>>
>>>
>>> Gert
>>>
>>>
>>>
>>> Erik Allais wrote:
>>>> hi,
>>>> Where can i find some tutorial to make my own SA with jdbc support?
>>>>
>>>> Regards,
>>>> Erik
>>>>
>>>>
>>>> Andrea Zoppello-2 wrote:
>>>>> Yes right,
>>>>>
>>>>> But this is referred to the JDBC Poller Binding component. If you need
>>>>> the service engine
>>>>> you must take the file spagic-advanced-jdbc-1.0.0-RC1.jar under
>>>>> SMX_HOME/lib/optional.
>>>>>
>>>>> Andrea Zoppello
>>>>> Erik Allais ha scritto:
>>>>>> Andrea Zoppello-2 wrote:
>>>>>>
>>>>>>> Here the instructions:
>>>>>>>
>>>>>>> - For the JDBC poller just download
>>>>>>> spagic-service-manager1.0.0-RC1.zip
>>>>>>> <http://forge.objectweb.org/project/download.php?group_id=298&file_id=8566>
>>>>>>> and unzip it the jdbcpoller is in
>>>>>>> /SMX_HOME/install/servicemix-jdbc-3.1-incubating-installer.zip
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>> Do you mean spagic-jdbc-1.0.0-RC1-incubating-installer.zip file?
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>
>>
>
>
--
View this message in context: http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a11646483
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: JDBC component still exist?
Posted by Gert Vanthienen <ge...@skynet.be>.
Erik,
Is your message flow something like...
HTTP/SOAP -> JSR-181 SU --> RDBMS
If so, wouldn't it be an option to add the necessary code to access the
DB right there in your JSR-181 webmethod?
Gert
Erik Allais wrote:
> Gert,
>
> Can i use the logic implemented inside the servicemix-bean SU in my
> webmethod (jsr-181)
> My webservice must send query to my database
>
> Regards,
> Erik
>
>
> Gert Vanthienen wrote:
>> Erik,
>>
>>
>> If you just want to create a SA that is able to access a database with
>> JDBC, you can consider the use of a servicemix-bean SU, in which you can
>> just write Java code to handle a message exchange (using JDBC or
>> whatever Java technology you want). This would probably be the easiest
>> solution for you.
>>
>> You could also write your own JDBC SE, to add JDBC functionality to the
>> JBI container and afterwards build a SA that targets this new SE.
>> There is a tutorial on writing these on
>> http://incubator.apache.org/servicemix/hello-world-se.html, but be sure
>> to check out
>> http://incubator.apache.org/servicemix/should-i-create-my-own-jbi-components.html
>> first. BTW, this would be a very welcome addition to ServiceMix, so any
>> contributions would be appreciated...
>>
>>
>> Gert
>>
>>
>>
>> Erik Allais wrote:
>>> hi,
>>> Where can i find some tutorial to make my own SA with jdbc support?
>>>
>>> Regards,
>>> Erik
>>>
>>>
>>> Andrea Zoppello-2 wrote:
>>>> Yes right,
>>>>
>>>> But this is referred to the JDBC Poller Binding component. If you need
>>>> the service engine
>>>> you must take the file spagic-advanced-jdbc-1.0.0-RC1.jar under
>>>> SMX_HOME/lib/optional.
>>>>
>>>> Andrea Zoppello
>>>> Erik Allais ha scritto:
>>>>> Andrea Zoppello-2 wrote:
>>>>>
>>>>>> Here the instructions:
>>>>>>
>>>>>> - For the JDBC poller just download
>>>>>> spagic-service-manager1.0.0-RC1.zip
>>>>>> <http://forge.objectweb.org/project/download.php?group_id=298&file_id=8566>
>>>>>> and unzip it the jdbcpoller is in
>>>>>> /SMX_HOME/install/servicemix-jdbc-3.1-incubating-installer.zip
>>>>>>
>>>>>>
>>>>>>
>>>>> Do you mean spagic-jdbc-1.0.0-RC1-incubating-installer.zip file?
>>>>>
>>>>>
>>>>>
>>>>
>>
>
Re: JDBC component still exist?
Posted by Erik Allais <er...@altervisions.com>.
Gert,
Can i use the logic implemented inside the servicemix-bean SU in my
webmethod (jsr-181)
My webservice must send query to my database
Regards,
Erik
Gert Vanthienen wrote:
>
> Erik,
>
>
> If you just want to create a SA that is able to access a database with
> JDBC, you can consider the use of a servicemix-bean SU, in which you can
> just write Java code to handle a message exchange (using JDBC or
> whatever Java technology you want). This would probably be the easiest
> solution for you.
>
> You could also write your own JDBC SE, to add JDBC functionality to the
> JBI container and afterwards build a SA that targets this new SE.
> There is a tutorial on writing these on
> http://incubator.apache.org/servicemix/hello-world-se.html, but be sure
> to check out
> http://incubator.apache.org/servicemix/should-i-create-my-own-jbi-components.html
> first. BTW, this would be a very welcome addition to ServiceMix, so any
> contributions would be appreciated...
>
>
> Gert
>
>
>
> Erik Allais wrote:
>> hi,
>> Where can i find some tutorial to make my own SA with jdbc support?
>>
>> Regards,
>> Erik
>>
>>
>> Andrea Zoppello-2 wrote:
>>> Yes right,
>>>
>>> But this is referred to the JDBC Poller Binding component. If you need
>>> the service engine
>>> you must take the file spagic-advanced-jdbc-1.0.0-RC1.jar under
>>> SMX_HOME/lib/optional.
>>>
>>> Andrea Zoppello
>>> Erik Allais ha scritto:
>>>> Andrea Zoppello-2 wrote:
>>>>
>>>>> Here the instructions:
>>>>>
>>>>> - For the JDBC poller just download
>>>>> spagic-service-manager1.0.0-RC1.zip
>>>>> <http://forge.objectweb.org/project/download.php?group_id=298&file_id=8566>
>>>>> and unzip it the jdbcpoller is in
>>>>> /SMX_HOME/install/servicemix-jdbc-3.1-incubating-installer.zip
>>>>>
>>>>>
>>>>>
>>>> Do you mean spagic-jdbc-1.0.0-RC1-incubating-installer.zip file?
>>>>
>>>>
>>>>
>>>
>>>
>>
>
>
--
View this message in context: http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a11646272
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: JDBC component still exist?
Posted by Gert Vanthienen <ge...@skynet.be>.
Erik,
If you just want to create a SA that is able to access a database with
JDBC, you can consider the use of a servicemix-bean SU, in which you can
just write Java code to handle a message exchange (using JDBC or
whatever Java technology you want). This would probably be the easiest
solution for you.
You could also write your own JDBC SE, to add JDBC functionality to the
JBI container and afterwards build a SA that targets this new SE.
There is a tutorial on writing these on
http://incubator.apache.org/servicemix/hello-world-se.html, but be sure
to check out
http://incubator.apache.org/servicemix/should-i-create-my-own-jbi-components.html
first. BTW, this would be a very welcome addition to ServiceMix, so any
contributions would be appreciated...
Gert
Erik Allais wrote:
> hi,
> Where can i find some tutorial to make my own SA with jdbc support?
>
> Regards,
> Erik
>
>
> Andrea Zoppello-2 wrote:
>> Yes right,
>>
>> But this is referred to the JDBC Poller Binding component. If you need
>> the service engine
>> you must take the file spagic-advanced-jdbc-1.0.0-RC1.jar under
>> SMX_HOME/lib/optional.
>>
>> Andrea Zoppello
>> Erik Allais ha scritto:
>>> Andrea Zoppello-2 wrote:
>>>
>>>> Here the instructions:
>>>>
>>>> - For the JDBC poller just download spagic-service-manager1.0.0-RC1.zip
>>>> <http://forge.objectweb.org/project/download.php?group_id=298&file_id=8566>
>>>> and unzip it the jdbcpoller is in
>>>> /SMX_HOME/install/servicemix-jdbc-3.1-incubating-installer.zip
>>>>
>>>>
>>>>
>>> Do you mean spagic-jdbc-1.0.0-RC1-incubating-installer.zip file?
>>>
>>>
>>>
>>
>>
>
Re: JDBC component still exist?
Posted by Erik Allais <er...@altervisions.com>.
hi,
Where can i find some tutorial to make my own SA with jdbc support?
Regards,
Erik
Andrea Zoppello-2 wrote:
>
> Yes right,
>
> But this is referred to the JDBC Poller Binding component. If you need
> the service engine
> you must take the file spagic-advanced-jdbc-1.0.0-RC1.jar under
> SMX_HOME/lib/optional.
>
> Andrea Zoppello
> Erik Allais ha scritto:
>>
>> Andrea Zoppello-2 wrote:
>>
>>> Here the instructions:
>>>
>>> - For the JDBC poller just download spagic-service-manager1.0.0-RC1.zip
>>> <http://forge.objectweb.org/project/download.php?group_id=298&file_id=8566>
>>> and unzip it the jdbcpoller is in
>>> /SMX_HOME/install/servicemix-jdbc-3.1-incubating-installer.zip
>>>
>>>
>>>
>>
>> Do you mean spagic-jdbc-1.0.0-RC1-incubating-installer.zip file?
>>
>>
>>
>
>
>
--
View this message in context: http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a11645758
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: JDBC component still exist?
Posted by Andrea Zoppello <zo...@tiscali.it>.
Yes right,
But this is referred to the JDBC Poller Binding component. If you need
the service engine
you must take the file spagic-advanced-jdbc-1.0.0-RC1.jar under
SMX_HOME/lib/optional.
Andrea Zoppello
Erik Allais ha scritto:
>
> Andrea Zoppello-2 wrote:
>
>> Here the instructions:
>>
>> - For the JDBC poller just download spagic-service-manager1.0.0-RC1.zip
>> <http://forge.objectweb.org/project/download.php?group_id=298&file_id=8566>
>> and unzip it the jdbcpoller is in
>> /SMX_HOME/install/servicemix-jdbc-3.1-incubating-installer.zip
>>
>>
>>
>
> Do you mean spagic-jdbc-1.0.0-RC1-incubating-installer.zip file?
>
>
>
Re: JDBC component still exist?
Posted by Erik Allais <er...@altervisions.com>.
Andrea Zoppello-2 wrote:
>
>
> Here the instructions:
>
> - For the JDBC poller just download spagic-service-manager1.0.0-RC1.zip
> <http://forge.objectweb.org/project/download.php?group_id=298&file_id=8566>
> and unzip it the jdbcpoller is in
> /SMX_HOME/install/servicemix-jdbc-3.1-incubating-installer.zip
>
>
Do you mean spagic-jdbc-1.0.0-RC1-incubating-installer.zip file?
--
View this message in context: http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a11621822
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: JDBC component still exist?
Posted by Andrea Zoppello <zo...@tiscali.it>.
Hi,
Spagic is composed of:
1) A service manager distribution. It's a full smx 3.1 distribution with
the following additions:
- Some patches to existing component to propagate informations for
monitoring
- Some new components ( like "jdbc poller (BC)" and advanced jdbc
component ( Lightweight SE ) and others )
- Spagic Listeners preconfigured to monitor process
2) The metadb model. Where all static and dynaimc informations about
process and process execution will be
stored.
3) Spagic Studio. ( An enhanced and tottaly reviewed version of cimero
to visually compose SA ).
If you want you can take only the components and install on a clean
servicemix distribution.
Here the instructions:
- For the JDBC poller just download spagic-service-manager1.0.0-RC1.zip
<http://forge.objectweb.org/project/download.php?group_id=298&file_id=8566>
and unzip it the jdbcpoller is in
/SMX_HOME/install/servicemix-jdbc-3.1-incubating-installer.zip
- The jdbc advanced components is lightweight component so you need only
t get the jar:
/SMX_HOME/lib/optional/spagic-advanced-jdbc-1.0.0-RC1.jar
You need to get in the classpath also commons-dbutils and the
dependencies. You can find all this jar
in spagic servicemanger distribution.
If you look at the documentations in the Spagic Studio Components Guide
it's expalined how to use this components.
Andrea Zoppello
Erik Allais ha scritto:
> hi Gianfranco,
>
> There is a jbi for spagic to do a hot deploy or i must install spagic in
> front of servicemix.
>
> Regards,
> Erik
>
>
> Gianfranco Boccalon-2 wrote:
>
>> In the Spagic platform (based on ServiceMix) released on
>> http://forge.objectweb.org/ we released two different JDBC binding
>> components:
>> 1. The first one is a JDBC poller able to perform polling on a database
>> table.
>> 2. The other is an advanced JDBC component able to call also stored
>> procedures.
>>
>> In the Spagic documentation you'll find the configuration for these
>> components.
>>
>> Regards
>> Gianfranco Boccalon
>>
>> rabi.mishra@wipro.com ha scritto:
>>
>>> 1.There is one jdbc lightweight component (only for queries) which you
>>> can use if it suffices your requirement.
>>> 2. you can also write your own DbHelper class as explained by Guillaume
>>> at
>>> http://gnodet.blogspot.com/2007/06/accessing-databases-in-servicemix.htm
>>> l
>>>
>>> 3. I am presently working on a JDBC BC using Spring JDBC. Not sure when
>>> I will be able to finish it..
>>>
>>>
>>> Regards,
>>> Rabi Mishra,
>>> http://rabisblog.blogspot.com/
>>> c++; /* this makes c bigger but returns the old value */
>>> -----Original Message-----
>>> From: Erik Allais [mailto:erik.allais@altervisions.com]
>>> Sent: Monday, July 16, 2007 1:30 PM
>>> To: servicemix-users@geronimo.apache.org
>>> Subject: JDBC component still exist?
>>>
>>>
>>> hi,
>>> i want to send queries inside my webmethod (jsr181) I dont see a
>>> component which could help me to access easily to my database...
>>> Must i implement myself the jdbc logic inside my webmethod or there a
>>> way more elegant to do that.
>>>
>>> Regards,
>>>
>>> Erik
>>> --
>>> View this message in context:
>>> http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a
>>> 11610682
>>> 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
>>>
>>>
>>>
>>
>>
>
>
Re: JDBC component still exist?
Posted by Erik Allais <er...@altervisions.com>.
hi Gianfranco,
There is a jbi for spagic to do a hot deploy or i must install spagic in
front of servicemix.
Regards,
Erik
Gianfranco Boccalon-2 wrote:
>
> In the Spagic platform (based on ServiceMix) released on
> http://forge.objectweb.org/ we released two different JDBC binding
> components:
> 1. The first one is a JDBC poller able to perform polling on a database
> table.
> 2. The other is an advanced JDBC component able to call also stored
> procedures.
>
> In the Spagic documentation you'll find the configuration for these
> components.
>
> Regards
> Gianfranco Boccalon
>
> rabi.mishra@wipro.com ha scritto:
>> 1.There is one jdbc lightweight component (only for queries) which you
>> can use if it suffices your requirement.
>> 2. you can also write your own DbHelper class as explained by Guillaume
>> at
>> http://gnodet.blogspot.com/2007/06/accessing-databases-in-servicemix.htm
>> l
>>
>> 3. I am presently working on a JDBC BC using Spring JDBC. Not sure when
>> I will be able to finish it..
>>
>>
>> Regards,
>> Rabi Mishra,
>> http://rabisblog.blogspot.com/
>> c++; /* this makes c bigger but returns the old value */
>> -----Original Message-----
>> From: Erik Allais [mailto:erik.allais@altervisions.com]
>> Sent: Monday, July 16, 2007 1:30 PM
>> To: servicemix-users@geronimo.apache.org
>> Subject: JDBC component still exist?
>>
>>
>> hi,
>> i want to send queries inside my webmethod (jsr181) I dont see a
>> component which could help me to access easily to my database...
>> Must i implement myself the jdbc logic inside my webmethod or there a
>> way more elegant to do that.
>>
>> Regards,
>>
>> Erik
>> --
>> View this message in context:
>> http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a
>> 11610682
>> 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#a11620097
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: JDBC component still exist?
Posted by Gianfranco Boccalon <gb...@tiscali.it>.
In the Spagic platform (based on ServiceMix) released on
http://forge.objectweb.org/ we released two different JDBC binding
components:
1. The first one is a JDBC poller able to perform polling on a database
table.
2. The other is an advanced JDBC component able to call also stored
procedures.
In the Spagic documentation you'll find the configuration for these
components.
Regards
Gianfranco Boccalon
rabi.mishra@wipro.com ha scritto:
> 1.There is one jdbc lightweight component (only for queries) which you
> can use if it suffices your requirement.
> 2. you can also write your own DbHelper class as explained by Guillaume
> at
> http://gnodet.blogspot.com/2007/06/accessing-databases-in-servicemix.htm
> l
>
> 3. I am presently working on a JDBC BC using Spring JDBC. Not sure when
> I will be able to finish it..
>
>
> Regards,
> Rabi Mishra,
> http://rabisblog.blogspot.com/
> c++; /* this makes c bigger but returns the old value */
> -----Original Message-----
> From: Erik Allais [mailto:erik.allais@altervisions.com]
> Sent: Monday, July 16, 2007 1:30 PM
> To: servicemix-users@geronimo.apache.org
> Subject: JDBC component still exist?
>
>
> hi,
> i want to send queries inside my webmethod (jsr181) I dont see a
> component which could help me to access easily to my database...
> Must i implement myself the jdbc logic inside my webmethod or there a
> way more elegant to do that.
>
> Regards,
>
> Erik
> --
> View this message in context:
> http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a
> 11610682
> 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
>
>
RE: JDBC component still exist?
Posted by ra...@wipro.com.
1.There is one jdbc lightweight component (only for queries) which you
can use if it suffices your requirement.
2. you can also write your own DbHelper class as explained by Guillaume
at
http://gnodet.blogspot.com/2007/06/accessing-databases-in-servicemix.htm
l
3. I am presently working on a JDBC BC using Spring JDBC. Not sure when
I will be able to finish it..
Regards,
Rabi Mishra,
http://rabisblog.blogspot.com/
c++; /* this makes c bigger but returns the old value */
-----Original Message-----
From: Erik Allais [mailto:erik.allais@altervisions.com]
Sent: Monday, July 16, 2007 1:30 PM
To: servicemix-users@geronimo.apache.org
Subject: JDBC component still exist?
hi,
i want to send queries inside my webmethod (jsr181) I dont see a
component which could help me to access easily to my database...
Must i implement myself the jdbc logic inside my webmethod or there a
way more elegant to do that.
Regards,
Erik
--
View this message in context:
http://www.nabble.com/JDBC-component-still-exist--tf4085038s12049.html#a
11610682
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