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








Reply via email to