Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I've seen MSMQ used transactionally and it didn't seem particularly complicated - a Transaction SCope wrapped the enqueue or dequeue calls along with database access and all was well as long as the queue was defined as transactional once it was created. I don't think this is true with ActiveMQ, which is a message broker, but MSMQ is installed locally on each endpoint machine so getting an item transactionally into the queue doesn't require a fancy distributed transaction.</p> <p>You are probably already be aware of this, but on .NET there are a few lightweight libraries that provide some nice abstractions over MSMQ (and theoretically other transports as well)</p> <p>nServiceBus : <a href="http://www.nservicebus.com" rel="nofollow noreferrer">www.nservicebus.com</a></p> <p>Mass Transit : <a href="http://code.google.com/p/masstransit/" rel="nofollow noreferrer">http://code.google.com/p/masstransit/</a></p> <p>Also, Oren Eini has an interesting if experimental file system based, transactional queue. The benefit of this library is that, unlike MSMQ, it can be deployed as a library and does not require the maintenance headache of deploying MSMQ.</p> <p>You can read about that here: <a href="http://ayende.com/Blog/archive/2008/08/01/Rhino.Queues.Storage.Disk.aspx" rel="nofollow noreferrer">http://ayende.com/Blog/archive/2008/08/01/Rhino.Queues.Storage.Disk.aspx</a></p> <p>Also, SQL Server 2005 does handle queuing fairly elegantly, using SQL Server Service Broker, but you'll need SQL Server installed at each endpoint, and I don't know if SSB crosses the firewall.</p> <p>Finally, if you don't get the answer you're looking for here I highly recommend the nSErviceBus discussion forum. Udi Dahan answers these kinds of questions along with his small band of message oriented followers, and it is the best resource I have found so far to get my queue oriented questions answered quickly and competently. That forum is here: <a href="http://tech.groups.yahoo.com/group/nservicebus/" rel="nofollow noreferrer">http://tech.groups.yahoo.com/group/nservicebus/</a></p>
    singulars
    1. This table or related slice is empty.
    1. POTransactional queueing/dequeueing
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USNathan
    1. USNathan
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTDownMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COSSB uses endpoints that are configured to use a UDP port. So the firewall can be configured to match
      singulars
      1. PO
      1. USSimon Munro
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload