2 Replies Latest reply on Jun 7, 2004 4:51 PM by adrian.brock

    Please give me a hand in configing XADatasoruce for db2 and

    bbsid

      I can't solve the problem mentioned above although I have spent a lot of time to search related topics in wikis or forums.
      Please help me!

      I copy the sqljdbc.dll to the Microsoft SQL Server\MSSQL\Binn directory.
      I finished Installing Stored Procedures for JTA (in SQL Server 2000)
      use the command in ms-dos window

      #ISQL -Usa -Psa_password -Sserver_name -id:\instjdbc.sql

      it print some messages:
      ....
      ....
      1> 2> 1> 2> 3> 4> 5> 6> 7> 8> 9> creating JDBC XA procedures
      1> 2> 3> 1> 2> 1> 2> 1> 2> 1> 2> 1> 2> 1> 2> 1> 2> 1> 2> 1> 2> 3> 4> 5> 6> 7> 1>
      2> 1> 2> 1> 2> 1> 2> 1> 2> 1> 2> 1> 2> 1> 2> 3> 4>
      instxa.sql completed successfully.
      1> 2> 3> 1> 2> 1> 2>

      I think the installing should be right.

      Then, I edit the mssql-xa-ds.xml file and copy it to default/default directory.
      JBoss generate such messages:
      09:39:46,343 INFO [MainDeployer] Starting deployment of package: file:/D:/Java/
      Servers/jboss-3.2.3/server/default/deploy/mssql-xa-ds.xml
      09:39:46,421 INFO [RARDeployment] Started jboss.jca:service=ManagedConnectionFa
      ctory,name=MSSQLXADS
      09:39:46,437 INFO [JBossManagedConnectionPool] Started jboss.jca:service=Manage
      dConnectionPool,name=MSSQLXADS
      09:39:46,437 INFO [MSSQLXADS] Bound connection factory for resource adapter for
      ConnectionManager 'jboss.jca:service=XATxCM,name=MSSQLXADS to JNDI name 'java:/
      MSSQLXADS'
      09:39:46,437 INFO [TxConnectionManager] Started jboss.jca:service=XATxCM,name=M
      SSQLXADS
      09:39:46,437 INFO [MainDeployer] Deployed package: file:/D:/Java/Servers/jboss-
      3.2.3/server/default/deploy/mssql-xa-ds.xml

      I don't know whether it is successful.

      I have no idea to go on. I just want to test XADatasource from a JSP.
      Maybe it's so easy for someone, but it's really hard for me.

      Who can tell me and someone else like me how to continue.