I would be tempted to push SOA one more level and have 3 web services.
1 for the application to call and one for each of the database services
to be called by the first service.
Using 2 databases in one service is not a web services question. You
just need to configure the 2 connectors and treat each one as if it was
there by itself.
We do this in one of our portlets with 1 (MySQL, Hibernate) database
that we own and 1 remote MS-SQL database that we need to write into at
the same time.
Nothing to do with CXF.
Ron
On 08/12/2010 2:34 AM, Edumudi Viswanath wrote:
Hi Guy,
Thanks for ur reply.
will u please provide the link/doc which you are talking abt?.
Regards
vishy
-----Original Message-----
From: Guy Pardon [mailto:[email protected]]
Sent: Tuesday, December 07, 2010 7:05 PM
To: [email protected]
Subject: Re: Insert data into 2 different databases& make it as a transaction
(WS-Atomic transaction)
Hi,
No, but the included jaxws sample is generic enough because it should work on
any jaxws stack.
Basically, you just need to configure:
-the interceptors (for transaction demarcation) on the outgoing and incoming
request chains (sender/receiver end), and
-the JDBC connectors as shown in our documentation or in the samples
HTH
Guy
On 7-dec-2010, at 14:09, Edumudi Viswanath wrote:
Thanks all.
Guy,
Is their any sample project available for cxf along with atomikos
TransactionsEssentialsR.
Regards
vishy
-----Original Message-----
From: Glen Mazza [mailto:[email protected]]
Sent: Monday, December 06, 2010 10:26 PM
To: [email protected]
Subject: Re: Insert data into 2 different databases& make it as a transaction
(WS-Atomic transaction)
Well, if it is one SOAP call which engenders the two INSERTs into
different data sources, this might not be a CXF question (i.e., the web
service provider handling would be the same regardless of the number of
inserts/data sources you're using), but rather something for the user's
list of whatever persistence technology you're using. This is simple
JDBC[1] for inserting into one data source, if that type of boilerplate
is what the original user is asking for.
Glen
[1] http://www.jroller.com/gmazza/entry/updating_database_tables_using_jaxws
On 12/06/2010 10:02 AM, Guy Pardon wrote:
Hi,
Check out http://www.atomikos.com/Main/ExtremeTransactions
It supports JTA/XA transactions and also WS transactions across services.
HTH
Guy
On 6-dec-2010, at 15:55, Edumudi Viswanath wrote:
Hi CXF users,
We have a requirement like below, which will be part of a project with CXF as
soap statck.
1) We should insert data into two different data sources& make it as a
transaction.
By exploring in google, we found that, there is no ready made sample project
available with cxf in java. Is it right?
Kindly throw some light on it& abt alternate ways to implement the same.
Regards
vishy