Known Issues and Limitations

• Some SQL data types do not have write support when using TableQuery: ** All binary types

  • All custom types

• When using Oracle or MS SQL database, the column name “ rownum” can not be used as a column name in a table connected to 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.

• When using FreeformQuery without providing a FreeformStatementDelegate, the row count query is very inefficient - avoid using FreeformQuery without implementing at least the count query properly.

• When using FreeformQuery without providing a FreeformStatementDelegate, writing, sorting and filtering will not be supported.