[Seasar-user:5458] DB2 S2DaoでBLOB型のデータを取得時にExceptionが発生
寺尾 浩平
[E-MAIL ADDRESS DELETED]
2006年 12月 14日 (木) 12:04:54 JST
お世話になります。寺尾と申します。
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 メーリングリストの案内