On 2 Jul 2007, at 17:00, Romeo Mihai DIMA wrote:
Hello,
Does anyone know if there is a guide to move nuxeo on oracle
including jackrabitt ?
Thank you
Nothing in the Nuxeo Book yet for lack of time, but here's a quick
HOWTO:
- in Oracle, create a user nuxeo with password nuxeo (or adapt :))
- download "jdbc thin" driver from
http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/
htdocs/jdbc_10201.html
file ojdbc14.jar and put it in jboss/server/default/lib
- change all datasources to:
<connection-url>
jdbc:oracle:thin:@172.16.245.129:1521:
</connection-url>
<driver-class>oracle.jdbc.OracleDriver</driver-class>
<user-name>nuxeo</user-name>
<password>nuxeo</password>
(with proper IP of course)
1521 is the default Oracle port
The last empty component after the port is the "sid", leaving it
empty seems to work for me.
- change config/sql.properties to:
org.nuxeo.ecm.sql.jena.databaseType=Oracle
- change compass config:
in nuxeo.ear/platform/nuxeo-platform-search-compass-plugin-5.1-
SNAPSHOT.jar/compass.cfg.xml
dialectClass="org.apache.lucene.store.jdbc.dialect.OracleDialect"
- change the Jackrabbit config in config/default-repository-config.xml:
<PersistenceManager
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
<param name="driver" value="oracle.jdbc.OracleDriver"/>
<param name="url"
value="jdbc:oracle:thin:@172.16.245.129:1521:"/>
<param name="user" value="nuxeo"/>
<param name="password" value="nuxeo"/>
<param name="schema" value="oracle"/>
<param name="schemaObjectPrefix" value="jcr_${wsp.name}_"/>
<param name="externalBLOBs" value="false"/>
</PersistenceManager>
and for versions:
<PersistenceManager
class="org.apache.jackrabbit.core.state.db.SimpleDbPersistenceManager">
<param name="driver" value="oracle.jdbc.OracleDriver"/>
<param name="url"
value="jdbc:oracle:thin:@172.16.245.129:1521:"/>
<param name="user" value="nuxeo"/>
<param name="password" value="nuxeo"/>
<param name="schema" value="oracle"/>
<param name="schemaObjectPrefix" value="jcr_ver_"/>
<param name="externalBLOBs" value="false"/>
</PersistenceManager>
Florent
--
Florent Guillaume, Director of R&D, Nuxeo
Open Source Enterprise Content Management (ECM)
http://www.nuxeo.com http://www.nuxeo.org +33 1 40 33 79 87
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
