Has anyone tried to deploy daytrader with SQL Server database, could anyone shed some light on the following issues:
1. How to support XA Transaction in SQL Server? There is not tranql connector for SQL Server.
2. Is there any specific settings for SQL Server? Daytrader thrown a lot of SQLException in both Direct (JDBC) mode and Full EJB3 mode.

Thanks a lot.