Spring Framework + Basic Datasource + JTDS + MS SQL Server Configuration

Java Configuration for spring framework based JTDS and MS Sql Server

<bean id="mssqlDataSource" class="org.apache.commons.dbcp.BasicDataSource">

<property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver" />

<property name="url" value="jdbc:jtds:sqlserver:/localhost:1433/<DATABASE NAME>;instance=<BLANK OR INSTANCE NAME>" />

<property name="username" value="sa" />

<property name="password" value="********" />

</bean>