5 Replies Latest reply: Aug 4, 2012 12:27 AM by Antoine Herzog RSS

    GateIn AS 7.1 preview is not able to switch to MySQL backend

    Tony Kaska Newbie

      I am using the AS 7.1 preview installation. I am trying to setup MySQL as my backend. I am following the reference guide online. Additionally I have setup the MySQL datasource in AS 7.1.

      But it is failing. Any guidance or help will be appreciated. Has anyone successfully able to create the schema automatically if they switch the db source? I appreciate any guidance.

       

      I am also wondering if there is any where you can find the specific errors that causes. Where the problem is exctly. I am not able to locate any log file. Thanks.

       

      Thank you.

       

       

              at org.exoplatform.web.CacheUserProfileFilter.doFilter(CacheUserProfileF

      ilter.java:73) [exo.portal.component.web.security-3.2.0-GA.jar:3.2.0-GA]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

              at org.exoplatform.frameworks.jcr.web.ThreadLocalSessionProviderInitiali

      zedFilter.doFilter(ThreadLocalSessionProviderInitializedFilter.java:116) [exo.jc

      r.framework.web-1.14.6-GA.jar:1.14.6-GA]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

              at org.exoplatform.services.security.web.SetCurrentIdentityFilter.doFilt

      er(SetCurrentIdentityFilter.java:88) [exo.core.component.security.core-2.4.6-GA.

      jar:2.4.6-GA]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

              at org.exoplatform.web.login.ClusteredSSOFilter.doFilter(ClusteredSSOFil

      ter.java:73) [exo.portal.component.web.security-3.2.0-GA.jar:3.2.0-GA]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

              at org.exoplatform.container.web.PortalContainerFilter.doFilter(PortalCo

      ntainerFilter.java:69) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-GA-AS

      7-Beta03]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV

      alve.java:275) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV

      alve.java:161) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica

      torBase.java:397) [jbossweb-7.0.10.Final.jar:]

              at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(Secu

      rityContextAssociationValve.java:154) [jboss-as-web-7.1.0.Final.jar:7.1.0.Final]

       

       

              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j

      ava:155) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j

      ava:102) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal

      ve.java:109) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav

      a:368) [jbossweb-7.0.10.Final.jar:]

              at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java

      :877) [jbossweb-7.0.10.Final.jar:]

              at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce

      ss(Http11Protocol.java:671) [jbossweb-7.0.10.Final.jar:]

              at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:93

      0) [jbossweb-7.0.10.Final.jar:]

              at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_31]

      Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

              at java.lang.ClassLoader.findClass(ClassLoader.java:358) [rt.jar:1.6.0_3

      1]

              at java.lang.ClassLoader.loadClass(ClassLoader.java:306) [rt.jar:1.6.0_3

      1]

              at java.lang.ClassLoader.loadClass(ClassLoader.java:247) [rt.jar:1.6.0_3

      1]

              at org.apache.commons.dbcp.BasicDataSource.createConnectionFactory(Basic

      DataSource.java:1420) [commons-dbcp-1.4.jar:1.4]

              ... 85 more

       

       

      04:34:24,884 ERROR [exo.kernel.container.MX4JComponentAdapter] (http--127.0.0.1-

      8080-1) Failed to instanciate plugin DefaultRequestHandler for component org.exo

      platform.web.WebAppController@1e600bf: Cannot instantiate component key=org.exop

      latform.portal.config.UserPortalConfigService type=org.exoplatform.portal.config

      .UserPortalConfigService found at jndi:/default-host/portal/WEB-INF/conf/portal/

      portal-configuration.xml: java.lang.RuntimeException: Cannot instantiate compone

      nt key=org.exoplatform.portal.config.UserPortalConfigService type=org.exoplatfor

      m.portal.config.UserPortalConfigService found at jndi:/default-host/portal/WEB-I

      NF/conf/portal/portal-configuration.xml

              at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan

      ce(MX4JComponentAdapter.java:135) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:

      2.3.6-GA-AS7-Beta03]

              at org.exoplatform.container.management.ManageableComponentAdapter.getCo

      mponentInstance(ManageableComponentAdapter.java:68) [exo.kernel.container-2.3.6-

      GA-AS7-Beta03.jar:2.3.6-GA-AS7-Beta03]

              at org.exoplatform.container.ConcurrentPicoContainer.getInstance(Concurr

      entPicoContainer.java:468) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-G

      A-AS7-Beta03]

              at org.exoplatform.container.ConcurrentPicoContainer.getComponentInstanc

      eOfType(ConcurrentPicoContainer.java:422) [exo.kernel.container-2.3.6-GA-AS7-Bet

      a03.jar:2.3.6-GA-AS7-Beta03]

              at org.exoplatform.container.CachingContainer.getComponentInstanceOfType

      (CachingContainer.java:139) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-

      GA-AS7-Beta03]

              at org.exoplatform.container.ExoContainer.createComponent(ExoContainer.j

      ava:407) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-GA-AS7-Beta03]

              at org.exoplatform.container.jmx.MX4JComponentAdapter.addComponentPlugin

      (MX4JComponentAdapter.java:155) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.

      3.6-GA-AS7-Beta03]

              at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan

      ce(MX4JComponentAdapter.java:114) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:

      2.3.6-GA-AS7-Beta03]

              at org.exoplatform.container.management.ManageableComponentAdapter.getCo

      mponentInstance(ManageableComponentAdapter.java:68) [exo.kernel.container-2.3.6-

      GA-AS7-Beta03.jar:2.3.6-GA-AS7-Beta03]

              at org.exoplatform.container.ConcurrentPicoContainer.getInstance(Concurr

      entPicoContainer.java:468) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-G

      A-AS7-Beta03]

              at org.exoplatform.container.ConcurrentPicoContainer.getComponentInstanc

      eOfType(ConcurrentPicoContainer.java:422) [exo.kernel.container-2.3.6-GA-AS7-Bet

      a03.jar:2.3.6-GA-AS7-Beta03]

              at org.exoplatform.container.CachingContainer.getComponentInstanceOfType

      (CachingContainer.java:139) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-

      GA-AS7-Beta03]

              at org.exoplatform.portal.application.PortalController.onService(PortalC

      ontroller.java:126) [exo.portal.webui.portal-3.2.0-GA.jar:3.2.0-GA]

              at org.exoplatform.container.web.AbstractHttpServlet.service(AbstractHtt

      pServlet.java:132) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-GA-AS7-Be

      ta03]

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-s

      ervlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:329) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

              at org.exoplatform.web.login.RememberMeFilter.doFilter(RememberMeFilter.

      java:89) [exo.portal.component.web.security-3.2.0-GA.jar:3.2.0-GA]

              at org.exoplatform.web.login.RememberMeFilter.doFilter(RememberMeFilter.

      java:55) [exo.portal.component.web.security-3.2.0-GA.jar:3.2.0-GA]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

              at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doF

      ilter(ExtensibleFilter.java:110) [exo.portal.component.web.api-3.2.0-GA.jar:3.2.

      0-GA]

              at org.exoplatform.sample.ext.web.SampleFilter.doFilter(SampleFilter.jav

      a:46) [exo.portal.sample.extension.jar-3.2.0-GA.jar:3.2.0-GA]

              at org.exoplatform.web.filter.ExtensibleFilter$ExtensibleFilterChain.doF

      ilter(ExtensibleFilter.java:106) [exo.portal.component.web.api-3.2.0-GA.jar:3.2.

      0-GA]

              at org.exoplatform.web.filter.ExtensibleFilter.doFilter(ExtensibleFilter

      .java:80) [exo.portal.component.web.api-3.2.0-GA.jar:3.2.0-GA]

              at org.exoplatform.web.filter.GenericFilter.doFilter(GenericFilter.java:

      79) [exo.portal.component.web.api-3.2.0-GA.jar:3.2.0-GA]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

              at org.exoplatform.web.CacheUserProfileFilter.doFilter(CacheUserProfileF

      ilter.java:73) [exo.portal.component.web.security-3.2.0-GA.jar:3.2.0-GA]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

              at org.exoplatform.frameworks.jcr.web.ThreadLocalSessionProviderInitiali

      zedFilter.doFilter(ThreadLocalSessionProviderInitializedFilter.java:116) [exo.jc

      r.framework.web-1.14.6-GA.jar:1.14.6-GA]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

              at org.exoplatform.services.security.web.SetCurrentIdentityFilter.doFilt

      er(SetCurrentIdentityFilter.java:88) [exo.core.component.security.core-2.4.6-GA.

      jar:2.4.6-GA]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

              at org.exoplatform.web.login.ClusteredSSOFilter.doFilter(ClusteredSSOFil

      ter.java:73) [exo.portal.component.web.security-3.2.0-GA.jar:3.2.0-GA]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

              at org.exoplatform.container.web.PortalContainerFilter.doFilter(PortalCo

      ntainerFilter.java:69) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-GA-AS

      7-Beta03]

              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl

      icationFilterChain.java:280) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF

      ilterChain.java:248) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV

      alve.java:275) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV

      alve.java:161) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica

      torBase.java:397) [jbossweb-7.0.10.Final.jar:]

              at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(Secu

      rityContextAssociationValve.java:154) [jboss-as-web-7.1.0.Final.jar:7.1.0.Final]

       

       

              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j

      ava:155) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j

      ava:102) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal

      ve.java:109) [jbossweb-7.0.10.Final.jar:]

              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav

      a:368) [jbossweb-7.0.10.Final.jar:]

              at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java

      :877) [jbossweb-7.0.10.Final.jar:]

              at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce

      ss(Http11Protocol.java:671) [jbossweb-7.0.10.Final.jar:]

              at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:93

      0) [jbossweb-7.0.10.Final.jar:]

              at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_31]

      Caused by: java.lang.RuntimeException: Cannot instantiate component key=org.exop

      latform.services.organization.OrganizationService type=org.exoplatform.services.

      organization.idm.PicketLinkIDMOrganizationServiceImpl found at jndi:/default-hos

      t/portal/WEB-INF/conf/organization/idm-configuration.xml

              at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan

      ce(MX4JComponentAdapter.java:135) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:

      2.3.6-GA-AS7-Beta03]

              at org.exoplatform.container.management.ManageableComponentAdapter.getCo

      mponentInstance(ManageableComponentAdapter.java:68) [exo.kernel.container-2.3.6-

      GA-AS7-Beta03.jar:2.3.6-GA-AS7-Beta03]

              at org.exoplatform.container.ConcurrentPicoContainer.getInstance(Concurr

      entPicoContainer.java:468) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-G

      A-AS7-Beta03]

              at org.exoplatform.container.ConcurrentPicoContainer.getComponentInstanc

      eOfType(ConcurrentPicoContainer.java:422) [exo.kernel.container-2.3.6-GA-AS7-Bet

      a03.jar:2.3.6-GA-AS7-Beta03]

              at org.exoplatform.container.CachingContainer.getComponentInstanceOfType

      (CachingContainer.java:139) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-

      GA-AS7-Beta03]

              at org.exoplatform.container.ExoContainer.createComponent(ExoContainer.j

      ava:407) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-GA-AS7-Beta03]

              at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan

      ce(MX4JComponentAdapter.java:97) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2

      .3.6-GA-AS7-Beta03]

              ... 54 more

      Caused by: java.lang.RuntimeException: Cannot instantiate component key=org.exop

      latform.services.organization.idm.PicketLinkIDMService type=org.exoplatform.serv

      ices.organization.idm.PicketLinkIDMServiceImpl found at jndi:/default-host/porta

      l/WEB-INF/conf/organization/idm-configuration.xml

              at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan

      ce(MX4JComponentAdapter.java:135) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:

      2.3.6-GA-AS7-Beta03]

              at org.exoplatform.container.management.ManageableComponentAdapter.getCo

      mponentInstance(ManageableComponentAdapter.java:68) [exo.kernel.container-2.3.6-

      GA-AS7-Beta03.jar:2.3.6-GA-AS7-Beta03]

              at org.exoplatform.container.ConcurrentPicoContainer.getInstance(Concurr

      entPicoContainer.java:468) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-G

      A-AS7-Beta03]

              at org.exoplatform.container.ConcurrentPicoContainer.getComponentInstanc

      eOfType(ConcurrentPicoContainer.java:422) [exo.kernel.container-2.3.6-GA-AS7-Bet

      a03.jar:2.3.6-GA-AS7-Beta03]

              at org.exoplatform.container.CachingContainer.getComponentInstanceOfType

      (CachingContainer.java:139) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-

      GA-AS7-Beta03]

              at org.exoplatform.container.ExoContainer.createComponent(ExoContainer.j

      ava:407) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-GA-AS7-Beta03]

              at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan

      ce(MX4JComponentAdapter.java:97) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2

      .3.6-GA-AS7-Beta03]

              ... 60 more

      Caused by: java.lang.reflect.InvocationTargetException

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

      [rt.jar:1.6.0_31]

              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct

      orAccessorImpl.java:39) [rt.jar:1.6.0_31]

              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC

      onstructorAccessorImpl.java:27) [rt.jar:1.6.0_31]

              at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [rt.j

      ar:1.6.0_31]

              at org.exoplatform.container.ExoContainer.createComponent(ExoContainer.j

      ava:417) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2.3.6-GA-AS7-Beta03]

              at org.exoplatform.container.jmx.MX4JComponentAdapter.getComponentInstan

      ce(MX4JComponentAdapter.java:97) [exo.kernel.container-2.3.6-GA-AS7-Beta03.jar:2

      .3.6-GA-AS7-Beta03]

              ... 66 more

      Caused by: org.hibernate.HibernateException: 'hibernate.dialect' must be set whe

      n no Connection avalable

              at org.hibernate.dialect.resolver.DialectFactory.buildDialect(DialectFac

      tory.java:107) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]

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

      134) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]

              at org.hibernate.cfg.Configuration.buildSettingsInternal(Configuration.j

      ava:2119) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]

              at org.hibernate.cfg.Configuration.buildSettings(Configuration.java:2115

      ) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]

              at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.jav

      a:1339) [hibernate-core-3.3.2.GA.jar:3.3.2.GA]

              at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(Annotat

      ionConfiguration.java:867) [hibernate-annotations-3.4.0.GA.jar:3.3.2.GA]

              at org.exoplatform.services.database.impl.HibernateServiceImpl$2.run(Hib

      ernateServiceImpl.java:302) [exo.core.component.database-2.4.6-GA.jar:2.4.6-GA]

              at org.exoplatform.services.database.impl.HibernateServiceImpl$2.run(Hib

      ernateServiceImpl.java:299) [exo.core.component.database-2.4.6-GA.jar:2.4.6-GA]

              at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedAction(Secur

      ityHelper.java:291) [exo.kernel.commons-2.3.6-GA.jar:3.2.0-GA]

              at org.exoplatform.services.database.impl.HibernateServiceImpl.getSessio

      nFactory(HibernateServiceImpl.java:298) [exo.core.component.database-2.4.6-GA.ja

      r:2.4.6-GA]

              at org.exoplatform.services.organization.idm.PicketLinkIDMServiceImpl.<i

      nit>(PicketLinkIDMServiceImpl.java:147) [exo.portal.component.identity-3.2.0-GA.

      jar:3.2.0-GA]

              ... 72 more

       

       

      04:34:25,034 ERROR [org.exoplatform.web.WebAppController] (http--127.0.0.1-8080-

      1) Could not associate the request path=/ with an handler

        • 1. Re: GateIn AS 7.1 preview is not able to switch to MySQL backend
          Stephan Müller Newbie

          Tony Kaska schrieb:

           

          ...

          Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

          ...

           

           

          I guess your MySQL Datasource is working and you tested it?

           

          Then you should try to make the com.mysql module globally available via standalone.xml

          <subsystem xmlns="urn:jboss:domain:ee:1.0">

                      <global-modules>

                          <module name="com.mysql" slot="main"/>

                      </global-modules>

          </subsystem>

           

          replace com.mysql with the place, where you put your module.

           

          ---

           

          I forgot to mention that i also changed the entries in the properties file under

          $JBossHome/gatein/modules/org/gatein/lib/main/exo.core.component.document-2.4.6-GA.jar/conf/configuration.properties

          This was needed because i got an error after restarting the server...

           

          Nachricht geändert durch Stephan Müller

          • 2. Re: GateIn AS 7.1 preview is not able to switch to MySQL backend
            Tony Kaska Newbie

            Thank you for tips. I am still not having any luck. My MySQL driver is not loading due to dependency error. May I know the version of the driver you are using and which is working for you. Please let me know. Thank you.

             

            -Tony

            • 3. Re: GateIn AS 7.1 preview is not able to switch to MySQL backend
              Minh Hoang TO Novice

              Could you post your configuration.properties file? In case you encounter exception even if the MySQL JDBC exists on the classpath, let's verify if the configuration.properties was correctly processed by setting

               

              -Dorg.exoplatform.container.configuration.debug=true and turn the log level of ConfigurationManagerImpl to FINEST.

              • 4. Re: GateIn AS 7.1 preview is not able to switch to MySQL backend
                Tony Kaska Newbie

                Thank you for helping me out. Please find the enclosed. But my problems are not with GateIn. Or I have not come to that level yet. I am not able to establish the MySQL datasource. That is where the problem is in my opinion. I am getting the following error. I need to get past setting the MySQL datasource right way first. I some help with that. Thank you.

                 

                JBAS014775:    New missing/unsatisfied dependencies:

                      service jboss.jdbc-driver.mysql-connector-java-5_1_19-bin_jar (missing) dependents: [service jboss.data-source.java:/MySqlDS]

                • 5. Re: GateIn AS 7.1 preview is not able to switch to MySQL backend
                  Antoine Herzog Master

                  Hi,

                   

                  I had the same error.

                  Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver

                  which causes also to see this error :

                  Caused by: org.hibernate.HibernateException: 'hibernate.dialect' must be set whe

                  n no Connection avalable

                  (which is not really a problem of dialect not being defined in the HibernateService configuration).

                   

                  It was solved with setting the driver as global module, with :

                   

                      
                  <subsystem xmlns="urn:jboss:domain:ee:1.0">
                          
                  <global-modules>
                              
                  <module name="com.mysql.jdbc" slot="main"/>
                          
                  </global-modules>
                      
                  </subsystem>
                  
                  
                  

                   

                  **********************

                  I did not need to do that :

                   

                  I forgot to mention that i also changed the entries in the properties file under

                  $JBossHome/gatein/modules/org/gatein/lib/main/exo.core.component.document-2.4.6-GA.jar/conf/configuration.properties

                  This was needed because i got an error after restarting the server...

                   

                  like Stephan, here above.

                   

                  I never had to change any config files inside the exo.core.component.document JAR, when using GateIn.

                  Changing config in the regular file (JBOSS_HOME/standalone/configuration/gatein/configuration.properties) is usually enough.

                  This way is quite stange... but if needed...

                   

                  **********************

                  Setting the driver as global is not the best way.

                   

                  This is a much better way to do this config, for a MySQL database for GateIn 3.3.0 and JBoss AS7 : https://community.jboss.org/message/741878#741878

                   

                  Antoine

                  JBoss Portal and GateIn (JSR-286), JSF, Richfaces, J2EE, Drools, BRMS.