[jboss-user] [JCA/JBoss] - Re: How to configure JBoss with MS SQL Server
jovi_iits
do-not-reply at jboss.com
Wed Aug 23 02:35:44 EDT 2006
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
More information about the jboss-user
mailing list