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

[jovi_iits]

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>
  | 

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3966877#3966877

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3966877