Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
This category contains release notes for releases in the MariaDB Connector/Node.js 2.x series
Download | Release Notes | Changelog |
Release date: 17 Feb 2022
MariaDB Connector/Node.js 2.5.6 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
[] Local infile file validation doesn't take in account escaped value
[] change default connection timeout value 1 second to permit pools to send correct error
correct character_set_client unexpect error parsing OK_Packet
For a complete list of changes made in this release, with links to detailed information on each push, see the .
Download | Release Notes | Changelog |
Release date: 14 Jun 2021
MariaDB Connector/Node.js 2.5.4 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
[] Authentication plugin failing doesn't always return error
[] Add API that list options default value
[] escaping correction
update iconv-lite dependency to 0.6.3
For a complete list of changes made in this release, with links to detailed information on each push, see the .
| | |
Release date: 20 Oct 2021
MariaDB Connector/Node.js 2.5.5 is a (GA) release.
For an overview of MariaDB Connector/Node.js see the page
For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.
| | |
Release date: 10 May 2019
MariaDB Connector/Node.js 2.0.4 is a (GA) release.
For an overview of MariaDB Connector/Node.js see the page
This version is a has been corrected with version, since TypeScript definition wasn't published on npm.
Please use this new 2.0.5 version.
For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.
Download | Release Notes | Changelog |
Release date: 2 Jul 2020
MariaDB Connector/Node.js 2.4.1 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
- pool.getConnection() might not timeout even with acquireTimeout set
- createConnection(string)` does not support URL-encoded credentials
- Support passing null values in array when doing queries. thanks to @koendeschacht
- set default value of option restoreNodeTimeout to 1000 to avoid using blacklisted pool in cluster
For a complete list of changes made in this release, with links to detailed information on each push, see the .
Download | Release Notes | Changelog |
Release date: 4 Dec 2020
MariaDB Connector/Node.js 2.5.2 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
[] bulk batch error (parameter truncation) #137
[] correction when enabling the permitLocalInfile option and some initial commands
[] Timezone support correction and clarification
[] correction to support for node.js 10.13 to 10.19
For a complete list of changes made in this release, with links to detailed information on each push, see the .
Download | Release Notes | Changelog |
Release date: 19 Nov 2019
MariaDB Connector/Node.js 2.1.3 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
Missing mysql only collation definition
typescript escape/escapeId definition
Change user callback function not called when no option is set and changing collation only if collation option is correct
properly escape boolean parameter false
PAM authentication with multiple steps can be achieved using password as array:
better cluster error when pool is full
adding test coverage
Download | Release Notes | Changelog |
Release date: 8 Jan 2020
MariaDB Connector/Node.js 2.1.5 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
Batch improvement
supporting array of parameters if only one parameter per query, not only array of array
supporting empty array for query without parameters
correction on licence tag: LGPL-2.1-or-later (was tag LGPL-2.1+ that is deprecated)
For a complete list of changes made in this release, with links to detailed information on each push, see the .
Download | Release Notes | Changelog | Connector/Node.js Overview
Release date: 13 Dec 2018
MariaDB Connector/Node.js 2.0.2 is a Release Candidate (RC) release.
For an overview of MariaDB Connector/Node.js see the page
New options:
using option connectAttributes value _server_host is correctly filled on Performance Schema.
batch improvement
error is now thrown when no values
BULK better handling when socket fail during command
For a complete list of changes made in this release, with links to detailed information on each push, see the .
| | |
Release date: 23 Jul 2020
MariaDB Connector/Node.js 2.4.2 is a (GA) release.
For an overview of MariaDB Connector/Node.js see the page
| | |
Release date: 31 Jan 2019
MariaDB Connector/Node.js 2.0.3 is a (GA) release.
For an overview of MariaDB Connector/Node.js see the page
| | |
Release date: 25 Sep 2018
MariaDB Connector/Node.js 2.0.0 is an release.
For an overview of MariaDB Connector/Node.js see the page
| | |
Release date: 26 Oct 2020
MariaDB Connector/Node.js 2.5.1 is a (GA) release.
For an overview of MariaDB Connector/Node.js see the page
| | |
Release date: 20 Mar 2020
MariaDB Connector/Node.js 2.3.1 is a (GA) release.
For an overview of MariaDB Connector/Node.js see the page
Corrective release of 2.3.0, changing new connection option timeout to queryTimeout
[CONJS-156] Ensure setting capability PLUGIN_AUTH only if server has it
documentation improvement
CONJS-105 Typecast provided date function erroneous parsing
CONJS-104 Pam authentication must permit to provide multiple passwords
dependencies update
Object with toSqlString function parameter support
null value correction when using BULK
timezone correction when not using "local" default values
now support very long parameter (> 16M)
rewrite correctly parse double slash
timezone option parsing correction (correctly handle negative values)
test coverage improvement
minor performance improvement
pool end() now correctly wait for all connections ending
For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.
[CONJS-56] TypeError: Cannot read property 'totalConnections' of undefined
[CONJS-59] pool now throw ER_ACCESS_DENIED_ERROR in place of a basic timeout error
[CONJS-60] handling pipe error when streaming, avoiding hang in case of pipe error.
[CONJS-55] Connector throw an error when using incompatible options
For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.
CONJS-42 : check other connections in pool when an unexpected connection error occur
CONJS-44 : Create option to permit setting Object to one prepareStatement parameter
CONJS-43 : Callback API is missing
CONJS-39 : support geometric GeoJSON structure format
: new option "sessionVariables" to permit setting session variable at connection
connection.end() immediate resolution on socket QUIT packet send.
improve documentation and set Promise API documentation to a dedicated page.
change pool implementation to permit node 6 compatibility (removal of async await)
CONJS-149 - Support of the new node.js version v15
For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.
For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.
Download | Release Notes | Changelog |
Release date: 12 Jul 2019
MariaDB Connector/Node.js 2.1.0 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
[] Implement Ed25519 plugin
[] Multiple alternative authentication methods for the same user ()
[] Permit handling expired password
[] Implement pool events according to mysql/mysql2 API
New Options
The option charset now corresponds to charset, still permitting collation for compatibility, but then a warning is thrown to the console.
Pools now emit events.
Example:
Download | Release Notes | Changelog |
Release date: 4 Feb 2019
MariaDB Connector/Node.js 2.2.0 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
Azure is using a proxy that will return a MySQL handshake not reflecting real server.
A new option forceVersionCheck is added to permit issuing a new SELECT @@Version command on connection creation,
to retrieve the correct server version. Connector will then act according to that server version.
This option is only permitted for MariaDB server >= 10.1.2, and permits to set a timeout to query operation.
Driver internally use SET STATEMENT max_statement_time=<timeout> FOR <command> permitting to cancel operation when timeout is reached,
Implementation of max_statement_time is engine dependent, so there might be some differences: For example, with Galera engine, a commits will ensure replication to other nodes to be done, possibly then exceeded timeout, to ensure proper server state.
example:
add mysql_native_password to fast-authentication path
plugin 'mysql_native_password' is used by default if default server plugin is unknown
unexpected packet type during handshake result will throw a good error.
A new option leakDetection permits to indicate a timeout to log connection borrowed from pool.
When a connection is borrowed from pool and this timeout is reached, a message will be logged to console indicating a possible connection leak.
Another message will tell if the possible logged leak has been released.
A value of 0 (default) meaning Leak detection is disable
Additionally, some error messages have improved:
Connection timeout now indicate that this correspond to socket failing to establish
differentiate timeout error when closing pool to standard connection retrieving timeout
Permit values in SQL object to permits compatibility with mysql/mysql2
missing import for Error when asking for connection when pool is closed. Thanks to @WayneMDB
correcting typescript import of @types/node to version >8 thanks to @SimonSchick
dependencies update
For a complete list of changes made in this release, with links to detailed information on each push, see the .
Download | Release Notes | Changelog |
Release date: 13 May 2019
MariaDB Connector/Node.js 2.0.5 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
[] permit set numeric parameter bigger than javascript 2^53-1 limitation
[] error when reading datetime data and timezone option is set
[] parse Query when receiving LOAD LOCAL INFILE, to prevent man in the middle attack
[] support named timezones and daylight savings time
New Options
This permits to set a minimum pool size, meaning that after a period of inactivity, the pool will decrease the inner number of connection to a minimum number of connections (defined with minimumIdle).
By default, connections not used after idleTimeout (default to 30 minutes) will be discarded, avoiding reaching server .
Pool handle connection creation automatically, with now some delayed after failing to establish a connection, to avoid using CPU unnecessary. Authentication error in pool have now a better handling.
For a complete list of changes made in this release, with links to detailed information on each push, see the .
Download | Release Notes | Changelog |
Release date: 26 May 2020
MariaDB Connector/Node.js 2.4.0 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
This version removes compatibility with Node.js 6, needing 10+ version!
- Support extension type format
- Error when using multipleStatements with metaAsArray
- Support 10.5 pluggable type
- checkDuplicate option is indicated in error when having dupplicate
- performance improvement
- typescript SqlError interface
For a complete list of changes made in this release, with links to detailed information on each push, see the .
Download | Release Notes | Changelog |
Release date: 24 Feb 2021
MariaDB Connector/Node.js 2.5.3 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
[] Batch error when setting maxAllowedPacket less than an insert parameter value
[] use BigInt constructor in place of literal to ensure maximum compatibility
[] Wrong definition for typescript PoolConnection.release
[] test 10.6 server latest build
For a complete list of changes made in this release, with links to detailed information on each push, see the .
Download | Release Notes | Changelog |
Release date: 17 Oct 2019
MariaDB Connector/Node.js 2.1.2 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
Implemented enhancements:
[] Escape functions API
[] Improve performance using reusable Object type for column definition result
[] Expose library version to API
Use milestone to specify in which version bug was fixed #22 Fixed bugs:
[] TypeScript definition typecast correction
[] Pool idle maintainer error
[] Missing collation option in typescript definition
[] Improve documentation for best practice concerning credential
| | |
Release date: 19 Oct 2020
MariaDB Connector/Node.js 2.5.0 is a (GA) release.
For an overview of MariaDB Connector/Node.js see the page
| | |
Release date: 15 Nov 2018
MariaDB Connector/Node.js 2.0.1 is a release.
For an overview of MariaDB Connector/Node.js see the page
| | |
Release date: 06 Sept 2019
MariaDB Connector/Node.js 2.1.1 is a (GA) release.
For an overview of MariaDB Connector/Node.js see the page
const mariadb = require('mariadb');
mariadb.createConnection({host: 'mydb.com', user: 'myUser', password: ['myPwd', 'myAuthToken']})
.then(conn => {
...
})
.catch(err => {
...
});[CONJS-87] Array parameter automatic conversion
[CONJS-89] Performance improvement on decoding string
[CONJS-88] Charset collation option separation
[CONJS-74] Types definition must be string, not byte, when using the option typeCast
[CONJS-75] Missing import dependencies for typeScript
[CONJS-79] Read errors while processing LOCAL INFILE can cause a process crash
[CONJS-83] Add poolCluster 'remove' event
[CONJS-84] Option restoreNodeTimeout is not respected when removeNodeErrorCount is set
[CONJS-73] Setting the timezone to the current IANA might provoke the server's automatic retrieval
collation
(used in replacement of charset) Permit to define the collation used for connection. This will define the charset encoding used for exchanges with the database and define the order used when comparing strings. It's mainly used for micro-optimizations
string
UTF8MB4_UNICODE_CI
permitConnectionWhenExpired
Permit a user with an expired password to connect. Only possible operation in this case will be to change the password ('SET PASSWORD=PASSWORD('XXX')')
boolean
false
acquire
This event indicates that a connection has been acquired from pool.
connection
This event is emitted when a new connection is added to the pool. Has a connection object parameter
enqueue
This event is emitted when a command cannot be satisfied immediately by the pool and is queued.
release
This event is emitted when a connection is released back into the pool. Has a connection object parameter
[CONJS-63] add type definitions for typescript
[CONJS-64] handle Error packet during resultset to permit query timeout with SET STATEMENT max_statement_time= FOR
[CONJS-66] SET datatype handling (returning array)
[CONJS-67] Changing user does not takes in account connector internal state (transaction status)
idleTimeout
Indicate idle time after which a pool connection is released. Value must be lower than . In seconds (0 means never release)
integer
1800
minimumIdle
Permit to set a minimum number of connection in pool. Recommendation is to use fixed pool, so not setting this value.
integer
set to connectionLimit value
[CONJS-97] Remove coverage comment on GitHub pull request
New Options
arrayParenthesis
Indicate if array are included in parenthesis. This option permit compatibility with version < 2.5
boolean
false
rsaPublicKey
Indicate path/content to MySQL server RSA public key. use requires Node.js v11.6+
string
cachingRsaPublicKey
Indicate path/content to MySQL server caching RSA public key. use requires Node.js v11.6+
string
CONJS-143 is a breaking change. Queries that have a IN parameter with array parameters format change. previous format did not accept parenthesis :
now, format is
same than mysql/mysql2 drivers.
previous behaviour can be reverted setting option arrayParenthesis to true.
For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.
CONJS-52 (Bug) Commit not executed when in transaction and autocommit is enabled
CONJS-50 (Bug) race condition when using authentication plugins
CONJS-21 add bulk insert method
Add connection reset
Handle multiple server pools with failover capabilities
test connector with maxscale
Permit use of connection string to provide options
Add option to permit query command when establishing a connection
For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.
node.js v12 CI testing
cluster ordered selector bug fix on failover (thanks to @kkx)
bump dependencies
documentation update with node.js v12 minimum TLSv1.2 default support
connection.reset() error message improvement (and documentation)
small performance improvement when debug not enable
Download | Release Notes | Changelog |
Release date: 2 Dec 2019
MariaDB Connector/Node.js 2.1.4 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
use pool reset only for corrected COM_RESET_CONNECTION
missing pool event definition
dependencies update
For a complete list of changes made in this release, with links to detailed information on each push, see the .
| | |
Release date: 20 Mar 2020
MariaDB Connector/Node.js 2.3.0 is a (GA) release.
For an overview of MariaDB Connector/Node.js see the page
2.3.0 has been deprecated to 2.3.1: changing new connection option timeout to queryTimeout
pool.on('connection', (conn) => console.log(`connection ${conn.threadId} has been created in pool`);
Poolconn.query('SELECT * FROM arrayParam WHERE id = ? AND val IN ?', [1, ['b', 'c']]);conn.query('SELECT * FROM arrayParam WHERE id = ? AND val IN (?)', [1, ['b', 'c']]);//query that takes more than 20s
connection
.query({sql: 'information_schema.tables, information_schema.tables as t2', timeout: 100 })
.then(...)
.catch(err => {
// SQLError: (conn=2987, no: 1969, SQLState: 70100) Query execution was interrupted (max_statement_time exceeded)
// sql: select * from information_schema.columns as c1, information_schema.tables, information_schema.tables as t2 - parameters:[]
// at Object.module.exports.createError (C:\projets\mariadb-connector-nodejs.git\lib\misc\errors.js:55:10)
// at PacketNodeEncoded.readError (C:\projets\mariadb-connector-nodejs.git\lib\io\packet.js:510:19)
// at Query.readResponsePacket (C:\projets\mariadb-connector-nodejs.git\lib\cmd\resultset.js:46:28)
// at PacketInputStream.receivePacketBasic (C:\projets\mariadb-connector-nodejs.git\lib\io\packet-input-stream.js:104:9)
// at PacketInputStream.onData (C:\projets\mariadb-connector-nodejs.git\lib\io\packet-input-stream.js:160:20)
// at Socket.emit (events.js:210:5)
// at addChunk (_stream_readable.js:309:12)
// at readableAddChunk (_stream_readable.js:290:11)
// at Socket.Readable.push (_stream_readable.js:224:10)
// at TCP.onStreamRead (internal/stream_base_commons.js:182:23) {
// fatal: true,
// errno: 1969,
// sqlState: '70100',
// code: 'ER_STATEMENT_TIMEOUT'
// }
});CONJS-127 - Resultset with same identifier skip data. Now an error will be thrown.
CONJS-126 - permit setting session query timeout per option
CONJS-124 - Force connection.escapeId to emit backtick #101
CONJS-123 - exporting SqlError class to permit instanceOf checks #100
- fix undefined localTz with timezone: 'Z' issue #92
- Connection.escapeId must always quote value to permit reserved words
misc:
appveyor testing server version upgrade
better debug logging trace format
correct ssl test
For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.
allowPublicKeyRetrieval
Indicate that if rsaPublicKey or cachingRsaPublicKey public key are not provided, if client can ask server to send public key.
boolean
false
supportBigInt
Whether resultset should return javascript ES2020 BigInt for data type. This ensures having expected value even for value > 2^53 (see range).
boolean
false
keepAliveDelay
permit to enable socket keep alive, setting delay. 0 means not enabled. Keep in mind that this don't reset server (use pool option idleTimeout for that). in ms
int
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.