I have been working on changing the default repository config to work with
Microsoft SQL. I believe my configuration is correct:
<!-- Workspaces configuration. Nuxeo only uses the default workspace. -->
(...)
<PersistenceManager
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
<param name="driver" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<param name="url" value="jdbc:microsoft:sqlserver://localhost/nuxeo"/>
<param name="user" value="sa"/>
<param name="password" value="xxxxxx"/>
<param name="schema" value="mssql"/>
<param name="schemaObjectPrefix" value="jcr_${wsp.name}_"/>
<param name="externalBLOBs" value="true"/>
</PersistenceManager>
(...)
<!-- Versioning configuration. -->
(...)
<PersistenceManager
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
<param name="driver" value="com.microsoft.jdbc.sqlserver.SQLServerDriver"/>
<param name="url" value="jdbc:microsoft:sqlserver://localhost/nuxeo"/>
<param name="user" value="sa"/>
<param name="password" value="xxxxxx"/>
<param name="schema" value="mssql"/>
<param name="schemaObjectPrefix" value="jcr_ver_"/>
<param name="externalBLOBs" value="true"/>
</PersistenceManager>
Also I added the 3 JDBC lib files to the nuxeo /lib path (downloaded from
microsoft)
the next step in the guide is "Create the database in the database server,
enable IP connection, setup permissions and test the connection"
Can someone explain what needs to be done next and let me know if my
configuration is correct for ms sql?
Thanks
Joe
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
