Added by Bart van der Schans, last edited by Bartosz Oudekerk on May 28, 2008
()
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