String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
    String connectionString = "jdbc:sqlserver://mySERVER;databasename=myDB";
    String userName = "user";
    String password = "Password";
    String query = "select * from table1 where id = ...."

    SQLContainer container = null;
    try
    {
          SimpleJDBCConnectionPool connectionPool = new SimpleJDBCConnectionPool(driver, connectionString, userName, password, 2, 5);
          FreeformQuery query = new FreeformQuery(queryString, connectionPool);
          container = new SQLContainer(query);
     }
     catch (SQLException e)
     {
           e.printStackTrace();
     }
           finally
     {
     
     }