Datum: Wed, 8 Nov 2006 02:36:22 -0800 (PST) Von: drvillo <f.vivoli_at_gmail.com>
> actually it seems it is more a xapool problem, I was reading also > http://forum.springframework.org/showthread.php?t=23056 > > it seems that xapool development is pretty stuck at the moment, > even if I managed to get rollback working with xapool-1.5. > nevertheless my confidence in this set up is pretty low at this point, > have you encountered any alternative to it in the meantime? Hello Francesco, I dropped XAPool completely from my setup. Not just because of its quality but especially because of the general problems of it with XA transactions. I found that comment [1] saying nearly the same as in the Spring thread. My solution is not to use Jencks's XAPoolDataSourceMCF, but my own extension of TranQL's AbstractXADataSourceMCF (let's call it MyXADataSourceMCF). Instead of passing an instance of XAPool's StandardXADataSource to the super constructor, I allow every UserPasswordXADataSource, which is an extension to XADataSource adding "String getUserName()" and "String getPassword()" just like TranQL's UserPasswordManagedConnectionFactory does it to ManagedConnectionFactory. Now MyXADataSourceMCF just implements both as following: public String getPassword() { return ((UserPasswordXADataSource)xaDataSource).getPassword(); } public String getUserName() { return ((UserPasswordXADataSource)xaDataSource).getUserName(); } Now I only need to provide extensions for the database specific XADataSource implementations, which can look like easy as the one for Derby: import org.apache.derby.jdbc.EmbeddedXADataSource; public class EmbeddedDerbyXADataSource extends EmbeddedXADataSource implements UserPasswordXADataSource { public String getUserName() { return getUser(); } } Hopefully those database specific XADataSource implementation handle XA transactions and so 2PC correctly ... Regards, Jörg [1] http://www.jroller.com/page/raible?entry=two_phase_commit_in_tomcat#comment11 -- Der GMX SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! Ideal für Modem und ISDN: http://www.gmx.net/de/go/smartsurfer --------------------------------------------------------------------- To unsubscribe from this list please visit: http://xircles.codehaus.org/manage_email
