Vaadin SQLContainer

Vaadin SQLContainer is a container implementation that reads it's contents from a JDBC data source.

Vaadin SQLContainer is meant as a replacement to the old QueryContainer and supports lazy loading and buffered writes.

Two modes of operation are supportedFreeformQuery and TableQuery:

FreeformQuery mode allows you to specify any complex query and have it's results populate the container, however you need to impelment support for writing, sorting, filtering and lazy loading by implementing the FreeformQueryDelegate interface.

TableQuery mode allows you to provide only a table name and the container takes care of populating itself and automatically supports writing, sorting, filtering and lazy loading for the following database engines: HSQLDB, MySQL, MSSQL, Oracle and PostgreSQL.

SQLContainer has been integrated into Vaadin 6.7 and this add-on will not receive any further updates. All changes will be made to the Vaadin Framework only.

Sample code

try {
    connectionPool = new SimpleJDBCConnectionPool(
            "org.hsqldb.jdbc.JDBCDriver",
            "jdbc:hsqldb:mem:sqlcontainer", "SA", "", 2, 2);
    SQLContainer container = new SQLContainer(new FreeformQuery(
            "SELECT * FROM people", Arrays.asList("ID"), connectionPool));
    Table table = new Table("People", container);
} catch (SQLException e) {
    // Handle error
    e.printStackTrace();
}

try {
    connectionPool = new SimpleJDBCConnectionPool(
            "org.hsqldb.jdbc.JDBCDriver",
            "jdbc:hsqldb:mem:sqlcontainer", "SA", "", 2, 2);
    FreeformQuery query = new FreeformQuery("SELECT * FROM people",
            Arrays.asList("ID"));
    query.setDelegate(myFreeformQueryDelegateImplementation);
    SQLContainer container = new SQLContainer(query, connectionPool);
    Table table = new Table("People", container);
} catch (SQLException e) {
    // Handle error
    e.printStackTrace();
}

Links

• More advanced Demo
• Discussion Forum
• Author Homepage
• Simple Demo
• Issue Tracker
• Source Code

Compatibility