import java.sql.*;
import org.apache.commons.dbcp.BasicDataSource;
public class MyDataSource extends BasicDataSource{
 public static BasicDataSource ds;
 
 private MyDataSource(){
  String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
  String url = "jdbc:sqlserver://localhost\\SQLExpress;"
                                                     +"DatabaseName=dbname";
  String uname = "sa";
  String upwd = "sa";
  
  ds = new BasicDataSource();
  ds.setDriverClassName(driver);
  ds.setUrl(url);
  ds.setUsername(uname);
  ds.setPassword(upwd);
  ds.setMaxActive(100);
 }
 
 public static synchronized BasicDataSource getDs(){
  if(ds==null)
  {
   new MyDataSource();
  }
  return ds;  
 }

}