//    SQLContainer contactContainer = createMySQLContainer();
    SQLContainer contactContainer = createMSSQLContainer();

package com;
import com.vaadin.data.util.sqlcontainer.SQLContainer;
import com.vaadin.data.util.sqlcontainer.connection.SimpleJDBCConnectionPool;
import com.vaadin.data.util.sqlcontainer.query.TableQuery;
import com.vaadin.server.VaadinRequest;
import com.vaadin.ui.Table;
import com.vaadin.ui.UI;
import com.vaadin.ui.VerticalLayout;
import java.sql.SQLException;


public class testmysql extends UI
{
    private static final long serialVersionUID = 1L;
    // creating a table for showing all data on screen 
    private Table contactList = new Table();
    //SQLContainer contactContainer = createMySQLContainer();
    SQLContainer contactContainer = createMSSQLContainer();
    VerticalLayout layout = new VerticalLayout();
    protected void init(VaadinRequest request)

    {
        initLayout();
        initContactList();
    }

    private void initLayout()
    {
        // setting the main layout 
        setContent(layout);
        // adding a table on out layout 
        layout.addComponent(contactList);
    }
    private void initContactList()
    {
        contactList.setContainerDataSource(contactContainer);
        contactList.setVisibleColumns("id","idd","art");
        contactList.setImmediate(true);
    }
    
    private static SQLContainer createMySQLContainer()
    {
        TableQuery query = null;
        SQLContainer temp = null;
        try
        {
            SimpleJDBCConnectionPool connectionPool = new
                    SimpleJDBCConnectionPool(
                    "com.mysql.jdbc.Driver",
                    "jdbc:mysql://localhost:3306/testdb", "root",
                    "fast11", 2, 5);
            query = new TableQuery("testtab", connectionPool);
            query.setVersionColumn("id");
            temp = new SQLContainer(query);
        }
        catch (SQLException e)
        {
            // TODO Auto-generated catch block 
            e.printStackTrace();
        }
        return temp;
    }

    private static SQLContainer createMSSQLContainer() {
        TableQuery query = null;
        SQLContainer temp = null;
        try {

            SimpleJDBCConnectionPool connectionPool = new
                    SimpleJDBCConnectionPool(
                    "com.microsoft.sqlserver.jdbc.SQLServerDriver", "jdbc:sqlserver://SQL\\SQL2008R2;databaseName=testbase", "testuser", "1234Qwer", 2, 5);
            query = new TableQuery("testtable", connectionPool);
            query.setVersionColumn("id");
            temp = new SQLContainer(query);
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }
        return  temp;

    }

}