Added by Bart van der Schans, last edited by Bartosz Oudekerk on May 28, 2008  (view change)

Labels:

repository repository Delete
mssql mssql Delete
store store Delete
slide slide Delete
configuration configuration Delete
database database Delete
Enter labels to add to this page:
Wait Image 
Looking for a label? Just start typing.

NOTE: This works with MSSQL 2000 and 2005

Sample of a definition.xml for MSSQL:

<?xml version="1.0"?>
<definition>
  <store name="default">
    <parameter name="tlock-timeout">120</parameter>
    <parameter name="cache-mode">full</parameter>
    <parameter name="object-cache-size">1000</parameter>
    <parameter name="permission-cache-size">1000</parameter>
    <parameter name="lock-cache-size">100</parameter>

    <parameter name="descriptors-cache-size">10000</parameter>
    <parameter name="descriptor-cache-size">10000</parameter>
    <parameter name="content-cache-size">10000</parameter>
    <parameter name="enable-content-caching">false</parameter>
    <parameter name="tx-content-cache-size">1000</parameter>
    <parameter name="content-cache-bytes">10000000</parameter>

    <parameter name="tx-content-cache-bytes">1000000</parameter>
    <parameter name="max-content-bytes-per-entry">50000</parameter>

    <parameter name="basicQueryClass">org.apache.slide.search.basic.LuceneBasicQuery</parameter>
    <parameter name="basicQueryEnvelopeClass">org.apache.slide.search.basic.LuceneBasicQueryEnvelope</parameter>

    <nodestore classname="org.apache.slide.store.impl.rdbms.JDBCStore">
      <parameter name="adapter">nl.hippo.slide.store.impl.rdbms.SQLServerRDBMSAdapter</parameter>
      <parameter name="driver">net.sourceforge.jtds.jdbc.Driver</parameter>
      <parameter name="url">jdbc:jtds:sqlserver://127.0.0.1;databaseName=slide_default</parameter>
      <parameter name="user">username</parameter>
      <parameter name="password">password</parameter>
      <parameter name="dbcpPooling">true</parameter>
      <parameter name="dbcp.testWhileIdle">true</parameter>
      <parameter name="dbcp.timeBetweenEvictionRunsMillis">900000</parameter>
      <parameter name="dbcp.validationQuery">SELECT 1</parameter>
      <parameter name="dbcp.maxActive">20</parameter>
      <parameter name="isolation">READ_COMMITTED</parameter>
      <parameter name="compress">false</parameter>
      <parameter name="use-rdbms-expression-factory">true</parameter>
      <parameter name="tlock-timeout">120</parameter>
    </nodestore>
    <contentstore>
      <reference store="nodestore"/>
      <parameter name="tlock-timeout">120</parameter>
    </contentstore>

    <securitystore>
      <reference store="nodestore"/>
    </securitystore>
    <lockstore>
      <reference store="nodestore"/>
    </lockstore>
    <revisiondescriptorsstore>
      <reference store="nodestore"/>
    </revisiondescriptorsstore>

    <revisiondescriptorstore>
      <reference store="nodestore"/>
    </revisiondescriptorstore>
  </store>
  <scope match="/" store="default"/>
</definition>
  • Create the database and user with your favorite tool
  • The following script can be used to setup the table structure: (MSSQL_CreateDatabases.sql)

Don't forget to:

  • Add the jtds jdbc connector
  • Adapt the build.properties when using MSSQL (for the jtds driver)
  • Make sure the MSSQL user can connect to the database from the repository server