Release Notes: This release adds a module for querying and updating Salesforce.com installations, backed by the Salesforce.com Web services. It adds a module for querying SugarCRM installations, backed by SugarCRM Web services. It optimizes support for DB2 queries with firstRow and maxRows properties set, yielding a ROW_NUMBER query in the background database interaction.
Release Notes: Many query parser improvements, including parsing column names with dots, mixed case clause declarations, select DISTINCT queries, select item aliases, and selecting everything from multiple from items. It also fixes two bugs: an issue with interpreting CHAR types as strings, and inclusion of function names (if available) in TableModel header names.
Release Notes: This release fixes timestamp literals on DB2's SQL-dialect.
Release Notes: This release drastically improves the performance of "DELETE FROM" statements on CSV files. It adds mapping of unavailable-to-available data types when issuing "CREATE TABLE" statements containing unavailable data types on e.g. DB2 or PostgreSQL. It fixes a bug pertaining to multi-threaded execution of compiled JDBC queries. A pool of prepared statements has been created to ensure parallel execution of compiled queries. A bug has been fixed pertaining to proper quoting of HAVING clause operands when the data type of the aggregate function is different from the data type of the functions argument.
Release Notes: This release provided full support for CRUD operations on JDBC databases, CSV files, Excel spreadsheets, and NoSQL stores. CREATE TABLE, DROP TABLE, UPDATE, and DELETE FROM operations were added. Support for LIST and MAP column types (common in NoSQL stores) was added. Awareness of primary key columns was implemented (especially useful for UPDATE operations). Support for plain Java collections as datastores (LINQ style) was added. Full support for CouchDB databases was provided. Several maturing improvements were made in the API's syntax and semantics.
Release Notes: The Excel adapter now uses the new Streaming API in Apache POI, which means that support for very large Excel spreadsheets is much better. A bug was fixed that caused CSV writing to not respect the separator and quote character defined for the file format. Performance was improved in query postprocessing by applying sub-selections just-in-time instead of ahead of time. An experimental adapter has been added for MongoDB databases. The adapter supports querying MongoDB using the well known MetaModel query API.
Release Notes: This release fixes an issue when encountering excel spreadsheets containing unparsable formulas. It improves automatic fetch size calculation for queries that are guaranteed to yield only a single row.
Release Notes: Support for Microsoft SQL Server has been added. Support has been added for choosing between different character encodings for CSV files.
Release Notes: A bug when querying PostgreSQL tables from schemas other than the "public" schema was fixed. A few code cleanups were introduced.
Release Notes: This is a stabilization release, containing some minor bugfixes, specifically regarding Schema serialization. If you're currently using any 1.1.x release of MetaModel, then you should do a drop-in replacement and expect no changes to your code.