<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!#(B<o:p></o:p> $B$*@$OC$K$J$C$F$*$j$^$9!#(B<o:p></o:p> Dolteng 0.17.0(Teeda + S2Dao)$B$G3+H/$r$7$F$*$j$^$9!#(B<o:p></o:p> Dao$B$r(BJUnit$B$G%F%9%H$9$k$H%(%i!<$,$G$^$9!#(B<o:p></o:p> $B>c32%H%l!<%9$K$O!"0J2<$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=42122, SQLState=42S22)$B$,H/@8$7$^$7$?!#M}M3$O(Borg.seasar.framework.exception.SSQLException: [ESSR0072]SQL$B$GNc30(B(SQL=[select book.id, bookSpec.title, book.shelfNumber, book.rowNumberfrom book, bookSpecwhere book.id=? and book.bookSpecId=bookSpec.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.BookDao$$EnhancedByS2AOP$$20fa83$$MethodInvocation$$findBookInfo0.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.BookDao$$EnhancedByS2AOP$$20fa83$$MethodInvocation$$findBookInfo0.proceed(MethodInvocationClassGenerator.java)<o:p></o:p>               at book.chura.dao.BookDao$$EnhancedByS2AOP$$20fa83.findBookInfo(BookDao$$EnhancedByS2AOP$$20fa83.java)<o:p></o:p>               at book.chura.dao.ReturnBookDaoTest.testFindBookInfo(ReturnBookDaoTest.java:27)<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 book.id, bookSpec.title, book.shelfNumber, book.rowNumberfrom book, bookSpecwhere book.id=? and book.bookSpecId=bookSpec.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: Column BOOK.ID not found; SQL statement: select book.id, bookSpec.title, book.shelfNumber, book.rowNumberfrom book, bookSpecwhere book.id=? and book.bookSpecId=bookSpec.id [42S22-30]<o:p></o:p> org.h2.jdbc.JdbcSQLException: Column BOOK.ID not found; SQL statement: select book.id, bookSpec.title, book.shelfNumber, book.rowNumberfrom book, bookSpecwhere book.id=? and book.bookSpecId=bookSpec.id [42S22-30]<o:p></o:p>               at org.h2.message.Message.addSQL(Message.java:338)<o:p></o:p>               at org.h2.command.Parser.prepareCommand(Parser.java:210)<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: Column BOOK.ID not found [42S22-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.expression.ExpressionColumn.optimize(ExpressionColumn.java:111)<o:p></o:p>               at org.h2.command.dml.Select.prepare(Select.java:461)<o:p></o:p>               at org.h2.command.Parser.prepareCommand(Parser.java:190)<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>  [42S22-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$O!"0J2<$,I=<($5$l$^$9!#(B<o:p></o:p> <o:p> </o:p> DEBUG 2007-03-20 19:18:55,046 [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-03-20 19:18:55,093 [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-03-20 19:18:55,203 [main] $B%/%i%9(B(book.chura.dao.BookDao[bookDao])$B$N%3%s%]!<%M%s%HDj5A$rEPO?$7$^$9(B<o:p></o:p> DEBUG 2007-03-20 19:18:55,296 [main] BEGIN book.chura.dao.BookDao#findBookInfo(039911175)<o:p></o:p> DEBUG 2007-03-20 19:18:55,500 [main] $BJ*M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(B<o:p></o:p> DEBUG 2007-03-20 19:18:55,500 [main] $BO@M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(B<o:p></o:p> DEBUG 2007-03-20 19:18:55,734 [main] $BO@M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(B<o:p></o:p> DEBUG 2007-03-20 19:18:55,828 [main] select book.id, bookSpec.title, book.shelfNumber, book.rowNumberfrom book, bookSpecwhere book.id='039911175' and book.bookSpecId=bookSpec.id<o:p></o:p> DEBUG 2007-03-20 19:18:55,828 [main] $BO@M}E*$J%3%M%/%7%g%s$r<hF@$7$^$7$?(B<o:p></o:p> DEBUG 2007-03-20 19:18:55,843 [main] $BJ*M}E*$J%3%M%/%7%g%s$rJD$8$^$7$?(B<o:p></o:p> DEBUG 2007-03-20 19:18:55,843 [main] END book.chura.dao.BookDao#findBookInfo(039911175) Throwable:org.seasar.framework.exception.SQLRuntimeException: [ESSR0071]SQL$B$GNc30(B(ErrorCode=42122, SQLState=42S22)$B$,H/@8$7$^$7$?!#M}M3$O(Borg.seasar.framework.exception.SSQLException: [ESSR0072]SQL$B$GNc30(B(SQL=[select book.id, bookSpec.title, book.shelfNumber, book.rowNumberfrom book, bookSpecwhere book.id=? and book.bookSpecId=bookSpec.id], ErrorCode={1}, SQLState={2})$B$,H/@8$7$^$7$?(B<o:p></o:p> <o:p> </o:p> $B$3$N%(%i!<$NBP=hJ}K!$4B8CN$NJ}!"$465<x$$$?$@$1$J$$$G$7$g$&$+!)(B<o:p></o:p> $B59$7$/!"8f4j$$CW$7$^$9!#(B<o:p></o:p> <o:p> </o:p> </div> </body> </html>