8 Replies Latest reply on Feb 28, 2008 10:54 PM by Henrique Simoes

    PortletPreferences in MySql

    Henrique Simoes Newbie

      I'm using MySql 5.0.45 database.
      Now i'm trying to configure some portlets, like RSS Reader included in JBoss Portal. But the preferences it's not working (save).
      If change to HSQLDB (default), the preferences works fine.
      The log is like this when try do save the change in portlet preferences (Portal Administrator/Portlet Instances):

      2008-02-26 16:26:37,359 ERROR [STDERR] org.jboss.portal.portlet.InvalidPortletIdException: Cannot configure producer offered portlets
      2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.state.producer.ProducerPortletInvoker.setProperties(ProducerPortletInvoker.java:538)
      2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.federation.impl.FederatedPortletInvokerService.setProperties(FederatedPortletInvokerService.java:212)
      2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.federation.impl.FederatingPortletInvokerService.setProperties(FederatingPortletInvokerService.java:205)
      2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.impl.model.instance.AbstractInstance.setProperties(AbstractInstance.java:185)
      2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.admin.ui.InstanceManagerBean.updatePrefs(InstanceManagerBean.java:410)
      2008-02-26 16:26:37,359 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2008-02-26 16:26:37,359 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      2008-02-26 16:26:37,359 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2008-02-26 16:26:37,359 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
      2008-02-26 16:26:37,359 ERROR [STDERR] at com.sun.el.parser.AstValue.invoke(AstValue.java:130)
      2008-02-26 16:26:37,359 ERROR [STDERR] at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)
      2008-02-26 16:26:37,359 ERROR [STDERR] at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
      2008-02-26 16:26:37,359 ERROR [STDERR] at com.sun.facelets.el.LegacyMethodBinding.invoke(LegacyMethodBinding.java:69)
      2008-02-26 16:26:37,359 ERROR [STDERR] at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:61)

      To other features, the portal is working very well. Only preferences is with this problem.
      Tks.

      sorry about my English... ^_^

        • 1. Re: PortletPreferences in MySql
          Prabhat Jha Master

          Can you post the complete stack track from server.log? This is weird because I have not had this problem before.

          • 2. Re: PortletPreferences in MySql
            Henrique Simoes Newbie

            Ok. I will post only the error when try to save the preferences. before this there are no errors.

            2008-02-26 16:26:37,359 ERROR [STDERR] org.jboss.portal.portlet.InvalidPortletIdException: Cannot configure producer offered portlets
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.state.producer.ProducerPortletInvoker.setProperties(ProducerPortletInvoker.java:538)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.federation.impl.FederatedPortletInvokerService.setProperties(FederatedPortletInvokerService.java:212)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.federation.impl.FederatingPortletInvokerService.setProperties(FederatingPortletInvokerService.java:205)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.impl.model.instance.AbstractInstance.setProperties(AbstractInstance.java:185)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.admin.ui.InstanceManagerBean.updatePrefs(InstanceManagerBean.java:410)
            2008-02-26 16:26:37,359 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
            2008-02-26 16:26:37,359 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
            2008-02-26 16:26:37,359 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            2008-02-26 16:26:37,359 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
            2008-02-26 16:26:37,359 ERROR [STDERR] at com.sun.el.parser.AstValue.invoke(AstValue.java:130)
            2008-02-26 16:26:37,359 ERROR [STDERR] at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)
            2008-02-26 16:26:37,359 ERROR [STDERR] at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
            2008-02-26 16:26:37,359 ERROR [STDERR] at com.sun.facelets.el.LegacyMethodBinding.invoke(LegacyMethodBinding.java:69)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:61)
            2008-02-26 16:26:37,359 ERROR [STDERR] at javax.faces.component.UICommand.broadcast(UICommand.java:109)
            2008-02-26 16:26:37,359 ERROR [STDERR] at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:97)
            2008-02-26 16:26:37,359 ERROR [STDERR] at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:171)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:95)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:70)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.apache.myfaces.portlet.MyFacesGenericPortlet.processAction(MyFacesGenericPortlet.java:246)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.faces.loader.FacesPortlet.processAction(FacesPortlet.java:83)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl.invokeAction(PortletContainerImpl.java:458)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.impl.jsr168.PortletContainerImpl.dispatch(PortletContainerImpl.java:401)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.container.PortletContainerInvoker$1.invoke(PortletContainerInvoker.java:86)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.org$jboss$portal$core$aspects$portlet$TransactionInterceptor$invokeRequired$aop(TransactionInterceptor.java:106)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.aspects.portlet.TransactionInterceptor$invokeRequired_9103964459766407072.invokeNext(TransactionInterceptor$invokeRequired_9103964459766407072.java)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.aspects.portlet.TransactionInterceptor$invokeRequired_9103964459766407072.invokeNext(TransactionInterceptor$invokeRequired_9103964459766407072.java)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.aspects.portlet.TransactionInterceptor$invokeRequired_9103964459766407072.invokeNext(TransactionInterceptor$invokeRequired_9103964459766407072.java)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.invokeRequired(TransactionInterceptor.java)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.aspects.portlet.TransactionInterceptor.invoke(TransactionInterceptor.java:72)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.aspects.portlet.HeaderInterceptor.invoke(HeaderInterceptor.java:50)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.aspects.portlet.ProducerCacheInterceptor.invoke(ProducerCacheInterceptor.java:53)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.aspects.portlet.AjaxInterceptor.invoke(AjaxInterceptor.java:51)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.aspects.portlet.ModesInterceptor.invoke(ModesInterceptor.java:62)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.bridge.BridgeInterceptor.invoke(BridgeInterceptor.java:47)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.aspects.portlet.WindowStatesInterceptor.invoke(WindowStatesInterceptor.java:55)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.aspects.portlet.PortletSessionSynchronizationInterceptor.invoke(PortletSessionSynchronizationInterceptor.java:80)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.aspects.portlet.ContextTrackerInterceptor.invoke(ContextTrackerInterceptor.java:46)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.aspects.portlet.ContextDispatcherInterceptor$1.doCallback(ContextDispatcherInterceptor.java:104)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.web.command.CommandDispatcher$CallbackCommand.execute(CommandDispatcher.java:74)
            2008-02-26 16:26:37,359 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor431.invoke(Unknown Source)
            2008-02-26 16:26:37,359 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
            2008-02-26 16:26:37,359 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.web.command.CommandServlet.doGet(CommandServlet.java:131)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.web.command.CommandServlet.doPost(CommandServlet.java:162)
            2008-02-26 16:26:37,359 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
            2008-02-26 16:26:37,359 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:557)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:481)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.web.command.CommandServlet.include(CommandServlet.java:80)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.web.command.CommandDispatcher.include(CommandDispatcher.java:50)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.web.jboss.JBossWebContext.include(JBossWebContext.java:66)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.web.ServletContainer.include(ServletContainer.java:182)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.impl.spi.AbstractRequestContext.dispatch(AbstractRequestContext.java:81)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.aspects.portlet.ContextDispatcherInterceptor.invoke(ContextDispatcherInterceptor.java:76)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.aspects.portlet.SecureTransportInterceptor.invoke(SecureTransportInterceptor.java:68)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.aspects.portlet.ValveInterceptor.invoke(ValveInterceptor.java:60)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:157)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.container.PortletContainerInvoker.invoke(PortletContainerInvoker.java:198)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.state.producer.ProducerPortletInvoker.invoke(ProducerPortletInvoker.java:233)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.impl.portlet.state.ProducerPortletInvoker.org$jboss$portal$core$impl$portlet$state$ProducerPortletInvoker$invoke$aop(ProducerPortletInvoker.java:53)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.impl.portlet.state.ProducerPortletInvoker$invoke_N8654503705355129869.invokeNext(ProducerPortletInvoker$invoke_N8654503705355129869.java)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.impl.portlet.state.ProducerPortletInvoker$invoke_N8654503705355129869.invokeNext(ProducerPortletInvoker$invoke_N8654503705355129869.java)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.impl.portlet.state.ProducerPortletInvoker$invoke_N8654503705355129869.invokeNext(ProducerPortletInvoker$invoke_N8654503705355129869.java)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.impl.portlet.state.ProducerPortletInvoker.invoke(ProducerPortletInvoker.java)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.federation.impl.FederatedPortletInvokerService.invoke(FederatedPortletInvokerService.java:147)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.federation.impl.FederatingPortletInvokerService.invoke(FederatingPortletInvokerService.java:150)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.impl.model.instance.InstanceContainerImpl$1.invoke(InstanceContainerImpl.java:99)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.management.PortletContainerManagementInterceptorImpl.invoke(PortletContainerManagementInterceptorImpl.java:58)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.aspects.portlet.PortalSessionSynchronizationInterceptor.invoke(PortalSessionSynchronizationInterceptor.java:116)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.model.instance.InstanceSecurityInterceptor.invoke(InstanceSecurityInterceptor.java:91)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.aspects.portlet.ConsumerCacheInterceptor.invoke(ConsumerCacheInterceptor.java:175)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.portlet.invocation.PortletInterceptor.invoke(PortletInterceptor.java:38)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:157)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.impl.model.instance.InstanceContainerImpl.org$jboss$portal$core$impl$model$instance$InstanceContainerImpl$invoke$aop(InstanceContainerImpl.java:427)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.impl.model.instance.InstanceContainerImpl$invoke_N8654503705355129869.invokeNext(InstanceContainerImpl$invoke_N8654503705355129869.java)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.impl.model.instance.InstanceContainerImpl$invoke_N8654503705355129869.invokeNext(InstanceContainerImpl$invoke_N8654503705355129869.java)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.impl.model.instance.InstanceContainerImpl$invoke_N8654503705355129869.invokeNext(InstanceContainerImpl$invoke_N8654503705355129869.java)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.impl.model.instance.InstanceContainerImpl.invoke(InstanceContainerImpl.java)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.impl.model.instance.AbstractInstance.invoke(AbstractInstance.java:231)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.model.portal.command.action.InvokePortletWindowActionCommand.execute(InvokePortletWindowActionCommand.java:174)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.controller.ControllerCommand$1.invoke(ControllerCommand.java:68)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.aspects.controller.node.EventBroadcasterInterceptor.invoke(EventBroadcasterInterceptor.java:123)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:40)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.aspects.controller.ControlInterceptor.invoke(ControlInterceptor.java:56)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:40)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.aspects.controller.PageCustomizerInterceptor.invoke(PageCustomizerInterceptor.java:133)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:40)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.aspects.controller.PolicyEnforcementInterceptor.invoke(PolicyEnforcementInterceptor.java:78)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:40)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.aspects.controller.node.PortalNodeInterceptor.invoke(PortalNodeInterceptor.java:81)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:40)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,359 ERROR [STDERR] at org.jboss.portal.core.aspects.controller.NavigationalStateInterceptor.invoke(NavigationalStateInterceptor.java:42)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:40)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.controller.ajax.AjaxInterceptor.invoke(AjaxInterceptor.java:56)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:40)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.aspects.controller.ResourceAcquisitionInterceptor.invoke(ResourceAcquisitionInterceptor.java:50)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.controller.ControllerInterceptor.invoke(ControllerInterceptor.java:40)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:157)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.controller.ControllerContext.execute(ControllerContext.java:134)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.controller.Controller.processCommand(Controller.java:235)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.controller.Controller.handle(Controller.java:217)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.server.RequestControllerDispatcher.invoke(RequestControllerDispatcher.java:51)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:131)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.cms.aspect.IdentityBindingInterceptor.invoke(IdentityBindingInterceptor.java:47)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.server.aspects.server.ContentTypeInterceptor.invoke(ContentTypeInterceptor.java:68)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.aspects.server.PortalContextPathInterceptor.invoke(PortalContextPathInterceptor.java:45)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.aspects.server.LocaleInterceptor.invoke(LocaleInterceptor.java:96)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.aspects.server.UserInterceptor.invoke(UserInterceptor.java:246)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.server.aspects.server.SignOutInterceptor.invoke(SignOutInterceptor.java:98)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.impl.api.user.UserEventBridgeTriggerInterceptor.invoke(UserEventBridgeTriggerInterceptor.java:65)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.aspects.server.TransactionInterceptor.org$jboss$portal$core$aspects$server$TransactionInterceptor$invoke$aop(TransactionInterceptor.java:49)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.java:253)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.aspects.tx.TxInterceptor$RequiresNew.invoke(TxInterceptor.java:262)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.aspects.server.TransactionInterceptor$invoke_N5143606530999904530.invokeNext(TransactionInterceptor$invoke_N5143606530999904530.java)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.core.aspects.server.TransactionInterceptor.invoke(TransactionInterceptor.java)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.server.ServerInterceptor.invoke(ServerInterceptor.java:38)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.server.aspects.LockInterceptor$InternalLock.invoke(LockInterceptor.java:69)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.server.aspects.LockInterceptor.invoke(LockInterceptor.java:130)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invokeNext(Invocation.java:115)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.common.invocation.Invocation.invoke(Invocation.java:157)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.portal.server.servlet.PortalServlet.service(PortalServlet.java:250)
            2008-02-26 16:26:37,375 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
            2008-02-26 16:26:37,375 ERROR [STDERR] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
            2008-02-26 16:26:37,375 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
            


            • 3. Re: PortletPreferences in MySql
              Prabhat Jha Master

              Before you and I dig any further, can you see if you can personalize some other portlets without any problem? This could be something with RSS portlet itself.

              • 4. Re: PortletPreferences in MySql
                Henrique Simoes Newbie

                I had the same question.
                So I tried other portlets (RSS from PortletSwap) (and created one, only to test preference), the problem is the same.
                I filled the fields, like RssXml atribute, and click on "Save". When back to verify the preference value, was not modified.
                So, if I back the database to HSQLDB, this functionality works fine. But I NEED to use MySql here... :(
                Tks

                • 5. Re: PortletPreferences in MySql
                  Peter Johnson Master

                  Our portal uses MySQL and the preferences are stored and retrieved without any problems. I suspect a database configuration issue. Please run the myssql utility, enter the following command, and post the results:

                  show variables;

                  (you will want to widen your console window to prevent line wrapping, 110 characters should be sufficient)

                  • 6. Re: PortletPreferences in MySql
                    Henrique Simoes Newbie

                    Hi,
                    here is the result:

                    auto_increment_increment: 1
                    auto_increment_offset: 1
                    automatic_sp_privileges: ON
                    back_log: 50
                    basedir: C :\Arquivos de programas\MySQL\MySQL Server 5.0\
                    binlog_cache_size: 32768
                    bulk_insert_buffer_size: 8388608
                    character_set_client: latin1
                    character_set_connection: latin1
                    character_set_database: latin1
                    character_set_filesystem: binary
                    character_set_results: latin1
                    character_set_server: latin1
                    character_set_system: utf8
                    character_sets_dir: C :\Arquivos de programas\MySQL\MySQL Server 5.0\share\charsets\
                    collation_connection: latin1_swedish_ci
                    collation_database: latin1_swedish_ci
                    collation_server: latin1_swedish_ci
                    completion_type: 0
                    concurrent_insert: 1
                    connect_timeout: 5
                    datadir: C :\Arquivos de programas\MySQL\MySQL Server 5.0\Data\
                    date_format: %Y-%m-%d
                    datetime_format: %Y-%m-%d %H :%i :%s
                    default_week_format: 0
                    delay_key_write: ON
                    delayed_insert_limit: 100
                    delayed_insert_timeout: 300
                    delayed_queue_size: 1000
                    div_precision_increment: 4
                    engine_condition_pushdown: OFF
                    expire_logs_days: 0
                    flush: OFF
                    flush_time: 1800
                    ft_boolean_syntax: + -><()~* :""&|
                    ft_max_word_len: 84
                    ft_min_word_len: 4
                    ft_query_expansion_limit: 20
                    ft_stopword_file: (built-in)
                    group_concat_max_len: 1024
                    have_archive: YES
                    have_bdb: NO
                    have_blackhole_engine: YES
                    have_compress: YES
                    have_crypt: NO
                    have_csv: NO
                    have_dynamic_loading: YES
                    have_example_engine: NO
                    have_federated_engine: YES
                    have_geometry: YES
                    have_innodb: YES
                    have_isam: NO
                    have_merge_engine: YES
                    have_ndbcluster: NO
                    have_openssl: DISABLED
                    have_ssl: DISABLED
                    have_query_cache: YES
                    have_raid: NO
                    have_rtree_keys: YES
                    have_symlink: YES
                    hostname: hsawork
                    init_connect:
                    init_file:
                    init_slave:
                    innodb_additional_mem_pool_size: 2097152
                    innodb_autoextend_increment: 8
                    innodb_buffer_pool_awe_mem_mb: 0
                    innodb_buffer_pool_size: 33554432
                    innodb_checksums: ON
                    innodb_commit_concurrency: 0
                    innodb_concurrency_tickets: 500
                    innodb_data_file_path: ibdata1 :10M :autoextend
                    innodb_data_home_dir:
                    innodb_doublewrite: ON
                    innodb_fast_shutdown: 1
                    innodb_file_io_threads: 4
                    innodb_file_per_table: OFF
                    innodb_flush_log_at_trx_commit: 1
                    innodb_flush_method:
                    innodb_force_recovery: 0
                    innodb_lock_wait_timeout: 50
                    innodb_locks_unsafe_for_binlog: OFF
                    innodb_log_arch_dir:
                    innodb_log_archive: OFF
                    innodb_log_buffer_size: 1048576
                    innodb_log_file_size: 10485760
                    innodb_log_files_in_group: 2
                    innodb_log_group_home_dir: .\
                    innodb_max_dirty_pages_pct: 90
                    innodb_max_purge_lag: 0
                    innodb_mirrored_log_groups: 1
                    innodb_open_files: 300
                    innodb_rollback_on_timeout: OFF
                    innodb_support_xa: ON
                    innodb_sync_spin_loops: 20
                    innodb_table_locks: ON
                    innodb_thread_concurrency: 8
                    innodb_thread_sleep_delay: 10000
                    interactive_timeout: 28800
                    join_buffer_size: 131072
                    key_buffer_size: 18874368
                    key_cache_age_threshold: 300
                    key_cache_block_size: 1024
                    key_cache_division_limit: 100
                    language: C :\Arquivos de programas\MySQL\MySQL Server 5.0\share\english\
                    large_files_support: ON
                    large_page_size: 0
                    large_pages: OFF
                    lc_time_names: en_US
                    license: GPL
                    local_infile: ON
                    log: OFF
                    log_bin: OFF
                    log_bin_trust_function_creators: OFF
                    log_error: C :\Arquivos de programas\MySQL\MySQL Server 5.0\Data\hsawork.err
                    log_queries_not_using_indexes: OFF
                    log_slave_updates: OFF
                    log_slow_queries: OFF
                    log_warnings: 1
                    long_query_time: 10
                    low_priority_updates: OFF
                    lower_case_file_system: ON
                    lower_case_table_names: 1
                    max_allowed_packet: 1048576
                    max_binlog_cache_size: 4294967295
                    max_binlog_size: 1073741824
                    max_connect_errors: 10
                    max_connections: 100
                    max_delayed_threads: 20
                    max_error_count: 64
                    max_heap_table_size: 16777216
                    max_insert_delayed_threads: 20
                    max_join_size: 4294967295
                    max_length_for_sort_data: 1024
                    max_prepared_stmt_count: 16382
                    max_relay_log_size: 0
                    max_seeks_for_key: 4294967295
                    max_sort_length: 1024
                    max_sp_recursion_depth: 0
                    max_tmp_tables: 32
                    max_user_connections: 0
                    max_write_lock_count: 4294967295
                    multi_range_count: 256
                    myisam_data_pointer_size: 6
                    myisam_max_sort_file_size: 107374182400
                    myisam_recover_options: OFF
                    myisam_repair_threads: 1
                    myisam_sort_buffer_size: 27262976
                    myisam_stats_method: nulls_unequal
                    named_pipe: OFF
                    net_buffer_length: 16384
                    net_read_timeout: 30
                    net_retry_count: 10
                    net_write_timeout: 60
                    new: OFF
                    old_passwords: OFF
                    open_files_limit: 622
                    optimizer_prune_level: 1
                    optimizer_search_depth: 62
                    pid_file: C :\Arquivos de programas\MySQL\MySQL Server 5.0\Data\hsawork.pid
                    port: 3307
                    preload_buffer_size: 32768
                    profiling: OFF
                    profiling_history_size: 15
                    protocol_version: 10
                    query_alloc_block_size: 8192
                    query_cache_limit: 1048576
                    query_cache_min_res_unit: 4096
                    query_cache_size: 0
                    query_cache_type: ON
                    query_cache_wlock_invalidate: OFF
                    query_prealloc_size: 8192
                    range_alloc_block_size: 2048
                    read_buffer_size: 61440
                    read_only: OFF
                    read_rnd_buffer_size: 258048
                    relay_log_purge: ON
                    relay_log_space_limit: 0
                    rpl_recovery_rank: 0
                    secure_auth: OFF
                    secure_file_priv:
                    shared_memory: OFF
                    shared_memory_base_name: MYSQL
                    server_id: 0
                    skip_external_locking: ON
                    skip_networking: OFF
                    skip_show_database: OFF
                    slave_compressed_protocol: OFF
                    slave_load_tmpdir: C :\WINDOWS\TEMP\
                    slave_net_timeout: 3600
                    slave_skip_errors: OFF
                    slave_transaction_retries: 10
                    slow_launch_time: 2
                    sort_buffer_size: 262136
                    sql_big_selects: ON
                    sql_mode:
                    sql_notes: ON
                    sql_warnings: OFF
                    ssl_ca:
                    ssl_capath:
                    ssl_cert:
                    ssl_cipher:
                    ssl_key:
                    storage_engine: InnoDB
                    sync_binlog: 0
                    sync_frm: ON
                    system_time_zone: Hora oficial do Brasil
                    table_cache: 256
                    table_lock_wait_timeout: 50
                    table_type: InnoDB
                    thread_cache_size: 8
                    thread_stack: 196608
                    time_format: %H :%i :%s
                    time_zone: SYSTEM
                    timed_mutexes: OFF
                    tmp_table_size: 13631488
                    tmpdir: C :\WINDOWS\TEMP\
                    transaction_alloc_block_size: 8192
                    transaction_prealloc_size: 4096
                    tx_isolation: REPEATABLE-READ
                    updatable_views_with_limit: YES
                    version: 5.0.45-community-nt
                    version_comment: MySQL Community Edition (GPL)
                    version_compile_machine: ia32
                    version_compile_os: Win32
                    wait_timeout: 28800
                    

                    This problem occurs only with a new instance of a portlet. Instances created by portlet.xml works fine.
                    tks

                    • 7. Re: PortletPreferences in MySql
                      Peter Johnson Master

                      I dumped my mysql variables and these are the differences that I noted:

                      1) I am using utf8 for my character sets:

                      | character_set_client | utf8
                      | character_set_connection | utf8
                      | character_set_database | utf8
                      | character_set_filesystem | binary
                      | character_set_results | utf8
                      | character_set_server | utf8
                      | character_set_system | utf8
                      | collation_connection | utf8_general_ci
                      | collation_database | utf8_general_ci
                      | collation_server | utf8_general_ci

                      This might have an effect on the sorting algorithm, and could be the cause of the problem you are seeing.

                      2) Various buffer sizes are different, but this probably just reflects differences in memory sizes.

                      3) You changed the port to 3307

                      4) Your sql-mode is set to nothing, while mine is:

                      | sql_mode | STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

                      Not sure if this could cause the problem.

                      • 8. Re: PortletPreferences in MySql
                        Henrique Simoes Newbie

                        Hi. I finaly 'resolved' the problem installing the server again, removed all files and installing from zero.
                        Now it's working fine. May be a made some modification in some file (what I don't remember when).
                        Tks