5 Replies Latest reply on Dec 10, 2013 5:01 PM by Charles Moore

    Unable to launch GateIn 3.6.0 Tomcat distro with Oracle

    Charles Moore Newbie

      I'm getting a problem with the IDM, on a fresh Gatein install using Oracle.

       

      I'm connecting to oracle 11g203.  Using the ojbdb6.jar  driver.

       

      Running GateIn 3.6.0 Tomcat7 distro.

       

      I created two empty schemas in our oracle Db (one for JCR, one for IDM) and granted all rolls and privileges.

       

      I updated the gatein/conf/configuration.properties file with the connection particulars

      # JCR

      gatein.jcr.datasource.driver=oracle.jdbc.OracleDriver

      gatein.jcr.datasource.url=jdbc:oracle:thin:@//192.168.7.222:1521/gmpdb

      gatein.jcr.datasource.username=gatein_jcr_cm

      gatein.jcr.datasource.password=temp123

      # IDM

      gatein.idm.datasource.driver=oracle.jdbc.OracleDriver

      gatein.idm.datasource.url=jdbc:oracle:thin:@//192.168.7.222:1521/gmpdb

      gatein.idm.datasource.username=gatein_idm_cm

      gatein.idm.datasource.password=temp123

       

      I launched Gatein with the command "gatein.bat run " from the gatein/bin directory.

       

      Hibernate creates the tables, for both JCR and IDM, but then throws the following exception and fails to start the portal:

       

      86808 [Catalina-startStop-1] ERROR exo.kernel.container.RootContainer - Cannot create the portal container 'portal' . ServletContext: org.apache.catalina.core.ApplicationContextFacade@328bf

      org.picocontainer.PicoIntrospectionException: Failed when calling start on org.exoplatform.services.organization.idm.PicketLinkIDMServiceImpl@13b2523

              at org.exoplatform.container.LifecycleVisitor.traverse(LifecycleVisitor.java:136)

              at org.exoplatform.container.LifecycleVisitor.start(LifecycleVisitor.java:170)

              at org.exoplatform.container.ConcurrentPicoContainer.start(ConcurrentPicoContainer.java:554)

              at org.exoplatform.container.ExoContainer.start(ExoContainer.java:270)

              at org.exoplatform.container.PortalContainer.start(PortalContainer.java:679)

              at org.exoplatform.container.ExoContainer.start(ExoContainer.java:258)

              at org.exoplatform.container.RootContainer.createPortalContainer(RootContainer.java:678)

              at org.exoplatform.container.RootContainer.createPortalContainers(RootContainer.java:343)

              at org.exoplatform.server.tomcat.PortalContainersCreator$1.run(PortalContainersCreator.java:53)

              at org.exoplatform.server.tomcat.PortalContainersCreator$1.run(PortalContainersCreator.java:51)

              at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedAction(SecurityHelper.java:290)

              at org.exoplatform.server.tomcat.PortalContainersCreator.createPortalContainers(PortalContainersCreator.java:51)

              at org.exoplatform.server.tomcat.PortalContainersCreator.lifecycleEvent(PortalContainersCreator.java:40)

              at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)

              at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)

              at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:402)

              at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:347)

              at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1140)

              at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:800)

              at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

              at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)

              at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)

              at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

              at java.util.concurrent.FutureTask.run(FutureTask.java:138)

              at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)

              at java.lang.Thread.run(Thread.java:662)

      Caused by: java.lang.RuntimeException: org.picketlink.idm.common.exception.IdentityConfigurationException: Failed to build IdentitySessionFactory

              at org.exoplatform.services.organization.idm.PicketLinkIDMServiceImpl.start(PicketLinkIDMServiceImpl.java:188)

              at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:597)

              at org.exoplatform.container.LifecycleVisitor.traverse(LifecycleVisitor.java:100)

              ... 26 more

      Caused by: org.picketlink.idm.common.exception.IdentityConfigurationException: Failed to build IdentitySessionFactory

              at org.picketlink.idm.impl.configuration.IdentityConfigurationImpl.buildIdentitySessionFactory(IdentityConfigurationImpl.java:153)

              at org.exoplatform.services.organization.idm.PicketLinkIDMServiceImpl.start(PicketLinkIDMServiceImpl.java:186)

              ... 30 more

      Caused by: org.picketlink.idm.common.exception.IdentityException: Failed to populate relationship types

              at org.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreImpl.bootstrap(HibernateIdentityStoreImpl.java:250)

              at org.picketlink.idm.impl.configuration.IdentityConfigurationImpl.createRealmMap(IdentityConfigurationImpl.java:194)

              at org.picketlink.idm.impl.configuration.IdentityConfigurationImpl.buildIdentitySessionFactory(IdentityConfigurationImpl.java:149)

              ... 31 more

      Caused by: org.hibernate.exception.SQLGrammarException: ORA-02289: sequence does not exist

              at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)

              at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)

              at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)

              at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)

              at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)

              at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)

              at com.sun.proxy.$Proxy90.executeQuery(Unknown Source)

              at org.hibernate.id.SequenceGenerator.generateHolder(SequenceGenerator.java:123)

              at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:116)

              at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:118)

              at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208)

              at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151)

              at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78)

              at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:844)

              at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:819)

              at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:823)

              at org.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreImpl.populateRelationshipTypes(HibernateIdentityStoreImpl.java:3016)

              at org.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreImpl.bootstrap(HibernateIdentityStoreImpl.java:241)

              ... 33 more

      Caused by: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)

              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)

              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:459)

              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:193)

              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)

              at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:1087)

              at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1348)

              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1539)

              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3929)

              at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3999)

              at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:4515)

              at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)

              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.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)

              ... 46 more

      Caused by:

      java.lang.RuntimeException: org.picketlink.idm.common.exception.IdentityConfigurationException: Failed to build IdentitySessionFactory

              at org.exoplatform.services.organization.idm.PicketLinkIDMServiceImpl.start(PicketLinkIDMServiceImpl.java:188)

              at sun.reflect.GeneratedMethodAccessor56.invoke(Unknown Source)

              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

              at java.lang.reflect.Method.invoke(Method.java:597)

              at org.exoplatform.container.LifecycleVisitor.traverse(LifecycleVisitor.java:100)

              at org.exoplatform.container.LifecycleVisitor.start(LifecycleVisitor.java:170)

              at org.exoplatform.container.ConcurrentPicoContainer.start(ConcurrentPicoContainer.java:554)

              at org.exoplatform.container.ExoContainer.start(ExoContainer.java:270)

              at org.exoplatform.container.PortalContainer.start(PortalContainer.java:679)

              at org.exoplatform.container.ExoContainer.start(ExoContainer.java:258)

              at org.exoplatform.container.RootContainer.createPortalContainer(RootContainer.java:678)

              at org.exoplatform.container.RootContainer.createPortalContainers(RootContainer.java:343)

              at org.exoplatform.server.tomcat.PortalContainersCreator$1.run(PortalContainersCreator.java:53)

              at org.exoplatform.server.tomcat.PortalContainersCreator$1.run(PortalContainersCreator.java:51)

              at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedAction(SecurityHelper.java:290)

              at org.exoplatform.server.tomcat.PortalContainersCreator.createPortalContainers(PortalContainersCreator.java:51)

              at org.exoplatform.server.tomcat.PortalContainersCreator.lifecycleEvent(PortalContainersCreator.java:40)

              at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)

              at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)

              at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:402)

              at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:347)

              at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1140)

              at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:800)

              at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

              at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)

              at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)

              at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)

              at java.util.concurrent.FutureTask.run(FutureTask.java:138)

              at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895)

              at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918)

              at java.lang.Thread.run(Thread.java:662)

      Caused by: org.picketlink.idm.common.exception.IdentityConfigurationException: Failed to build IdentitySessionFactory

              at org.picketlink.idm.impl.configuration.IdentityConfigurationImpl.buildIdentitySessionFactory(IdentityConfigurationImpl.java:153)

              at org.exoplatform.services.organization.idm.PicketLinkIDMServiceImpl.start(PicketLinkIDMServiceImpl.java:186)

              ... 30 more

      Caused by: org.picketlink.idm.common.exception.IdentityException: Failed to populate relationship types

              at org.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreImpl.bootstrap(HibernateIdentityStoreImpl.java:250)

              at org.picketlink.idm.impl.configuration.IdentityConfigurationImpl.createRealmMap(IdentityConfigurationImpl.java:194)

              at org.picketlink.idm.impl.configuration.IdentityConfigurationImpl.buildIdentitySessionFactory(IdentityConfigurationImpl.java:149)

              ... 31 more

      Caused by: org.hibernate.exception.SQLGrammarException: ORA-02289: sequence does not exist

              at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:82)

              at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)

              at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125)

              at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110)

              at org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129)

              at org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81)

              at com.sun.proxy.$Proxy90.executeQuery(Unknown Source)

              at org.hibernate.id.SequenceGenerator.generateHolder(SequenceGenerator.java:123)

              at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:116)

              at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:118)

              at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208)

              at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151)

              at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78)

              at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:844)

              at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:819)

              at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:823)

              at org.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreImpl.populateRelationshipTypes(HibernateIdentityStoreImpl.java:3016)

              at org.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreImpl.bootstrap(HibernateIdentityStoreImpl.java:241)

              ... 33 more

      Caused by: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)

              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837)

              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:459)

              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:193)

              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225)

              at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:1087)

              at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1348)

              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1539)

              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3929)

              at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3999)

              at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:4515)

              at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)

              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.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122)

              ... 46 more

       

       

       

       

       

       

       

      Any ideas?

        • 1. Re: Unable to launch GateIn 3.6.0 Tomcat distro with Oracle
          Marc Agate Newbie

          Hi!

           

          Your db urls are the same: how come hibernate created the tables? I have the same problem as yours anyway using mysql and tomcat), excepted that hiberante doesn't create the tables.

           

          Here is the stack trace:

          java.lang.RuntimeException: Cannot instantiate component key=org.exoplatform.portal.config.UserPortalConfigService type=org.exoplatform.portal.config.UserPortalConfigService found at jndi:/localhost/portal/WEB-INF/conf/portal/portal-configuration.xml

                  at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstance(MX4JComponentAdapter.java:135)

                  at org.exoplatform.container.management.ManageableComponentAdapter.getComponentInstance(ManageableComponentAdapter.java:68)

                  at org.exoplatform.container.ConcurrentPicoContainer.getInstance(ConcurrentPicoContainer.java:468)

                  at org.exoplatform.container.ConcurrentPicoContainer.getComponentInstancesOfType(ConcurrentPicoContainer.java:366)

                  at org.exoplatform.container.CachingContainer.getComponentInstancesOfType(CachingContainer.java:111)

                  at org.exoplatform.container.LifecycleVisitor.visitContainer(LifecycleVisitor.java:151)

                  at org.exoplatform.container.ConcurrentPicoContainer.accept(ConcurrentPicoContainer.java:615)

                  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpljava:57)

                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                  at java.lang.reflect.Method.invoke(Method.java:601)

                  at org.picocontainer.defaults.AbstractPicoVisitor.traverse(AbstractPicoVisitor.java:32)

                  at org.exoplatform.container.LifecycleVisitor.traverse(LifecycleVisitor.java:90)

                  at org.exoplatform.container.LifecycleVisitor.start(LifecycleVisitor.java:170)

                  at org.exoplatform.container.ConcurrentPicoContainer.start(ConcurrentPicoContainer.java:554)

                  at org.exoplatform.container.ExoContainer.start(ExoContainer.java:270)

                  at org.exoplatform.container.PortalContainer.start(PortalContainer.java:679)

                  at org.exoplatform.container.ExoContainer.start(ExoContainer.java:258)

                  at org.exoplatform.container.RootContainer.createPortalContainer(RootContainer.java:678)

                  at org.exoplatform.container.RootContainer.createPortalContainers(RootContainer.java:343)

                  at org.exoplatform.server.tomcat.PortalContainersCreator$1.run(PortalContainersCreator.java:53)

                  at org.exoplatform.server.tomcat.PortalContainersCreator$1.run(PortalContainersCreator.java:51)

                  at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedAction(SecurityHelper.java:290)

                  at org.exoplatform.server.tomcat.PortalContainersCreator.createPortalContainers(PortalContainersCreator.java:51)

                  at org.exoplatform.server.tomcat.PortalContainersCreator.lifecycleEvent(PortalContainersCreator.java:40)

                  at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)

                  at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:90)

                  at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:402)

                  at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:347)

                  at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:1140)

                  at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:800)

                  at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)

                  at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)

                  at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)

                  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

                  at java.util.concurrent.FutureTask.run(FutureTask.java:166)

                  at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

                  at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)

                  at java.lang.Thread.run(Thread.java:722)

          Caused by: java.lang.RuntimeException: Cannot instantiate component key=org.exoplatform.services.organization.OrganizationService type=org.exoplatform.services.organization.idm.PicketLinkIDMOrganizationServiceImpl found at jndi:/localhost/portal/WEB-INF/conf/organization/idm-configuration.xml

                  at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstance(MX4JComponentAdapter.java:135)

                  at org.exoplatform.container.management.ManageableComponentAdapter.getComponentInstance(ManageableComponentAdapter.java:68)

                  at org.exoplatform.container.ConcurrentPicoContainer.getInstance(ConcurrentPicoContainer.java:468)

                  at org.exoplatform.container.ConcurrentPicoContainer.getComponentInstanceOfType(ConcurrentPicoContainer.java:422)

                  at org.exoplatform.container.CachingContainer.getComponentInstanceOfType(CachingContainer.java:139)

                  at org.exoplatform.container.ExoContainer.createComponent(ExoContainer.java:412)

                  at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstance(MX4JComponentAdapter.java:97)

                  ... 38 more

          Caused by: java.lang.RuntimeException: Cannot instantiate component key=org.exoplatform.services.organization.idm.PicketLinkIDMService type=org.exoplatform.serv

          ices.organization.idm.PicketLinkIDMServiceImpl found at jndi:/localhost/portal/WEB-INF/conf/organization/idm-configuration.xml

                  at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstance(MX4JComponentAdapter.java:135)

                  at org.exoplatform.container.management.ManageableComponentAdapter.getComponentInstance(ManageableComponentAdapter.java:68)

                  at org.exoplatform.container.ConcurrentPicoContainer.getInstance(ConcurrentPicoContainer.java:468)

                  at org.exoplatform.container.ConcurrentPicoContainer.getComponentInstanceOfType(ConcurrentPicoContainer.java:422)

                  at org.exoplatform.container.CachingContainer.getComponentInstanceOfType(CachingContainer.java:139)

                  at org.exoplatform.container.ExoContainer.createComponent(ExoContainer.java:412)

                  at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstance(MX4JComponentAdapter.java:97)

                  ... 44 more

          Caused by: java.lang.reflect.InvocationTargetException

                  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

                  at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)

                  at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

                  at java.lang.reflect.Constructor.newInstance(Constructor.java:525)

                  at org.exoplatform.container.ExoContainer.createComponent(ExoContainer.java:422)

                  at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstance(MX4JComponentAdapter.java:97)

                  ... 50 more

          Caused by: org.hibernate.HibernateException: Connection cannot be null when 'hibernate.dialect' not set

                  at org.hibernate.service.jdbc.dialect.internal.DialectFactoryImpl.determineDialect(DialectFactoryImpl.java:97)

                  at org.hibernate.service.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java:67)

                  at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:170)

                  at org.hibernate.service.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:75)

                  at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:159)

                  at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:131)

                  at org.hibernate.cfg.SettingsFactory.buildSettings(SettingsFactory.java:73)

                  at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.java:2279)

                  at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2275)

                  at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1744)

                  at org.exoplatform.services.organization.idm.CustomHibernateServiceImpl.buildSessionFactory(CustomHibernateServiceImpl.java:102)

                  at org.exoplatform.services.organization.idm.CustomHibernateServiceImpl$1.run(CustomHibernateServiceImpl.java:59)

                  at org.exoplatform.services.organization.idm.CustomHibernateServiceImpl$1.run(CustomHibernateServiceImpl.java:57)

                  at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedAction(SecurityHelper.java:290)

                  at org.exoplatform.services.organization.idm.CustomHibernateServiceImpl.getSessionFactory(CustomHibernateServiceImpl.java:57)

                  at org.exoplatform.services.organization.idm.PicketLinkIDMServiceImpl.<init>(PicketLinkIDMServiceImpl.java:132)

                  ... 56 more

          32608 [Catalina-startStop-1] WARN exo.kernel.container.RootContainer - The portal container 'portal' doesn't exist or it has not yet been registered, please check your PortalContainerDefinitions and the loading order.

           

          Help !!!

           

          Marc

          • 2. Re: Unable to launch GateIn 3.6.0 Tomcat distro with Oracle
            Marc Agate Newbie

            One more funny thing:

             

            I ran "gatein-dev  start" (instead of "gatein start") which created the tables in my dbs. Then I stopped it ("gatein-dev  stop"), and ran "gatein start" once again with no error at all!

             

            I got the whole thing up and running...but i still can't figure out why it didn't work with the sole use of "gatein start"...

             

            Any clue?

             

            Marc

            • 3. Re: Unable to launch GateIn 3.6.0 Tomcat distro with Oracle
              Charles Moore Newbie

              The DBs share the same SIDs, but the schema are different.

               

              Note: If I set up the IDM to use hsqldb and JCR to use Oracle the portal starts normally.

              • 4. Re: Unable to launch GateIn 3.6.0 Tomcat distro with Oracle
                Charles Moore Newbie

                More information:

                 

                I installed Oracle locally on my (Windows) development machine and changed the connection strings.  It connected and generated both the IDM and the JCR schemas properly.

                 

                The Oracle instance where the IDM schema cannot generate the sequence number is running on RHEL.

                • 5. Re: Unable to launch GateIn 3.6.0 Tomcat distro with Oracle
                  Charles Moore Newbie

                  Here’s the steps I just performed that seem like they worked:

                   

                  I installed Java 7 and downloaded ojbdc7.jar from Oracle.  I don’t know if this is important, at the time it didn’t appear to make any difference.

                   

                  I edited the file gatein-3.6.0.final-tomcat7/webapps/portal/WEB-INF/conf/organization/idm-configuration.xml and  changed the value of hibernate.hbm2ddl.auto from ‘update’ to ‘create’ (line 46)

                   

                  I started the tomcat instance it populated the tables and the portal came up.

                   

                  I shut it down and again edited the file gatein-3.6.0.final-tomcat7/webapps/portal/WEB-INF/conf/organization/idm-configuration.xml .  This time changing the value of hibernate.hbm2ddl.auto from ‘create’ to ‘none’ ( if you don’t do this it will re-create the schema every time the portal launches, changing ti back to update was also an option, but I didn’t want it messing with the schema).

                   

                  I started the tomcat instance the portal came back up.