I'm using jboss TS 4.2.1 to perform transaction that includes JBoss cache and sybase DB. The database data source is defined as local resource. will Jboss TS use last resource commit optimization automatically in this case or should I add some special configuration in order for it to be supported ?
can I be certain that the transaction is atomic even though one of its participants is one phase aware ?



The sybase datasource definition:


<local-tx-datasource>


<jndi-name>jdbc/XXX</jndi-name>
<driver-class>com.sybase.jdbc2.jdbc.SybDataSource</driver-class>

......

</local-tx-datasource>