Hello,
Just to be sure, have you done the following actions ?
* rm
/opt/nuxeo-dm-5.3.2/server/default/deploy/nuxeo.ear/system/nuxeo-platform-directory-sql-5.3.2.jar
* echo
"org.nuxeo.ecm.directory.dialect.override=org.hibernate.dialect.Oracle10gDialect"
>>
/opt/nuxeo-dm-5.3.2/server/default/deploy/nuxeo.ear/config/nuxeo.properties
Also, I don't understand why you have an error about
"nuxeo-platform-audit-facade-5.3.1.jar", there should be no 5.3.1
jar in the 5.3.2 version of Nuxeo.
Regards,
Le 18/10/10 15:15, Joseph John a écrit :
> Hi
> I had gone though the steps which was mentioned and I have kept the
> fiels in the location as instructed.
> Now when I start the nuxeo, I get error from hibernate, so we can
> make sure that it has problem in connecting to the database.
> My hibernate files has the follwoing information and location
>
> [r...@dm ~]# cat
> /opt/nuxeo-dm-5.3.2/server/default/deploy/nuxeo.ear/config/sql.properties
> # Jena database type and transaction mode
> org.nuxeo.ecm.sql.jena.databaseType=Oracle
> org.nuxeo.ecm.sql.jena.databaseTransactionEnabled=true
>
>
> [r...@dm ~]# cat
> /opt/nuxeo-dm-5.3.2/server/default/deploy/nuxeo.ear/hibernate.properties
> hibernate.dialect=org.hibernate.dialect.Oracle10gDialect
> hibernate.default_schema=nuxeo
>
>
>
> The hibnernate error which is throw is
> ObjectName: persistence.units:ear=nuxeo.ear,unitName=nxaudit-logs
> State: FAILED
> Reason: javax.persistence.PersistenceException:
> org.hibernate.HibernateException: Hibernate Dialect must be explicitly
> set
> I Depend On:
> jboss.jca:name=nxaudit-logs,service=DataSourceBinding
> Depends On Me:
>
> jboss.j2ee:ear=nuxeo.ear,jar=nuxeo-platform-audit-facade-5.3.1.jar,name=LogsBean,service=EJB3
>
> .
> .
> .
> .
> ... 30 more
> 01:33:24,629 ERROR [OSGiAdapter] Error during Framework Listener
> execution : class
> org.nuxeo.ecm.platform.jbpm.core.service.JbpmComponent
> org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
> at
> org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57)
> at
> org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
> at
> org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426)
> at
> org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:128)
> at
> org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2009)
> .
> .
> .
> 01:33:24,777 ERROR [OSGiAdapter] Error during Framework Listener
> execution : class org.nuxeo.ecm.platform.tag.TagServiceImpl$1
> org.hibernate.HibernateException: Hibernate Dialect must be explicitly set
> at
> org.hibernate.dialect.DialectFactory.determineDialect(DialectFactory.java:57)
> at
> org.hibernate.dialect.DialectFactory.buildDialect(DialectFactory.java:39)
> at
> org.hibernate.cfg.SettingsFactory.determineDialect(SettingsFactory.java:426)
> at org.hibernate.cfg.SettingsFac
>
> ####################################
> There are other errors also thrown
> which I have cut and pasted as below
>
> .
> .
> 01:33:17,332 ERROR [ComponentManagerImpl] Failed to create contribution
> objects
> java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:616)
> at
> org.nuxeo.common.xmap.XMethodAccessor.setValue(XMethodAccessor.java:47)
> .
> .
> .
>
> 01:33:17,445 ERROR [RelationService] Error while initializing graph
> publication
> java.lang.RuntimeException: java.lang.IllegalArgumentException:
> SQLException while opening java:/nxrelations-default-jena
> 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:217)
> at
> org.jboss.system.ListenerServiceMBeanSupport.handleNotification(ListenerServiceMBeanSupport.java:403)
> at sun.reflect.GeneratedMethodAccessor4.invoke(Unknown Source)
> at sun.reflect.DelegatingMethodAccessorImpl.in
> ...
>
> ################
>
> Advice requested to solve this issue
> Thanks
> Joseph John
>
> On Mon, Oct 18, 2010 at 11:59 AM, Thierry Delprat <[email protected]> wrote:
>> The sql directory patched version must replace the one in
>> deploy/nuxeo.ear/system
>>
>> Tiry
>>
>> Le 17 oct. 2010 10:34, "Joseph John" <[email protected]> a écrit :
>>> HI Russel
>>> My file location are
>>> "ojdbc14.jar"
>>>
>>> /opt/nuxeo-dm-5.3.2/server/default/lib/ojdbc14.jar
>>>
>>> and for "nuxeo-platform-directory-sql-5.3.2-NXP-5795.jar" I kept it in
>>> a different places,Since I was not sure of JBOSS lib directorry
>>>
>>> /opt/nuxeo-dm-5.3.2/lib/nuxeo-platform-directory-sql-5.3.2-NXP-5795.jar
>>>
>>> /opt/nuxeo-dm-5.3.2/server/default/deploy/nuxeo.ear/system/nuxeo-platform-directory-sql-5.3.2-NXP-5795.jar
>>>
>>> /opt/nuxeo-dm-5.3.2/server/default/lib/nuxeo-platform-directory-sql-5.3.2-NXP-5795.jar
>>>
>>> I have checked my databases it is up and running
>>> Thanks
>>>
>>>
>>>
>>> On Sun, Oct 17, 2010 at 10:23 AM, Alexandre Russel <[email protected]>
>>> wrote:
>>>> where did you put the oracle driver ?
>>>>
>>>> On 17 October 2010 07:08, Joseph John <[email protected]> wrote:
>>>>> Hi Thierry
>>>>> Thanks for the mail, I had gone through the link
>>>>> "https://jira.nuxeo.org/browse/NXP-5795";
>>>>> did the changes in "hibernate.properties" and in "nuxeo.properties"
>>>>> (in the templates) .
>>>>> Downloaded the file "nuxeo-platform-directory-sql-5.3.2-NXP-5795.jar "
>>>>> kept in the directory
>>>>> "/opt/nuxeo-dm-5.3.2/server/default/deploy/nuxeo.ear/system/"
>>>>> restarted the system. I am still getting the error on "stderr.log" as
>>>>> soon as I access the url to nuxeo
>>>>> I have cut and pasted the error message
>>>>> "2010-10-15 21:30:16,567 ERROR [STDERR] java.lang.RuntimeException:
>>>>> java.lang.RuntimeException: Unkown user directory userDirectory
>>>>> 2010-10-15 21:30:16,568 ERROR [STDERR] at
>>>>>
>>>>>
>>>>> org.jboss.ejb3.interceptor.LifecycleInterceptorHandler.postConstruct(LifecycleInterceptorHandler.java:113)
>>>>> 2010-10-15 21:30:16,568 ERROR [STDERR] at
>>>>> org.jboss.ejb3.EJBContainer.invokePostConstruct(EJBContainer.java:623)
>>>>> 2010-10-15 21:30:16,568 ERROR [STDERR] at
>>>>> org.jboss.ejb3.AbstractPool.create(AbstractPool.java:131)
>>>>> 2010-10-15 21:30:16,568 ERROR [STDERR] at
>>>>> org.jboss.ejb3.InfinitePool.get(InfinitePool.java:49)
>>>>> .
>>>>> .
>>>>> 2010-10-15 21:30:16,572 ERROR [STDERR] Caused by:
>>>>> org.nuxeo.ecm.directory.DirectoryException:
>>>>> org.nuxeo.ecm.core.api.WrappedException: Exception:
>>>>> org.nuxeo.ecm.directory.DirectoryException. message: could not obtain
>>>>> a connection
>>>>> 2010-10-15 21:30:16,573 ERROR [STDERR] at
>>>>>
>>>>>
>>>>> org.nuxeo.ecm.directory.sql.SQLDirectoryProxy.getDirectory(SQLDirectoryProxy.java:52)
>>>>> 2010-10-15 21:30:16,573 ERROR [STDERR] at
>>>>>
>>>>>
>>>>> org.nuxeo.ecm.directory.sql.SQLDirectoryProxy.getSchema(SQLDirectoryProxy.java:67)
>>>>> 2010-10-15 21:30:16,573 ERROR [STDERR] at
>>>>>
>>>>>
>>>>> org.nuxeo.ecm.directory.DirectoryServiceImpl.getDirectorySchema(DirectoryServiceImpl.java:154)
>>>>> 2010-10-15 21:30:16,573 ERROR [STDERR] at
>>>>>
>>>>>
>>>>> org.nuxeo.ecm.platform.usermanager.UserManagerImpl.setUserDirectoryName(UserManagerImpl.java:181)
>>>>> 2010-10-15 21:30:16,573 ERROR [STDERR] ... 61 more
>>>>> 2010-10-15 21:30:16,573 ERROR [STDERR] Caused by:
>>>>> org.nuxeo.ecm.core.api.WrappedException: Exception:
>>>>> org.nuxeo.ecm.directory.DirectoryException. message: could not obtain
>>>>> a connection
>>>>> .
>>>>> .
>>>>> 2010-10-15 21:30:16,573 ERROR [STDERR] Caused by:
>>>>> org.nuxeo.ecm.core.api.WrappedException: Exception:
>>>>> org.jboss.util.NestedSQLException. message: Could not create
>>>>> connection; - nested throwable:
>>>>> (org.jboss.resource.JBossResourceException: Failed to register driver
>>>>> for: oracle.jdbc.driver.OracleDriver; - nested throwable:
>>>>> (java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver));
>>>>> - nested throwable: (org.jboss.resource.JBossResourceException: Could
>>>>> not create connection; - nested throwable:
>>>>> (org.jboss.resource.JBossResourceException: Failed to register driver
>>>>> for: oracle.jdbc.driver.OracleDriver; - nested throwable:
>>>>> (java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver)))
>>>>> 2010-10-15 21:30:16,573 ERROR [STDERR] at
>>>>>
>>>>>
>>>>> org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
>>>>> 2010-10-15 21:30:16,573 ERROR [STDERR] at
>>>>>
>>>>>
>>>>> org.nuxeo.ecm.directory.sql.SQLDirectory.getConnection(SQLDirectory.java:214)
>>>>> 2010-10-15 21:30:16,573 ERROR [STDERR] ... 67 more
>>>>> 2010-10-15 21:30:16,573 ERROR [STDERR] Caused by:
>>>>> org.nuxeo.ecm.core.api.WrappedException: Exception:
>>>>> org.jboss.resource.JBossResourceException. message: Could not create
>>>>> connection; - nested throwable:
>>>>> (org.jboss.resource.JBossResourceException: Failed to register driver
>>>>> for: oracle.jdbc.driver.OracleDriver; - nested throwable:
>>>>> (java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver))
>>>>> 2010-10-15 21:30:16,574 ERROR [STDERR] at
>>>>>
>>>>>
>>>>> org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:190)
>>>>> "
>>>>>
>>>>> Thanks
>>>>> Joseph John
>>>>>
>>>>> On Thu, Oct 14, 2010 at 4:21 PM, Thierry Delprat <[email protected]>
>>>>> wrote:
>>>>>> java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
>>>>>> => You need to add the oracle JDBC driver in Jboss lib
>>>>>> Furthermore if you are using Oracle 11, the hibernate version that
>>>>>> comes
>>>>>> with Jboss 4.2 does not support correctly Oracle 11 (wrong detection).
>>>>>> => You may need to look at https://jira.nuxeo.org/browse/NXP-5795
>>>>>> Tiry
>>>>>>
>>>>>> On 14 October 2010 14:03, Joseph John <[email protected]> wrote:
>>>>>>> Hi
>>>>>>> I am trying to make nuxeo 5.3.2 with oracle 11.1
>>>>>>> Edited /bin/nuxeo.conf file and restarted nuxeo 5.3.2, I did not get
>>>>>>> any error messages on
>>>>>>> boot.log
>>>>>>> nuxeo-error.log
>>>>>>> but I get error log in "stderr.log" when I try to log in from the
>>>>>>> nuxeo interface. the error in "stderr.log" I have cut and pasted
>>>>>>> "
>>>>>>> java.lang.RuntimeException: java.lang.RuntimeException: Unkown user
>>>>>>> directory userDirectory
>>>>>>> 2010-10-13 04:26:09,331 ERROR [STDERR] at
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> org.jboss.ejb3.interceptor.LifecycleInterceptorHandler.postConstruct(LifecycleInterceptorHandler.java:113)
>>>>>>> 2010-10-13 04:26:09,331 ERROR [STDERR] at
>>>>>>>
>>>>>>> org.jboss.ejb3.EJBContainer.invokePostConstruct(EJBContainer.java:623)
>>>>>>> 2010-10-13 04:26:09,331 ERROR [STDERR] at
>>>>>>> org.jboss.ejb3.AbstractPool.create(AbstractPool.java:131)
>>>>>>> 2010-10-13 04:26:09,331 ERROR [STDERR] at
>>>>>>> org.jboss.ejb3.InfinitePool.get(InfinitePool.java:49)
>>>>>>> 2010-10-13 04:26:09,331 ERROR [STDERR] at
>>>>>>> org.jboss.ejb3.ThreadlocalPool.create(ThreadlocalPool.java:50)
>>>>>>> 2010-10-13 04:26:09,331 ERROR [STDERR] at
>>>>>>> org.jboss.ejb3.ThreadlocalPool.get(ThreadlocalPool.java:90)
>>>>>>> 2010-10-13 04:26:09,331 ERROR [STDERR] at
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:54)
>>>>>>> 2010-10-13 04:26:09,332 ERROR [STDERR] at
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
>>>>>>> 2010-10-13 04:26:09,332 ERROR [STDERR] at org.jboss.aspects.security
>>>>>>>
>>>>>>> ...
>>>>>>> ..
>>>>>>> 2010-10-13 04:26:09,336 ERROR [STDERR] Caused by:
>>>>>>> org.nuxeo.ecm.directory.DirectoryException:
>>>>>>> org.nuxeo.ecm.core.api.WrappedException: Exception:
>>>>>>> org.nuxeo.ecm.directory.DirectoryException. message: could not obtain
>>>>>>> a connection
>>>>>>> 2010-10-13 04:26:09,336 ERROR [STDERR] at
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> org.nuxeo.ecm.directory.sql.SQLDirectoryProxy.getDirectory(SQLDirectoryProxy.java:52)
>>>>>>> 2010-10-13 04:26:09,336 ERROR [STDERR] at
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> org.nuxeo.ecm.directory.sql.SQLDirectoryProxy.getSchema(SQLDirectoryProxy.java:67)
>>>>>>> 2010-10-13 04:26:09,336 ERROR [STDERR] at
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> org.nuxeo.ecm.directory.DirectoryServiceImpl.getDirectorySchema(DirectoryServiceImpl.java:154)
>>>>>>> 2010-10-13 04:26:09,336 ERROR [STDERR] at
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> org.nuxeo.ecm.platform.usermanager.UserManagerImpl.setUserDirectoryName(UserManagerImpl.java:181)
>>>>>>> 2010-10-13 04:26:09,336 ERROR [STDERR] ... 61 more
>>>>>>> 2010-10-13 04:26:09,336 ERROR [STDERR] Caused by:
>>>>>>> org.nuxeo.ecm.core.api.WrappedException: Exception:
>>>>>>> org.nuxeo.ecm.directory.DirectoryException. message: could not obtain
>>>>>>> a connection
>>>>>>> 2010-10-13 04:26:09,336 ERROR [STDERR] at
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> org.nuxeo.ecm.directory.sql.SQLDirectory.getConnection(SQLDirectory.java:216)
>>>>>>> 2010-10-13 04:26:09,336 ERROR [STDERR] at
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> org.nuxeo.ecm.directory.sql.SQLDirectory.buildDialect(SQLDirectory.java:297)
>>>>>>> 2010-10-13 04:26:09,336 ERROR [STDERR] at
>>>>>>> org.nuxeo.ecm.directory.sql.SQLDirectory.<init>(SQLDirectory.java:90)
>>>>>>> 2010-10-13 04:26:09,336 ERROR [STDERR] at
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> org.nuxeo.ecm.directory.sql.SQLDirectoryProxy.getDirectory(SQLDirectoryProxy.java:50)
>>>>>>> 2010-10-13 04:26:09,336 ERROR [STDERR] ... 64 more
>>>>>>> 2010-10-13 04:26:09,336 ERROR [STDERR] Caused by:
>>>>>>> org.nuxeo.ecm.core.api.WrappedException: Exception:
>>>>>>> org.jboss.util.NestedSQLException. message: Could not create
>>>>>>> connection; - nested throwable:
>>>>>>> (org.jboss.resource.JBossResourceException: Failed to register driver
>>>>>>> for: oracle.jdbc.driver.OracleDriver; - nested throwable:
>>>>>>> (java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver));
>>>>>>> - nested throwable: (org.jboss.resource.JBossResourceException: Could
>>>>>>> not create connection; - nested throwable:
>>>>>>> (org.jboss.resource.JBossResourceException: Failed to register driver
>>>>>>> for: oracle.jdbc.driver.OracleDriver; - nested throwable:
>>>>>>> (java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver)))
>>>>>>> 2010-10-13 04:26:09,336 ERROR [STDERR] at
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
>>>>>>> 2010-10-13 04:26:09,336 ERROR [STDERR] at
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> org.nuxeo.ecm.directory.sql.SQLDirectory.getConnection(SQLDirectory.java:214)
>>>>>>> 2010-10-13 04:26:09,336 ERROR [STDERR] ... 67 more
>>>>>>> 2010-10-13 04:26:09,337 ERROR [STDERR] Caused by:
>>>>>>> org.nuxeo.ecm.core.api.WrappedException: Exception:
>>>>>>> org.jboss.resource.JBossResourceException. message: Could not create
>>>>>>> connection; - nested throwable:
>>>>>>> (org.jboss.resource.JBossResourceException: Failed to register driver
>>>>>>> for: oracle.jdbc.driver.OracleDriver; - nested throwable:
>>>>>>> (java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver))
>>>>>>>
>>>>>>> #
>>>>>>> Going through the error, I have a feeling that there is no
>>>>>>> information
>>>>>>> of nuxeo users on oracle database, Do I need to import some tables
>>>>>>> and
>>>>>>> values to make it work
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Thanks
>>>>>>> Joseph John
>>>>>>> http://www.oss101.com/
>>>>>>> _______________________________________________
>>>>>>> ECM mailing list
>>>>>>> [email protected]
>>>>>>> http://lists.nuxeo.com/mailman/listinfo/ecm
>>>>>>> To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> Thanks
>>>>> Joseph John
>>>>> http://www.oss101.com/
>>>>> _______________________________________________
>>>>> ECM mailing list
>>>>> [email protected]
>>>>> http://lists.nuxeo.com/mailman/listinfo/ecm
>>>>> To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
>>>>
>>>
>>>
>>> --
>>> Thanks
>>> Joseph John
>>> http://www.oss101.com/
>>> _______________________________________________
>>> ECM mailing list
>>> [email protected]
>>> http://lists.nuxeo.com/mailman/listinfo/ecm
>>> To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
>
>
--
Julien Carsique, Nuxeo (Paris, France)
www.nuxeo.com - The Open Source ECM Platform - www.nuxeo.org
Nuxeo ECM Stack - The Java EE, scalable, standard-based ECM Platform
_______________________________________________
ECM mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm
To unsubscribe, go to http://lists.nuxeo.com/mailman/options/ecm
