I am trying to bind my SQLServer to JBoss using the jDTS JDBC driver. When I use the Local Transaction, I get a "prepare called on a local tx. You might not be getting the semantics that you expect". But, when I change it to a XA transaction, I get a java.lang.reflect.UndeclaredThrowableException...Caused by: javax.resource.ResourceException: associateConnection not supported
I have changed my JDBC driver to MS's JDBC driver and to Avenir's aveConnect3.0 driver with the same result.
JBoss 3.0.4 (with Tomcat)
SQLServer 2000 SP3
I am attaching my datasource XML files.
I am not sure what else to try to fix this problem. Any help would be greatly appreciated.
Forgot to include that when I am using the local transactions, I get the "prepare called using local tx..." but it is a warning. I still get my expected result. But, am not sure if this will affect anything else as I haven't done a thorough system wide test yet.
If I ignore this warning, what is the worst thing that could happen?
Thanks in advance.