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.