sqlssb's Introduction

sqlssb

SQL Server Service Broker client for Node.js

Using

const Sqlssb = require('sqlssb')
const service1 = new Sqlssb({
  user: 'sa',
  password: '<PASSOWRD>',
  server: 'localhost',
  database: 'sqlssbb',
  service: 'sqlssb-demo-sample-service',
  queue: 'sqlssb-demo-sample-queue'
})

service1.on('sqlssb-demo-message-type', ctx => {
  console.log(ctx.conversationId);
  console.log(ctx.messageBody);
  console.log(ctx.messageTypeName);
  console.log(ctx.messageSequenceNumber);
  console.log(ctx.serviceName);
})

service1.start({ //default settings:
  timeout: 5000, //5 seconds
  count: 1 //one message at a time
})

Examples

See demo folder for more examples.

Development

To setup / reset demo stuff:

sqlcmd -S localhost -U sa -P Sqlssb01 -i demo/reset.sql

Tests:

npm test

sqlssb's People

Contributors

Stargazers

Watchers

sqlssb's Issues

Change default port

Yo,

First of all, thank you for this awesome work.

I juste want to say that it will be more useful to be able to change the default broker port.

Thank you

database disconnects are not handled

I have not found a way to catch and handle ECONNRESET errors from the tedious library in sqlssb
This happens when the database restarts or the network connection between the server and database drops or any reason why SQL Server may disconnect clients.

Does this exist and I do not see it?
Does it not yet exist?

demo not working

I setup the demo and configured the database properly but the messages don't appear to be received. Is there a good way to check in the database that a message was sent?

Recommend Projects