Exception in thread "main" org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host localhost, named instance sqlexpress failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434.  For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.
    at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
    at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:390)
    at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:470)
    at org.springframework.jdbc.core.JdbcTemplate.queryForRowSet(JdbcTemplate.java:511)
    at org.springdemo.demo1.CustomJDBCTemplate.getDBs(CustomJDBCTemplate.java:25)
    at org.springdemo.demo1.MainApp.main(MainApp.java:15)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host localhost, named instance sqlexpress failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434.  For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.0.xsd ">

<bean id="dataSource1"
    class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
    <property name="url"
        value="jdbc:sqlserver://localhost\SQLExpress;integratedSecurity=true;" />
</bean>

<bean id="dataSource2"
    class="org.apache.commons.dbcp2.BasicDataSource">
    <property name="driverClassName" value="net.sourceforge.jtds.jdbc.Driver" />
    <property name="url"
        value="jdbc:sqlserver://localhost\SQLExpress;integratedSecurity=true;" />
</bean>

<bean id="customJDBCTemplate" class="org.springdemo.demo1.CustomJDBCTemplate">
    <property name="dataSources">
        <list>
            <ref bean="dataSource1" />
        </list>
    </property>
</bean>

package org.springdemo.demo1;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
import org.springframework.jdbc.support.rowset.SqlRowSet;

public class MainApp {

public static void main(String[] args) {
    ApplicationContext context = new ClassPathXmlApplicationContext(
            "beans.xml");
    CustomJDBCTemplate template = (CustomJDBCTemplate) context
            .getBean("customJDBCTemplate");

    SqlRowSet srs = template.getDBs();
    while (srs.next()) {
        System.out.println(srs.getString("name"));
    }
}
}

package org.springdemo.demo1;

import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import javax.sql.DataSource;

import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.support.rowset.SqlRowSet;

public class CustomJDBCTemplate {
    private List<DataSource> dataSources;
    private List<JdbcTemplate> jdbcTemplateObjects = new ArrayList<JdbcTemplate>();

    public void setDataSources(List<DataSource> dataSources) {
        this.dataSources = dataSources;
        for(DataSource s : dataSources)
            this.jdbcTemplateObjects.add(new JdbcTemplate(s));
    }

    public SqlRowSet getDBs()
    {
        String query = "SELECT name FROM master.dbo.sysdatabases WHERE name NOT IN ('master', 'tempdb', 'model', 'msdb');";
        return jdbcTemplateObjects.get(0).queryForRowSet(query);
    }
}