[Ecm] Set up the repository on MS SQL Server

Viktar Duzh Mon, 09 Jul 2007 05:01:01 -0700

Hi  guys,

I tried to install Nuxeo on MS SQL Server according to the instructions defined in http://doc.nuxeo.org/current/reference/html/administration.html . But I failed.

Here is just a piece of MS SQL Server specific definition (more details in attachments)

..
<!-- Workspaces configuration. Nuxeo only uses the default workspace. -->

       <Workspace name="${wsp.name}">

           <param name="path" value="${wsp.home}"/>
         </FileSystem>

             <param name="user" value="admin"/>
             <param name="password" value="admin"/>
             <param name="schema" value="mssql"/>
             <param name="schemaObjectPrefix" value="jcr_${wsp.name}_"/>
             <param name="externalBLOBs" value="false"/>
         </PersistenceManager>

           <param name="path" value="${wsp.home}/index"/>
         </SearchIndex>
       </Workspace>

       <!-- Versioning configuration. -->
       <Versioning rootPath="${rep.home}/version">

           <param name="path" value="${rep.home}/version"/>
         </FileSystem>

             <param name="user" value="admin"/>
             <param name="password" value="admin"/>
             <param name="schema" value="mssql"/>
             <param name="schemaObjectPrefix" value="jcr_ver_"/>
             <param name="externalBLOBs" value="false"/>
         </PersistenceManager>
       </Versioning>
....

The following exceptions occur:

13:01:49,620 ERROR [DatabasePersistenceManager] failed to write node state: cafebabe-cafe-babe-cafe-babecafebabe com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown Source) at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(Unknown Source)

....
       at org.jboss.Main$1.run(Main.java:464)
       at java.lang.Thread.run(Thread.java:595)

13:01:49,636 WARN [DatabasePersistenceManager] storing changes failed, about to reconnect... com.microsoft.sqlserver.jdbc.SQLServerException: String or binary data would be truncated. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source) at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown Source)

I found cafebabe-cafe-babe-cafe-babecafebabe in Jackrabbit code :-) It seems to me that Jackrabbit has not been tested on MS SQL Server yet.

I tried JTDS and Microsoft JDBC drivers and got similar results.

Regards,

-- Viktar

BTW, there is some helpfull information about configuration of SimpleDbPersistenceManager at http://jackrabbit.apache.org/api-1/org/apache/jackrabbit/core/state/db/SimpleDbPersistenceManager.html

MyRepo-repositoy-config.xml
Description: Binary data

MyPlatform-Layout-config.xml
Description: Binary data

_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm

[Ecm] Set up the repository on MS SQL Server

Reply via email to