diff options
| author | Ilia Motornyi <elmot@vaadin.com> | 2015-12-03 14:59:05 +0000 |
|---|---|---|
| committer | Vaadin Code Review <review@vaadin.com> | 2015-12-03 14:59:12 +0000 |
| commit | 2af72ba9636bec70046394c41744f89ce4572e35 (patch) | |
| tree | ccb3dc2d2239585f8c3f79eb5f131ff61ca9ce86 /documentation/sqlcontainer/sqlcontainer-limitations.asciidoc | |
| parent | 8aa5fabe89f2967e966a64842a608eceaf80d08f (diff) | |
| download | vaadin-framework-2af72ba9636bec70046394c41744f89ce4572e35.tar.gz vaadin-framework-2af72ba9636bec70046394c41744f89ce4572e35.zip | |
Revert "Merge branch 'documentation'"7.6.0.beta2
This reverts commit f6874bde3d945c8b2d1b5c17ab50e2d0f1f8ff00.
Change-Id: I67ee1c30ba3e3bcc3c43a1dd2e73a822791514bf
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. - - - - |