v4.2.0

Based from node-oracledb v4.2.0

• https://github.com/oracle/node-oracledb/blob/master/CHANGELOG.md#node-oracledb-v420-24-jan-2020

v4.2.0 Release Notes

• Added support for binding using the node-oracledb Database Type Constants DB_TYPE_DATE, DB_TYPE_CHAR, DB_TYPE_NCHAR, DB_TYPE_NVARCHAR, DB_TYPE_NCLOB, DB_TYPE_BINARY_DOUBLE, DB_TYPE_BINARY_FLOAT, DB_TYPE_BINARY_INTEGER, DB_TYPE_TIMESTAMP, and DB_TYPE_TIMESTAMP_TZ.
• Added support for binding using DB_TYPE_BOOLEAN (Diego Arce).
• Added support for creating temporary NCLOBS with connection.createLob(oracledb.NCLOB).
• Added client initiated connection support for Continuous Query Notification (CQN) and other subscription based notifications.
• Added result.lastRowid to execute(). It contains the ROWID of the last row affected by an INSERT, UPDATE, DELETE or MERGE statement.
• Changed the Error object offset to be 32-bit, allowing the batchErrors mode of executeMany() to show row offset values up to (2^32)-1 (ODPI-C change).
• Avoid intermediate conversion from the database national character set to the database character set when querying NCLOB columns as String.
• Fixed various execution failures with Node.js 13.2 due to a Node.js NULL pointer behavior change (ODPI-C change).
• Fixed connection pooling so sharded pool.getConnection() requests respect queueTimeout when poolMaxPerShard has been reached.
• Added a directory to the binary module search to help Webpack use, though a copy plugin is still required, see here.
• Fixed some static code analysis warnings.
• Updated Lob streaming documentation and examples. Applications should use the end event (for readable streams) and finish event (for writeable streams) instead of the close event. The node-oracledb lob.close() method is now deprecated in favor of the more functional Node.js 8 Stream destroy() method.
• Test and documentation improvements.