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
>
--
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
