Problem connecting SQLServer to JBoss

[sridharsa]

Hi all,
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
at org.jboss.resource.adapter.jdbc.BaseManagedConnection.associateConnection(BaseManagedConnection.java:91)

I have changed my JDBC driver to MS's JDBC driver and to Avenir's aveConnect3.0 driver with the same result.

Environment:
JBoss 3.0.4 (with Tomcat)
SQLServer 2000 SP3
JDK 1.4.1_01
Win2K

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.
Sridhar.

[sridharsa]

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.
Sridhar.