Directory

← Back

SQLContainer Enhanced

Drop-in replacement for SQLContainer

Author

Rating

Popularity

<100

Enhanced version of SQLContainer. This is a drop-in replacement.

  • Auto-detect database type. If you've ever tried to use TableQuery just by following the Vaadin Docs then you've probably begun to see strange errors. This is because TableQuery really need to know what database you are using. If not, it will just take a wild guess and this may be wrong, at least if you are using Oracle or MS SQL Server. In the enhanced version we can pass a JDBC Driver Class name (something your application should know) and from this the Enhanced SQLContainer can tell what your database is and therefore use the correct SQLGenerator. Generally this makes it easier/possible to deliver solutions to your customer that can run on any supported database rather than being tied to a single type of database.
  • Support for MariaDB and Apache Derby has been added.
  • Support for conversion of vendor-specific data types such as Oracle's proprietary timestamp type or PostgreSQL's Geographic types. This type of conversion cannot be done in a standard Vaadin Converter because the conversion needs access to the JDBC connection.

Usage guide is on the GitHub README. Apart from that this is really a drop-in replacement so all of the official Vaadin documentation for SQLContainer applies.

As of Vaadin 8 there will no longer be any SQLContainer in the Vaadin Framework. What this means for this add-on is currently undecided. But in any case you can continue to use this add-on as it is also in Vaadin 8 with the v7 compatibility package.

Compatibility

(Loading compatibility data...)

Was this helpful? Need more help?
Leave a comment or a question below. You can also join the chat on Discord or ask questions on StackOverflow.

Version

Corrected a bug in the upload to directory.

Released
2016-10-23
Maturity
STABLE
License
Apache License 2.0

Compatibility

Framework
Vaadin 7.7+
Vaadin 6.0+ in 0.9.8
Browser
N/A

SQLContainer Enhanced - Vaadin Add-on Directory

Drop-in replacement for SQLContainer SQLContainer Enhanced - Vaadin Add-on Directory
Enhanced version of **SQLContainer**. This is a drop-in replacement. * Auto-detect database type. If you've ever tried to use `TableQuery` just by following the Vaadin Docs then you've probably begun to see strange errors. This is because `TableQuery` really need to know what database you are using. If not, it will just take a wild guess and this may be wrong, at least if you are using Oracle or MS SQL Server. In the enhanced version we can pass a JDBC Driver Class name (something your application *should* know) and from this the Enhanced SQLContainer can tell what your database is and therefore use the correct `SQLGenerator`. Generally this makes it easier/possible to deliver solutions to your customer that can run on any supported database rather than being tied to a single type of database. * Support for MariaDB and Apache Derby has been added. * Support for conversion of vendor-specific data types such as Oracle's proprietary timestamp type or PostgreSQL's Geographic types. This type of conversion cannot be done in a standard Vaadin Converter because the conversion needs access to the JDBC connection. Usage guide is on the GitHub README. Apart from that this is really a drop-in replacement so all of the official Vaadin documentation for SQLContainer applies. As of Vaadin 8 there will no longer be any SQLContainer in the Vaadin Framework. What this means for this add-on is currently undecided. But in any case you can continue to use this add-on as it is also in Vaadin 8 with the v7 compatibility package.
Online