search/filtering SQL container data...

Vaadin 6 / 7 / 8 Framework Data Binding
1

I am new to Vaaading… so please stay with me

I have the following code similar to the addressBook example published by Vaadin, except it connects to a MySQL db;
It compiles fine but when I type into the searchField i get the following error related to MySQL

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 1

1-what is the issue?
2-how can I see the sql sent to the DBMS?
3-the contaner alread has the data, why does it goes out again to the DBMS to get the searched data and not just filter the data already in the container?

thanks

[font=courier new]
private void initSearch() {
searchField.setInputPrompt(“Search Zipcode”);
searchField.setTextChangeEventMode(TextChangeEventMode.LAZY);
searchField.addTextChangeListener(new TextChangeListener() {
public void textChange(final TextChangeEvent event) {
containerZipcode.removeAllContainerFilters();
containerZipcode.addContainerFilter(new zipcodeFilter(event.getText()));
}
});
}

private class zipcodeFilter implements Filter {
    private String needle;

    public zipcodeFilter(String needle) {
        this.needle = needle.toLowerCase();
    }

    public boolean passesFilter(Object itemId, Item item) {
        String haystack = ("" + item.getItemProperty(ZIPCODE).getValue())
            .toLowerCase();
        return haystack.contains(needle);
    }

    public boolean appliesToProperty(Object id) {
        return true;
    }
}

[/font]