[Seasar-user:16318] [s2unit] deleteDb で エラー (SQLServer)

Mitsutaka Sato [E-MAIL ADDRESS DELETED]
2008年 11月 19日 (水) 15:37:37 JST


佐藤です。
いつもお世話になっております。

s2testcaseの deleteDbを実行したときに以下のエラーが発生しました。
(readXlsReplaceDb 等も)

S2-2.4.32, SQLServer2005で実行しました。
確かに、"DELETE FROM account_history_table W" を SQLServerManagementStudio等で実行すると
同様のエラーとなります。

以上よろしくお願いします。

================================
org.seasar.framework.exception.SQLRuntimeException:
[ESSR0072]SQLで例外(SQL=[DELETE FROM account_history_table W],
Message=[[ESSR0072]SQLで例外(SQL=[DELETE FROM account_history_table W],
Message=[102], ErrorCode=S0001, SQLState={3})が発生しました : [SQLで例外(Message=['W'
付近に不適切な構文があります。], ErrorCode=102, SQLState=S0001)が発生しました。], ['W'
付近に不適切な構文があります。], ErrorCode=102, SQLState=S0001)が発生しました
    at
org.seasar.framework.util.PreparedStatementUtil.executeUpdate(PreparedStatementUtil.java:68)
    at
org.seasar.extension.jdbc.impl.BasicUpdateHandler.execute(BasicUpdateHandler.java:102)
    at
org.seasar.extension.jdbc.impl.BasicUpdateHandler.execute(BasicUpdateHandler.java:80)
    at
org.seasar.extension.dataset.states.AbstractRowState.execute(AbstractRowState.java:63)
    at
org.seasar.extension.dataset.states.AbstractRowState.update(AbstractRowState.java:39)
    at
org.seasar.extension.dataset.impl.SqlDeleteTableWriter.doWrite(SqlDeleteTableWriter.java:45)
    at
org.seasar.extension.dataset.impl.SqlTableWriter.write(SqlTableWriter.java:62)
    at org.seasar.extension.unit.S2TestCase.deleteDb(S2TestCase.java:442)
    at
com.valuecardservice.soap.services.DealServiceRollbackTest.setUpInvalidReceiptNo(DealServiceRollbackTest.java:89)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.seasar.framework.util.MethodUtil.invoke(MethodUtil.java:96)
    at
org.seasar.framework.unit.S2FrameworkTestCase.invoke(S2FrameworkTestCase.java:653)
    at
org.seasar.framework.unit.S2FrameworkTestCase.setUpForEachTestMethod(S2FrameworkTestCase.java:486)
    at
org.seasar.framework.unit.S2FrameworkTestCase.runBare(S2FrameworkTestCase.java:298)
    at junit.framework.TestResult$1.protect(TestResult.java:106)
    at junit.framework.TestResult.runProtected(TestResult.java:124)
    at junit.framework.TestResult.run(TestResult.java:109)
    at junit.framework.TestCase.run(TestCase.java:120)
    at junit.framework.TestSuite.runTest(TestSuite.java:230)
    at junit.framework.TestSuite.run(TestSuite.java:225)
    at
org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:130)
    at
org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)
    at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)
    at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)
    at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)
    at
org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)
Caused by: org.seasar.framework.exception.SSQLException:
[ESSR0072]SQLで例外(SQL=[DELETE FROM account_history_table W], Message=[102],
ErrorCode=S0001, 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:66)
    ... 28 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: 'W'
付近に不適切な構文があります。
    at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown
Source)
    at com.microsoft.sqlserver.jdbc.IOBuffer.processPackets(Unknown Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.getPrepExecResponse(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PreparedStatementExecutionRequest.executeStatement(Unknown
Source)
    at com.microsoft.sqlserver.jdbc.CancelableRequest.execute(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerConnection.executeRequest(Unknown
Source)
    at
com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeUpdate(Unknown
Source)
    at
org.seasar.extension.jdbc.impl.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:89)
    ... 29 more
-------------- next part --------------
HTMLの添付ファイルを保管しました...
URL: <http://ml.seasar.org/archives/seasar-user/attachments/20081119/2b1a45ac/attachment-0001.html>


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