[Seasar-user:9170] Re: [S2Dao]Pager でSqlファイルを指定する場合

[Hideyuki Ohkawa]

小林様
大川です。


こちらの、環境で言い忘れていたことがありました。
Pager機能はteeda1.0.7上で使用しています。

また、Dtoは、Pagerで使用していますので、
「DefaultPagerCondition」を継承しています。


> 念のため，dto.userId != "789" の場合のスタック
> トレースを見せていただけますか？
ファイルを添付いたしました。


> それから，Dao を呼び出す前に UserInfoDto の
> userId プロパティの値をログに出力してください．
> # System.out.println(〜) で構いません．
System.out.println(〜)で出力したところ、
789
と、表示されました。


どうかよろしくお願いいたします。


07/07/13 に Koichi Kobayashi<[E-MAIL ADDRESS DELETED]> さんは書きました:
> 小林 (koichik) です．
>
> Date:    Fri, 13 Jul 2007 14:25:22 +0900
> From:    "Hideyuki Ohkawa" <[E-MAIL ADDRESS DELETED]>
> To:       [E-MAIL ADDRESS DELETED]
> Subject: [Seasar-user:9160] Re: [S2Dao]Pager でSqlファイルを指定する場合
>
> > 下記の方法の、
> > dto.userId != "789"
> > !dto.userId.equals("789")
> > ともに試してみましたが、今までと同じ例外が発生して、
> > 結果は変わりませんでした。
>
> 両辺が文字列なら全く同じ例外になることは
> なさそうですが．．．
> 表面的には同じ OgnlRuntimeException でも，
> その原因になった例外が [Seasar-user:9148] の
> NumberFormatException とは変わっていないでしょうか？
>
> 念のため，dto.userId != "789" の場合のスタック
> トレースを見せていただけますか？
>
> それから，Dao を呼び出す前に UserInfoDto の
> userId プロパティの値をログに出力してください．
> # System.out.println(〜) で構いません．
>
>
> --
> <signature>
>   <name>Koichi Kobayashi</name>
>   <e-mail>[E-MAIL ADDRESS DELETED]</e-mail>
> </signature>
>
> _______________________________________________
> Seasar-user mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-user
>
-------------- next part --------------
org.seasar.framework.exception.OgnlRuntimeException: [ESSR0073]OGNL〓〓〓〓〓O〓〓〓〓〓〓〓〓〓〓〓〓〓〓〓B〓〓〓R〓〓For input string: "[E-MAIL ADDRESS DELETED]"
  at org.seasar.framework.util.OgnlUtil#getValue (OgnlUtil.java#62)
  at org.seasar.framework.util.OgnlUtil#getValue (OgnlUtil.java#42)
  at org.seasar.framework.util.OgnlUtil#getValue (OgnlUtil.java#37)
  at org.seasar.dao.node.IfNode#accept (IfNode.java#55)
  at org.seasar.dao.node.ContainerNode#accept (ContainerNode.java#34)
  at org.seasar.dao.node.BeginNode#accept (BeginNode.java#32)
  at org.seasar.dao.node.ContainerNode#accept (ContainerNode.java#34)
  at org.seasar.dao.impl.AbstractDynamicCommand#apply (AbstractDynamicCommand.java#66)
  at org.seasar.dao.impl.SelectDynamicCommand#execute (SelectDynamicCommand.java#50)
  at org.seasar.dao.interceptors.S2DaoInterceptor#invoke (S2DaoInterceptor.java#53)
  at org.seasar.dao.pager.PagerS2DaoInterceptorWrapper#invoke (PagerS2DaoInterceptorWrapper.java#71)
  at ookawara.web.cando.UserInfoDao$$EnhancedByS2AOP$$f38b42$$MethodInvocation$$getMurakiCondition4#proceed (MethodInvocationClassGenerator.java)
  at org.seasar.framework.aop.interceptors.TraceInterceptor#invoke (TraceInterceptor.java#70)
  at ookawara.web.cando.UserInfoDao$$EnhancedByS2AOP$$f38b42$$MethodInvocation$$getMurakiCondition4#proceed (MethodInvocationClassGenerator.java)
  at ookawara.web.cando.UserInfoDao$$EnhancedByS2AOP$$f38b42#getMurakiCondition (UserInfoDao$$EnhancedByS2AOP$$f38b42.java)
  at ookawara.web.cando.ResultPage#prerender (ResultPage.java#238)
  at ookawara.web.cando.ResultPage$$EnhancedByS2AOP$$db81f3#$$prerender$$invokeSuperMethod$$ (ResultPage$$EnhancedByS2AOP$$db81f3.java)
  at ookawara.web.cando.ResultPage$$EnhancedByS2AOP$$db81f3$$MethodInvocation$$prerender1#proceed (MethodInvocationClassGenerator.java)
  at org.seasar.framework.aop.interceptors.ThrowsInterceptor#invoke (ThrowsInterceptor.java#73)
  at ookawara.web.cando.ResultPage$$EnhancedByS2AOP$$db81f3$$MethodInvocation$$prerender1#proceed (MethodInvocationClassGenerator.java)
  at ookawara.web.cando.ResultPage$$EnhancedByS2AOP$$db81f3#prerender (ResultPage$$EnhancedByS2AOP$$db81f3.java)
  at sun.reflect.NativeMethodAccessorImpl#invoke0 (NativeMethodAccessorImpl.java)
  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.seasar.framework.util.MethodUtil#invoke (MethodUtil.java#49)
  at org.seasar.framework.beans.impl.BeanDescImpl#invoke (BeanDescImpl.java#213)
  at org.seasar.teeda.extension.html.impl.HtmlComponentInvokerImpl#invoke (HtmlComponentInvokerImpl.java#159)
  at org.seasar.teeda.extension.render.TViewRootRenderer#invoke (TViewRootRenderer.java#325)
  at org.seasar.teeda.extension.render.TViewRootRenderer#invoke (TViewRootRenderer.java#319)
  at org.seasar.teeda.extension.render.TViewRootRenderer#encodeBegin (TViewRootRenderer.java#213)
  at javax.faces.component.UIComponentBase#encodeBegin (UIComponentBase.java#331)
  at javax.faces.component.UIViewRoot#encodeBegin (UIViewRoot.java#100)
  at javax.faces.webapp.UIComponentTag#encodeBegin (UIComponentTag.java#240)
  at javax.faces.webapp.UIComponentTag#doStartTag (UIComponentTag.java#177)
  at org.seasar.teeda.extension.taglib.TViewTag#doStartTag (TViewTag.java#90)
  at org.seasar.teeda.extension.html.processor.ElementProcessorImpl#processTag (ElementProcessorImpl.java#145)
  at org.seasar.teeda.extension.html.processor.ElementProcessorImpl#process (ElementProcessorImpl.java#138)
  at org.seasar.teeda.extension.html.processor.ElementProcessorImpl#process (ElementProcessorImpl.java#119)
  at org.seasar.teeda.extension.html.impl.HtmlViewHandler#renderView (HtmlViewHandler.java#145)
  at org.seasar.teeda.extension.html.impl.HtmlViewHandler#renderView (HtmlViewHandler.java#135)
  at org.seasar.teeda.core.lifecycle.impl.RenderResponsePhase#executePhase (RenderResponsePhase.java#38)
  at org.seasar.teeda.core.lifecycle.AbstractPhase#execute (AbstractPhase.java#55)
  at org.seasar.teeda.core.lifecycle.LifecycleImpl#render (LifecycleImpl.java#128)

java.lang.NumberFormatException: For input string: "[E-MAIL ADDRESS DELETED]"
  at sun.misc.FloatingDecimal#readJavaFormatString (FloatingDecimal.java#1224)
  at java.lang.Double#parseDouble (Double.java#482)
  at ognl.OgnlOps#doubleValue (OgnlOps.java#214)
  at ognl.OgnlOps#compareWithConversion (OgnlOps.java#99)
  at ognl.OgnlOps#isEqual (OgnlOps.java#142)
  at ognl.OgnlOps#equal (OgnlOps.java#533)
  at ognl.ASTNotEq#getValueBody (ASTNotEq.java#51)
  at ognl.SimpleNode#evaluateGetValueBody (SimpleNode.java#170)
  at ognl.SimpleNode#getValue (SimpleNode.java#210)
  at ognl.Ognl#getValue (Ognl.java#333)
  at ognl.Ognl#getValue (Ognl.java#413)
  at ognl.Ognl#getValue (Ognl.java#395)
  at org.seasar.framework.util.OgnlUtil#getValue (OgnlUtil.java#56)
  at org.seasar.framework.util.OgnlUtil#getValue (OgnlUtil.java#42)
  at org.seasar.framework.util.OgnlUtil#getValue (OgnlUtil.java#37)
  at org.seasar.dao.node.IfNode#accept (IfNode.java#55)
  at org.seasar.dao.node.ContainerNode#accept (ContainerNode.java#34)
  at org.seasar.dao.node.BeginNode#accept (BeginNode.java#32)
  at org.seasar.dao.node.ContainerNode#accept (ContainerNode.java#34)
  at org.seasar.dao.impl.AbstractDynamicCommand#apply (AbstractDynamicCommand.java#66)
  at org.seasar.dao.impl.SelectDynamicCommand#execute (SelectDynamicCommand.java#50)
  at org.seasar.dao.interceptors.S2DaoInterceptor#invoke (S2DaoInterceptor.java#53)
  at org.seasar.dao.pager.PagerS2DaoInterceptorWrapper#invoke (PagerS2DaoInterceptorWrapper.java#71)
  at ookawara.web.cando.UserInfoDao$$EnhancedByS2AOP$$f38b42$$MethodInvocation$$getMurakiCondition4#proceed (MethodInvocationClassGenerator.java)
  at org.seasar.framework.aop.interceptors.TraceInterceptor#invoke (TraceInterceptor.java#70)
  at ookawara.web.cando.UserInfoDao$$EnhancedByS2AOP$$f38b42$$MethodInvocation$$getMurakiCondition4#proceed (MethodInvocationClassGenerator.java)
  at ookawara.web.cando.UserInfoDao$$EnhancedByS2AOP$$f38b42#getMurakiCondition (UserInfoDao$$EnhancedByS2AOP$$f38b42.java)
  at ookawara.web.cando.ResultPage#prerender (ResultPage.java#238)
  at ookawara.web.cando.ResultPage$$EnhancedByS2AOP$$db81f3#$$prerender$$invokeSuperMethod$$ (ResultPage$$EnhancedByS2AOP$$db81f3.java)
  at ookawara.web.cando.ResultPage$$EnhancedByS2AOP$$db81f3$$MethodInvocation$$prerender1#proceed (MethodInvocationClassGenerator.java)
  at org.seasar.framework.aop.interceptors.ThrowsInterceptor#invoke (ThrowsInterceptor.java#73)
  at ookawara.web.cando.ResultPage$$EnhancedByS2AOP$$db81f3$$MethodInvocation$$prerender1#proceed (MethodInvocationClassGenerator.java)
  at ookawara.web.cando.ResultPage$$EnhancedByS2AOP$$db81f3#prerender (ResultPage$$EnhancedByS2AOP$$db81f3.java)
  at sun.reflect.NativeMethodAccessorImpl#invoke0 (NativeMethodAccessorImpl.java)
  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.seasar.framework.util.MethodUtil#invoke (MethodUtil.java#49)
  at org.seasar.framework.beans.impl.BeanDescImpl#invoke (BeanDescImpl.java#213)
  at org.seasar.teeda.extension.html.impl.HtmlComponentInvokerImpl#invoke (HtmlComponentInvokerImpl.java#159)
  at org.seasar.teeda.extension.render.TViewRootRenderer#invoke (TViewRootRenderer.java#325)
  at org.seasar.teeda.extension.render.TViewRootRenderer#invoke (TViewRootRenderer.java#319)
  at org.seasar.teeda.extension.render.TViewRootRenderer#encodeBegin (TViewRootRenderer.java#213)
  at javax.faces.component.UIComponentBase#encodeBegin (UIComponentBase.java#331)
  at javax.faces.component.UIViewRoot#encodeBegin (UIViewRoot.java#100)
  at javax.faces.webapp.UIComponentTag#encodeBegin (UIComponentTag.java#240)
  at javax.faces.webapp.UIComponentTag#doStartTag (UIComponentTag.java#177)
  at org.seasar.teeda.extension.taglib.TViewTag#doStartTag (TViewTag.java#90)
  at org.seasar.teeda.extension.html.processor.ElementProcessorImpl#processTag (ElementProcessorImpl.java#145)
  at org.seasar.teeda.extension.html.processor.ElementProcessorImpl#process (ElementProcessorImpl.java#138)
  at org.seasar.teeda.extension.html.processor.ElementProcessorImpl#process (ElementProcessorImpl.java#119)
  at org.seasar.teeda.extension.html.impl.HtmlViewHandler#renderView (HtmlViewHandler.java#145)
  at org.seasar.teeda.extension.html.impl.HtmlViewHandler#renderView (HtmlViewHandler.java#135)
  at org.seasar.teeda.core.lifecycle.impl.RenderResponsePhase#executePhase (RenderResponsePhase.java#38)
  at org.seasar.teeda.core.lifecycle.AbstractPhase#execute (AbstractPhase.java#55)
  at org.seasar.teeda.core.lifecycle.LifecycleImpl#render (LifecycleImpl.java#128)