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: 20 Oct 2021
MariaDB Connector/Node.js 2.5.5 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
[] Pool.query(undefined) never release connection
[] not permitting providing null as a value without an array
[] Missing leakDetectionTimeout option in Typescript description
For a complete list of changes made in this release, with links to detailed information on each push, see the .
| | |
Release date: 14 Jun 2021
MariaDB Connector/Node.js 2.5.4 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: 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: 24 Feb 2021
MariaDB Connector/Node.js 2.5.3 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
| | |
Release date: 13 Dec 2018
MariaDB Connector/Node.js 2.0.2 is a release.
For an overview of MariaDB Connector/Node.js see the page
| | |
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: 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.
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.
For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.
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
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.
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: 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: 31 Jan 2019
MariaDB Connector/Node.js 2.0.3 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
[] TypeError: Cannot read property 'totalConnections' of undefined
[] pool now throw ER_ACCESS_DENIED_ERROR in place of a basic timeout error
[] handling pipe error when streaming, avoiding hang in case of pipe error.
[] 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 .
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: 26 May 2020
MariaDB Connector/Node.js 2.4.0 is a (GA) release.
For an overview of MariaDB Connector/Node.js see the page
This version removes compatibility with Node.js 6, needing 10+ version!
| | |
Release date: 19 Nov 2019
MariaDB Connector/Node.js 2.1.3 is a (GA) release.
For an overview of MariaDB Connector/Node.js see the page
| | |
Release date: 4 Dec 2020
MariaDB Connector/Node.js 2.5.2 is a (GA) 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
| | |
Release date: 2 Jul 2020
MariaDB Connector/Node.js 2.4.1 is a (GA) release.
For an overview of MariaDB Connector/Node.js see the page
dependencies update
[CONJS-97] Remove coverage comment on GitHub pull request
CONJS-86 - Support extension type format
CONJS-128 - Error when using multipleStatements with metaAsArray
CONJS-129 - Support 10.5 pluggable type
CONJS-131 - checkDuplicate option is indicated in error when having dupplicate
CONJS-132 - performance improvement
CONJS-136 - typescript SqlError interface
For a complete list of changes made in this release, with links to detailed information on each push, see the changelog.
CONJS-109 Missing mysql only collation definition
CONJS-108 typescript escape/escapeId definition
CONJS-107 Change user callback function not called when no option is set and changing collation only if collation option is correct
CONJS-106 properly escape boolean parameter false
Typecast provided date function erroneous parsing
Pam authentication must permit to provide multiple passwords
PAM authentication with multiple steps can be achieved using password as array:
better cluster error when pool is full
adding test coverage
[CONJS-151] bulk batch error (parameter truncation) #137
[CONJS-152] correction when enabling the permitLocalInfile option and some initial commands
[CONJS-154] Timezone support correction and clarification
[CONJS-155] correction to support for node.js 10.13 to 10.19
[] Ensure setting capability PLUGIN_AUTH only if server has it
documentation improvement
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
CONJS-139 - createConnection(string)` does not support URL-encoded credentials
CONJS-140 - Support passing null values in array when doing queries. thanks to @koendeschacht
CONJS-141 - 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 changelog.
Download | Release Notes | Changelog |
Release date: 20 Mar 2020
MariaDB Connector/Node.js 2.3.0 is a Stable (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 to avoid any confusion.
- Resultset with same identifier skip data. Now an error will be thrown.
- permit setting session query timeout per option
- Force connection.escapeId to emit backtick #101
- exporting SqlError class to permit instanceOf checks #100
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 .
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 | Connector/Node.js Overview
Release date: 15 Nov 2018
MariaDB Connector/Node.js 2.0.1 is a Beta release.
For an overview of MariaDB Connector/Node.js see the page
(Bug) Commit not executed when in transaction and autocommit is enabled
(Bug) race condition when using authentication plugins
add bulk insert method
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: 25 Sep 2018
MariaDB Connector/Node.js 2.0.0 is an Alpha release.
For an overview of MariaDB Connector/Node.js see the page
: check other connections in pool when an unexpected connection error occur
: Create option to permit setting Object to one prepareStatement parameter
: Callback API is missing
: support geometric GeoJSON structure format
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: 12 Jul 2019
MariaDB Connector/Node.js 2.1.0 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-122 - fix undefined localTz with timezone: 'Z' issue #92
CONJS-121 - Connection.escapeId must always quote value to permit reserved words
[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-38 Add connection reset
CONJS-41 Handle multiple server pools with failover capabilities
CONJS-49 test connector with maxscale
CONJS-51 Permit use of connection string to provide options
CONJS-48 Add option to permit query command when establishing a connection
CONJS-24 : 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-19] Implement Ed25519 plugin
[CONJS-57] Multiple alternative authentication methods for the same user (MariaDB 10.4)
[CONJS-61] Permit handling expired password
[CONJS-85] Implement pool events according to mysql/mysql2 API
[] Array parameter automatic conversion
[] Performance improvement on decoding string
[] Charset collation option separation
[] Types definition must be string, not byte, when using the option typeCast
[] Missing import dependencies for typeScript
[] Read errors while processing LOCAL INFILE can cause a process crash
[] Add poolCluster 'remove' event
[] Option restoreNodeTimeout is not respected when removeNodeErrorCount is set
[] Setting the timezone to the current IANA might provoke the server's automatic retrieval
New Options
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
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.
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
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: 19 Oct 2020
MariaDB Connector/Node.js 2.5.0 is a Stable (GA) release.
For an overview of MariaDB Connector/Node.js see the page
- permit setting socket keep alive (option keepAliveDelay)
- Array parameter escaping differ from mysql/mysql2
- Support ES2020 BigInt object (option supportBigInt)
New Options
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.
- batch rewrite error when packet reach maxAllowedPacket
- Using callback API, batch, avoid return error if connection not established
- TypeScript type ssl wrong definitions
For a complete list of changes made in this release, with links to detailed information on each push, see the .
pool.on('connection', (conn) => console.log(`connection ${conn.threadId} has been created in pool`);
PoolCONJS-76 - Support MySQL sha256_password authentication
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 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
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
conn.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'
// }
});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.