FYI,
I have created the SM-1864 concerning the servicemix-bean with database
backend sample.
Regards
JB
Jean-Baptiste Onofré wrote:
Hi Brad,
sure.
You can find the tutorial concerning how to deploy EJB inside SMX:
http://servicemix.apache.org/6-intermediate-using-ejb-inside-servicemix.html
I will add two new tutorials:
1/ how to make query on a database (oracle) using servicemix-bean component
2/ how to use camel inside SMX as a ETL (related to SM-1291)
Make my best to do it this morning (depending of my customer's
emergencies).
Regards
JB
[email protected] 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
