Version 2.2.0 of SQL Relay, the powerful connection pool, load balancer, query router, and database proxy, is now available.
This release adds a native JDBC driver, technically making SQL Relay the obscure Type 3 JDBC driver.
It also add support for configurable transaction models. You can make Oracle act like PostgreSQL, PostgreSQL act like MySQL, any of them act like MSSQL, etc. Just set transactionmodel to one of:
- "none" - no transactions
- "native" - the database's native transaction model
- "implicit" - oracle-style
- "explicit" - postgresql-style
- "explicit-deferred" - mysql-style
- "explicit-error" - sap/mssql-style
This is an upgrade to the old parameter faketransactionblocks which basically toggled between native and explicit.
The ODBC driver has been wrung out and improved in this release too.
Finally, there is a new savepoints trigger that wraps each query in a savepoint, and rolls back to that savepoint if the query fails. This is especially helpful when migrating an app to PostgreSQL, as PostgreSQL otherwise aborts a transaction if a query fails.
As usual, there are also plenty of improvements and bug fixes.
