Hi
I am trying out Nuxeo 5.4 with oracle,Oracle listener is working and
I am able to loginto the oracle server using user nuxeo with password
nuxeo
I have copied the oraclejdbc driver to the "
/opt/nuxeo-dm-5.4.0.1-jboss/server/default/lib/"
"ls /opt/nuxeo-dm-5.4.0.1-jboss/server/default/lib/" shows
derby-10.5.3.0_1.jar mysql-connector-java-5.1.6.jar
orai18n.jar
logging-monitor-5.1.0.GA.jar
nuxeo-generic-wss-front-5.4.0.1.jar postgresql-9.0-801.jdbc4.jar
cat
/opt/nuxeo-dm-5.4.0.1-jboss/server/default/deploy/nuxeo.ear/hibernate.properties
hibernate.default_schema=nuxeo
cat
/opt/nuxeo-dm-5.4.0.1-jboss/server/default/deploy/nuxeo.ear/config/sql.properties
# Jena database type and transaction mode
org.nuxeo.ecm.sql.jena.databaseType=Oracle
cat /opt/nuxeo-dm-5.4.0.1-jboss/bin/nuxeo.conf contains database
setttings such as
# Database configuration
nuxeo.db.name=orcl
nuxeo.db.user=nuxeo
nuxeo.db.password=nuxeo
nuxeo.db.host=localhost
nuxeo.db.port=1521
nuxeo.db.min-pool-size=5
#nuxeo.db.max-pool-size=
#nuxeo.vcs.min-pool-size=
#nuxeo.vcs.max-pool-size=
#########################################33
But when I try to log into the nuxeo server using user name
"Administrator" and password "Administrator" (I tried with small
letter "a"also) I get the following error, Guidance requested
e.javascript] <IMPORT-ALL>NON_EMPTY}}
at
org.jboss.classloader.spi.base.BaseClassLoader.loadClass(BaseClassLoader.java:448)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:247)
at
org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:474)
... 29 more
11:57:49,321 ERROR [AsyncEventExecutor] Failed to execute async event
loginFailed on listener auditLoggertListener
javax.persistence.PersistenceException: [PersistenceUnit:
nxaudit-logs] Unable to build EntityManagerFactory
at
org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:677)
at
org.hibernate.ejb.Ejb3Configuration.createEntityManagerFactory(Ejb3Configuration.java:646)
at
org.nuxeo.ecm.core.persistence.HibernateConfiguration.getFactory(HibernateConfiguration.java:139)
at
org.nuxeo.ecm.core.persistence.HibernateConfiguration.getFactory(HibernateConfiguration.java:174)
at
org.nuxeo.ecm.core.persistence.PersistenceProvider.openPersistenceUnit(PersistenceProvider.java:50)
at
org.nuxeo.ecm.platform.audit.service.NXAuditEventsService.activatePersistenceProvider(NXAuditEventsService.java:123)
at
org.nuxeo.ecm.platform.audit.service.NXAuditEventsService.getOrCreatePersistenceProvider(NXAuditEventsService.java:111)
at
org.nuxeo.ecm.platform.audit.service.NXAuditEventsService.logEvents(NXAuditEventsService.java:709)
at
org.nuxeo.ecm.platform.audit.listener.AuditEventLogger.handleEvent(AuditEventLogger.java:53)
at
org.nuxeo.ecm.core.event.impl.AsyncEventExecutor$Job.run(AsyncEventExecutor.java:153)
at
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:662)
Caused by: org.hibernate.HibernateException: 'hibernate.dialect' must
be set when no Connection avalable
at
org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFactory.java:107)
at
org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:134)
at
org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2119)
at
org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2115)
at
org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1339)
at
org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
at
org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
--
Thanks
Joseph John
http://www.oss101.com/
---
Mailing list: [email protected]
Forum: http://forum.nuxeo.org/f/1/
