You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@servicemix.apache.org by Brad_CSG <se...@freelance-it.com> on 2009/06/08 17:08:02 UTC
ServiceMix & Oracle
Just wondering if anyone has an example showing the end to end implementation
of creating a service in ServiceMix which is either (or both) a consumer or
provider service where the endpoint is an Oracle stored procedure or
function or even an SQL statement of some kind???
I am wanting to connect an Oracle database to our app via the ServiceMix
ESB, but have found very little in the way of sample documentation available
which demonstrates the configuration files required in order to establish
this connection. The most I've seen in terms of database connectivity is to
a MySQL database, and unfortunately that does not help - I would like to see
the configuration elements required to make a connection to an Oracle
database.
I am also interested to hear peoples points of view on the best method in
which to achieve this form of database connectivity.
Any/all assistance is greatly appreciated. Thanks in advance.
Brad
--
View this message in context: http://www.nabble.com/ServiceMix---Oracle-tp23925864p23925864.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.
Re: ServiceMix & Oracle
Posted by Jean-Baptiste Onofré <jb...@nanthrax.net>.
Hi Brad
I have made two things that use Oracle database as backend:
1/ I have a EJB deployed into an application server and that use a DAO
on Oracle. The EJB is used into SMX using CXF-SE.
2/ I have created a bean exposed using servicemix-bean. This bean uses a
DAO to execute a stored procedure inside Oracle.
Regards
JB
Brad_CSG wrote:
> Just wondering if anyone has an example showing the end to end implementation
> of creating a service in ServiceMix which is either (or both) a consumer or
> provider service where the endpoint is an Oracle stored procedure or
> function or even an SQL statement of some kind???
>
> I am wanting to connect an Oracle database to our app via the ServiceMix
> ESB, but have found very little in the way of sample documentation available
> which demonstrates the configuration files required in order to establish
> this connection. The most I've seen in terms of database connectivity is to
> a MySQL database, and unfortunately that does not help - I would like to see
> the configuration elements required to make a connection to an Oracle
> database.
>
> I am also interested to hear peoples points of view on the best method in
> which to achieve this form of database connectivity.
>
> Any/all assistance is greatly appreciated. Thanks in advance.
>
> Brad
Re: ServiceMix & Oracle
Posted by Jean-Baptiste Onofré <jb...@nanthrax.net>.
You're welcome Brad.
I haven't yet fully completed the sample but you have a starting point :)
Regards
JB
Brad_CSG wrote:
> Hi JB,
>
> Thanks very much for that...that's excellent!!! Exactly what I wanted!!!
>
> Cheers
> Brad
>
>
>
>
> Jean-Baptiste Onofré wrote:
>> I have commited first files of the datasbe-bean sample.
>>
>> You can see it:
>> http://svn.apache.org/repos/asf/servicemix/smx3/trunk/samples/database-bean/
>>
>> I will write the tutorial wiki and complete the sample tomorrow.
>>
>> Regards
>> JB
>>
>> servicemix@freelance-it.com wrote:
>>> Hi JB,
>>>
>>> Thanks for your quick reply. Would you be able to share with us the
>>> files that are used in the ServiceMix configuration which allows you to
>>> make your connection to Oracle please - so that there is a sample of how
>>> to do it. This is the area where I do not understand, that is, what
>>> configurations files are needed, and what should those config files
>>> contain.
>>>
>>> Thanks in advance.
>>>
>>> Brad
>>>
>>>
>>> Jean-Baptiste Onofré wrote:
>>>> Hi Brad
>>>>
>>>> I have made two things that use Oracle database as backend:
>>>> 1/ I have a EJB deployed into an application server and that use a DAO
>>>> on Oracle. The EJB is used into SMX using CXF-SE.
>>>> 2/ I have created a bean exposed using servicemix-bean. This bean uses a
>>>> DAO to execute a stored procedure inside Oracle.
>>>>
>>>> Regards
>>>> JB
>>>>
>>>> Brad_CSG wrote:
>>>>> Just wondering if anyone has an example showing the end to end
>>>>> implementation
>>>>> of creating a service in ServiceMix which is either (or both) a
>>>>> consumer
>>>>> or
>>>>> provider service where the endpoint is an Oracle stored procedure or
>>>>> function or even an SQL statement of some kind???
>>>>>
>>>>> I am wanting to connect an Oracle database to our app via the
>>>>> ServiceMix
>>>>> ESB, but have found very little in the way of sample documentation
>>>>> available
>>>>> which demonstrates the configuration files required in order to
>>>>> establish
>>>>> this connection. The most I've seen in terms of database connectivity
>>>>> is
>>>>> to
>>>>> a MySQL database, and unfortunately that does not help - I would like
>>>>> to
>>>>> see
>>>>> the configuration elements required to make a connection to an Oracle
>>>>> database.
>>>>>
>>>>> I am also interested to hear peoples points of view on the best method
>>>>> in
>>>>> which to achieve this form of database connectivity.
>>>>>
>>>>> Any/all assistance is greatly appreciated. Thanks in advance.
>>>>>
>>>>> Brad
>>> Quoted from:
>>> http://www.nabble.com/ServiceMix---Oracle-tp23925864p23926704.html
>>>
>>
>
Re: ServiceMix & Oracle
Posted by Brad_CSG <se...@freelance-it.com>.
Hi JB,
Thanks very much for that...that's excellent!!! Exactly what I wanted!!!
Cheers
Brad
Jean-Baptiste Onofré wrote:
>
> I have commited first files of the datasbe-bean sample.
>
> You can see it:
> http://svn.apache.org/repos/asf/servicemix/smx3/trunk/samples/database-bean/
>
> I will write the tutorial wiki and complete the sample tomorrow.
>
> Regards
> JB
>
> servicemix@freelance-it.com wrote:
>> Hi JB,
>>
>> Thanks for your quick reply. Would you be able to share with us the
>> files that are used in the ServiceMix configuration which allows you to
>> make your connection to Oracle please - so that there is a sample of how
>> to do it. This is the area where I do not understand, that is, what
>> configurations files are needed, and what should those config files
>> contain.
>>
>> Thanks in advance.
>>
>> Brad
>>
>>
>> Jean-Baptiste Onofré wrote:
>>> Hi Brad
>>>
>>> I have made two things that use Oracle database as backend:
>>> 1/ I have a EJB deployed into an application server and that use a DAO
>>> on Oracle. The EJB is used into SMX using CXF-SE.
>>> 2/ I have created a bean exposed using servicemix-bean. This bean uses a
>>> DAO to execute a stored procedure inside Oracle.
>>>
>>> Regards
>>> JB
>>>
>>> Brad_CSG wrote:
>>>> Just wondering if anyone has an example showing the end to end
>>>> implementation
>>>> of creating a service in ServiceMix which is either (or both) a
>>>> consumer
>>>> or
>>>> provider service where the endpoint is an Oracle stored procedure or
>>>> function or even an SQL statement of some kind???
>>>>
>>>> I am wanting to connect an Oracle database to our app via the
>>>> ServiceMix
>>>> ESB, but have found very little in the way of sample documentation
>>>> available
>>>> which demonstrates the configuration files required in order to
>>>> establish
>>>> this connection. The most I've seen in terms of database connectivity
>>>> is
>>>> to
>>>> a MySQL database, and unfortunately that does not help - I would like
>>>> to
>>>> see
>>>> the configuration elements required to make a connection to an Oracle
>>>> database.
>>>>
>>>> I am also interested to hear peoples points of view on the best method
>>>> in
>>>> which to achieve this form of database connectivity.
>>>>
>>>> Any/all assistance is greatly appreciated. Thanks in advance.
>>>>
>>>> Brad
>>>
>> Quoted from:
>> http://www.nabble.com/ServiceMix---Oracle-tp23925864p23926704.html
>>
>
>
--
View this message in context: http://www.nabble.com/ServiceMix---Oracle-tp23925864p23974392.html
Sent from the ServiceMix - User mailing list archive at Nabble.com.