Re: Heterogenous distributed transactions (was RE: best way to refresh (copy) DB2 files to MySql(on windows))

["Charles Wilt" <charles.wilt@xxxxxxxxx>]

Yes JDBC supports distributed transactions using XA

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/topic/rzahh/jdbcxa.htm

Charles



On Tue, Jan 6, 2009 at 3:07 PM,  <lgoodbar@xxxxxxxxxxxxxx> wrote:
> Not strictly related to the OP, but how do distributed transactions work
> between different database engines (DB2 and MySQL as below, Oracle and
> SQL Server, etc.)? I presume DRDA is one way if all the platforms in the
> transaction support it. Does JDBC have distributed transaction support?
> (Obviously I'm not that familiar with JDBC.) I have used distributed
> transactions in SQL Server environments and it works pretty well.
>
> --Loyd
>
>
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Gerald
> Sent: Tuesday, January 06, 2009 1:48 PM
> To: midrange-l@xxxxxxxxxxxx
> Subject: best way to refresh (copy) DB2 files to MySql(on windows)
>
> 10 files need "refreshed" every night.
> I do have the JDBC stuff working on the system i,
> but was wondering if there was a better way to
> get the data into the MySQL database.
>
> Thanks...
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.