Vaadin 7 & Spring Boot : SqlContainer doesnot work with Filter

Question

Spring Boot: 1.3.2.RELEASE Vaadin : 7.6.3 Mysql: mysql-java-connector-5.1.38 HikariCP: 2.4.3

So I create a Table with only id and name columns. Then a vaadin componant Table to show the content of table. Until now everything is fine. Then I tried to filter the table with a vaadin Filter, and it works if the connection pool is com.vaadin.data.util.sqlcontainer.connection.SimpleJDBCConnectionPool, and doesnot if it is com.vaadin.data.util.sqlcontainer.connection.J2EEConnectionPool which I use HikariCP as the data source.

DBConfig.java

@Configuration
@EnableTransactionManagement
public class DatabaseConfig {

@Bean
public HikariConfig hikariConfig() {
    HikariConfig config = new HikariConfig();
    config.setDriverClassName("com.mysql.jdbc.Driver");
    config.setJdbcUrl("jdbc:mysql://localhost:3306/test?autoReconnect=true&useSSL=false");
    config.setUsername("root");
    config.setPassword("root");
    config.setMaximumPoolSize(20);
    config.setPoolName("connectionPool");
    return config;
}

@Bean
public DataSource dataSource() {
    HikariDataSource dataSource = new HikariDataSource(hikariConfig());
    return dataSource;
}

ApplicationUI.java

@Autowired
private J2EEConnectionPool connectionPool;

@Override
protected void init(VaadinRequest arg0) {
    TableQuery tq = new TableQuery("medecine", connectionPool);// it does not work if I use HikariCP as the J2EEConnectionPool

JDBCConnectionPool pool = new SimpleJDBCConnectionPool("com.mysql.jdbc.Driver",
                "jdbc:mysql://localhost:3306/test?autoReconnect=true&useSSL=false", "root", "root");
TableQuery tq = new TableQuery("medecine", connectionPool);// it works if I use **SimpleJDBCConnectionPool**.

    container = new SQLContainer(tq);
    table = new Table();
    table.setContainerDataSource(container);
    table.setWidth(100, Unit.PERCENTAGE);
    mainLayout.addComponent(table);

Button addFilter = new Button("filter", new ClickListener() {

        private static final long serialVersionUID = -7071683058766115266L;

        @Override
        public void buttonClick(ClickEvent arg0) {
            Filter filter = new SimpleStringFilter("name", "medecine2", true, false);
            container.addContainerFilter(filter);
        }
    });
mainLayout.addComponent(addFilter);
}

The reason I choose HikariCP as the data source is for a better performance and I'm not sure that the vaadin connection pool will be better than HikariCP. Or, it is limited to vaadin connection pool for the filtering function?