[Seasar-user:11676] [DBFlute] SQLコマンドが正しく終了されていません が発生します
Junichi Kato
[E-MAIL ADDRESS DELETED]
2007年 11月 16日 (金) 15:07:11 JST
加藤です．
お疲れ様です．
insertOrUpdateNonstrictをかけると，以下のようにSQLコマンドが正しく終了されていませんが発生していまいます．
原因を探っているのですが，ちょっと不明です．
insertOrUpdateNonstrictを使っている理由としては，CSVのデータをDBにインポートするために使っております．
見た感じ WHERE句のところがWで切れているのですが，これはどうなんでしょうか？
S2Daoは1.0.47-RC1です．
DEBUG 2007-11-16 14:54:22,001 [TP-Processor1] /================================================================================================
DEBUG 2007-11-16 14:54:22,001 [TP-Processor1] AlbumTrackDao.updateNonstrictModifiedOnly()
DEBUG 2007-11-16 14:54:22,001 [TP-Processor1] ==========================================/
DEBUG 2007-11-16 14:54:22,003 [TP-Processor1] AlbumTrackExportImportPage.doImport():387 --> AlbumTrackBhv.delegateUpdateNonstrict() --> ...
DEBUG 2007-11-16 14:54:22,033 [TP-Processor1] 論理的なコネクションを取得しました。tx=[FormatId=4360, GlobalId=1195189232748/80, BranchId=]
DEBUG 2007-11-16 14:54:26,119 [TP-Processor1] 論理的なコネクションを閉じました。tx=[FormatId=4360, GlobalId=1195189232748/80, BranchId=]
DEBUG 2007-11-16 14:54:26,120 [TP-Processor1] SqlCommand Initialization Cost: [00m04s117ms]
DEBUG 2007-11-16 14:54:26,122 [TP-Processor1] 論理的なコネクションを取得しました。tx=[FormatId=4360, GlobalId=1195189232748/80, BranchId=]
DEBUG 2007-11-16 14:54:26,123 [TP-Processor1] UPDATE ALBUM_TRACK SET UPDATE_DATE = '2007-11-16 14.54.22', VERSION_NO = 1, ALBUM_ID = 14, ALBUM_TRACK_ID = 280, TRACK_ID = 57, DISPLAY_NO = 0 W
DEBUG 2007-11-16 14:54:26,205 [TP-Processor1] 論理的なコネクションを閉じました。tx=[FormatId=4360, GlobalId=1195189232748/80, BranchId=]
DEBUG 2007-11-16 14:54:26,205 [TP-Processor1] SqlCommand threw the exception: class org.seasar.framework.exception.SQLRuntimeException msg=[ESSR0072]SQLで例外(SQL=[UPDATE ALBUM_TRACK SET UPDATE _DATE = ?, VERSION_NO = ?, ALBUM_ID = ?, ALBUM_TRACK_ID = ?, TRACK_ID = ?, DISPLAY_NO = ? W], Message=[[ESSR0072]SQLで例外(SQL=[UPDATE ALBUM_TRACK SET UPDATE_DATE = ?, VERSION_NO = ?, ALBUM_ID = ?, ALBUM_TRACK_ID = ?, TRACK_ID = ?, DISPLAY_NO = ? W], Message=[933], ErrorCode=42000, SQLState={3})が発生しました : [SQLで例外(Message=[ORA-00933: SQLコマンドが正しく終了されていません。
], ErrorCode=933, SQLState=42000)が発生しました。], [ORA-00933: SQLコマンドが正しく終了されていません。
], ErrorCode=933, SQLState=42000)が発生しました
DEBUG 2007-11-16 14:54:26,206 [TP-Processor1] method --> public abstract int bz.hoge.hoge.common.dbflute.bsdao.BsAlbumTrackDao.updateNonstrictModifiedOnly(bz.hoge.hoge.common.dbfl ute.exentity.AlbumTrack)
DEBUG 2007-11-16 14:54:26,206 [TP-Processor1] argument --> {280,14,57,0,null,null,null,2007-11-16 14:54:22.0,null}
DEBUG 2007-11-16 14:54:26,206 [TP-Processor1] sql --> UPDATE ALBUM_TRACK SET UPDATE_DATE = ?, VERSION_NO = ?, ALBUM_ID = ?, ALBUM_TRACK_ID = ?, TRACK_ID = ?, DISPLAY_NO = ? W
WARN 2007-11-16 14:54:26,215 [TP-Processor1] インポートに失敗しました。
org.seasar.framework.exception.SQLRuntimeException: [ESSR0072]SQLで例外(SQL=[UPDATE ALBUM_TRACK SET UPDATE_DATE = ?, VERSION_NO = ?, ALBUM_ID = ?, ALBUM_TRACK_ID = ?, TRACK_ID = ?, DISPLAY_NO = ? W], Message=[[ESSR0072]SQLで例外(SQL=[UPDATE ALBUM_TRACK SET UPDATE_DATE = ?, VERSION_NO = ?, ALBUM_ID = ?, ALBUM_TRACK_ID = ?, TRACK_ID = ?, DISPLAY_NO = ? W], Message=[933], ErrorCode=4200 0, SQLState={3})が発生しました : [SQLで例外(Message=[ORA-00933: SQLコマンドが正しく終了されていません。
], ErrorCode=933, SQLState=42000)が発生しました。], [ORA-00933: SQLコマンドが正しく終了されていません。
], ErrorCode=933, SQLState=42000)が発生しました
at org.seasar.framework.util.PreparedStatementUtil.executeUpdate(PreparedStatementUtil.java:65)
at org.seasar.dao.impl.AbstractAutoHandler.execute(AbstractAutoHandler.java:141)
at org.seasar.dao.impl.AbstractAutoHandler.execute(AbstractAutoHandler.java:122)
at org.seasar.dao.impl.UpdateModifiedOnlyCommand.execute(UpdateModifiedOnlyCommand.java:63)
at bz.hoge.hoge.common.dbflute.allcommon.s2dao.S2DaoInterceptor.invoke(S2DaoInterceptor.java:94)
at bz.hoge.hoge.common.dbflute.exdao.AlbumTrackDao$$EnhancedByS2AOP$$123961b$$MethodInvocation$$updateNonstrictModifiedOnly11.proceed(MethodInvocationClassGenerator.java)
at bz.hoge.hoge.common.dbflute.exdao.AlbumTrackDao$$EnhancedByS2AOP$$123961b.updateNonstrictModifiedOnly(AlbumTrackDao$$EnhancedByS2AOP$$123961b.java)
at bz.hoge.hoge.common.dbflute.bsbhv.BsAlbumTrackBhv.delegateUpdateNonstrict(BsAlbumTrackBhv.java:296)
at bz.hoge.hoge.common.dbflute.bsbhv.BsAlbumTrackBhv$9.callbackDelegateUpdateNonstrict(BsAlbumTrackBhv.java:629)
at bz.hoge.hoge.common.dbflute.bsbhv.BsAlbumTrackBhv$9.callbackDelegateUpdateNonstrict(BsAlbumTrackBhv.java:629)
at bz.hoge.hoge.common.dbflute.allcommon.bhv.AbstractBehaviorWritable.helpUpdateNonstrictInternally(AbstractBehaviorWritable.java:565)
at bz.hoge.hoge.common.dbflute.bsbhv.BsAlbumTrackBhv.updateNonstrict(BsAlbumTrackBhv.java:628)
at bz.hoge.hoge.common.dbflute.bsbhv.BsAlbumTrackBhv$11.callbackUpdateNonstrict(BsAlbumTrackBhv.java:704)
at bz.hoge.hoge.common.dbflute.bsbhv.BsAlbumTrackBhv$11.callbackUpdateNonstrict(BsAlbumTrackBhv.java:704)
at bz.hoge.hoge.common.dbflute.allcommon.bhv.AbstractBehaviorWritable.helpInsertOrUpdateInternally(AbstractBehaviorWritable.java:622)
at bz.hoge.hoge.common.dbflute.bsbhv.BsAlbumTrackBhv.insertOrUpdateNonstrict(BsAlbumTrackBhv.java:702)
at bz.hoge.hoge.web.web.admin.AlbumTrackExportImportPage.doImport(AlbumTrackExportImportPage.java:387)
at bz.hoge.hoge.web.web.admin.AlbumTrackExportImportPage$$EnhancedByS2AOP$$1b0e2c3.$$doImport$$invokeSuperMethod$$(AlbumTrackExportImportPage$$EnhancedByS2AOP$$1b0e2c3.java)
at bz.hoge.hoge.web.web.admin.AlbumTrackExportImportPage$$EnhancedByS2AOP$$1b0e2c3$$MethodInvocation$$doImport2.proceed(MethodInvocationClassGenerator.java)
at org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:55)
at bz.hoge.hoge.web.interceptor.AdminAuthenticationInterceptor.invoke(AdminAuthenticationInterceptor.java:17)
at org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:53)
at org.seasar.framework.container.customizer.AspectCustomizer$LookupAdaptorInterceptor.invoke(AspectCustomizer.java:195)
at bz.hoge.hoge.web.web.admin.AlbumTrackExportImportPage$$EnhancedByS2AOP$$1b0e2c3$$MethodInvocation$$doImport2.proceed(MethodInvocationClassGenerator.java)
at org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:55)
at bz.hoge.hoge.web.interceptor.HttpsTransitionInterceptor.invoke(HttpsTransitionInterceptor.java:38)
at org.seasar.framework.aop.impl.NestedMethodInvocation.proceed(NestedMethodInvocation.java:53)
at org.seasar.framework.container.customizer.AspectCustomizer$LookupAdaptorInterceptor.invoke(AspectCustomizer.java:195)
at bz.hoge.hoge.web.web.admin.AlbumTrackExportImportPage$$EnhancedByS2AOP$$1b0e2c3$$MethodInvocation$$doImport2.proceed(MethodInvocationClassGenerator.java)
at org.seasar.extension.tx.DefaultTransactionCallback.execute(DefaultTransactionCallback.java:58)
at org.seasar.extension.tx.adapter.JTATransactionManagerAdapter.required(JTATransactionManagerAdapter.java:65)
at org.seasar.extension.tx.RequiredInterceptor.invoke(RequiredInterceptor.java:41)
at bz.hoge.hoge.web.web.admin.AlbumTrackExportImportPage$$EnhancedByS2AOP$$1b0e2c3$$MethodInvocation$$doImport2.proceed(MethodInvocationClassGenerator.java)
at org.seasar.framework.aop.interceptors.ThrowsInterceptor.invoke(ThrowsInterceptor.java:77)
at bz.hoge.hoge.web.web.admin.AlbumTrackExportImportPage$$EnhancedByS2AOP$$1b0e2c3$$MethodInvocation$$doImport2.proceed(MethodInvocationClassGenerator.java)
at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:73)
at bz.hoge.hoge.web.web.admin.AlbumTrackExportImportPage$$EnhancedByS2AOP$$1b0e2c3$$MethodInvocation$$doImport2.proceed(MethodInvocationClassGenerator.java)
at bz.hoge.hoge.web.web.admin.AlbumTrackExportImportPage$$EnhancedByS2AOP$$1b0e2c3.doImport(AlbumTrackExportImportPage$$EnhancedByS2AOP$$1b0e2c3.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:93)
at org.seasar.framework.beans.impl.BeanDescImpl.invoke(BeanDescImpl.java:213)
at org.seasar.teeda.extension.html.impl.HtmlComponentInvokerImpl.invoke(HtmlComponentInvokerImpl.java:160)
at org.seasar.teeda.extension.html.impl.HtmlActionListener.processAction(HtmlActionListener.java:62)
at javax.faces.component.UICommand.broadcast(UICommand.java:149)
at org.seasar.teeda.extension.component.html.THtmlCommandButton.broadcast(THtmlCommandButton.java:61)
at javax.faces.component.UIViewRoot.broadcastEvents(UIViewRoot.java:192)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:117)
at org.seasar.teeda.core.lifecycle.impl.InvokeApplicationPhase.executePhase(InvokeApplicationPhase.java:29)
at org.seasar.teeda.core.lifecycle.AbstractPhase.execute(AbstractPhase.java:57)
at org.seasar.teeda.core.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:97)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:94)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.seasar.framework.container.filter.S2ContainerFilter.doFilter(S2ContainerFilter.java:77)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.seasar.framework.container.hotdeploy.HotdeployFilter.doFilter(HotdeployFilter.java:70)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.seasar.extension.httpsession.SessionFilter.doFilter(SessionFilter.java:60)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.seasar.extension.filter.EncodingFilter.doFilter(EncodingFilter.java:69)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:210)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:200)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:283)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:773)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:895)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.seasar.framework.exception.SSQLException: [ESSR0072]SQLで例外(SQL=[UPDATE ALBUM_TRACK SET UPDATE_DATE = ?, VERSION_NO = ?, ALBUM_ID = ?, ALBUM_TRACK_ID = ?, TRACK_ID = ?, DISPLAY _NO = ? W], Message=[933], ErrorCode=42000, SQLState={3})が発生しました
at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.wrapException(PreparedStatementWrapper.java:72)
at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.wrapException(PreparedStatementWrapper.java:67)
at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:91)
at org.seasar.framework.util.PreparedStatementUtil.executeUpdate(PreparedStatementUtil.java:63)
... 83 more
Caused by: java.sql.SQLException: ORA-00933: SQLコマンドが正しく終了されていません。
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:582)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1986)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1144)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2152)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2035)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2876)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:609)
at org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:89)
... 84 more
───────────────────────────────
株式会社 グランテック
代表取締役社長
加藤 潤一 Junichi Kato
〒154-0012
東京都世田谷区駒沢2-16-1 サンドー駒沢ビル4F
TEL 050-5538-2383 FAX 03-3487-7211
HP : http://www.grandtech.jp/
BLOG : http://d.hatena.ne.jp/j5ik2o/
E-MAIL : [E-MAIL ADDRESS DELETED]
Seasar-user メーリングリストの案内