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
