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
primaryKeys
instance function onConnection
to call ODBC SQLPrimaryKeys functionforeignKeys
instance function onConnection
to 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
callProcedure
was given the wrong procedure name or number of parameters - Fixed TypeScript definition for Connection's
tables
function
binding.gyp
path for OS400 (IBM i)
- Updated dependencies for security fixes
- Fixed generation of
callProcedure
sql string whenUNICODE
is defined
binding.gyp
build instructions for MacOSStatement
's.execute
function can now return aCursor
when the correct queryOption is passed
Statement
andCursor
should now better handle freeing memoryConnection
's.callProcedure
should now work on Windows withUNICODE
defined- 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
cursor
query option is set totrue
. Cursor allows users to fetch partial result sets through callingfetch
- NEW
timeout
query property allows users to define the number of seconds to wait for execution before returning to the application - NEW
initialBufferSize
query 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
DEBUG
define, but through existing connection manager facilities - Updated dependencies
- Emergency version to fix a push made to
npm
in 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
UNICODE
defined by default (like in 1.x)
columns
array on result set now includescolumnSize
,decimalDigits
, andnullable
data fromSQLDescribeCol
- Fixed bug with
callProcedure
on big-endian systems
node-pre-gyp
added 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
odbcErrors
object 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
lodash
from 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
async
package
- COMPLETE REWRITE OF THE PACKAGE