Hi Alex,
Thanks for your reply!
I am trying to setup 5.2.0.m4 to use Oracle. Here are what I have found:
1 default-repository-config.xml looks quite different from 5.1.6. So the
document instruction has to be modified for 5.2. I added the
OraclePersistenceManager to workspace and versioning, by guessing. But
it looks working! I attached the xml file.
2 Modifying comapss.cfg.xml for Compass search, the instruction can be
be followed because there is no
system/nuxeo-platform-search-compass-plugin-5.1.6.jar. (So I skipped
this part.) The instruction also needs to be modified for 5.2.
The first time when I startup the server, I saw some error messages
related to JENA:
12:28:04,027 WARN [DriverRDB] Problem formatting database
java.sql.SQLException: ORA-00942: table or view does not exist
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:11
2)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at
oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
at
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:957)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.
java:1170)
at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:
1696)
at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1662)
at
org.jboss.resource.adapter.jdbc.WrappedStatement.execute(WrappedStatemen
t.java:91)
at
com.hp.hpl.jena.db.impl.SQLCache.runSQLGroup(SQLCache.java:560)
at
com.hp.hpl.jena.db.impl.DriverRDB.formatAndConstructSystemSpecializedGra
ph(DriverRDB.java:427)
at
com.hp.hpl.jena.db.impl.DriverRDB.getSystemSpecializedGraph(DriverRDB.ja
va:305)
at
com.hp.hpl.jena.db.impl.DriverRDB.getDefaultModelProperties(DriverRDB.ja
va:835)
at
com.hp.hpl.jena.db.DBConnection.getDefaultModelProperties(DBConnection.j
ava:195)
at
com.hp.hpl.jena.db.impl.GraphRDBMaker.consGraph(GraphRDBMaker.java:123)
at
com.hp.hpl.jena.db.impl.GraphRDBMaker.createGraph(GraphRDBMaker.java:107
)
at
com.hp.hpl.jena.rdf.model.impl.ModelMakerImpl.createModel(ModelMakerImpl
.java:47)
at
com.hp.hpl.jena.rdf.model.impl.ModelMakerImpl.createModel(ModelMakerImpl
.java:50)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.openGraph(JenaGraph.java
:288)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.openGraph(JenaGraph.java
:187)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.size(JenaGraph.java:828)
at
org.nuxeo.ecm.platform.relations.services.RelationService.frameworkEvent
(RelationService.java:514)
at
org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:200)
at
org.nuxeo.osgi.jboss.JBossOSGiAdapter.handleNotification2(JBossOSGiAdapt
er.java:219)
at
org.jboss.system.ListenerServiceMBeanSupport.handleNotification(Listener
ServiceMBeanSupport.java:403)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.jboss.mx.notification.NotificationListenerProxy.invoke(NotificationL
istenerProxy.java:153)
at $Proxy121.handleNotification(Unknown Source)
at
org.jboss.mx.util.JBossNotificationBroadcasterSupport.handleNotification
(JBossNotificationBroadcasterSupport.java:127)
at
org.jboss.mx.util.JBossNotificationBroadcasterSupport.sendNotification(J
BossNotificationBroadcasterSupport.java:110)
at
org.jboss.system.server.ServerImpl.sendNotification(ServerImpl.java:916)
at
org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:497)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
at org.jboss.Main.boot(Main.java:200)
at org.jboss.Main$1.run(Main.java:508)
at java.lang.Thread.run(Thread.java:619)
12:28:04,074 ERROR [RelationService] Error while initializing graph wiki
java.lang.RuntimeException: com.hp.hpl.jena.shared.JenaException: The
database appears to be unformatted or corrupted and
an attempt to automatically format the database has failed
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.wrapException(JenaGraph.
java:178)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.size(JenaGraph.java:833)
at
org.nuxeo.ecm.platform.relations.services.RelationService.frameworkEvent
(RelationService.java:514)
at
org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:200)
at
org.nuxeo.osgi.jboss.JBossOSGiAdapter.handleNotification2(JBossOSGiAdapt
er.java:219)
at
org.jboss.system.ListenerServiceMBeanSupport.handleNotification(Listener
ServiceMBeanSupport.java:403)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.jboss.mx.notification.NotificationListenerProxy.invoke(NotificationL
istenerProxy.java:153)
at $Proxy121.handleNotification(Unknown Source)
at
org.jboss.mx.util.JBossNotificationBroadcasterSupport.handleNotification
(JBossNotificationBroadcasterSupport.java:127)
at
org.jboss.mx.util.JBossNotificationBroadcasterSupport.sendNotification(J
BossNotificationBroadcasterSupport.java:110)
at
org.jboss.system.server.ServerImpl.sendNotification(ServerImpl.java:916)
at
org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:497)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
at org.jboss.Main.boot(Main.java:200)
at org.jboss.Main$1.run(Main.java:508)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.hp.hpl.jena.shared.JenaException: The database appears to
be unformatted or corrupted and
an attempt to automatically format the database has failed
at
com.hp.hpl.jena.db.impl.DriverRDB.getSystemSpecializedGraph(DriverRDB.ja
va:311)
at
com.hp.hpl.jena.db.impl.DriverRDB.getDefaultModelProperties(DriverRDB.ja
va:835)
at
com.hp.hpl.jena.db.DBConnection.getDefaultModelProperties(DBConnection.j
ava:195)
at
com.hp.hpl.jena.db.impl.GraphRDBMaker.consGraph(GraphRDBMaker.java:123)
at
com.hp.hpl.jena.db.impl.GraphRDBMaker.createGraph(GraphRDBMaker.java:107
)
at
com.hp.hpl.jena.rdf.model.impl.ModelMakerImpl.createModel(ModelMakerImpl
.java:47)
at
com.hp.hpl.jena.rdf.model.impl.ModelMakerImpl.createModel(ModelMakerImpl
.java:50)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.openGraph(JenaGraph.java
:288)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.openGraph(JenaGraph.java
:187)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.size(JenaGraph.java:828)
... 17 more
Caused by: com.hp.hpl.jena.db.RDFRDBException: java.sql.SQLException:
ORA-00942: table or view does not exist
at
com.hp.hpl.jena.db.impl.DriverRDB.formatAndConstructSystemSpecializedGra
ph(DriverRDB.java:477)
at
com.hp.hpl.jena.db.impl.DriverRDB.getSystemSpecializedGraph(DriverRDB.ja
va:305)
... 26 more
But when I startup the server the second time, the error messages
changed to:
12:55:49,876 INFO [RelationService] create RDF Graph wiki
12:55:50,110 ERROR [RelationService] Error while initializing graph wiki
java.lang.RuntimeException: com.hp.hpl.jena.shared.JenaException:
Database created with incompatible database type for this versio
n of Jena: Oracle
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.wrapException(JenaGraph.
java:178)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.size(JenaGraph.java:833)
at
org.nuxeo.ecm.platform.relations.services.RelationService.frameworkEvent
(RelationService.java:514)
at
org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:200)
at
org.nuxeo.osgi.jboss.JBossOSGiAdapter.handleNotification2(JBossOSGiAdapt
er.java:219)
at
org.jboss.system.ListenerServiceMBeanSupport.handleNotification(Listener
ServiceMBeanSupport.java:403)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.jboss.mx.notification.NotificationListenerProxy.invoke(NotificationL
istenerProxy.java:153)
at $Proxy121.handleNotification(Unknown Source)
at
org.jboss.mx.util.JBossNotificationBroadcasterSupport.handleNotification
(JBossNotificationBroadcasterSupport.java:127)
at
org.jboss.mx.util.JBossNotificationBroadcasterSupport.sendNotification(J
BossNotificationBroadcasterSupport.java:110)
at
org.jboss.system.server.ServerImpl.sendNotification(ServerImpl.java:916)
at
org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:497)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
at org.jboss.Main.boot(Main.java:200)
at org.jboss.Main$1.run(Main.java:508)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.hp.hpl.jena.shared.JenaException: Database created with
incompatible database type for this version of Jena: Oracle
at
com.hp.hpl.jena.db.impl.DriverRDB.checkEngine(DriverRDB.java:378)
at
com.hp.hpl.jena.db.impl.DriverRDB.getSystemSpecializedGraph(DriverRDB.ja
va:356)
at
com.hp.hpl.jena.db.DBConnection.containsModel(DBConnection.java:227)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.openGraph(JenaGraph.java
:252)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.openGraph(JenaGraph.java
:187)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.size(JenaGraph.java:828)
... 17 more
Other than that, the server is working fine on Oracle. I have two
related questions:
1) In which function area does the JENA problem affect?
2) I checked server/default/data folder, there is still hypersonic
database created. So something is still using HSQL instead of Oracle.
What is that?
Best regards,
Brian
________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of
Alexandre Russel
Sent: Monday, March 23, 2009 4:17 PM
To: Xiang, Brian (Dean Group Inc.)
Cc: [email protected]; [email protected]
Subject: Re: [Ecm] Nuxeo on Oracle
There is no any previously installed JBPM tables under NUXEO
schema. I created a completely new schema NUXEO. When Nuxeo starts, I
can see some JBPM_ tables are created, some are not. So something is not
work properly with Nuxeo/JBPM/Oracle combination.
I definitely recommend using 5.2, especially for a new project.
If you want to work with 5.1.6, you might try to run this script to
create the table:
http://www.jboss.org/community/servlet/JiveServlet/download/11155-21-534
3/oracle.create.sql
Could you confirm that you're using a plain Nuxeo (no modification) and
that you haven't change the nxworkflow-jbpm-ds.xml
If still not working and you still want 5.1.6, could you give a list of
JBPM_* tables created.
alex
<?xml version="1.0"?>
<component name="default-repository-config">
<extension target="org.nuxeo.ecm.core.repository.RepositoryService"
point="repository">
<repository name="default"
factory="org.nuxeo.ecm.core.storage.sql.coremodel.SQLRepositoryFactory">
<repository name="default">
<Workspace name="${wsp.name}">
<!--
virtual file system of the workspace:
class: FQN of class implementing the FileSystem interface
-->
<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${wsp.home}"/>
</FileSystem>
<!--
persistence manager of the workspace:
class: FQN of class implementing the PersistenceManager interface
-->
<!--
<PersistenceManager class="org.apache.jackrabbit.core.state.obj.ObjectPersistenceManager">
</PersistenceManager>
-->
<PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
<param name="driver" value="oracle.jdbc.OracleDriver"/>
<param name="url" value="jdbc:oracle:thin:@localhost:1521:lego"/>
<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>
<!--
Search index and the file system it uses.
class: FQN of class implementing the QueryHandler interface
-->
<SearchIndex class="org.apache.jackrabbit.core.query.lucene.SearchIndex">
<param name="path" value="${wsp.home}/index"/>
</SearchIndex>
</Workspace>
<!--
Configures the versioning
-->
<Versioning rootPath="${rep.home}/version">
<!--
Configures the filesystem to use for versioning for the respective
persistence manager
-->
<FileSystem class="org.apache.jackrabbit.core.fs.local.LocalFileSystem">
<param name="path" value="${rep.home}/version"/>
</FileSystem>
<!--
Configures the persistence manager to be used for persisting version state.
Please note that the current versioning implementation is based on
a 'normal' persistence manager, but this could change in future
implementations.
-->
<!--
<PersistenceManager class="org.apache.jackrabbit.core.state.obj.ObjectPersistenceManager">
</PersistenceManager>
-->
<PersistenceManager class="org.apache.jackrabbit.core.persistence.bundle.OraclePersistenceManager">
<param name="driver" value="oracle.jdbc.OracleDriver"/>
<param name="url" value="jdbc:oracle:thin:@localhost:1521:lego"/>
<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>
</Versioning>
<indexing>
<!-- for H2 (Lucene Analyzer): -->
<fulltext analyzer="org.apache.lucene.analysis.fr.FrenchAnalyzer"/>
<!-- for PostgreSQL (Text Search Configuration):
<fulltext analyzer="english"/>
-->
</indexing>
</repository>
</repository>
</extension>
</component>
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
