[jboss-user] [JCA/JBoss] - Re: How to configure JBoss with MS SQL Server

I used the configuration for MSSQL 2000 with msbase.jar, msutil.jar, mssqlserver.jar then my app worked fine in some cases but could not execute multiple statements with "Can't start a cloned connection while in manual transaction mode." exception. When I try to use below configuration for MSSQL 2005 with sqljdbc.jar <?xml version="1.0" encoding="UTF-8"?> | <!-- The SQL Server 2005 Database JCA connection factory config --> | <datasources> | <local-tx-datasource> | <jndi-name>MYDATASOURCE</jndi-name> | <connection-url>jdbc:sqlserver://my-server;databaseName=MYDATABASE</connection-url> | <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> | <user-name>user</user-name> | <password>password</password> | <!-- This will be run before a managed connection is removed from the pool for use by a client--> | <check-valid-connection-sql>select 1</check-valid-connection-sql> | <!-- The minimum connections in a pool/sub-pool. Pools are lazily constructed on first use --> | <min-pool-size>10</min-pool-size> | <!-- The maximum connections in a pool/sub-pool --> | <max-pool-size>30</max-pool-size> | </local-tx-datasource> | </datasources> then my app could not get connection from datasource. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3964931#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...