<div>$B;{Hx$5$s(B</div> <div> </div> <div>$B2<5->pJs$r8+$D$1$^$7$?!#(B</div> <div>$B;29M$^$G(B</div> <div> </div> <div>$B;VB<(B</div> <div> </div> <div><a href="http://dbforums.com/t807113.html">http://dbforums.com/t807113.html</a> SQLCODE -270 correpsonds to the error message SQL0270. And that one says: SQL0270N Function not supported (Reason code = ""). So you have to look at SQLERRMC to get the token (reason code). Reason code 63 says: 63 A column with a LOB type, distinct type on a LOB type, or structured type cannot be specified in the select-list of an insensitive scrollable cursor. The user response suggests that you should not include a LOB column in the select clause. But that is obviously not an option for you. So you could altenatively change your environment to not use a scrollable cursor for this query. p.s: You can also get a short help for SQLSTATE 42997 by simply typing: db2 "? 42997" -- Knut Stolze Information Integration IBM Germany / University of Jena 06/12/14 $B$K(B $B;{Hx(B $B9@J?(B<<a href="mailto:terao_kouhei@intec.co.jp">terao_kouhei@intec.co.jp</a>> $B$5$s$O=q$-$^$7$?(B: > > $B$*@$OC$K$J$j$^$9!#;{Hx$H?=$7$^$9!#(B > > DB2$B$N4D6-$G(BS2Dao$B$r;HMQ$7$F!"(BBLOB$B7?$NNs$r4^$`%F!<%V%k$K(B > select$BJ8$rH/9T$9$k$H(B Exception$B$,H/@8$7$F$7$^$$$^$9!#(B > BLOB$B7?$N(Binsert$B$O$&$^$/$G$-$?$N$G$9$,!&!&!&!#(B > > $B62$lF~$j$^$9$,!"BP1~J}K!$r$4B8CN$NJ}$,$$$i$C$7$c$$$^$7$?$i(B > $B2sEz$*$M$,$$$?$7$^$9!#(B > > $B!Z(B $B<B9T4D6-(B $B![(B > Seasar >  s2-extension-2.3.15.jar >  s2-framework-2.3.15.jar >  s2-dao-1.0.38.jar > > DB >  DB2 V9.1.0 > > $B!Z(BSQL$B![(B > SELECT KEY, SHEET_NAME, VERSION_NO, INPUT_DATA > FROM EX_ORDER_SHEET2 > WHERE > SHEET_NAME = '$B%f!<%6>pJs(B' AND KEY = '20061114162834' > > $B"((BINPUT_DATA$B%U%#!<%k%I$,(BBLOB$B7?(B > > $B!Z(B Exception$B>pJs(B $B![(B > > 5) Exception Information > ********************************************* > Exception Type$B!'(B com.ibm.db2.jcc.c.SqlException > Message$B!'(B DB2 SQL error: SQLCODE: -270, SQLSTATE: 42997, SQLERRMC: 63 > > StackTrace$B!'(B > ********************************************* > at com.ibm.db2.jcc.c.fg.e(fg.java:1596) > at com.ibm.db2.jcc.c.fg.a(fg.java:1206) > at com.ibm.db2.jcc.b.gb.g(gb.java:140) > at com.ibm.db2.jcc.b.gb.a(gb.java:39) > at com.ibm.db2.jcc.b.w.a(w.java:34) > at com.ibm.db2.jcc.b.vb.g(vb.java:139) > at com.ibm.db2.jcc.c.fg.n(fg.java:1177) > at com.ibm.db2.jcc.c.gg.eb(gg.java:1862) > at com.ibm.db2.jcc.c.gg.d(gg.java:2295) > at com.ibm.db2.jcc.c.gg.V (gg.java:424) > at com.ibm.db2.jcc.c.gg.executeQuery(gg.java:407) > at > org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:71) > at > org.seasar.framework.util.PreparedStatementUtil.executeQuery (PreparedStatementUtil.java:35) > at > org.seasar.extension.jdbc.impl.BasicResultSetFactory.createResultSet(BasicResultSetFactory.java:36) > at > org.seasar.dao.pager.PagerResultSetFactoryWrapper.createResultSet (PagerResultSetFactoryWrapper.java:63) > at > org.seasar.extension.jdbc.impl.BasicSelectHandler.createResultSet(BasicSelectHandler.java:173) > at > org.seasar.extension.jdbc.impl.BasicSelectHandler.execute (BasicSelectHandler.java:162) > at > org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:135) > at > org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java :120) > at > org.seasar.dao.impl.SelectDynamicCommand.execute(SelectDynamicCommand.java:55) > at > org.seasar.dao.interceptors.S2DaoInterceptor.invoke(S2DaoInterceptor.java:53) > at > org.seasar.dao.pager.PagerS2DaoInterceptorWrapper.invoke (PagerS2DaoInterceptorWrapper.java:64) > at > org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:43) > at > jp.co.intec.solves4.framework.interceptor.CstmTraceInterceptor.invoke (CstmTraceInterceptor.java:53) > at > org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:43) > at > org.seasar.framework.aop.interceptors.ThrowsInterceptor.invoke (ThrowsInterceptor.java:64) > at > org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:43) > at > org.seasar.framework.aop.interceptors.InterceptorChain.invoke( InterceptorChain.java:42) > at > jp.co.intec.solves4.app.EX.ZZZ.dao.OrderSheetDao$$EnhancedByS2AOP$$11b92ef$$MethodInvocation$$getAllData0.proceed(MethodInvocationClassGenerator.java) > at > jp.co.intec.solves4.app.EX.ZZZ.dao.OrderSheetDao$$EnhancedByS2AOP$$11b92ef.getAllData (OrderSheetDao$$EnhancedByS2AOP$$11b92ef.java) > at > jp.co.intec.solves4.app.EX.ZZZ.service.impl.EXZZZ000RServiceImpl.getOrderSheetData(EXZZZ000RServiceImpl.java:82) > at > jp.co.intec.solves4.app.EX.ZZZ.service.impl.EXZZZ000RServiceImpl$$EnhancedByS2AOP$$ced6e2.getOrderSheetData$$invokeSuperMethod$$ (EXZZZ000RServiceImpl$$EnhancedByS2AOP$$ced6e2.java) > at > jp.co.intec.solves4.app.EX.ZZZ.service.impl.EXZZZ000RServiceImpl$$EnhancedByS2AOP$$ced6e2$$MethodInvocation$$getOrderSheetData4.proceed(MethodInvocationClassGenerator.java ) > at > org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:45) > at > org.seasar.framework.aop.interceptors.ThrowsInterceptor.invoke(ThrowsInterceptor.java:64) > at > org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:43) > at > jp.co.intec.solves4.framework.interceptor.CstmTraceInterceptor.invoke(CstmTraceInterceptor.java :53) > at > org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:43) > at > org.seasar.framework.aop.interceptors.InterceptorChain.invoke(InterceptorChain.java:42) > at > jp.co.intec.solves4.app.EX.ZZZ.service.impl.EXZZZ000RServiceImpl$$EnhancedByS2AOP$$ced6e2$$MethodInvocation$$getOrderSheetData4.proceed(MethodInvocationClassGenerator.java) > at > jp.co.intec.solves4.app.EX.ZZZ.service.impl.EXZZZ000RServiceImpl$$EnhancedByS2AOP$$ced6e2.getOrderSheetData (EXZZZ000RServiceImpl$$EnhancedByS2AOP$$ced6e2.java) > at > jp.co.intec.solves4.app.EX.ZZZ.action.impl.EXZZZ000RActionImpl.deserialize(EXZZZ000RActionImpl.java:293) > at > jp.co.intec.solves4.app.EX.ZZZ.action.impl.EXZZZ000RActionImpl$$EnhancedByS2AOP$$3abc87.deserialize$$invokeSuperMethod$$ (EXZZZ000RActionImpl$$EnhancedByS2AOP$$3abc87.java) > at > jp.co.intec.solves4.app.EX.ZZZ.action.impl.EXZZZ000RActionImpl$$EnhancedByS2AOP$$3abc87$$MethodInvocation$$deserialize4.proceed(MethodInvocationClassGenerator.java ) > at > org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:45) > at > org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:40) > at > org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:43) > at > jp.co.intec.solves4.framework.interceptor.PDFDownloadInterceptor.invoke(PDFDownloadInterceptor.java:54) > at > org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:43) > at > jp.co.intec.solves4.framework.interceptor.IllegalAccessCheckInterceptor.invoke(IllegalAccessCheckInterceptor.java :76) > at > org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:43) > at > jp.co.intec.solves4.framework.interceptor.CstmTraceInterceptor.invoke(CstmTraceInterceptor.java :53) > at > org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:43) > at > org.seasar.framework.aop.interceptors.ThrowsInterceptor.invoke(ThrowsInterceptor.java :64) > at > jp.co.intec.solves4.framework.interceptor.ActionThrowsInterceptor.invoke(ActionThrowsInterceptor.java:46) > at > org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java :43) > at > org.seasar.framework.aop.interceptors.InterceptorChain.invoke(InterceptorChain.java:42) > at > jp.co.intec.solves4.app.EX.ZZZ.action.impl.EXZZZ000RActionImpl$$EnhancedByS2AOP$$3abc87$$MethodInvocation$$deserialize4.proceed (MethodInvocationClassGenerator.java) > at > jp.co.intec.solves4.app.EX.ZZZ.action.impl.EXZZZ000RActionImpl$$EnhancedByS2AOP$$3abc87.deserialize(EXZZZ000RActionImpl$$EnhancedByS2AOP$$3abc87.java) > at sun.reflect.NativeMethodAccessorImpl.invoke0 (Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > at java.lang.reflect.Method.invoke(Method.java:585) > at org.seasar.framework.util.MethodUtil.invoke(MethodUtil.java:42) > at > org.seasar.framework.beans.impl.BeanDescImpl.invoke(BeanDescImpl.java:190) > at org.seasar.struts.processor.MethodBinding.invoke(MethodBinding.java:75) > at org.seasar.struts.processor.MethodBinding.invoke(MethodBinding.java:66) > at > org.seasar.struts.processor.MethodBindingActionCommand.execute (MethodBindingActionCommand.java:40) > at > org.seasar.struts.processor.ActionExecuteProcessorImpl.processActionExecute(ActionExecuteProcessorImpl.java:48) > at > org.seasar.struts.processor.S2RequestProcessor.processActionExecute (S2RequestProcessor.java:177) > at org.seasar.struts.processor.AcceptorImpl.process(AcceptorImpl.java:128) > at > org.seasar.struts.processor.S2RequestProcessor.process(S2RequestProcessor.java:61) > at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) > at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter (ApplicationFilterChain.java:173) > at > jp.co.intec.solves4.framework.web.filter.ConfigFilter.doFilter(ConfigFilter.java:97) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter (ApplicationFilterChain.java:202) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at > org.seasar.extension.filter.EncodingFilter.doFilter(EncodingFilter.java :62) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java :173) > at org.seasar.struts.filter.S2StrutsFilter.doFilter(S2StrutsFilter.java:42) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at > org.seasar.framework.container.filter.S2ContainerFilter.doFilter(S2ContainerFilter.java:60) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at > jp.co.intec.solves4.framework.web.filter.LoggingFilter.doFilter(LoggingFilter.java:85) > at > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) > at > org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) > at > org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) > at > org.apache.catalina.core.StandardContextValve.invoke (StandardContextValve.java:178) > at > org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) > at > org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) > at > org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) > at > org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) > at > org.apache.coyote.http11.Http11Processor.process (Http11Processor.java:869) > at > org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) > at > org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket (PoolTcpEndpoint.java:527) > at > org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) > at > org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run (ThreadPool.java:684) > at java.lang.Thread.run(Thread.java:595) > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ >  ($B3t(B)$B%$%s%F%C%/(B > $B;{Hx!!9@J?(B > eMail $B!'(B<a href="mailto:terao_kouhei@intec.co.jp"> terao_kouhei@intec.co.jp</a> > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > > _______________________________________________ > Seasar-user mailing list > <a href="mailto:Seasar-user@ml.seasar.org"> Seasar-user@ml.seasar.org</a> > <a href="https://ml.seasar.org/mailman/listinfo/seasar-user">https://ml.seasar.org/mailman/listinfo/seasar-user</a> >  </div>