Hi all,
I can confirm that with MS SQL 2005, the Nuxeo Repository works ok, if
you use
the persistence manager :
org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager.
Here a sample config :
...
<PersistenceManager
class="org.apache.jackrabbit.core.persistence.bundle.MSSqlPersistenceManager">
<param name="driver"
value="com.microsoft.sqlserver.jdbc.SQLServerDriver"></param>
<param name="url"
value="jdbc:sqlserver://127.0.0.1:1433;databaseName=Nuxeo5;integratedSecurity=false;"></param>
<param name="user" value="sa"></param>
<param name="password" value="password"></param>
<param name="schema" value="mssql"></param>
<param name="schemaObjectPrefix" value="jcr_${wsp.name
<http://wsp.name>}_"></param>
....
Tiry
Olivier Grisel a écrit :
> 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
>
>
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
