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:[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: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
_______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
