Node-MSSQL查询事务

Question

我在使用节点MsSQL库https://www.npmjs.com/package/mssql成功完成数据库事务时遇到了问题。一切似乎都在执行，然而，我没有收到任何数据到我的数据库。非常感谢您的帮助，谢谢！

    # Create connection
config =
    user: ''
    password: ''
    server: ''
    database: ''

connection = new sql.Connection(config)

# Send to table
sendData = (a, b, dsHost, dsUsername, dsSessionname, dsMode, dsRemotelocation, dsSessionactivity, dsActivityduration) ->
    transaction = new sql.Transaction(connection)
    transaction.begin (err) ->
        if err
            console.log err
        else
            request = new sql.Request(transaction)
            request.query "INSERT INTO dbo.sessionManager SET host=?, username=?, sessionname=?, mode=?, remotelocation=?, sessionactivity=?, activityduration=?", [dsHost, dsUsername, dsSessionname, dsMode, dsRemotelocation, dsSessionactivity, dsActivityduration], (err, recordset) ->
                transaction.commit (err, recordset) ->
                    if err
                        throw err

根据具体情况，sendData()可能会被调用一次或一千次。

Answer 1

request = new sql.Request(transaction)
request.query "INSERT INTO dbo.sessionManager SET host=?, ...], (err, recordset) ->
   // I think that your query is incorrect, e.g. by db constraints.
   // So you need check err here.
   transaction.commit (err, recordset) ->
       if err
          throw err