JBoss sql server connection JDBC configuration

Below given datasource configuration is a sample configuration which can be referred for jboss sql server connection.

-----sample datasource.xml------------

<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>MYNewDB</jndi-name>
<connection-url>
 jdbc:sqlserver://db993Host55\development;DatabaseName=MYNewDB;integratedsecurity=true;
</connection-url>
<user-name>uid</user-name>
<password>password</password>

<driver-class>
com.microsoft.sqlserver.jdbc.SQLServerDriver
</driver-class>

<metadata>
<type-mapping>MS SQLSERVER2005</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>

------------end of datasource.xml---------------------------

The library is called sqljdbc.jar  which can be taken from microsoft website downloads.

Depending how you’re connecting to the database (windows credentials) or with local credentials might change the IntegratedSecurity=true to IntegratedSecurity=false.

In case of any ©Copyright or missing credits issue please check CopyRights page for faster resolutions.