If error occurred when transaction rollbacking

[purejs]

See your doc https://github.com/felixge/node-mysql#transactions。
I'm wondering how can I catch the error of rollbacking.
Or can you promise there is no error anymore when rollbacking?

[dougwilson]

The example doesn't show, yes, but everything provides an error, so you could get the error from the rollback itself using

connection.rollback(function(err) {
})

[purejs]

ok, btw, if the connection created from a pool, after the transaction is commited, should I call connection.release() to return this connection? or the commit method implicit the action of release?

[dougwilson]

If you call pool.getConnection(function (err, conn) {}), you must always call conn.release() exactly once on the conn; there are no exceptions :) This makes the API easy to understand when you should call it: always :)

[purejs]

got it :)