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.