Skip to content

v2.0.15

Choose a tag to compare

@TimelordUK TimelordUK released this 17 Apr 16:53
· 1382 commits to master since this release
  1. add binary support for node v16
  2. #203

stored proc call via a pool or connection

see unit tests for sproc or samples\javascript\procedure.js

// connectionProxy can be a pool or connection
const q = connectionProxy.callproc(spName, o, (err, results, output, more) => { })
javascript git(master) node .\procedure.js
Debugger attached.
asConnection 1000 invocations, elapsed = 1427, res length=1000
pool opened : {
    "floor": 0,
    "ceiling": 5,
    "heartbeatSecs": 20,
    "heartbeatSql": "select @@SPID as spid",
    "inactivityTimeoutSecs": 60,
    "connectionString": "Driver={ODBC Driver 17 for SQL Server};Server=(localdb)\\node;Database=scratch;Trusted_Connection=yes;"
}
asPool [5] 1000 invocations, elapsed = 230, res length=1000
done
Waiting for the debugger to disconnect...