1 Reply Latest reply on Jun 11, 2003 9:27 AM by Sridhar

    Problem connecting SQLServer to JBoss

    Sridhar Newbie

      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.

        • 1. Re: Problem connecting SQLServer to JBoss
          Sridhar Newbie

          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.