diff options
Diffstat (limited to 'documentation/sqlcontainer/sqlcontainer-limitations.asciidoc')
| -rw-r--r-- | documentation/sqlcontainer/sqlcontainer-limitations.asciidoc | 44 |
1 files changed, 44 insertions, 0 deletions
diff --git a/documentation/sqlcontainer/sqlcontainer-limitations.asciidoc b/documentation/sqlcontainer/sqlcontainer-limitations.asciidoc new file mode 100644 index 0000000000..3e245a1ddf --- /dev/null +++ b/documentation/sqlcontainer/sqlcontainer-limitations.asciidoc @@ -0,0 +1,44 @@ +--- +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. + + + + |