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#3964931
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3964931
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
