Get started
Loading...
Important Notice - Forums is archived

To simplify things and help our users to be more productive, we have archived the current forum and focus our efforts on helping developers on Stack Overflow. You can post new questions on Stack Overflow or join our Discord channel.

Product icon
TUTORIAL

Vaadin lets you build secure, UX-first PWAs entirely in Java.
Free ebook & tutorial.

CssImport when using Component Exporter by Mikhail Shabarov, 1 month ago
Recent Posts
Vaadin Forum3. Vaadin 6, 7, 8

SQLContainer to Grid. ​Unknown table 'table_name' in information_schema

Prat Mishra
5 years ago Feb 02, 2017 5:06pm

Hi

I'm trying to add SqlContainier to a grid 

public SQLContainer initSQLContainer(SimpleJDBCConnectionPool pool) {

        TableQuery tq = new TableQuery("users", pool);

        SQLContainer users = null;

        try {

            users = new SQLContainer(tq);

        } catch (SQLException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }
        return users;
    }

java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: Unknown table 'users' in information_schema
    at com.vaadin.data.util.sqlcontainer.query.TableQuery.fetchMetaData(TableQuery.java:659)
    at com.vaadin.data.util.sqlcontainer.query.TableQuery.<init>(TableQuery.java:189)
    at com.vaadin.data.util.sqlcontainer.query.TableQuery.<init>(TableQuery.java:127)
    at com.vaadin.data.util.sqlcontainer.query.TableQuery.<init>(TableQuery.java:105)
    at com.vaadin.data.util.sqlcontainer.query.TableQuery.<init>(TableQuery.java:147)

I'm using MariaDB version 10.1.19

Thanks!