4 Replies Latest reply on Mar 23, 2006 8:18 AM by Olaf Maass

    Error in installation of Jboss portal server with mysql4.0.2

    Pravin Surawar Newbie

      I have installed Jboss portal 2.2.1RC3 on JBOSS Server 4.0.3sp1 with mysql 4.0.21-debug on WINDOWS 2003 server. I have copied mysql-connector-java-3.1.12-bin.jar file in C:\jboss-4.0.3SP1\server\default\lib directory & portal-mysql-ds.xml file in C:\jboss-4.0.3SP1\server\default\deploy directory .

      As per installation guide, I have created jbossportal as database and portal@localhost as user with password 'portalpassword' with all privileges on jbossportal database.


      After starting JBOSS Server I am getting following error in server.log og JBOSS Server.
      ******************************************************
      --- MBeans waiting for other MBeans ---
      ObjectName: portal:service=TreeCache,type=persistent
      State: FAILED
      Reason: org.hibernate.exception.GenericJDBCException: could not execute query
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=PortalDS
      Depends On Me:
      portal:service=TreeCacheProvider,type=persistent

      ObjectName: portal:service=Hibernate
      State: FAILED
      Reason: org.hibernate.exception.GenericJDBCException: could not execute query
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=PortalDS
      Depends On Me:
      portal:service=Module,type=User
      portal:service=Module,type=Role

      ObjectName: portal:service=Hibernate,type=globalinstance
      State: FAILED
      Reason: org.hibernate.exception.GenericJDBCException: could not execute query
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=PortalDS
      Depends On Me:
      portal:container=Instance,type=global

      ObjectName: portal:service=Hibernate,type=globalportal
      State: FAILED
      Reason: org.hibernate.exception.GenericJDBCException: could not execute query
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=PortalDS
      Depends On Me:
      portal:container=PortalObject,type=global

      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      ObjectName: portal:service=Hibernate
      State: FAILED
      Reason: org.hibernate.exception.GenericJDBCException: could not execute query
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=PortalDS
      Depends On Me:
      portal:service=Module,type=User
      portal:service=Module,type=Role

      ObjectName: portal:service=Hibernate,type=globalportal
      State: FAILED
      Reason: org.hibernate.exception.GenericJDBCException: could not execute query
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=PortalDS
      Depends On Me:
      portal:container=PortalObject,type=global

      ObjectName: portal:service=Hibernate,type=globalinstance
      State: FAILED
      Reason: org.hibernate.exception.GenericJDBCException: could not execute query
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=PortalDS
      Depends On Me:
      portal:container=Instance,type=global

      ObjectName: portal:service=TreeCache,type=persistent
      State: FAILED
      Reason: org.hibernate.exception.GenericJDBCException: could not execute query
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=PortalDS
      Depends On Me:
      portal:service=TreeCacheProvider,type=persistent
      ******************************************************

      Also when I tried to check portal server with url http://localhost:8080/portal I am getting following error in server.log of jboss server
      ***********************************************
      2006-03-21 13:16:52,890 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/portal].[PortalServletWithPathMapping]] Servlet.service() for servlet PortalServletWithPathMapping threw exception
      java.lang.NullPointerException
      at org.jboss.portal.core.impl.model.portal.PersistentPortalObjectContainer.getObject(PersistentPortalObjectContainer.java:153)
      at org.jboss.portal.core.impl.model.portal.PersistentPortalObjectContainer.getContext(PersistentPortalObjectContainer.java:171)
      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:585)
      at org.jboss.mx.interceptor.AttributeDispatcher.invoke(AttributeDispatcher.java:84)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.interceptor.ModelMBeanAttributeInterceptor.invoke(ModelMBeanAttributeInterceptor.java:182)
      at org.jboss.mx.interceptor.PersistenceInterceptor.invoke(PersistenceInterceptor.java:61)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.server.AbstractMBeanInvoker.getAttribute(AbstractMBeanInvoker.java:343)
      at org.jboss.mx.server.MBeanServerImpl.getAttribute(MBeanServerImpl.java:541)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:106)
      at $Proxy53.getContext(Unknown Source)
      at org.jboss.portal.core.model.portal.DefaultPortalCommandMapper.doMapping(DefaultPortalCommandMapper.java:86)
      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:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
      at $Proxy57.doMapping(Unknown Source)
      at org.jboss.portal.core.CoreController.handle(CoreController.java:189)
      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:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:273)
      at $Proxy108.handle(Unknown Source)
      at org.jboss.portal.server.ServerInvocation.dispatch(ServerInvocation.java:76)
      at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:140)
      at org.jboss.portal.core.aspects.server.SubjectAssociationInterceptor.invoke(SubjectAssociationInterceptor.java:47)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
      at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.server.PolicyAssociationInterceptor.invoke(PolicyAssociationInterceptor.java:52)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
      at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:68)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
      at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleInterceptor.java:69)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
      at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInterceptor.java:184)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
      at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.server.aspects.server.SessionInvalidatorInterceptor.invoke(SessionInvalidatorInterceptor.java:87)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
      at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.core.aspects.server.TransactionInterceptor.invoke(TransactionInterceptor.java:75)
      at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
      at org.jboss.portal.server.invocation.Invocation.invokeNext(Invocation.java:130)
      at org.jboss.portal.server.invocation.Invocation.invoke(Invocation.java:175)
      at org.jboss.portal.server.servlet.PortalServlet.doGet(PortalServlet.java:221)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:696)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:809)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)
      at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)
      at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:407)
      at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
      at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)
      at java.lang.Thread.run(Thread.java:595)
      ***********************************************

      Can any body help me ....

      Thanks ..//
      PRavin..//