Configuring Sybase ASE for XA

SimpleDataSourceBean example

SimpleDataSourceBean ds = new SimpleDataSourceBean();
ds.setUniqueResourceName("ase");
ds.setXaDataSourceClassName("com.sybase.jdbc2.jdbc.SybXADataSource");
ds.setXaDataSourceProperties("user=java;password=java;serverName=localhost-ase;portNumber=5000");
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