[Seasar-user:5461] Re: DB2 S2DaoでBLOB型のデータを取得時にExceptionが発生

Masanobu Shimura [E-MAIL ADDRESS DELETED]
2006年 12月 14日 (木) 12:16:31 JST


寺尾さん

下記情報を見つけました。
参考まで

志村

http://dbforums.com/t807113.html

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 に 寺尾 浩平<[E-MAIL ADDRESS DELETED]> さんは書きました:
>
> お世話になります。寺尾と申します。
>
> DB2の環境でS2Daoを使用して、BLOB型の列を含むテーブルに
> select文を発行すると Exceptionが発生してしまいます。
> BLOB型のinsertはうまくできたのですが・・・。
>
> 恐れ入りますが、対応方法をご存知の方がいらっしゃいましたら
> 回答おねがいたします。
>
> 【 実行環境 】
> Seasar
>  s2-extension-2.3.15.jar
>  s2-framework-2.3.15.jar
>  s2-dao-1.0.38.jar
>
> DB
>  DB2 V9.1.0
>
> 【SQL】
> SELECT KEY, SHEET_NAME, VERSION_NO, INPUT_DATA
> FROM EX_ORDER_SHEET2
> WHERE
> SHEET_NAME = 'ユーザ情報' AND KEY = '20061114162834'
>
> ※INPUT_DATAフィールドがBLOB型
>
> 【 Exception情報 】
>
> 5) Exception Information
> *********************************************
> Exception Type: com.ibm.db2.jcc.c.SqlException
> Message: DB2 SQL error: SQLCODE: -270, SQLSTATE: 42997, SQLERRMC: 63
>
> StackTrace:
> *********************************************
> 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)
>
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
>  (株)インテック
> 寺尾 浩平
> eMail :[E-MAIL ADDRESS DELETED]
> _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
>
> _______________________________________________
> Seasar-user mailing list
> [E-MAIL ADDRESS DELETED]
> https://ml.seasar.org/mailman/listinfo/seasar-user
>
-------------- next part --------------
HTMLの添付ファイルを保管しました...
URL: http://ml.seasar.org/archives/seasar-user/attachments/20061214/22e418a3/attachment-0004.html 


Seasar-user メーリングリストの案内