Configuring Sybase ASE for XA

AtomikosDataSourceBean example

AtomikosDataSourceBean ds = new AtomikosDataSourceBean();
ds.setUniqueResourceName("ase");
ds.setXaDataSourceClassName("com.sybase.jdbc2.jdbc.SybXADataSource");
Properties p = new Properties();
p.setProperty ( "user" , "java" );
p.setProperty ( "password" , "java" );
p.setProperty ( "serverName" , "localhost-ase" );
p.setProperty ( "portNumber" , "5000" );
ds.setXaDataSourceProperties ( p );
ds.setConnectionPoolSize(5);

Notes

Sybase ASE 15 is known to be working with driver jConnect version 5.5. Version 12.5 should be fine as well but has not been tested so far.

XA support is handled by Distributed Transaction Manager (DTM) which must be manually enabled in the DB before it can be used:

sp_configure enable dtm;
sp_configure enable xact coordination;

Also see here: http://infocenter.sybase.com/help/topic/com.sybase.help.ase_15.0.dtm/html/dtm/dtm12.htm

-- LudovicOrban - 04 Nov 2007

spacer
Copyright © 2014 Atomikos BVBA. Transaction Management for Extreme Transaction Processing and SOA Environments serving ISV, Commercial, OEM and Open Source Markets
Site map RSS ATOM