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.

Where to include a web components css file when integrating a third party w by Martin Vyšný, 1 week 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!