I've been trying the solutions I found in previous posts but still could not
find out how to adjust Nuxeo to start working with Oracle 11g
This is what I am doing.
1) I added
<property name="hibernate.dialect"
value="org.hibernate.dialect.Oracle10gDialect"/>
to
nuxeo-distribution-jboss-5.3.0\server\default\deploy\nuxeo.ear\system\nuxeo-platform-placeful-facade-5.3.0.jar\OSGI-INF\persistence.xml
file
2) Also I added
hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
to the
nuxeo-distribution-jboss-5.3.0\server\default\deploy\ejb3.deployer\META-INF\persistence.properties
3) my unified-nuxeo-ds.xml looks as follows
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>NuxeoDS</jndi-name>
<connection-url>jdbc:oracle:thin:@localhost:1521:NUXEO</connection-url>
<driver-class>oracle.jdbc.OracleDriver</driver-class>
<user-name>nuxeo</user-name>
<password>nuxeo</password>
</local-tx-datasource>
</datasources>
4) default-repository-ds.xml looks as follows
<?xml version="1.0"?>
<connection-factories>
<tx-connection-factory>
<jndi-name>NXRepository/default</jndi-name>
<xa-transaction/>
<track-connection-by-tx/>
<adapter-display-name>Nuxeo SQL Repository DataSource</adapter-display-name>
<rar-name>nuxeo.ear#nuxeo-core-storage-sql-ra-1.6.0.rar</rar-name>
<connection-definition>org.nuxeo.ecm.core.storage.sql.Repository</connection-definition>
<config-property name="name">default</config-property>
<config-property name="xaDataSource"
type="java.lang.String">oracle.jdbc.xa.client.OracleXADataSource</config-property>
<config-property name="property"
type="java.lang.String">URL=jdbc:oracle:thin:@localhost:1521:NUXEO</config-property>
<config-property name="property"
type="java.lang.String">User=nuxeo</config-property>
<config-property name="property"
type="java.lang.String">Password=nuxeo</config-property>
<max-pool-size>20</max-pool-size>
<isSameRM-override-value>false</isSameRM-override-value>
<!-- Oracles XA datasource cannot reuse a connection outside a transaction
once enlisted in a global transaction and vice-versa -->
<no-tx-separate-pools></no-tx-separate-pools>
</tx-connection-factory>
</connection-factories>
Still jboss is giving me "unknown Oracle major version [11]"
and also some other errors saying "The database appears to be unformatted or
corrupted and
an attempt to automatically format the database has failed
16:15:20,953 ERROR [ComponentManager] Failed to create contribution objects
java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at
org.nuxeo.common.xmap.XMethodAccessor.setValue(XMethodAccessor.java:47)
at
org.nuxeo.common.xmap.XAnnotatedMember.setValue(XAnnotatedMember.java:68)
at
org.nuxeo.common.xmap.XAnnotatedMember.process(XAnnotatedMember.java:95)
at
org.nuxeo.common.xmap.XAnnotatedObject.newInstance(XAnnotatedObject.java:77)
at org.nuxeo.common.xmap.XMap.loadAll(XMap.java:454)
at org.nuxeo.common.xmap.XMap.loadAll(XMap.java:460)
at org.nuxeo.common.xmap.XMap.loadAll(XMap.java:410)
at
org.nuxeo.runtime.model.impl.ExtensionPointImpl.loadContributions(ExtensionPointImpl.java:96)
at
org.nuxeo.runtime.model.impl.ComponentManagerImpl.loadContributions(ComponentManagerImpl.java:452)
at
org.nuxeo.runtime.model.impl.ComponentManagerImpl.registerExtension(ComponentManagerImpl.java:391)
at
org.nuxeo.runtime.model.impl.RegistrationInfoImpl.activate(RegistrationInfoImpl.java:283)
at
org.nuxeo.runtime.model.impl.RegistrationInfoImpl.resolve(RegistrationInfoImpl.java:347)
at
org.nuxeo.runtime.model.impl.ComponentManagerImpl._register(ComponentManagerImpl.java:200)
at
org.nuxeo.runtime.model.impl.ComponentManagerImpl._register(ComponentManagerImpl.java:214)
at
org.nuxeo.runtime.model.impl.ComponentManagerImpl.register(ComponentManagerImpl.java:145)
at
org.nuxeo.runtime.osgi.OSGiRuntimeService.deployFrameworkStartedComponent(OSGiRuntimeService.java:446)
at
org.nuxeo.runtime.osgi.OSGiRuntimeService.frameworkEvent(OSGiRuntimeService.java:402)
at org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:203)
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 $Proxy64.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: org.hibernate.HibernateException: unknown Oracle major version [11]
at
org.hibernate.dialect.DialectFactory$1.getDialectClass(DialectFactory.java:136)
at
org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:65)
at
org.nuxeo.ecm.directory.sql.SQLDirectory.buildDialect(SQLDirectory.java:313)
at org.nuxeo.ecm.directory.sql.SQLDirectory.<init>(SQLDirectory.java:90)
at
org.nuxeo.ecm.directory.sql.SQLDirectoryProxy.getDirectory(SQLDirectoryProxy.java:50)
at
org.nuxeo.ecm.directory.sql.SQLDirectoryProxy.getSchema(SQLDirectoryProxy.java:67)
at
org.nuxeo.ecm.webapp.directory.DirectoryTreeDescriptor.setDirectories(DirectoryTreeDescriptor.java:104)
... 37 more
16:15:20,968 INFO [OSGiRuntimeService] Nuxeo EP Started
======================================================================
= Nuxeo EP Started
======================================================================
= Component Loading Status: Pending: 0 / Unstarted: 0 / Total: 329
======================================================================
16:15:20,968 INFO [RelationService] Relation Service initialization
16:15:20,968 INFO [RelationService] create RDF Graph publication
16:15:21,859 ERROR [RelationService] Error while initializing graph publication
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:172)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.size(JenaGraph.java:825)
at
org.nuxeo.ecm.platform.relations.services.RelationService.frameworkEvent(RelationService.java:476)
at org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:203)
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 $Proxy64.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:280)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.openGraph(JenaGraph.java:181)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.size(JenaGraph.java:820)
... 17 more
Caused by: com.hp.hpl.jena.db.RDFRDBException: Exception when checking for
database lock -
com.hp.hpl.jena.db.RDFRDBException: Internal error in driver - database not
locked for cleaning.
at com.hp.hpl.jena.db.impl.DriverRDB.doCleanDB(DriverRDB.java:1002)
at
com.hp.hpl.jena.db.impl.DriverRDB.getSystemSpecializedGraph(DriverRDB.java:303)
... 26 more
16:15:21,859 INFO [RelationService] create RDF Graph versionned-annotation
16:15:22,015 ERROR [RelationService] Error while initializing graph
versionned-annotation
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:172)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.size(JenaGraph.java:825)
at
org.nuxeo.ecm.platform.relations.services.RelationService.frameworkEvent(RelationService.java:476)
at org.nuxeo.osgi.OSGiAdapter.fireFrameworkEvent(OSGiAdapter.java:203)
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 $Proxy64.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:280)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.openGraph(JenaGraph.java:181)
at
org.nuxeo.ecm.platform.relations.jena.JenaGraph.size(JenaGraph.java:820)
... 17 more
Is anyone here who uses Oracle 11g with Nuxeo? What am I doing wrong?
Thanks in advance
--
Posted by "JumpAround" at Nuxeo Discussions <http://nuxeo.org/discussions>
View the complete thread:
<http://www.nuxeo.org/discussions/thread.jspa?threadID=3557#10936>
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
