Joe a écrit :
> 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?
According to your file you need to create a database 'nuxeo' owned by the user
'sa' and ensure you can actually connect yourself with that user credentials on
that database with some MSSQL client (I don't know any of them) on the default
MSSQL port from the machine you will run Nuxeo EP on.
The needed tables will be created at first Nuxeo EP start provided the
connection parameters are alright.
You should also try with
org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager wich is
likely to give you a 100% performance boost over SimpleDbPersistenceManager.
http://jackrabbit.apache.org/api/1.3/org/apache/jackrabbit/core/persistence/bundle/MSSqlPersistenceManager.html
--
Olivier
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
