<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40"> <head> <meta http-equiv=Content-Type content="text/html; charset=iso-2022-jp"> <meta name=Generator content="Microsoft Word 11 (filtered medium)"> <style>  </style> </head> <body lang=JA link=blue vlink=purple style='text-justify-trim:punctuation'> <div class=Section1 style='layout-grid:18.0pt'> $B:4F#E0B@O:$G$9!#$*@$OC$K$J$C$F$*$j$^$9!#(B<o:p></o:p> <o:p> </o:p> Dolteng 0.16.1$B$G(BChuraProject(Teeda+S2Dao)$B$r:n$j!"(Bdao$B$r(BJUnit$B$G%F%9%H$7$?$i%(%i!<$,=P$^$9!#(B<o:p></o:p> $B>c32%H%l!<%9$K$O2<5-$N$h$&$KI=<($5$l$^$9!#(B<o:p></o:p> <o:p> </o:p> org.seasar.framework.exception.SQLRuntimeException: [ESSR0071]SQL$B$GNc30(B(ErrorCode=42102, SQLState=42S02)$B$,H/@8$7$^$7$?!#M}M3$O(Borg.seasar.framework.exception.SSQLException: [ESSR0072]SQL$B$GNc30(B(SQL=[select shelfNumber, rowNumber from book where id=?], ErrorCode={1}, SQLState={2})$B$,H/@8$7$^$7$?(B<o:p></o:p>               at org.seasar.extension.jdbc.util.ConnectionUtil.prepareStatement(ConnectionUtil.java:52)<o:p></o:p>               at org.seasar.extension.jdbc.impl.BasicStatementFactory.createPreparedStatement(BasicStatementFactory.java:34)<o:p></o:p>               at org.seasar.extension.jdbc.impl.BasicHandler.prepareStatement(BasicHandler.java:95)<o:p></o:p>               at org.seasar.extension.jdbc.impl.BasicSelectHandler.prepareStatement(BasicSelectHandler.java:146)<o:p></o:p>               at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:131)<o:p></o:p>               at org.seasar.extension.jdbc.impl.BasicSelectHandler.execute(BasicSelectHandler.java:120)<o:p></o:p>               at org.seasar.dao.impl.SelectDynamicCommand.execute(SelectDynamicCommand.java:55)<o:p></o:p>               at org.seasar.dao.interceptors.S2DaoInterceptor.invoke(S2DaoInterceptor.java:53)<o:p></o:p>               at book.chura.dao.BookInfoDao$$EnhancedByS2AOP$$e34726$$MethodInvocation$$findBookPosition0.proceed(MethodInvocationClassGenerator.java)<o:p></o:p>               at org.seasar.framework.aop.interceptors.TraceInterceptor.invoke(TraceInterceptor.java:59)<o:p></o:p>               at book.chura.dao.BookInfoDao$$EnhancedByS2AOP$$e34726$$MethodInvocation$$findBookPosition0.proceed(MethodInvocationClassGenerator.java)<o:p></o:p>               at book.chura.dao.BookInfoDao$$EnhancedByS2AOP$$e34726.findBookPosition(BookInfoDao$$EnhancedByS2AOP$$e34726.java)<o:p></o:p>               at book.chura.dao.ReturnBookDaoTest.testFindBookPosition(ReturnBookDaoTest.java:36)<o:p></o:p>               at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<o:p></o:p>               at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<o:p></o:p>               at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<o:p></o:p>               at java.lang.reflect.Method.invoke(Method.java:585)<o:p></o:p>               at junit.framework.TestCase.runTest(TestCase.java:164)<o:p></o:p>               at org.seasar.framework.unit.S2FrameworkTestCase.doRunTest(S2FrameworkTestCase.java:305)<o:p></o:p>               at org.seasar.extension.unit.S2TestCase.doRunTest(S2TestCase.java:92)<o:p></o:p>               at org.seasar.framework.unit.S2FrameworkTestCase.runBare(S2FrameworkTestCase.java:190)<o:p></o:p>               at junit.framework.TestResult$1.protect(TestResult.java:106)<o:p></o:p>               at junit.framework.TestResult.runProtected(TestResult.java:124)<o:p></o:p>               at junit.framework.TestResult.run(TestResult.java:109)<o:p></o:p>               at junit.framework.TestCase.run(TestCase.java:120)<o:p></o:p>               at junit.framework.TestSuite.runTest(TestSuite.java:230)<o:p></o:p>               at junit.framework.TestSuite.run(TestSuite.java:225)<o:p></o:p>               at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:128)<o:p></o:p>               at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38)<o:p></o:p>               at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:460)<o:p></o:p>               at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:673)<o:p></o:p>               at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:386)<o:p></o:p>               at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:196)<o:p></o:p> Caused by: org.seasar.framework.exception.SSQLException: [ESSR0072]SQL$B$GNc30(B(SQL=[select shelfNumber, rowNumber from book where id=?], ErrorCode={1}, SQLState={2})$B$,H/@8$7$^$7$?(B<o:p></o:p>               at org.seasar.extension.dbcp.impl.ConnectionWrapperImpl.wrapException(ConnectionWrapperImpl.java:526)<o:p></o:p>               at org.seasar.extension.dbcp.impl.ConnectionWrapperImpl.prepareStatement(ConnectionWrapperImpl.java:144)<o:p></o:p>               at org.seasar.extension.jdbc.util.ConnectionUtil.prepareStatement(ConnectionUtil.java:50)<o:p></o:p>               ... 32 more<o:p></o:p> Caused by: org.h2.jdbc.JdbcSQLException: Table BOOK not found; SQL statement: select shelfNumber, rowNumber from book where id=? [42S02-30]<o:p></o:p> org.h2.jdbc.JdbcSQLException: Table BOOK not found; SQL statement: select shelfNumber, rowNumber from book where id=? [42S02-30]<o:p></o:p>               at org.h2.message.Message.addSQL(Message.java:338)<o:p></o:p>               at org.h2.command.Parser.parse(Parser.java:224)<o:p></o:p>               at org.h2.command.Parser.prepareCommand(Parser.java:189)<o:p></o:p>               at org.h2.engine.Session.prepareLocal(Session.java:170)<o:p></o:p>               at org.h2.server.TcpServerThread.process(TcpServerThread.java:200)<o:p></o:p>               at org.h2.server.TcpServerThread.run(TcpServerThread.java:127)<o:p></o:p>               at java.lang.Thread.run(Thread.java:595)<o:p></o:p> org.h2.jdbc.JdbcSQLException: Table BOOK not found [42S02-30]<o:p></o:p>               at org.h2.message.Message.getSQLException(Message.java:67)<o:p></o:p>               at org.h2.message.Message.getSQLException(Message.java:49)<o:p></o:p>               at org.h2.schema.Schema.getTableOrView(Schema.java:199)<o:p></o:p>               at org.h2.command.Parser.readTableFilter(Parser.java:704)<o:p></o:p>               at org.h2.command.Parser.parseSelectSimpleFromPart(Parser.java:1162)<o:p></o:p>               at org.h2.command.Parser.parseSelectSimple(Parser.java:1229)<o:p></o:p>               at org.h2.command.Parser.parseSelectSub(Parser.java:1156)<o:p></o:p>               at org.h2.command.Parser.parseSelectUnion(Parser.java:1043)<o:p></o:p>               at org.h2.command.Parser.parseSelect(Parser.java:1036)<o:p></o:p>               at org.h2.command.Parser.parse(Parser.java:331)<o:p></o:p>               at org.h2.command.Parser.parse(Parser.java:218)<o:p></o:p>               at org.h2.command.Parser.prepareCommand(Parser.java:189)<o:p></o:p>               at org.h2.engine.Session.prepareLocal(Session.java:170)<o:p></o:p>               at org.h2.server.TcpServerThread.process(TcpServerThread.java:200)<o:p></o:p>               at org.h2.server.TcpServerThread.run(TcpServerThread.java:127)<o:p></o:p>               at java.lang.Thread.run(Thread.java:595)<o:p></o:p>  [42S02-30]<o:p></o:p>               at org.h2.engine.SessionRemote.done(SessionRemote.java:288)<o:p></o:p>               at org.h2.command.CommandRemote.prepare(CommandRemote.java:40)<o:p></o:p>               at org.h2.command.CommandRemote.<init>(CommandRemote.java:54)<o:p></o:p>               at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:224)<o:p></o:p>               at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:946)<o:p></o:p>               at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:1082)<o:p></o:p>               at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:135)<o:p></o:p>               at org.seasar.extension.dbcp.impl.ConnectionWrapperImpl.prepareStatement(ConnectionWrapperImpl.java:140)<o:p></o:p>               ... 33 more<o:p></o:p> <o:p> </o:p> $B%3%s%=!<%k$K$O2<5-$,I=<($5$l$^$9!#(B<o:p></o:p> <o:p> </o:p> DEBUG 2007-02-06 16:13:23,109 [main] $B%/%i%9(B(book.chura.dao.BookInfoDao[bookInfoDao])$B$N%3%s%]!<%M%s%HDj5A$rEPO?$7$^$9(B<o:p></o:p> DEBUG 2007-02-06 16:13:23,234 [main] $B%/%i%9(B(book.chura.dao.RentInfoDao[rentInfoDao])$B$N%3%s%]!<%M%s%HDj5A$rEPO?$7$^$9(B<o:p></o:p> DEBUG 2007-02-06 16:13:23,312 [main] BEGIN book.chura.dao.BookInfoDao#findBookPosition(039911174)<o:p></o:p> DEBUG 2007-02-06 16:13:24,703 [main] $BJ*M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(B<o:p></o:p> DEBUG 2007-02-06 16:13:24,703 [main] $BO@M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(B<o:p></o:p> WARN  2007-02-06 16:13:25,156 [main] $B%F!<%V%k(B(book)$B$,8+$D$+$j$^$;$s(B<o:p></o:p> DEBUG 2007-02-06 16:13:25,281 [main] $BO@M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(B<o:p></o:p> DEBUG 2007-02-06 16:13:25,406 [main] select shelfNumber, rowNumber from book where id='039911174'<o:p></o:p> DEBUG 2007-02-06 16:13:25,406 [main] $BO@M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(B<o:p></o:p> DEBUG 2007-02-06 16:13:25,734 [main] $BJ*M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(B<o:p></o:p> DEBUG 2007-02-06 16:13:25,734 [main] END book.chura.dao.BookInfoDao#findBookPosition(039911174) Throwable:org.seasar.framework.exception.SQLRuntimeException: [ESSR0071]SQL$B$GNc30(B(ErrorCode=42102, SQLState=42S02)$B$,H/@8$7$^$7$?!#M}M3$O(Borg.seasar.framework.exception.SSQLException: [ESSR0072]SQL$B$GNc30(B(SQL=[select shelfNumber, rowNumber from book where id=?], ErrorCode={1}, SQLState={2})$B$,H/@8$7$^$7$?(B<o:p></o:p> <o:p> </o:p> $B%F!<%V%k$r:n$C$?$O$:$J$N$K!V%F!<%V%k(B(book)$B$,8+$D$+$j$^$;$s!W$H$$$&I=<($,$5$l$^$9!#(B<o:p></o:p> $B%F!<%V%k$r:n$C$?;~$NJ}K!$O!"(B<o:p></o:p> $B%W%m%8%'%/%H$r1&%/%j%C%/!"(BH2$B$r%/%j%C%/!"(BView DataBase Manager$B$r%/%j%C%/(B<o:p></o:p> Connect$B$r%/%j%C%/!"(BSQL statement$B$NOH$NCf$K(Bcreate table$BJ8$r=q$-$^$7$?!#(B<o:p></o:p> $B$3$N$d$jJ}$G@5$7$$$N$G$7$g$&$+!)(B<o:p></o:p> $B$[$+$K$J$K$+(BH2$B$N@_Dj$+2?$+$7$J$1$l$P$J$i$J$$$N$G$7$g$+!)(B<o:p></o:p> <o:p> </o:p> $B$h$m$7$/$*4j$$$$$?$7$^$9!#(B<o:p></o:p> <o:p> </o:p> </div> </body> </html>