Configuring Sybase ASE for XA

22 Jul 2015 - 07:23 | Version 7 | | ,

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

Contact Us

Atomikos Corporate Headquarters
Hoveniersstraat, 39/1, 2800
Mechelen, Belgium

E info@atomikos.com
E sales@atomikos.com
T +3215613055

Subscribe to our newsletter

Never miss an update

Copyright 2016 Atomikos BVBA