14 Replies Latest reply on Apr 17, 2007 4:57 PM by Prabhat Jha

    MS SQL with Jboss-portal-2.6-BETA1

    Grant Newbie

      MSSQL 8.0 and portal beta 1. All the tables appear to build and populate, but I can't access the portal. This is my portalDs:

      <local-tx-datasource>
      <jndi-name>PortalDS</jndi-name>
      <connection-url>jdbc:inetdae:localhost:1433?database=jbossbeta1</connection-url>
      <driver-class>com.inet.tds.TdsDriver</driver-class>
      <user-name>portal</user-name>
      portal
      </local-tx-datasource>


      if I use the hsqldb-ds everything works fine. Is anyone using mssql with jboss portal?

        • 1. Re: MS SQL with Jboss-portal-2.6-BETA1
          Prabhat Jha Master

          I am not sure if you cut and pasted it worng but your ds.xml does not look right. Also, please send the error from server log.

          • 2. Re: MS SQL with Jboss-portal-2.6-BETA1
            Grant Newbie

            I restarted and now I get the log in screen. I log in as admin and I get the following error:
            14:45:25,798 ERROR [PortalServlet] Unexpected exception
            java.lang.NullPointerException
            at org.jboss.portal.core.impl.model.CustomizationManagerService.getDashb
            oard(CustomizationManagerService.java:257)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
            java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
            sorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
            er.java:155)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
            at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
            or.java:133)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
            at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
            BeanOperationInterceptor.java:142)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
            java:264)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
            at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
            at $Proxy116.getDashboard(Unknown Source)
            at org.jboss.portal.core.aspects.controller.PageCustomizerInterceptor.in
            jectDashboardNav(PageCustomizerInterceptor.java:191)
            at org.jboss.portal.core.aspects.controller.PageCustomizerInterceptor.in
            voke(PageCustomizerInterceptor.java:127)
            at org.jboss.portal.core.controller.ControllerInterceptor.invoke(Control
            lerInterceptor.java:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor
            .invoke(PolicyEnforcementInterceptor.java:68)
            at org.jboss.portal.core.controller.ControllerInterceptor.invoke(Control
            lerInterceptor.java:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.core.aspects.controller.node.PortalNodeInterceptor.i
            nvoke(PortalNodeInterceptor.java:54)
            at org.jboss.portal.core.controller.ControllerInterceptor.invoke(Control
            lerInterceptor.java:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:
            157)
            at org.jboss.portal.core.controller.ControllerContext.execute(Controller
            Context.java:86)
            at org.jboss.portal.core.controller.classic.ClassicController.handle(Cla
            ssicController.java:88)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
            java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
            sorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
            er.java:155)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
            at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
            or.java:133)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
            at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
            BeanOperationInterceptor.java:142)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
            java:264)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
            at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.ja
            va:287)
            at $Proxy230.handle(Unknown Source)
            at org.jboss.portal.server.RequestControllerDispatcher.invoke(RequestCon
            trollerDispatcher.java:51)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:131)
            at org.jboss.portal.core.cms.aspect.IdentityBindingInterceptor.invoke(Id
            entityBindingInterceptor.java:46)
            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
            va:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(
            ContentTypeInterceptor.java:67)
            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
            va:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleI
            nterceptor.java:108)
            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
            va:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInter
            ceptor.java:188)
            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
            va:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.server.aspects.server.SessionInvalidatorInterceptor.
            invoke(SessionInvalidatorInterceptor.java:85)
            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
            va:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.core.aspects.server.TransactionInterceptor.org$jboss
            $portal$core$aspects$server$TransactionInterceptor$invoke$aop(TransactionInterce
            ptor.java:49)
            at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5
            143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530
            .java)
            at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
            at org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.j
            ava:262)
            at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5
            143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530
            .java)
            at org.jboss.portal.core.aspects.server.TransactionInterceptor.invoke(Tr
            ansactionInterceptor.java)
            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
            va:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:
            157)
            at org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.j
            ava:381)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
            icationFilterChain.java:252)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
            ilterChain.java:173)
            at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
            lter.java:96)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
            icationFilterChain.java:202)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
            ilterChain.java:173)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
            alve.java:213)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
            alve.java:178)
            at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
            yAssociationValve.java:175)
            at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
            torBase.java:524)
            at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
            e.java:74)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
            ava:126)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
            ava:105)
            at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConne
            ctionValve.java:156)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
            ve.java:107)
            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
            a:148)
            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
            :869)
            at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
            rocessConnection(Http11BaseProtocol.java:664)
            at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
            int.java:527)
            at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
            kerThread.java:112)
            at java.lang.Thread.run(Thread.java:534)
            14:45:25,845 ERROR [[PortalServletWithPathMapping]] Servlet.service() for servle
            t PortalServletWithPathMapping threw exception
            java.lang.NullPointerException
            at org.jboss.portal.core.impl.model.CustomizationManagerService.getDashb
            oard(CustomizationManagerService.java:257)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
            java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
            sorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
            er.java:155)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
            at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
            or.java:133)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
            at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
            BeanOperationInterceptor.java:142)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
            java:264)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
            at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
            at $Proxy116.getDashboard(Unknown Source)
            at org.jboss.portal.core.aspects.controller.PageCustomizerInterceptor.in
            jectDashboardNav(PageCustomizerInterceptor.java:191)
            at org.jboss.portal.core.aspects.controller.PageCustomizerInterceptor.in
            voke(PageCustomizerInterceptor.java:127)
            at org.jboss.portal.core.controller.ControllerInterceptor.invoke(Control
            lerInterceptor.java:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor
            .invoke(PolicyEnforcementInterceptor.java:68)
            at org.jboss.portal.core.controller.ControllerInterceptor.invoke(Control
            lerInterceptor.java:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.core.aspects.controller.node.PortalNodeInterceptor.i
            nvoke(PortalNodeInterceptor.java:54)
            at org.jboss.portal.core.controller.ControllerInterceptor.invoke(Control
            lerInterceptor.java:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:
            157)
            at org.jboss.portal.core.controller.ControllerContext.execute(Controller
            Context.java:86)
            at org.jboss.portal.core.controller.classic.ClassicController.handle(Cla
            ssicController.java:88)
            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.
            java:39)
            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
            sorImpl.java:25)
            at java.lang.reflect.Method.invoke(Method.java:324)
            at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatch
            er.java:155)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
            at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractIntercept
            or.java:133)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
            at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelM
            BeanOperationInterceptor.java:142)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.
            java:264)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
            at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.ja
            va:287)
            at $Proxy230.handle(Unknown Source)
            at org.jboss.portal.server.RequestControllerDispatcher.invoke(RequestCon
            trollerDispatcher.java:51)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:131)
            at org.jboss.portal.core.cms.aspect.IdentityBindingInterceptor.invoke(Id
            entityBindingInterceptor.java:46)
            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
            va:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(
            ContentTypeInterceptor.java:67)
            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
            va:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleI
            nterceptor.java:108)
            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
            va:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInter
            ceptor.java:188)
            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
            va:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.server.aspects.server.SessionInvalidatorInterceptor.
            invoke(SessionInvalidatorInterceptor.java:85)
            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
            va:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.core.aspects.server.TransactionInterceptor.org$jboss
            $portal$core$aspects$server$TransactionInterceptor$invoke$aop(TransactionInterce
            ptor.java:49)
            at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5
            143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530
            .java)
            at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
            at org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.j
            ava:262)
            at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5
            143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530
            .java)
            at org.jboss.portal.core.aspects.server.TransactionInterceptor.invoke(Tr
            ansactionInterceptor.java)
            at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.ja
            va:38)
            at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.j
            ava:115)
            at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:
            157)
            at org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.j
            ava:381)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
            icationFilterChain.java:252)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
            ilterChain.java:173)
            at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
            lter.java:96)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
            icationFilterChain.java:202)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
            ilterChain.java:173)
            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
            alve.java:213)
            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
            alve.java:178)
            at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
            yAssociationValve.java:175)
            at org.apache.catalina.authenticator.AuthenticatorBase.invoke(Authentica
            torBase.java:524)
            at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
            e.java:74)
            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
            ava:126)
            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
            ava:105)
            at org.jboss.web.tomcat.tc5.jca.CachedConnectionValve.invoke(CachedConne
            ctionValve.java:156)
            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
            ve.java:107)
            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
            a:148)
            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
            :869)
            at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.p
            rocessConnection(Http11BaseProtocol.java:664)
            at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
            int.java:527)
            at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
            kerThread.java:112)
            at java.lang.Thread.run(Thread.java:534)





















            • 3. Re: MS SQL with Jboss-portal-2.6-BETA1
              Grant Newbie

              I restarted and got no errors during startup, however when I go to the localhost:8080/portal I get the following:
              java.lang.IllegalStateException: Default portal does not exist
              org.jboss.portal.core.model.portal.DefaultPortalCommandFactory.doMapping(DefaultPortalCommandFactory.java:74)
              sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              java.lang.reflect.Method.invoke(Method.java:324)
              org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
              org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
              org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
              org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
              org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
              org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
              org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
              org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
              org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
              $Proxy110.doMapping(Unknown Source)
              org.jboss.portal.core.controller.classic.ClassicController.handle(ClassicController.java:69)
              sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              java.lang.reflect.Method.invoke(Method.java:324)
              org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
              org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
              org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
              org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
              org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
              org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
              org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
              org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
              org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:287)
              $Proxy229.handle(Unknown Source)
              org.jboss.portal.server.RequestControllerDispatcher.invoke(RequestControllerDispatcher.java:51)
              org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
              org.jboss.portal.core.cms.aspect.IdentityBindingInterceptor.invoke(IdentityBindingInterceptor.java:46)
              org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
              org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
              org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:67)
              org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
              org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
              org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleInterceptor.java:108)
              org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
              org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
              org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInterceptor.java:188)
              org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
              org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
              org.jboss.portal.server.aspects.server.SessionInvalidatorInterceptor.invoke(SessionInvalidatorInterceptor.java:85)
              org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
              org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
              org.jboss.portal.core.aspects.server.TransactionInterceptor.org$jboss$portal$core$aspects$server$TransactionInterceptor$invoke$aop(TransactionInterceptor.java:49)
              org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
              org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
              org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.java:262)
              org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
              org.jboss.portal.core.aspects.server.TransactionInterceptor.invoke(TransactionInterceptor.java)
              org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
              org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
              org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:157)
              org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:381)
              javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
              org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

              • 4. Re: MS SQL with Jboss-portal-2.6-BETA1
                Prabhat Jha Master

                I had tested 2.6 beta1 with mysql8 and dont remember seeing any problem. Are you using the DB instance from older portal installation? If you have not tried that already, I would suggest dropping the database and recreating it again and see if that solves the problem. Also don't forget to clean up server/default/data folder as well.

                • 5. Re: MS SQL with Jboss-portal-2.6-BETA1
                  Grant Newbie

                  What does this mean? clean up server/default/data folder

                  • 6. Re: MS SQL with Jboss-portal-2.6-BETA1
                    Prabhat Jha Master

                    The data folder is in $JBOSS_INSTALL_DIR/server/default. Please delete data, work and tmp folders.

                    • 7. Re: MS SQL with Jboss-portal-2.6-BETA1
                      Grant Newbie

                      Also, this is MS SQL sever 2000

                      • 8. Re: MS SQL with Jboss-portal-2.6-BETA1
                        Prabhat Jha Master

                        My bad, I read MSSQL as MYSql. We run our testssuite with MS Sqlserver 2005 and use corresponding hibernate dialect. We have not run testsuite with SQL Server 2000 in a while. But I dont think it would be of much difference.

                        • 9. Re: MS SQL with Jboss-portal-2.6-BETA1
                          Grant Newbie

                          can you post or email your ds files. I have been developing on alpha with hypersonic, however I will need this to be working with MSSQL and Oracle soon. We had Mr. Russo on site (McKesson) a couple months ago so he is familiar with what we are trying to accomplish.

                          • 10. Re: MS SQL with Jboss-portal-2.6-BETA1
                            Prabhat Jha Master

                            <local-tx-datasource>
                            <jndi-name>PortalDS</jndi-name>
                            <connection-url>jdbc:jtds:sqlserver://host:port/portal</connection-url>
                            <driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>
                            <user-name>portal</user-name>
                            your_password
                            </local-tx-datasource>

                            • 11. Re: MS SQL with Jboss-portal-2.6-BETA1
                              Grant Newbie

                              This is a list of tables built and populated, are they all there?
                              jbp_cms_cmsentry
                              jbp_cms_perm
                              jbp_cms_perm_criteria
                              jbp_cms_perm_role
                              jbp_cms_perm_user
                              jbp_cms_repositoryentry
                              jbp_cms_version_binval
                              jbp_cms_version_node
                              jbp_cms_version_prop
                              jbp_cms_version_refs
                              jbp_cms_versionentry
                              jbp_cms_wsp_binval
                              jbp_cms_wsp_node
                              jbp_cms_wsp_prop
                              jbp_cms_wsp_refs
                              JBP_CONTEXT
                              JBP_INSTANCE
                              JBP_INSTANCE_PER_USER
                              JBP_INSTANCE_SECURITY
                              JBP_INSTANCE_SECURITY_ACTIONS
                              JBP_OBJECT_NODE
                              JBP_OBJECT_NODE_SEC
                              JBP_OBJECT_NODE_SEC_ACTIONS
                              JBP_PAGE
                              JBP_PORTAL
                              JBP_PORTAL_MODE
                              JBP_PORTAL_OBJECT
                              JBP_PORTAL_OBJECT_PROPS
                              JBP_PORTAL_WINDOW_STATE
                              JBP_PORTLET_CONSUMER
                              JBP_PORTLET_GROUP
                              JBP_PORTLET_REGISTRATION
                              JBP_PORTLET_STATE
                              JBP_PORTLET_STATE_ENTRY
                              JBP_PORTLET_STATE_ENTRY_VALUE
                              jbp_role_membership
                              jbp_roles
                              jbp_user_prop
                              jbp_users
                              JBP_WINDOW
                              JBPM_ACTION
                              JBPM_BYTEARRAY
                              JBPM_BYTEBLOCK
                              JBPM_COMMENT
                              JBPM_DECISIONCONDITIONS
                              JBPM_DELEGATION
                              JBPM_EVENT
                              JBPM_EXCEPTIONHANDLER
                              JBPM_ID_GROUP
                              JBPM_ID_MEMBERSHIP
                              JBPM_ID_PERMISSIONS
                              JBPM_ID_USER
                              JBPM_LOG
                              JBPM_MESSAGE
                              JBPM_MODULEDEFINITION
                              JBPM_MODULEINSTANCE
                              JBPM_NODE
                              JBPM_POOLEDACTOR
                              JBPM_PROCESSDEFINITION
                              JBPM_PROCESSINSTANCE
                              JBPM_RUNTIMEACTION
                              JBPM_SWIMLANE
                              JBPM_SWIMLANEINSTANCE
                              JBPM_TASK
                              JBPM_TASKACTORPOOL
                              JBPM_TASKCONTROLLER
                              JBPM_TASKINSTANCE
                              JBPM_TIMER
                              JBPM_TOKEN
                              JBPM_TOKENVARIABLEMAP
                              JBPM_TRANSITION
                              JBPM_VARIABLEACCESS
                              JBPM_VARIABLEINSTANCE

                              • 12. Re: MS SQL with Jboss-portal-2.6-BETA1
                                Grant Newbie

                                These are the table built and populated. Are they all there?
                                jbp_cms_cmsentry
                                jbp_cms_perm
                                jbp_cms_perm_criteria
                                jbp_cms_perm_role
                                jbp_cms_perm_user
                                jbp_cms_repositoryentry
                                jbp_cms_version_binval
                                jbp_cms_version_node
                                jbp_cms_version_prop
                                jbp_cms_version_refs
                                jbp_cms_versionentry
                                jbp_cms_wsp_binval
                                jbp_cms_wsp_node
                                jbp_cms_wsp_prop
                                jbp_cms_wsp_refs
                                JBP_CONTEXT
                                JBP_INSTANCE
                                JBP_INSTANCE_PER_USER
                                JBP_INSTANCE_SECURITY
                                JBP_INSTANCE_SECURITY_ACTIONS
                                JBP_OBJECT_NODE
                                JBP_OBJECT_NODE_SEC
                                JBP_OBJECT_NODE_SEC_ACTIONS
                                JBP_PAGE
                                JBP_PORTAL
                                JBP_PORTAL_MODE
                                JBP_PORTAL_OBJECT
                                JBP_PORTAL_OBJECT_PROPS
                                JBP_PORTAL_WINDOW_STATE
                                JBP_PORTLET_CONSUMER
                                JBP_PORTLET_GROUP
                                JBP_PORTLET_REGISTRATION
                                JBP_PORTLET_STATE
                                JBP_PORTLET_STATE_ENTRY
                                JBP_PORTLET_STATE_ENTRY_VALUE
                                jbp_role_membership
                                jbp_roles
                                jbp_user_prop
                                jbp_users
                                JBP_WINDOW
                                JBPM_ACTION
                                JBPM_BYTEARRAY
                                JBPM_BYTEBLOCK
                                JBPM_COMMENT
                                JBPM_DECISIONCONDITIONS
                                JBPM_DELEGATION
                                JBPM_EVENT
                                JBPM_EXCEPTIONHANDLER
                                JBPM_ID_GROUP
                                JBPM_ID_MEMBERSHIP
                                JBPM_ID_PERMISSIONS
                                JBPM_ID_USER
                                JBPM_LOG
                                JBPM_MESSAGE
                                JBPM_MODULEDEFINITION
                                JBPM_MODULEINSTANCE
                                JBPM_NODE
                                JBPM_POOLEDACTOR
                                JBPM_PROCESSDEFINITION
                                JBPM_PROCESSINSTANCE
                                JBPM_RUNTIMEACTION
                                JBPM_SWIMLANE
                                JBPM_SWIMLANEINSTANCE
                                JBPM_TASK
                                JBPM_TASKACTORPOOL
                                JBPM_TASKCONTROLLER
                                JBPM_TASKINSTANCE
                                JBPM_TIMER
                                JBPM_TOKEN
                                JBPM_TOKENVARIABLEMAP
                                JBPM_TRANSITION
                                JBPM_VARIABLEACCESS
                                JBPM_VARIABLEINSTANCE

                                • 13. Re: MS SQL with Jboss-portal-2.6-BETA1
                                  Grant Newbie

                                  I switched to a different driver and it seems to work fine.


                                  <local-tx-datasource>
                                  <jndi-name>PortalDS</jndi-name>
                                  <connection-url>jdbc:inetdae7:localhost:1433?database=jbossportal</connection-url>
                                  <driver-class>com.inet.tds.TdsDriver</driver-class>
                                  <user-name>portal</user-name>
                                  portal
                                  </local-tx-datasource>

                                  • 14. Re: MS SQL with Jboss-portal-2.6-BETA1
                                    Prabhat Jha Master

                                    I am glad it's working.