This content has been marked as final.
Show 3 replies
-
1. Re: How to configure JBoss with MS SQL Server
jovi_iits Aug 14, 2006 7:01 AM (in response to tahirakramch)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. -
2. Re: How to configure JBoss with MS SQL Server
jovi_iits Aug 23, 2006 2:35 AM (in response to tahirakramch)Tried to use below configuration for MSSQL 2005 with sqljdbc.jar and did succesfull:
<?xml version="1.0" encoding="UTF-8"?> <datasources> <local-tx-datasource> <jndi-name>MYDATASOURCE</jndi-name> <connection-url>jdbc:sqlserver://my-server;databaseName=MYDATABASE;SelectMethod=cursor</connection-url> <driver-class>com.microsoft.sqlserver.jdbc.SQLServerDriver</driver-class> <user-name>user</user-name> <password>password</password> <min-pool-size>5</min-pool-size> <max-pool-size>10</max-pool-size> <blocking-timeout-millis>50000</blocking-timeout-millis> <idle-timeout-minutes>30</idle-timeout-minutes> <meta-data> <type-mapping>MS SQLSERVER2005</type-mapping> </meta-data> </local-tx-datasource> </datasources>
-
3. Re: How to configure JBoss with MS SQL Server
ivanlc Sep 5, 2006 2:06 PM (in response to tahirakramch)Could you post your standardjbosscmp-jdbc.xml excerpt
for the SQLSERVER 2005 type mappings?
Or where can I get it?
I keep on getting The Incoming Tabular Data Stream (TDS) remote procedure call (RPC).
What version of the driver are you using?
Best regards,
Ivan