SHARE
TWEET

defaul-sql-directories-bundle.xml

a guest Dec 6th, 2011 118 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?xml version="1.0"?>
  2.  
  3. <component name="org.nuxeo.ecm.directory.sql.storage">
  4.  
  5.   <implementation class="org.nuxeo.ecm.directory.sql.SQLDirectoryDescriptor" />
  6.  
  7.   <require>org.nuxeo.ecm.directory.sql.SQLDirectoryFactory</require>
  8.  
  9.   <extension target="org.nuxeo.ecm.directory.sql.SQLDirectoryFactory"
  10.    point="directories">
  11.  
  12. <directory name="userDirectory">
  13.  
  14.       <schema>user</schema>
  15.  
  16.       <dataSource>jdbc/nxsqldirectory</dataSource>
  17.  
  18.       <table>users</table>
  19.       <idField>username</idField>
  20.       <passwordField>password</passwordField>
  21.       <passwordHashAlgorithm>SSHA</passwordHashAlgorithm>
  22.       <autoincrementIdField>false</autoincrementIdField>
  23.       <dataFile>users.csv</dataFile>
  24.       <createTablePolicy>on_missing_columns</createTablePolicy>
  25.       <querySizeLimit>50</querySizeLimit>
  26.  
  27.       <references>
  28.         <inverseReference field="groups" directory="groupDirectory"
  29.          dualReferenceField="members" />
  30.       </references>
  31.  
  32.     </directory>
  33.  
  34.     <directory name="groupDirectory">
  35.  
  36.       <schema>group</schema>
  37.       <dataSource>jdbc/nxsqldirectory</dataSource>
  38.       <table>groups</table>
  39.       <idField>groupname</idField>
  40.       <dataFile>groups.csv</dataFile>
  41.       <createTablePolicy>on_missing_columns</createTablePolicy>
  42.       <autoincrementIdField>false</autoincrementIdField>
  43.  
  44.       <!-- Add 10 min cache to avoid refetching the groups during login -->
  45.       <cacheTimeout>360</cacheTimeout>
  46.       <cacheMaxSize>1000</cacheMaxSize>
  47.  
  48.       <references>
  49.         <tableReference field="members" directory="userDirectory"
  50.          table="user2group" sourceColumn="groupId" targetColumn="userId" schema="user2group"
  51.          dataFile="user2group.csv" />
  52.         <!-- Warning ! From Nuxeo 5.3.1, a wrong setting has been fixed. See
  53.        http://jira.nuxeo.org/browse/NXP-4401 . Nuxeo upgrades would need a fix in the
  54.        database (inverting parentGroupId and childGroupId in the group2group)  -->
  55.         <tableReference field="subGroups" directory="groupDirectory"
  56.          table="group2group" sourceColumn="parentGroupId"
  57.          targetColumn="childGroupId" schema="group2group" />
  58.         <inverseReference field="parentGroups" directory="groupDirectory"
  59.          dualReferenceField="subGroups" />
  60.       </references>
  61.  
  62.     </directory>
  63.  
  64.   </extension>
  65. </component>
  66.  
  67.  
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top