I have the following configuration:

<store name="mssql">
  <!-- using JDBCStore with SQLServer adapter -->
  ...
</store>

<store name="users">
  <!-- stores using the same configuration as the mssql store -->
  ...
</store>

<scope match="/users" store="users" />
<scope match="/" store="mssql"/>


Correct me if I'm wrong.  Currently, Slide will start a new transaction when it
encounters a new node store.  So, when Slide initializes the Domain and starts
loading data definition from Domain.xml, it creates object nodes from "/" using
transaction #1.  When subject nodes are read, Slide sees that the "users" store
is currently from the current "mssql" store, it starts another transaction #2.
Deadlock occurs because transaction #1 locks many database objects that
transaction #2 needs to access.

The above sample Domain.xml is to reproduce the problem.

My real life example is below.  I have good reason for the 2 stores having the
same rdbms resource.  I just want the nodes coming from LDAP while others coming
from database.

<store name="useres">
  <nodestore>
     <!-- connect to LDAP -->
  </nodestore>
  <!-- other stores using the same configuration as the mssql store -->
  ...
</store>



--
Willie Vu
Center for Enhanced Learning and Teaching
Hong Kong University of Science and Technology
(O) +852 2358 8926
(F) +852 2358 2201
mailto:[EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to