Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>My understanding of the JobStoreCMT is that you declare all of your transactions using the classes in System.Transactions namespace that was introduced in .NET 2.0. Fortunately NHibernate operates well with these transactions as well, so you would put your Quartz operations and NHibernate operations in a single TransactionScope, like the following:</p> <pre><code>using (var ts = new TransactionScope()) { // do something with your scheduler here, eg _scheduler.ScheduleJob(someJobDetail, someTrigger); // create an NHibernate session that will be part of the same transaction using (var session = _sessionFactory.OpenSession()) { // perform actions on session here, but do *not* make use of // NHibernate transaction methods, such as ISession.BeginTransaction(), // because the transaction is controlled via the TransactionScope instance. } ts.Complete(); } </code></pre> <p>The code above assumes that elsewhere the following vars are declared and initialized:</p> <pre><code>Quartz.IScheduler _scheduler; NHibernate.ISessionFactory _sessionFactory; </code></pre> <p>The above code sample is not packed with detail, but this is the general idea.</p> <p>One problem you may run into is that the above code will require a distributed transaction because the Quartz JobStoreCMT class creates one database connection, and the NHibernate session creates another database connection. Although it is possible (with SQL Server, at least) to have two different database connections share the same transaction, my understanding is that the current implementation of System.Transactions will upgraded the transaction to a distributed transaction with the opening of the second connection. This will have a significant effect on performance as a distributed transaction is significantly slower than a simple transaction.</p>
    singulars
    1. This table or related slice is empty.
    1. POIntegrate Quartz .NET with NHibernate
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USJohn Jeffery
    1. USJohn Jeffery
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIntegrate Quartz .NET with NHibernate
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
 

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