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

[Hideyuki Ohkawa]

せとあずさ様

下記の指摘通り、SQL_FILEアノテーションを付けて実行してみましたが、
発生する例外は変わりませんでした。
public String findMurakiCondition_SQL_FILE = null;
public List<UserInfo> findMurakiCondition(UserInfoConditionDto dto);

ちなみに、スタックトレースは下記のように出力されています。
org.seasar.framework.exception.OgnlRuntimeException:
[ESSR0073]OGNLで例外が発生しました。理由は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$$68097d$$MethodInvocation$$findMurakiCondition4#proceed
(MethodInvocationClassGenerator.java)
  at org.seasar.framework.aop.interceptors.TraceInterceptor#invoke
(TraceInterceptor.java#70)
  at ookawara.web.cando.UserInfoDao$$EnhancedByS2AOP$$68097d$$MethodInvocation$$findMurakiCondition4#proceed
(MethodInvocationClassGenerator.java)
  at ookawara.web.cando.UserInfoDao$$EnhancedByS2AOP$$68097d#findMurakiCondition
(UserInfoDao$$EnhancedByS2AOP$$68097d.java)
  at ookawara.web.cando.ResultPage#prerender (ResultPage.java#235)
  at ookawara.web.cando.ResultPage$$EnhancedByS2AOP$$1e142a5#$$prerender$$invokeSuperMethod$$
(ResultPage$$EnhancedByS2AOP$$1e142a5.java)
  at ookawara.web.cando.ResultPage$$EnhancedByS2AOP$$1e142a5$$MethodInvocation$$prerender1#proceed
(MethodInvocationClassGenerator.java)
  at org.seasar.framework.aop.interceptors.ThrowsInterceptor#invoke
(ThrowsInterceptor.java#73)
  at ookawara.web.cando.ResultPage$$EnhancedByS2AOP$$1e142a5$$MethodInvocation$$prerender1#proceed
(MethodInvocationClassGenerator.java)
  at ookawara.web.cando.ResultPage$$EnhancedByS2AOP$$1e142a5#prerender
(ResultPage$$EnhancedByS2AOP$$1e142a5.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$$68097d$$MethodInvocation$$findMurakiCondition4#proceed
(MethodInvocationClassGenerator.java)
  at org.seasar.framework.aop.interceptors.TraceInterceptor#invoke
(TraceInterceptor.java#70)
  at ookawara.web.cando.UserInfoDao$$EnhancedByS2AOP$$68097d$$MethodInvocation$$findMurakiCondition4#proceed
(MethodInvocationClassGenerator.java)
  at ookawara.web.cando.UserInfoDao$$EnhancedByS2AOP$$68097d#findMurakiCondition
(UserInfoDao$$EnhancedByS2AOP$$68097d.java)
  at ookawara.web.cando.ResultPage#prerender (ResultPage.java#235)
  at ookawara.web.cando.ResultPage$$EnhancedByS2AOP$$1e142a5#$$prerender$$invokeSuperMethod$$
(ResultPage$$EnhancedByS2AOP$$1e142a5.java)
  at ookawara.web.cando.ResultPage$$EnhancedByS2AOP$$1e142a5$$MethodInvocation$$prerender1#proceed
(MethodInvocationClassGenerator.java)
  at org.seasar.framework.aop.interceptors.ThrowsInterceptor#invoke
(ThrowsInterceptor.java#73)
  at ookawara.web.cando.ResultPage$$EnhancedByS2AOP$$1e142a5$$MethodInvocation$$prerender1#proceed
(MethodInvocationClassGenerator.java)
  at ookawara.web.cando.ResultPage$$EnhancedByS2AOP$$1e142a5#prerender
(ResultPage$$EnhancedByS2AOP$$1e142a5.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

07/07/13 に SETO Azusa<[E-MAIL ADDRESS DELETED]> さんは書きました:
> せとあずさです。
>
> ----- Original Message -----
> From: "Hideyuki Ohkawa" <[E-MAIL ADDRESS DELETED]>
> To: <[E-MAIL ADDRESS DELETED]>
> Sent: Friday, July 13, 2007 11:42 AM
> Subject: [Seasar-user:9143][S2Dao]PagerでSqlファイルを指定する場合
>
>
>
> > org.seasar.framework.exception.OgnlRuntimeException:
> > [ESSR0073]OGNLで例外が発生しました。理由はFor input string:
> > "[E-MAIL ADDRESS DELETED]"
> >
>
> スタックトレースがないと判断が難しい部分はあるのですが、
> SQLファイルを見つけられてない可能性はあります。
>
> 該当のDaoメソッドにSQL_FILEアノテーションをつけると
> どうなりますか？
> http://s2dao.seasar.org/ja/s2dao.html#SqlFileAnnotation
>
>
> _______________________________________________
> Seasar-user mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-user
>