Vaadin SQL Container - Table Query

-


Sometimes I think I am the only Java programmer in Australia who uses the Java Framework called Vaadin. For the most part my colleagues are deeply entrenched in Spring and have no time to lift their heads out of the Spring Documentation to experiment with a different type of Framework.

One of the interesting features of Vaadin is its simple, but effective SQL Container Add On. It provides a simple layer on top of a database. The add on does not provide a JPA interface into the data ( this feature is supported by a different commercial add on ) it does however provide a nice, simple object model for queries and database connections.

This short blog will focus on a Table Query using the SQL Container Add On. I will create other blogs in the future describing more complex features of the Add On.

The first thing you need to establish is a Connection Pool.
            
SimpleJDBCConnectionPool connectionPool =  new SimpleJDBCConnectionPool "com.mysql.jdbc.Driver","jdbc:mysql://localhost:3306/<database name>", "<user>", "<password>", 2, 5);

 In this method a Simple Connection Pool object is created against a MySQL Database. The initial connections has been set to two ( 2 ), with a maximum of five ( 5 ) connections allowed.

There is also a J2EE Connection Pool which can be used within J2EE containers which have J2EE data resources. This class simplifies the connection into these resources.

Following the creation of the connection pool you can create a Table Query. This is a component which provides operations on a single database table.

For example if you have a table within your database called suburb, then a Table Query for that table may look like this:

TableQuery q = new TableQuery("suburb", connectionPool);

The TableQuery supports multiple users attempting to write to this table at the same time. This is achieved via an optimistic locking process.

q.setVersionColumn("OPTLOCK");

Once the Table Query is in place, you need to create a SQL Container. A container is an important concept in Vaadin as they are used as components that link the UI to the Data.

SQLContainer container = new SQLContainer(q);

That's it for basic database connections and tables.

More interesting operations to follow in later blogs.



Comments

Post a Comment

Popular posts from this blog

Vaadin - GRID Component

-
Image
Introduction Vaadin 7.4 was recently released and it includes a new component called the GRID . It represents a 'Spreadsheet" type model from a UI perspective, however I think it lacks a lot of features you would expect from this type of component. Maybe this component will evolve over time and it will begin to have the functions that you expect from a spreadsheet. ( note: there is a commercial add on called the Spreadsheet from Vaadin ) Use Case The use case I am demonstrating below is a simple grid showing projected sales of Widgets over a five year period. Creation Creating a Grid is very simple and you have numerous options for sizing on the page. In the example below I setting it across the page. The Grid rows can be selected for editing, you can select single or multiple rows in a single action. myGrid = new Grid(); myGrid.setSizeFull(); myGrid.setSelectionMode(SelectionMode.SINGLE); Container Backing Similar to many other Vaadin componen...
Read more

Connecting a Vaadin SQL Container to a Combo Box

-
It must be me. But I spent a lot of time trying to figure out how to connect a database table implemented as a Vaadin SQL Container to a Vaadin Combo Box. It seems such a simple concept. Anyway, here was my requirement. I needed a combo box to contain a list of Australia suburbs. The user would select a suburb which would filter the results in a table on the screen. My database table was very simple. A id field ( which was the primary key ) and a name field which contained the suburb name. The code for the SQL Container was simple. TableQuery q = new TableQuery("suburb", connectionPool); suburbContainer = new SQLContainer(q); Now code to establish the combo box and links to the SQL Container.   ComboBox suburbCB = new ComboBox();  suburbCB.addItem("");  suburbCB.setCaption("Filter by Suburb");  suburbCB.setContainerDataSource(app.getDatabase().loadSuburbs());  suburbCB.setItemCaptionPropertyId("name");  suburbCB.setItemC...
Read more

Vaadin and Google Maps

-
Vaadin and a Google Map Widget One of my major irritations with Vaadin has been its lack of support for Google Maps as a standard widget. The reality is that many commercial applications require some form of mapping feature and the lack of support for a standard Google Map widget has been a major problem. However this has changed with Version 7.x of Vaadin, a new Google Map Addon has appeared and it fills a very important gap in the Vaadin feature set. How to Use It. If you use Maven in your development process then using the Addon in your Vaadin project is very easy. Just place this dependency in your POM file and make sure you have the correct repository established for the Vaadin Add On's. <dependency>    <groupId>com.vaadin.tapio</groupId>    <artifactId>googlemaps</artifactId>    <version>0.6.2</version> </dependency> Here is some simple code to get you started. It creates a Googl...
Read more