All notable changes to this project will be documented in this file.
- Fixed static cursor declaration causeing performance degredatio
- Fixed a memory leak with certain long binary and character types
- Fixed TypeScript definition error preventing compilation
primaryKeysinstance function onConnectionto call ODBC SQLPrimaryKeys functionforeignKeysinstance function onConnectionto call ODBC SQLForeignKeys function- Binaries added for all supported N-API versions for all GitHub Actions runners
- Fixed VARCHAR(MAX) fields creating 0-sized buffers (MSSQL)
- Fixed various TypeScript type definitions
- Fixed application crashing when
callProcedurewas given the wrong procedure name or number of parameters - Fixed TypeScript definition for Connection's
tablesfunction
binding.gyppath for OS400 (IBM i)
- Updated dependencies for security fixes
- Fixed generation of
callProceduresql string whenUNICODEis defined
binding.gypbuild instructions for MacOSStatement's.executefunction can now return aCursorwhen the correct queryOption is passed
StatementandCursorshould now better handle freeing memoryConnection's.callProcedureshould now work on Windows withUNICODEdefined- Fixed up TypeScript definitions
- Simple binding path allows driver's that don't implement block fetch and column-wise binding to still be able to fetch results
- Allow pool.query() to use query options
- Update timeout definitions in README.md
- Fixed multiple memory leaks
- Fixed multiple segfaults
- NEW Cursor class that is returned when new
cursorquery option is set totrue. Cursor allows users to fetch partial result sets through callingfetch - NEW
timeoutquery property allows users to define the number of seconds to wait for execution before returning to the application - NEW
initialBufferSizequery property property allows users to define the size of a buffer for SQL_LONG data types before resizing - Tests for multiple DBMSs added
- Support for FreeBSD build
- Connection generation in pools is now more efficient and doesn't block queries
- Retrieving binary data
- Improved TypeScript definitions
- BIGINT fields are now bound by default correctly
- Fixed multiple memory leaks
- Fixed multiple uncaught errors
- Dozens of minor fixes (see GitHub issues)
- SQL_LONG* fields now use SQLGetData ODBC function, greatly increasing performance
- Connection options can now be passed through to pool connections
- Debugging no longer done through
DEBUGdefine, but through existing connection manager facilities - Updated dependencies
- Emergency version to fix a push made to
npmin error.
- Fixed multiple connections being created after
pool.query()is called.
- Fixed bug when UNICODE is defined where statement in result object and column name properties wouldn't encode correctly
- Update package-lock.json with vulnerability fixes
- Fixed bug when UNICODE is defined where error message, error state, and column names wouldn't encode correctly
- Fixed bug with REAL, DECIMAL, and NUMERIC fields ocassionaly returning incorrect results
- Windows binaries are now built with
UNICODEdefined by default (like in 1.x)
columnsarray on result set now includescolumnSize,decimalDigits, andnullabledata fromSQLDescribeCol
- Fixed bug with
callProcedureon big-endian systems
node-pre-gypadded to dependencies to download pre-built binaries- TypeScript definitions added for all functions and objects
- Refactored how column values are bound (now bound to correct C type)
- Promises no longer overwrite
odbcErrorsobject on Errors - Parameters can now correctly be classified as integers or doubles
- Multi-byte UTF-8 strings are now returned correctly
- Fixed SQL_DECIMAL, SQL_REAL, and SQL_NUMERIC losing precision
- pool.query() now closes the connections after query
- Closing queries rapidly no longer causes segfaults
- Added
CHANGELONG.md - Added Connection function
.setIsolationLevel(level, callback?)
- Refactored how parameters are stored and returned
- SQL_NO_TOTAL should no longer return error on queries
- connection.close() is now more stable
- Created much more rebust DEBUG messages
- Added support for
SQL_TINYINT
- Upgraded
lodashfrom version 4.17.11 to 4.17.15
- Added support for JavaScript BigInt binding to
SQL_BIGINT
- Removed a debug message
- Fixed errors in
.callProcedure()
- Fixed Windows compilation issues
- Fixed dependency issue with
asyncpackage
- COMPLETE REWRITE OF THE PACKAGE