diff options
| author | Denis <denis@vaadin.com> | 2016-12-19 16:12:41 +0200 |
|---|---|---|
| committer | Pekka Hyvönen <pekka@vaadin.com> | 2016-12-19 16:12:41 +0200 |
| commit | 5121f1f38e727ccbcd8b24c27cdd91864125ed12 (patch) | |
| tree | 54392dbf29c62bc24cd502cd1e1f5359a1ee97a4 /documentation/sqlcontainer/sqlcontainer-limitations.asciidoc | |
| parent | 576a6012e002a78c58bd74a4c09683867cc43755 (diff) | |
| download | vaadin-framework-5121f1f38e727ccbcd8b24c27cdd91864125ed12.tar.gz vaadin-framework-5121f1f38e727ccbcd8b24c27cdd91864125ed12.zip | |
Remove sqlcontainer section. (#8046)
* Remove sqlcontainer section.
Diffstat (limited to 'documentation/sqlcontainer/sqlcontainer-limitations.asciidoc')
| -rw-r--r-- | documentation/sqlcontainer/sqlcontainer-limitations.asciidoc | 44 |
1 files changed, 0 insertions, 44 deletions
diff --git a/documentation/sqlcontainer/sqlcontainer-limitations.asciidoc b/documentation/sqlcontainer/sqlcontainer-limitations.asciidoc deleted file mode 100644 index 3e245a1ddf..0000000000 --- a/documentation/sqlcontainer/sqlcontainer-limitations.asciidoc +++ /dev/null @@ -1,44 +0,0 @@ ---- -title: Known Issues and Limitations -order: 9 -layout: page ---- - -[[sqlcontainer.limitations]] -= Known Issues and Limitations - -At this point, there are still some known issues and limitations affecting the -use of SQLContainer in certain situations. The known issues and brief -explanations are listed below: - -* Some SQL data types do not have write support when using TableQuery: ** All binary types -** All custom types -** CLOB (if not converted automatically to a [classname]#String# by the JDBC driver in use) -** See [classname]#com.vaadin.addon.sqlcontainer.query.generator.StatementHelper# for details. - - -* When using Oracle or MS SQL database, the column name " [parameter]#rownum#" can -not be used as a column name in a table connected to [classname]#SQLContainer#. - -+ -This limitation exists because the databases in question do not support -limit/offset clauses required for paging. Instead, a generated column named -'rownum' is used to implement paging support. - - -The permanent limitations are listed below. These can not or most probably will -not be fixed in future versions of SQLContainer. - -* The [methodname]#getItemIds()# method is very inefficient - avoid calling it unless absolutely required! -* When using [classname]#FreeformQuery# without providing a [classname]#FreeformStatementDelegate#, the row count query is very inefficient - avoid using [classname]#FreeformQuery# without implementing at least the count query properly. -* When using [classname]#FreeformQuery# without providing a [classname]#FreeformStatementDelegate#, writing, sorting and filtering will not be supported. -* When using Oracle database most or all of the numeric types are converted to -[classname]#java.math.BigDecimal# by the Oracle JDBC Driver. - -+ -This is a feature of how Oracle DB and the Oracle JDBC Driver handles data -types. - - - - |