Property 'releaseConnection' does not exist on type 'Pool'.

[amirhossein-karimi]

Hi,

I use the connection pool and according to the documentation, when I release it (connection), I face the following problem .
Property 'releaseConnection' does not exist on type 'Pool'.

notes : i used typescript

and this is my code
pool.getConnection(function (err, conn) { // Do something with the connection conn.query("CREATE DATABASE IF NOT EXISTS zxc CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;", (err, rows, fields) => { if (err) throw err; }); pool.releaseConnection(conn); })

[jake-knerr]

I am having the same problem. I am using conn.release() instead.

[JiaJiaJiang]

The doc here is wrong, please fix it.
The correct one is conn.release, not pool.releaseConnection

[wellwelwel]

@JiaJiaJiang, the documentation is correct.

The releaseConnection is used as a method from the pool, like:

pool.getConnection((err, conn) => {
  pool.releaseConnection(conn);
});

The release is used as a method of the connection from pool, like:

pool.getConnection((err, conn) => {
  conn.release();
});

---

In fact, the type releaseConnection is missing in Pool.

[wellwelwel]

@amirhossein-karimi and @jake-knerr, can you check this in ^3.3.4 version?

[wellwelwel]

After version ^3.3.4, you can follow this example for releaseConnection:

node-mysql2/test/tsc-build/mysql/createPool/callbacks/releaseConnection.ts

Lines 4 to 8 in 00508c3

	const pool = mysql.createPool(access);
	pool.getConnection((_err, conn) => {
	pool.releaseConnection(conn);
	});

And for release:

node-mysql2/test/tsc-build/mysql/createPool/callbacks/release.ts

Lines 4 to 7 in 00508c3

	const pool = mysql.createPool(access);
	pool.getConnection((_err, conn) => {
	conn.release();

---

I'm closing this Issue, but feel free to ask anything 🙋🏻‍♂️