Atomikos Forum

Hi,
I'm trying out Atomikos transactions essentials as a JTA implementation, to be used with Hibernate JMS and EHCache.
I've followed your "Tomcat 6 Integration with Atomikos 3.3+" tutorial and am having problems with MS-Sql server working with it. I was hoping someone has encountered this problem. The only changes I made, with respect to MS-SQL, were to copy microsoft's driver(sqljdbc4.jar) into TOMCAT_HOME/lib and to change the Resource element in the context.xml to:
<Resource name="jdbc/myDB" auth="Container" type="com.atomikos.jdbc.AtomikosDataSourceBean"
            factory="com.atomikos.tomcat.BeanFactory"
            uniqueResourceName="jdbc/myDB"
            xaDataSourceClassName="com.microsoft.sqlserver.jdbc.SQLServerXADataSource"
            maxPoolSize="3"
            xaProperties.databaseName="MedCPU"
             xaProperties.user="MedCPU"
            xaProperties.password="MedCPU"
            />
When I start up the demo application I see an __ Exception in the apache tomcat console (full exception stack: http://pastebin.com/ptYdG1jv ).
I have gone over these tutorials http://msdn.microsoft.com/en-us/library/aa342335.aspx  http://www.senthilb.com/2010/01/how-to-make-xa-datasource-work-in-mssql.html but I have not been able to get passed this exception.
Is there anyone who was successfull with using Atomikos on a MS-SQL Server?
I'd appreciate any help granted and if you need any info I'll be happy to provide it.
Also I don't know if this is relevant but the Server is WIN-XP SP3 (I'm saying this because one of the tutorials speaks of a problem with win-xp when in actuality it's about win-xp sp2 and under).

Hi,

Did you try this? http://www.atomikos.com/Documentation/ConfiguringSQLServer

HTH