Hi,
I hope Nuxeo team find the info helpful.
> 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?
I checked the data/hypersonic/localDB. These are the table still
using hypersonic even though it suppose to use Oracle instead:
HILOSEQUENCES
JMS_* (There are 5 JMS tables)
TIMERS
Thanks,
Brian
From: [email protected] [mailto:ecm-
[email protected]] On Behalf Of Xiang, Brian (Dean Group Inc.)
Sent: Tuesday, March 24, 2009 1:12 PM
To: [email protected]
Cc: [email protected]
Subject: Re: [Ecm] Nuxeo 5.2-m4 on Oracle
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:112)
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(WrappedStatement.java:91)
at
com.hp.hpl.jena.db.impl.SQLCache.runSQLGroup(SQLCache.java:560)
at
com
.hp
.hpl
.jena
.db
.impl
.DriverRDB.formatAndConstructSystemSpecializedGraph(DriverRDB.java:
427)
at
com
.hp
.hpl.jena.db.impl.DriverRDB.getSystemSpecializedGraph(DriverRDB.java:
305)
at
com
.hp
.hpl.jena.db.impl.DriverRDB.getDefaultModelProperties(DriverRDB.java:
835)
at
com
.hp
.hpl
.jena.db.DBConnection.getDefaultModelProperties(DBConnection.java: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(JBossOSGiAdapter.java:219)
at
org
.jboss
.system
.ListenerServiceMBeanSupport
.handleNotification(ListenerServiceMBeanSupport.java:403)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at
sun
.reflect
.DelegatingMethodAccessorImpl
.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org
.jboss
.mx
.notification
.NotificationListenerProxy.invoke(NotificationListenerProxy.java:153)
at $Proxy121.handleNotification(Unknown Source)
at
org
.jboss
.mx
.util
.JBossNotificationBroadcasterSupport
.handleNotification(JBossNotificationBroadcasterSupport.java:127)
at
org
.jboss
.mx
.util
.JBossNotificationBroadcasterSupport
.sendNotification(JBossNotificationBroadcasterSupport.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(JBossOSGiAdapter.java:219)
at
org
.jboss
.system
.ListenerServiceMBeanSupport
.handleNotification(ListenerServiceMBeanSupport.java:403)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at
sun
.reflect
.DelegatingMethodAccessorImpl
.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org
.jboss
.mx
.notification
.NotificationListenerProxy.invoke(NotificationListenerProxy.java:153)
at $Proxy121.handleNotification(Unknown Source)
at
org
.jboss
.mx
.util
.JBossNotificationBroadcasterSupport
.handleNotification(JBossNotificationBroadcasterSupport.java:127)
at
org
.jboss
.mx
.util
.JBossNotificationBroadcasterSupport
.sendNotification(JBossNotificationBroadcasterSupport.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.java:
311)
at
com
.hp
.hpl.jena.db.impl.DriverRDB.getDefaultModelProperties(DriverRDB.java:
835)
at
com
.hp
.hpl
.jena.db.DBConnection.getDefaultModelProperties(DBConnection.java: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.formatAndConstructSystemSpecializedGraph(DriverRDB.java:
477)
at
com
.hp
.hpl.jena.db.impl.DriverRDB.getSystemSpecializedGraph(DriverRDB.java:
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(JBossOSGiAdapter.java:219)
at
org
.jboss
.system
.ListenerServiceMBeanSupport
.handleNotification(ListenerServiceMBeanSupport.java:403)
at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
at
sun
.reflect
.DelegatingMethodAccessorImpl
.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org
.jboss
.mx
.notification
.NotificationListenerProxy.invoke(NotificationListenerProxy.java:153)
at $Proxy121.handleNotification(Unknown Source)
at
org
.jboss
.mx
.util
.JBossNotificationBroadcasterSupport
.handleNotification(JBossNotificationBroadcasterSupport.java:127)
at
org
.jboss
.mx
.util
.JBossNotificationBroadcasterSupport
.sendNotification(JBossNotificationBroadcasterSupport.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.java:
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-5343/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
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
