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
[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
