How to configure Nuxeo with Oracle and SQLBinaryManager

martin_ — Thu, 08 Jan 2015 14:32:29 GMT

Hello,

I'm evaluating Nuxeo 6.0 for possible future usage in my company.

I already managed to set up Nuxeo with metadata stored in Oracle. This works fine, even if I get lots of type mismatch errors in server.log like ERROR [localhost-startStop-1] [org.nuxeo.ecm.core.storage.sql.jdbc.JDBCMapper] SQL type mismatch for "HIERARCHY"."NAME": expected 12, database has -9 / NVARCHAR2 (2000), but this is not my question yet.

As a special requirement document data has to be stored in Oracle database, too. I found this link to SQLBinaryManager at http://doc.nuxeo.com/display/NXDOC/VCS bottom. I tried to install that into Nuxeo as a local package but didn't work. I assume, it is already part of default Nuxeo and only has to be activated. I continued to follow the instructions, but didn't work. Then I recognized that nuxeo.templates value is not empty but oracle and nuxeo.templates.includes value is not empty but common. So I append special settings and ended up with ERROR [localhost-startStop-1] [org.nuxeo.common.xmap.XValueFactory] Cannot load class: org.nuxeo.ecm.core.storage.sql.SQLBinaryManager.

This is my (nonworking) nuxeo.conf belonging to this:

nuxeo.templates=oracle,custom
nuxeo.template.includes=common,C:/nuxeo/templates/custom/nxserver/config/default-repository-config.xml

and default-repository-config.xml

<?xml version="1.0"?>
<component name="default-repository-config">
<extension target="org.nuxeo.ecm.core.storage.sql.RepositoryService" point="repository">
<repository name="default"
factory="org.nuxeo.ecm.core.storage.sql.ra.PoolingRepositoryFactory">
<pool minPoolSize="0" maxPoolSize="20"
blockingTimeoutMillis="100" idleTimeoutMinutes="10" />
<clustering enabled="false" delay="1000" />
<binaryStore path="" />
<noDDL>false</noDDL>
<aclOptimizations enabled="true"/>
<pathOptimizations enabled="true"/>
<idType>varchar</idType>
<indexing>
<fulltext disabled="false">
<index name="default">
<!-- all props implied -->
</index>
<index name="title">
<field>dc:title</field>
</index>
<index name="description">
<field>dc:description</field>
</index>
</fulltext>
<!--
For Oracle (Oracle Text indexing parameters):
<fulltext analyzer="LEXER MY_LEXER"/>
See doc at:
http://jira.nuxeo.org/browse/NXP-4035
http://download.oracle.com/docs/cd/B19306_01/text.102/b14218/cdatadic.htm
-->
</indexing>
<usersSeparator key="|" />
<binaryManager class="org.nuxeo.ecm.core.storage.sql.SQLBinaryManager"
key="datasource=jdbc/binaries,table=binaries,cachesize=10MB" />
</repository>
</extension>
</component>

Can somebody give me a proper configuration?

Thanks in advance

Re: How to configure Nuxeo with Oracle and SQLBinaryManager

Florent_Guillau — Fri, 09 Jan 2015 10:54:40 GMT

No, nuxeo-core-binarymanager-sql is not part of the standard Nuxeo distribution. You have to install the JAR yourself in your Nuxeo instance (in nxserver/bundles).

Re: How to configure Nuxeo with Oracle and SQLBinaryManager

martin_ — Fri, 09 Jan 2015 12:34:50 GMT

Hello Florent,

thanks for yuor quick response! I am only able to find java source code, no jar. I am not a java developer, nor do I have a java developing environment. A jar contains compiled java code, right? I have no idea how to create that jar from source code. Pls can you

give me command lines to create that jar using javac - or
point me to where to download that jar (much easier!) - or
put that jar as an addon to the marketplace (easiest)?

Thanks!

Re: How to configure Nuxeo with Oracle and SQLBinaryManager

Thierry_Martins — Wed, 14 Jan 2015 22:59:47 GMT

you can find almost any Nuxeo artifacts in our Nexus repository.

topic Re: How to configure Nuxeo with Oracle and SQLBinaryManager in Nuxeo Forum

How to configure Nuxeo with Oracle and SQLBinaryManager

Re: How to configure Nuxeo with Oracle and SQLBinaryManager

Re: How to configure Nuxeo with Oracle and SQLBinaryManager

Re: How to configure Nuxeo with Oracle and SQLBinaryManager