Unable to launch GateIn 3.6.0 Tomcat distro with Oracle

[charlesmoore]

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?

[magate]

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

[magate]

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

[charlesmoore]

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.

[charlesmoore]

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.

[charlesmoore]

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.