定期的に実行
Updating <a href='https://www.seasar.org/svn/sandbox/s2dao-codegen/trunk/codegen-lib'>https://www.seasar.org/svn/sandbox/s2dao-codegen/trunk/codegen-lib</a>
'<a href='https://www.seasar.org/svn/sandbox/s2dao-codegen/trunk/codegen-core'>https://www.seasar.org/svn/sandbox/s2dao-codegen/trunk/codegen-core</a>'のリビジョン-1を'/home/services/hudson/jobs/codegen-lib-generate/workspace/codegen-lib/codegen-core'へ取得中
At revision 811
At revision 811
no change for <a href='https://www.seasar.org/svn/sandbox/s2dao-codegen/trunk/codegen-lib'>https://www.seasar.org/svn/sandbox/s2dao-codegen/trunk/codegen-lib</a> since the previous build
no change for <a href='https://www.seasar.org/svn/sandbox/s2dao-codegen/trunk/codegen-core'>https://www.seasar.org/svn/sandbox/s2dao-codegen/trunk/codegen-core</a> since the previous build
[codegen-lib] $ /usr/local/java/maven/bin/mvn -f codegen-core/pom.xml clean compile
[INFO] Scanning for projects...
[INFO] ------------------------------------------------------------------------
[INFO] Building S2Dao Code Generator
[INFO]    task-segment: [clean, compile]
[INFO] ------------------------------------------------------------------------
[INFO] [clean:clean {execution: default-clean}]
[INFO] Deleting directory /home/services/hudson/jobs/codegen-lib-generate/workspace/codegen-lib/codegen-core/target
[INFO] [resources:resources {execution: default-resources}]
[WARNING] Using platform encoding (UTF-8 actually) to copy filtered resources, i.e. build is platform dependent!
[INFO] Copying 34 resources
[INFO] [compiler:compile {execution: default-compile}]
[INFO] Compiling 72 source files to /home/services/hudson/jobs/codegen-lib-generate/workspace/codegen-lib/codegen-core/target/classes
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESSFUL
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 3 seconds
[INFO] Finished at: Fri Feb 04 12:30:46 JST 2011
[INFO] Final Memory: 23M/154M
[INFO] ------------------------------------------------------------------------
[codegen-lib] $ /usr/local/java/ant/bin/ant
Buildfile: build.xml

gen:
     [java] 12:30:47.733 JST [main] INFO  o.s.f.c.f.SingletonS2ContainerFactory - s2-frameworkのバージョンは2.4.40です。
     [java] 12:30:47.738 JST [main] INFO  o.s.f.c.f.SingletonS2ContainerFactory - s2-extensionのバージョンは2.4.40です。
     [java] 12:30:47.739 JST [main] INFO  o.s.f.c.f.SingletonS2ContainerFactory - s2-tigerのバージョンは2.4.40です。
     [java] 12:30:48.310 JST [main] INFO  o.s.f.c.f.SingletonS2ContainerFactory - Running on [ENV]product, [DEPLOY MODE]Normal Mode
     [java] log4j:WARN No appenders could be found for logger (freemarker.cache).
     [java] log4j:WARN Please initialize the log4j system properly.
     [java] 12:30:49.131 JST [main] WARN  o.s.codegen.impl.DDLOutputCodeImpl - テンプレートが存在しないのでDDLを生成しません(createTable_h2.ftl)。
     [java] 12:30:49.138 JST [main] WARN  o.s.codegen.impl.DDLOutputCodeImpl - テンプレートが存在しないのでDDLを生成しません(dropTable_h2.ftl)。

BUILD SUCCESSFUL
Total time: 2 seconds
[codegen-lib] $ /usr/local/java/maven/bin/mvn clean test
[INFO] Scanning for projects...
[INFO] ------------------------------------------------------------------------
[INFO] Building codegen-lib
[INFO]    task-segment: [clean, test]
[INFO] ------------------------------------------------------------------------
[INFO] [clean:clean {execution: default-clean}]
[INFO] Deleting directory /home/services/hudson/jobs/codegen-lib-generate/workspace/codegen-lib/target
[INFO] [build-helper:add-test-source {execution: add-test-source}]
[INFO] Test Source directory: /home/services/hudson/jobs/codegen-lib-generate/workspace/codegen-lib/src/sample/java added.
[INFO] [resources:resources {execution: default-resources}]
[WARNING] Using platform encoding (UTF-8 actually) to copy filtered resources, i.e. build is platform dependent!
[INFO] Copying 3 resources
[INFO] [compiler:compile {execution: default-compile}]
[INFO] Compiling 25 source files to /home/services/hudson/jobs/codegen-lib-generate/workspace/codegen-lib/target/classes
[INFO] [resources:testResources {execution: default-testResources}]
[WARNING] Using platform encoding (UTF-8 actually) to copy filtered resources, i.e. build is platform dependent!
[INFO] Copying 11 resources
[INFO] Copying 1 resource
[INFO] Copying 11 resources
[INFO] [compiler:testCompile {execution: default-testCompile}]
[INFO] Compiling 34 source files to /home/services/hudson/jobs/codegen-lib-generate/workspace/codegen-lib/target/test-classes
[INFO] [surefire:test {execution: default-test}]
[INFO] Surefire report directory: /home/services/hudson/jobs/codegen-lib-generate/workspace/codegen-lib/target/surefire-reports

-------------------------------------------------------
 T E S T S
-------------------------------------------------------
Running org.seasar.codegen.lib.internal.impl.CodeGenDaoMetaDataImplTest
Tests run: 14, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 6.562 sec
Running org.seasar.codegen.lib.internal.impl.FindSqlCommandTest
DEBUG 2011-02-04 12:31:01,037 [main] SELECT EMP_TABLE.EMP_NO, EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.TSTAMP, EMP_TABLE.VERSIONNO FROM EMP_TABLE WHERE EMP_TABLE.EMP_NO =100
DEBUG 2011-02-04 12:31:01,145 [main] SELECT EMP_TABLE.EMP_NO, EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.TSTAMP, EMP_TABLE.VERSIONNO FROM EMP_TABLE
 WHERE EMP_TABLE.EMP_NO =? AND EMP_TABLE.SAL &lt;&gt;? AND ENAME = ?
Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.515 sec
Running org.seasar.codegen.sample.dao.ShiftJISDaoTest
DEBUG 2011-02-04 12:31:01,599 [main] BEGIN org.seasar.codegen.sample.dao.ShiftJISDao#selectByShiftJISFile()
DEBUG 2011-02-04 12:31:01,631 [main] SELECT * FROM EMP_TABLE WHERE ENAME &lt;&gt; '文字列'
DEBUG 2011-02-04 12:31:01,632 [main] END org.seasar.codegen.sample.dao.ShiftJISDao#selectByShiftJISFile() : []
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.167 sec
Running org.seasar.codegen.lib.impl.ConditionElementImplTest
[ECGL0001]org.seasar.codegen.lib.impl.ConditionElementImplTest$NullConditionのカラムbbbに対する検索条件がnullです。
Tests run: 15, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.016 sec
Running org.seasar.codegen.sample.dao.EmpTableDaoTest
DEBUG 2011-02-04 12:31:02,005 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:02,006 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:02,016 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:02,018 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:02,018 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:02,019 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:02,026 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,028 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,029 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,030 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,030 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,031 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,032 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,033 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:02,033 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,034 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,035 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,036 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,036 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,037 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,038 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getAllEmpTable()
DEBUG 2011-02-04 12:31:02,049 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE ORDER BY EMP_NO
DEBUG 2011-02-04 12:31:02,053 [main] END org.seasar.codegen.sample.dao.EmpTableDao#getAllEmpTable() : [[/empNo=7369/ename=SMITH/job=CLERK/mgr=7902/hireDate=1980-12-17 00:00:00.0/sal=800/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7499/ename=ALLEN/job=SALESMAN/mgr=7698/hireDate=1981-02-20 00:00:00.0/sal=1600/comm=300/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7521/ename=WARD/job=SALESMAN/mgr=7698/hireDate=1981-02-22 00:00:00.0/sal=1250/comm=500/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7566/ename=JONES/job=MANAGER/mgr=7839/hireDate=1981-04-02 00:00:00.0/sal=2975/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7654/ename=MARTIN/job=SALESMAN/mgr=7698/hireDate=1981-09-28 00:00:00.0/sal=1250/comm=1400/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7698/ename=BLAKE/job=MANAGER/mgr=7839/hireDate=1981-05-01 00:00:00.0/sal=2850/comm=null/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7782/ename=CLARK/job=MANAGER/mgr=7839/hireDate=1981-06-09 00:00:00.0/sal=2450/comm=null/deptNo=10/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7788/ename=SCOTT/job=ANALYST/mgr=7566/hireDate=1982-12-09 00:00:00.0/sal=3000.0/comm=null/deptNo=20/tstamp=2005-01-18 13:09:32.213/versionno=1], [/empNo=7839/ename=KING/job=PRESIDENT/mgr=null/hireDate=1981-11-17 00:00:00.0/sal=5000/comm=null/deptNo=10/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7844/ename=TURNER/job=SALESMAN/mgr=7698/hireDate=1981-09-08 00:00:00.0/sal=1500/comm=0/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]]
DEBUG 2011-02-04 12:31:02,230 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:02,230 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:02,235 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:02,235 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:02,236 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:02,236 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:02,242 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,243 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,244 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,245 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,245 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,246 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,247 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,247 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:02,248 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,249 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,249 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,250 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,251 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,252 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,252 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7521)
DEBUG 2011-02-04 12:31:02,264 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE WHERE EMP_NO = 7521
DEBUG 2011-02-04 12:31:02,265 [main] END org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7521) : [/empNo=7521/ename=WARD/job=SALESMAN/mgr=7698/hireDate=1981-02-22 00:00:00.0/sal=1250/comm=500/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]
DEBUG 2011-02-04 12:31:02,461 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:02,461 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:02,466 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:02,466 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:02,467 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:02,467 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:02,474 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,475 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,475 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,476 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,477 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,478 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,479 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,480 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:02,480 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,481 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,482 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,483 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,483 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,484 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,485 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIds([7566, 7654])
DEBUG 2011-02-04 12:31:02,496 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE WHERE EMP_NO in (7566, 7654) ORDER BY EMP_NO
DEBUG 2011-02-04 12:31:02,500 [main] END org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIds([7566, 7654]) : [[/empNo=7566/ename=JONES/job=MANAGER/mgr=7839/hireDate=1981-04-02 00:00:00.0/sal=2975/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7654/ename=MARTIN/job=SALESMAN/mgr=7698/hireDate=1981-09-28 00:00:00.0/sal=1250/comm=1400/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]]
DEBUG 2011-02-04 12:31:02,685 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:02,686 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:02,691 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:02,692 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:02,692 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:02,693 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:02,699 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,700 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,701 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,701 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,702 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,703 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,703 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,704 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:02,705 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,705 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,706 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,707 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,707 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,708 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,709 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableWithRelation(7369)
DEBUG 2011-02-04 12:31:02,720 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP, deptTableEntity.VERSIONNO AS VERSIONNO_0, deptTableEntity.DEPT_ID AS DEPT_ID_0, deptTableEntity.DNAME AS DNAME_0, deptTableEntity.LOC AS LOC_0, deptTableEntity.ACTIVE AS ACTIVE_0 FROM EMP_TABLE LEFT OUTER JOIN DEPT_TABLE deptTableEntity ON EMP_TABLE.DEPT_NO = deptTableEntity.DEPT_ID WHERE EMP_NO  = 7369 ORDER BY EMP_NO
DEBUG 2011-02-04 12:31:02,723 [main] END org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableWithRelation(7369) : [/empNo=7369/ename=SMITH/job=CLERK/mgr=7902/hireDate=1980-12-17 00:00:00.0/sal=800/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=20/dname=RESEARCH/loc=DALLAS/versionno=0/active=true]
DEBUG 2011-02-04 12:31:02,877 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:02,877 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:02,882 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:02,882 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:02,883 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:02,883 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:02,890 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,891 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,891 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,892 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,893 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,893 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,894 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,895 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:02,895 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,896 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,897 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,898 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,898 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,899 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:02,900 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#insert([/empNo=null/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 12:31:02 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null])
DEBUG 2011-02-04 12:31:02,912 [main] CALL NEXTVAL('EMPNO')
DEBUG 2011-02-04 12:31:02,913 [main] INSERT INTO EMP_TABLE (ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, VERSIONNO, EMP_NO) VALUES ('せとあずさ', 'MANAGER', 7902, '2006-11-01', 10000, 1000, 10, 0, 1)
DEBUG 2011-02-04 12:31:02,913 [main] END org.seasar.codegen.sample.dao.EmpTableDao#insert([/empNo=null/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 12:31:02 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]) : 1
DEBUG 2011-02-04 12:31:02,917 [main] SELECT * FROM EMP_TABLE ORDER BY emp_no
DEBUG 2011-02-04 12:31:03,081 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:03,081 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:03,086 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:03,087 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:03,087 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:03,087 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:03,096 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,097 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,098 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,098 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,099 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,100 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,100 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,101 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:03,102 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,102 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,103 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,104 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,104 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,105 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,106 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7369)
DEBUG 2011-02-04 12:31:03,116 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE WHERE EMP_NO = 7369
DEBUG 2011-02-04 12:31:03,117 [main] END org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7369) : [/empNo=7369/ename=SMITH/job=CLERK/mgr=7902/hireDate=1980-12-17 00:00:00.0/sal=800/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1]
DEBUG 2011-02-04 12:31:03,117 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#update([/empNo=7369/ename=null/job=CLERK/mgr=7902/hireDate=1980-12-17 00:00:00.0/sal=800/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1])
DEBUG 2011-02-04 12:31:03,118 [main] UPDATE EMP_TABLE SET ENAME = null, JOB = 'CLERK', MGR = 7902, HIRE_DATE = '1980-12-17 00.00.00', SAL = 800, COMM = null, DEPT_NO = 20, VERSIONNO = 2, TSTAMP = '2000-01-01 00.00.00' WHERE EMP_NO = 7369 AND VERSIONNO = 1
DEBUG 2011-02-04 12:31:03,119 [main] END org.seasar.codegen.sample.dao.EmpTableDao#update([/empNo=7369/ename=null/job=CLERK/mgr=7902/hireDate=1980-12-17 00:00:00.0/sal=800/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1]) : 1
DEBUG 2011-02-04 12:31:03,129 [main] SELECT * FROM emp_table ORDER BY emp_no
DEBUG 2011-02-04 12:31:03,143 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7369'
DEBUG 2011-02-04 12:31:03,143 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7499'
DEBUG 2011-02-04 12:31:03,144 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7521'
DEBUG 2011-02-04 12:31:03,144 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7566'
DEBUG 2011-02-04 12:31:03,145 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7654'
DEBUG 2011-02-04 12:31:03,145 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7698'
DEBUG 2011-02-04 12:31:03,145 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7782'
DEBUG 2011-02-04 12:31:03,146 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7788'
DEBUG 2011-02-04 12:31:03,146 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7839'
DEBUG 2011-02-04 12:31:03,146 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7844'
DEBUG 2011-02-04 12:31:03,147 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7876'
DEBUG 2011-02-04 12:31:03,147 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7900'
DEBUG 2011-02-04 12:31:03,148 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7902'
DEBUG 2011-02-04 12:31:03,148 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7934'
DEBUG 2011-02-04 12:31:03,305 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:03,305 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:03,310 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:03,310 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:03,310 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:03,311 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:03,317 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,318 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,318 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,319 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,320 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,320 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,321 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,322 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:03,322 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,323 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,324 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,324 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,325 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,326 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,326 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7369)
DEBUG 2011-02-04 12:31:03,337 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE WHERE EMP_NO = 7369
DEBUG 2011-02-04 12:31:03,338 [main] END org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7369) : [/empNo=7369/ename=SMITH/job=CLERK/mgr=7902/hireDate=1980-12-17 00:00:00.0/sal=800/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1]
DEBUG 2011-02-04 12:31:03,338 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#updateNonCheck([/empNo=7369/ename=null/job=CLERK/mgr=7902/hireDate=1980-12-17 00:00:00.0/sal=800/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=10])
DEBUG 2011-02-04 12:31:03,338 [main] UPDATE EMP_TABLE SET ENAME = null, JOB = 'CLERK', MGR = 7902, HIRE_DATE = '1980-12-17 00.00.00', SAL = 800, COMM = null, DEPT_NO = 20, VERSIONNO = 11, TSTAMP = '2000-01-01 00.00.00' WHERE EMP_NO = 7369 AND VERSIONNO = 10
DEBUG 2011-02-04 12:31:03,339 [main] END org.seasar.codegen.sample.dao.EmpTableDao#updateNonCheck([/empNo=7369/ename=null/job=CLERK/mgr=7902/hireDate=1980-12-17 00:00:00.0/sal=800/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=10]) : 0
DEBUG 2011-02-04 12:31:03,339 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#updateNonCheckModifiedOnly([/empNo=7369/ename=null/job=CLERK/mgr=7902/hireDate=1980-12-17 00:00:00.0/sal=800/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=11])
DEBUG 2011-02-04 12:31:03,339 [main] UPDATE EMP_TABLE SET ENAME = null, VERSIONNO = 12 WHERE EMP_NO = 7369 AND VERSIONNO = 11
DEBUG 2011-02-04 12:31:03,339 [main] END org.seasar.codegen.sample.dao.EmpTableDao#updateNonCheckModifiedOnly([/empNo=7369/ename=null/job=CLERK/mgr=7902/hireDate=1980-12-17 00:00:00.0/sal=800/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=11]) : 0
DEBUG 2011-02-04 12:31:03,501 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:03,502 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:03,507 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:03,507 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:03,507 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:03,508 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:03,515 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,515 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,516 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,517 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,518 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,518 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,519 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,520 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:03,521 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,521 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,522 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,523 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,523 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,524 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,525 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#delete([/empNo=7369/ename=null/job=null/mgr=null/hireDate=null/sal=null/comm=null/deptNo=null/tstamp=null/versionno=1])
DEBUG 2011-02-04 12:31:03,538 [main] DELETE FROM EMP_TABLE WHERE EMP_NO = 7369 AND VERSIONNO = 1
DEBUG 2011-02-04 12:31:03,538 [main] END org.seasar.codegen.sample.dao.EmpTableDao#delete([/empNo=7369/ename=null/job=null/mgr=null/hireDate=null/sal=null/comm=null/deptNo=null/tstamp=null/versionno=1]) : 1
DEBUG 2011-02-04 12:31:03,548 [main] SELECT * FROM emp_table ORDER BY emp_no
DEBUG 2011-02-04 12:31:03,561 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7499'
DEBUG 2011-02-04 12:31:03,562 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7521'
DEBUG 2011-02-04 12:31:03,562 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7566'
DEBUG 2011-02-04 12:31:03,562 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7654'
DEBUG 2011-02-04 12:31:03,563 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7698'
DEBUG 2011-02-04 12:31:03,563 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7782'
DEBUG 2011-02-04 12:31:03,564 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7788'
DEBUG 2011-02-04 12:31:03,564 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7839'
DEBUG 2011-02-04 12:31:03,564 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7844'
DEBUG 2011-02-04 12:31:03,565 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7876'
DEBUG 2011-02-04 12:31:03,565 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7900'
DEBUG 2011-02-04 12:31:03,566 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7902'
DEBUG 2011-02-04 12:31:03,566 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7934'
DEBUG 2011-02-04 12:31:03,741 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:03,741 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:03,746 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:03,747 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:03,747 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:03,747 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:03,753 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,754 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,755 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,756 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,757 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,757 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,758 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,759 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:03,760 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,760 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,761 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,762 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,762 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,763 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,765 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.EMP_NO&gt;7500/EMP_TABLE.HIRE_DATE&gt;=Mon Jan 01 00:00:00 JST 1900/offset=0/limit=-1)
DEBUG 2011-02-04 12:31:03,779 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE WHERE EMP_TABLE.EMP_NO &gt;7500 AND EMP_TABLE.HIRE_DATE &gt;='1900-01-01'
DEBUG 2011-02-04 12:31:03,782 [main] END org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.EMP_NO&gt;7500/EMP_TABLE.HIRE_DATE&gt;=Mon Jan 01 00:00:00 JST 1900/offset=0/limit=-1) : [[/empNo=7521/ename=WARD/job=SALESMAN/mgr=7698/hireDate=1981-02-22 00:00:00.0/sal=1250/comm=500/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7566/ename=JONES/job=MANAGER/mgr=7839/hireDate=1981-04-02 00:00:00.0/sal=2975/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7654/ename=MARTIN/job=SALESMAN/mgr=7698/hireDate=1981-09-28 00:00:00.0/sal=1250/comm=1400/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7698/ename=BLAKE/job=MANAGER/mgr=7839/hireDate=1981-05-01 00:00:00.0/sal=2850/comm=null/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7782/ename=CLARK/job=MANAGER/mgr=7839/hireDate=1981-06-09 00:00:00.0/sal=2450/comm=null/deptNo=10/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7788/ename=SCOTT/job=ANALYST/mgr=7566/hireDate=1982-12-09 00:00:00.0/sal=3000.0/comm=null/deptNo=20/tstamp=2005-01-18 13:09:32.213/versionno=1], [/empNo=7839/ename=KING/job=PRESIDENT/mgr=null/hireDate=1981-11-17 00:00:00.0/sal=5000/comm=null/deptNo=10/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7844/ename=TURNER/job=SALESMAN/mgr=7698/hireDate=1981-09-08 00:00:00.0/sal=1500/comm=0/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7876/ename=ADAMS/job=CLERK/mgr=7788/hireDate=1983-01-12 00:00:00.0/sal=1100/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7900/ename=JAMES/job=CLERK/mgr=7698/hireDate=1981-12-03 00:00:00.0/sal=950/comm=null/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]]
DEBUG 2011-02-04 12:31:03,941 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:03,941 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:03,945 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:03,946 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:03,946 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:03,946 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:03,952 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,953 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,953 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,954 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,955 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,955 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,956 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,956 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:03,957 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,958 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,958 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,959 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,960 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,960 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:03,961 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.EMP_NO&lt;&gt;7500/offset=0/limit=-1)
DEBUG 2011-02-04 12:31:03,972 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE WHERE EMP_TABLE.EMP_NO &lt;&gt;7500 AND DEPT_NO &lt;&gt; 10
DEBUG 2011-02-04 12:31:03,975 [main] END org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.EMP_NO&lt;&gt;7500/offset=0/limit=-1) : [[/empNo=7369/ename=SMITH/job=CLERK/mgr=7902/hireDate=1980-12-17 00:00:00.0/sal=800/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7499/ename=ALLEN/job=SALESMAN/mgr=7698/hireDate=1981-02-20 00:00:00.0/sal=1600/comm=300/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7521/ename=WARD/job=SALESMAN/mgr=7698/hireDate=1981-02-22 00:00:00.0/sal=1250/comm=500/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7566/ename=JONES/job=MANAGER/mgr=7839/hireDate=1981-04-02 00:00:00.0/sal=2975/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7654/ename=MARTIN/job=SALESMAN/mgr=7698/hireDate=1981-09-28 00:00:00.0/sal=1250/comm=1400/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7698/ename=BLAKE/job=MANAGER/mgr=7839/hireDate=1981-05-01 00:00:00.0/sal=2850/comm=null/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7788/ename=SCOTT/job=ANALYST/mgr=7566/hireDate=1982-12-09 00:00:00.0/sal=3000.0/comm=null/deptNo=20/tstamp=2005-01-18 13:09:32.213/versionno=1], [/empNo=7844/ename=TURNER/job=SALESMAN/mgr=7698/hireDate=1981-09-08 00:00:00.0/sal=1500/comm=0/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7876/ename=ADAMS/job=CLERK/mgr=7788/hireDate=1983-01-12 00:00:00.0/sal=1100/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7900/ename=JAMES/job=CLERK/mgr=7698/hireDate=1981-12-03 00:00:00.0/sal=950/comm=null/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]]
DEBUG 2011-02-04 12:31:04,116 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:04,116 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:04,121 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:04,121 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:04,121 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:04,122 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:04,127 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,128 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,129 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,129 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,130 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,131 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,131 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,132 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:04,133 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,133 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,134 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,135 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,135 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,136 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,136 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#find(/offset=0/limit=-1)
DEBUG 2011-02-04 12:31:04,147 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE WHERE DEPT_NO &lt;&gt; 10
DEBUG 2011-02-04 12:31:04,149 [main] END org.seasar.codegen.sample.dao.EmpTableDao#find(/offset=0/limit=-1) : [[/empNo=7369/ename=SMITH/job=CLERK/mgr=7902/hireDate=1980-12-17 00:00:00.0/sal=800/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7499/ename=ALLEN/job=SALESMAN/mgr=7698/hireDate=1981-02-20 00:00:00.0/sal=1600/comm=300/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7521/ename=WARD/job=SALESMAN/mgr=7698/hireDate=1981-02-22 00:00:00.0/sal=1250/comm=500/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7566/ename=JONES/job=MANAGER/mgr=7839/hireDate=1981-04-02 00:00:00.0/sal=2975/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7654/ename=MARTIN/job=SALESMAN/mgr=7698/hireDate=1981-09-28 00:00:00.0/sal=1250/comm=1400/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7698/ename=BLAKE/job=MANAGER/mgr=7839/hireDate=1981-05-01 00:00:00.0/sal=2850/comm=null/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7788/ename=SCOTT/job=ANALYST/mgr=7566/hireDate=1982-12-09 00:00:00.0/sal=3000.0/comm=null/deptNo=20/tstamp=2005-01-18 13:09:32.213/versionno=1], [/empNo=7844/ename=TURNER/job=SALESMAN/mgr=7698/hireDate=1981-09-08 00:00:00.0/sal=1500/comm=0/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7876/ename=ADAMS/job=CLERK/mgr=7788/hireDate=1983-01-12 00:00:00.0/sal=1100/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7900/ename=JAMES/job=CLERK/mgr=7698/hireDate=1981-12-03 00:00:00.0/sal=950/comm=null/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]]
DEBUG 2011-02-04 12:31:04,288 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:04,288 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:04,292 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:04,292 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:04,292 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:04,292 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:04,297 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,297 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,298 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,299 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,299 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,300 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,300 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,301 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:04,302 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,302 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,303 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,303 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,304 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,305 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,305 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.COMM=1000/EMP_TABLE.DEPT_NOIN10/EMP_TABLE.EMP_NOIN100/EMP_TABLE.ENAMEIS NULL/EMP_TABLE.HIRE_DATEIS NOT NULL/EMP_TABLE.MGR&lt;1000/EMP_TABLE.SAL&lt;=100/EMP_TABLE.MGR&gt;0/EMP_TABLE.SAL&gt;=0/EMP_TABLE.TSTAMP&lt;&gt;2011-02-04 12:31:04.305/EMP_TABLE.VERSIONNOnot in1/EMP_TABLE.EMP_NOnot in99/offset=0/limit=-1)
DEBUG 2011-02-04 12:31:04,316 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE WHERE EMP_TABLE.COMM =1000 AND EMP_TABLE.DEPT_NO IN(10) AND EMP_TABLE.EMP_NO IN(100) AND EMP_TABLE.ENAME IS NULL AND EMP_TABLE.HIRE_DATE IS NOT NULL AND EMP_TABLE.MGR &lt;1000 AND EMP_TABLE.SAL &lt;=100 AND EMP_TABLE.MGR &gt;0 AND EMP_TABLE.SAL &gt;=0 AND EMP_TABLE.TSTAMP &lt;&gt;'2011-02-04 12.31.04' AND EMP_TABLE.VERSIONNO not in(1) AND EMP_TABLE.EMP_NO not in(99)
DEBUG 2011-02-04 12:31:04,318 [main] END org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.COMM=1000/EMP_TABLE.DEPT_NOIN10/EMP_TABLE.EMP_NOIN100/EMP_TABLE.ENAMEIS NULL/EMP_TABLE.HIRE_DATEIS NOT NULL/EMP_TABLE.MGR&lt;1000/EMP_TABLE.SAL&lt;=100/EMP_TABLE.MGR&gt;0/EMP_TABLE.SAL&gt;=0/EMP_TABLE.TSTAMP&lt;&gt;2011-02-04 12:31:04.305/EMP_TABLE.VERSIONNOnot in1/EMP_TABLE.EMP_NOnot in99/offset=0/limit=-1) : []
DEBUG 2011-02-04 12:31:04,493 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:04,493 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:04,497 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:04,497 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:04,497 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:04,498 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:04,502 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,502 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,503 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,504 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,504 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,505 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,505 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,506 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:04,507 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,507 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,508 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,508 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,509 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,510 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,510 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#soleMatch(/EMP_TABLE.EMP_NO&gt;=7934/EMP_TABLE.HIRE_DATE&gt;Mon Jan 01 00:00:00 JST 1900/offset=0/limit=-1)
/EMP_TABLE.EMP_NO&gt;=7934/EMP_TABLE.HIRE_DATE&gt;Mon Jan 01 00:00:00 JST 1900/offset=0/limit=-1
DEBUG 2011-02-04 12:31:04,521 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE WHERE EMP_TABLE.EMP_NO &gt;=7934 AND EMP_TABLE.HIRE_DATE &gt;'1900-01-01'
DEBUG 2011-02-04 12:31:04,522 [main] END org.seasar.codegen.sample.dao.EmpTableDao#soleMatch(/EMP_TABLE.EMP_NO&gt;=7934/EMP_TABLE.HIRE_DATE&gt;Mon Jan 01 00:00:00 JST 1900/offset=0/limit=-1) : [/empNo=7934/ename=MILLER/job=CLERK/mgr=7782/hireDate=1982-01-23 00:00:00.0/sal=1300/comm=null/deptNo=10/tstamp=2000-01-01 00:00:00.0/versionno=1]
/ORDER BY EMP_TABLE.EMP_NO ,EMP_TABLE.DEPT_NO DESC/offset=0/limit=-1
DEBUG 2011-02-04 12:31:04,622 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#find(/ORDER BY EMP_TABLE.EMP_NO ,EMP_TABLE.DEPT_NO DESC/offset=0/limit=-1)
DEBUG 2011-02-04 12:31:04,662 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE  ORDER BY EMP_TABLE.EMP_NO,EMP_TABLE.DEPT_NO DESC 
DEBUG 2011-02-04 12:31:04,663 [main] END org.seasar.codegen.sample.dao.EmpTableDao#find(/ORDER BY EMP_TABLE.EMP_NO ,EMP_TABLE.DEPT_NO DESC/offset=0/limit=-1) : []
DEBUG 2011-02-04 12:31:04,760 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#findWithRelation(/deptTableEntity.LOC=DALLAS/offset=0/limit=-1)
DEBUG 2011-02-04 12:31:04,803 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP, deptTableEntity.VERSIONNO AS VERSIONNO_0, deptTableEntity.DEPT_ID AS DEPT_ID_0, deptTableEntity.DNAME AS DNAME_0, deptTableEntity.LOC AS LOC_0, deptTableEntity.ACTIVE AS ACTIVE_0 FROM EMP_TABLE LEFT OUTER JOIN DEPT_TABLE deptTableEntity ON EMP_TABLE.DEPT_NO = deptTableEntity.DEPT_ID WHERE deptTableEntity.LOC ='DALLAS'
DEBUG 2011-02-04 12:31:04,804 [main] END org.seasar.codegen.sample.dao.EmpTableDao#findWithRelation(/deptTableEntity.LOC=DALLAS/offset=0/limit=-1) : []
DEBUG 2011-02-04 12:31:04,948 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:04,948 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:04,951 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:04,952 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:04,952 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:04,952 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:04,956 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,956 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,957 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,957 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,958 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,959 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,959 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,960 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:04,960 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,961 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,962 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,962 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,963 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:04,963 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
/EMP_TABLE.HIRE_DATE&gt;Mon Jan 01 00:00:00 JST 1900/ORDER BY EMP_TABLE.EMP_NO /offset=5/limit=5
DEBUG 2011-02-04 12:31:04,964 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.HIRE_DATE&gt;Mon Jan 01 00:00:00 JST 1900/ORDER BY EMP_TABLE.EMP_NO /offset=5/limit=5)
DEBUG 2011-02-04 12:31:04,975 [main] SELECT count(*) FROM (SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE WHERE EMP_TABLE.HIRE_DATE &gt;'1900-01-01' ) AS total
DEBUG 2011-02-04 12:31:04,980 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE WHERE EMP_TABLE.HIRE_DATE &gt;'1900-01-01' ORDER BY EMP_TABLE.EMP_NO LIMIT 5 OFFSET 5
DEBUG 2011-02-04 12:31:04,982 [main] END org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.HIRE_DATE&gt;Mon Jan 01 00:00:00 JST 1900/ORDER BY EMP_TABLE.EMP_NO /offset=5/limit=5) : [[/empNo=7698/ename=BLAKE/job=MANAGER/mgr=7839/hireDate=1981-05-01 00:00:00.0/sal=2850/comm=null/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7782/ename=CLARK/job=MANAGER/mgr=7839/hireDate=1981-06-09 00:00:00.0/sal=2450/comm=null/deptNo=10/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7788/ename=SCOTT/job=ANALYST/mgr=7566/hireDate=1982-12-09 00:00:00.0/sal=3000.0/comm=null/deptNo=20/tstamp=2005-01-18 13:09:32.213/versionno=1], [/empNo=7839/ename=KING/job=PRESIDENT/mgr=null/hireDate=1981-11-17 00:00:00.0/sal=5000/comm=null/deptNo=10/tstamp=2000-01-01 00:00:00.0/versionno=1], [/empNo=7844/ename=TURNER/job=SALESMAN/mgr=7698/hireDate=1981-09-08 00:00:00.0/sal=1500/comm=0/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]]
DEBUG 2011-02-04 12:31:05,124 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:05,124 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:05,127 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:05,127 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:05,128 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:05,128 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:05,131 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,132 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,132 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,133 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,133 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,134 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,135 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,135 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:05,136 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,136 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,137 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,137 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,138 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,139 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,139 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7654)
DEBUG 2011-02-04 12:31:05,149 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE WHERE EMP_NO = 7654
DEBUG 2011-02-04 12:31:05,150 [main] END org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7654) : [/empNo=7654/ename=MARTIN/job=SALESMAN/mgr=7698/hireDate=1981-09-28 00:00:00.0/sal=1250/comm=1400/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]
DEBUG 2011-02-04 12:31:05,150 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#updateModifiedOnly([/empNo=7654/ename=せとあずさ/job=SALESMAN/mgr=7698/hireDate=1981-09-28 00:00:00.0/sal=1250/comm=1400/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1])
DEBUG 2011-02-04 12:31:05,150 [main] UPDATE EMP_TABLE SET ENAME = 'せとあずさ', VERSIONNO = 2 WHERE EMP_NO = 7654 AND VERSIONNO = 1
DEBUG 2011-02-04 12:31:05,151 [main] END org.seasar.codegen.sample.dao.EmpTableDao#updateModifiedOnly([/empNo=7654/ename=せとあずさ/job=SALESMAN/mgr=7698/hireDate=1981-09-28 00:00:00.0/sal=1250/comm=1400/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]) : 1
DEBUG 2011-02-04 12:31:05,280 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:05,280 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:05,283 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:05,284 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:05,284 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:05,284 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:05,288 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,289 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,290 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,290 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,291 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,291 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,292 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,292 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:05,293 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,293 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,294 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,295 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,295 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,296 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,296 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#insertBatch([[/empNo=9990/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 12:31:05 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=9991/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 12:31:05 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]])
DEBUG 2011-02-04 12:31:05,307 [main] INSERT INTO EMP_TABLE (ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, VERSIONNO, EMP_NO, TSTAMP) VALUES ('せとあずさ', 'MANAGER', 7902, '2006-11-01', 10000, 1000, 10, 0, 9990, null)
DEBUG 2011-02-04 12:31:05,307 [main] INSERT INTO EMP_TABLE (ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, VERSIONNO, EMP_NO, TSTAMP) VALUES ('せとあずさ', 'MANAGER', 7902, '2006-11-01', 10000, 1000, 10, 0, 9991, null)
DEBUG 2011-02-04 12:31:05,309 [main] END org.seasar.codegen.sample.dao.EmpTableDao#insertBatch([[/empNo=9990/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 12:31:05 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=9991/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 12:31:05 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) : [1, 1]
DEBUG 2011-02-04 12:31:05,310 [main] SELECT * FROM EMP_TABLE ORDER BY emp_no
DEBUG 2011-02-04 12:31:05,444 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:05,444 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:05,447 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:05,448 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:05,448 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:05,448 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:05,451 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,452 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,452 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,453 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,453 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,454 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,455 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,455 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:05,456 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,456 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,457 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,457 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,458 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,458 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,459 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#updateBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 12:31:05 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=7499/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 12:31:05 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]])
DEBUG 2011-02-04 12:31:05,470 [main] UPDATE EMP_TABLE SET ENAME = 'せとあずさ', JOB = 'MANAGER', MGR = 7902, HIRE_DATE = '2006-11-01', SAL = 10000, COMM = 1000, DEPT_NO = 10, VERSIONNO = 1, TSTAMP = null WHERE EMP_NO = 7369 AND VERSIONNO = null
DEBUG 2011-02-04 12:31:05,470 [main] UPDATE EMP_TABLE SET ENAME = 'せとあずさ', JOB = 'MANAGER', MGR = 7902, HIRE_DATE = '2006-11-01', SAL = 10000, COMM = 1000, DEPT_NO = 10, VERSIONNO = 1, TSTAMP = null WHERE EMP_NO = 7499 AND VERSIONNO = null
DEBUG 2011-02-04 12:31:05,470 [main] END org.seasar.codegen.sample.dao.EmpTableDao#updateBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 12:31:05 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=7499/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 12:31:05 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) : [0, 0]
DEBUG 2011-02-04 12:31:05,600 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:05,600 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:05,603 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:05,603 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:05,604 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:05,604 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:05,607 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,608 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,608 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,609 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,609 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,610 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,610 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,611 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:05,611 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,612 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,612 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,613 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,613 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,614 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,614 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#deleteBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 12:31:05 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=7499/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 12:31:05 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]])
DEBUG 2011-02-04 12:31:05,625 [main] DELETE FROM EMP_TABLE WHERE EMP_NO = 7369 AND VERSIONNO = null
DEBUG 2011-02-04 12:31:05,625 [main] DELETE FROM EMP_TABLE WHERE EMP_NO = 7499 AND VERSIONNO = null
DEBUG 2011-02-04 12:31:05,625 [main] END org.seasar.codegen.sample.dao.EmpTableDao#deleteBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 12:31:05 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=7499/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 12:31:05 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) : [0, 0]
DEBUG 2011-02-04 12:31:05,626 [main] SELECT * FROM EMP_TABLE ORDER BY emp_no
DEBUG 2011-02-04 12:31:05,764 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:05,764 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:05,767 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:05,767 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:05,767 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:05,768 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:05,771 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,771 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,772 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,772 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,773 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,773 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,774 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,774 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:05,775 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,775 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,776 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,776 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,777 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,778 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:05,778 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#findWithRelation(/offset=0/limit=-1)
DEBUG 2011-02-04 12:31:05,788 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP, deptTableEntity.VERSIONNO AS VERSIONNO_0, deptTableEntity.DEPT_ID AS DEPT_ID_0, deptTableEntity.DNAME AS DNAME_0, deptTableEntity.LOC AS LOC_0, deptTableEntity.ACTIVE AS ACTIVE_0 FROM EMP_TABLE LEFT OUTER JOIN DEPT_TABLE deptTableEntity ON EMP_TABLE.DEPT_NO = deptTableEntity.DEPT_ID 
DEBUG 2011-02-04 12:31:05,791 [main] END org.seasar.codegen.sample.dao.EmpTableDao#findWithRelation(/offset=0/limit=-1) : [[/empNo=7369/ename=SMITH/job=CLERK/mgr=7902/hireDate=1980-12-17 00:00:00.0/sal=800/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=20/dname=RESEARCH/loc=DALLAS/versionno=0/active=true], [/empNo=7499/ename=ALLEN/job=SALESMAN/mgr=7698/hireDate=1981-02-20 00:00:00.0/sal=1600/comm=300/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=30/dname=SALES/loc=CHICAGO/versionno=0/active=true], [/empNo=7521/ename=WARD/job=SALESMAN/mgr=7698/hireDate=1981-02-22 00:00:00.0/sal=1250/comm=500/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=30/dname=SALES/loc=CHICAGO/versionno=0/active=true], [/empNo=7566/ename=JONES/job=MANAGER/mgr=7839/hireDate=1981-04-02 00:00:00.0/sal=2975/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=20/dname=RESEARCH/loc=DALLAS/versionno=0/active=true], [/empNo=7654/ename=MARTIN/job=SALESMAN/mgr=7698/hireDate=1981-09-28 00:00:00.0/sal=1250/comm=1400/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=30/dname=SALES/loc=CHICAGO/versionno=0/active=true], [/empNo=7698/ename=BLAKE/job=MANAGER/mgr=7839/hireDate=1981-05-01 00:00:00.0/sal=2850/comm=null/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=30/dname=SALES/loc=CHICAGO/versionno=0/active=true], [/empNo=7782/ename=CLARK/job=MANAGER/mgr=7839/hireDate=1981-06-09 00:00:00.0/sal=2450/comm=null/deptNo=10/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=10/dname=ACCOUNTING/loc=NEW YORK/versionno=0/active=true], [/empNo=7788/ename=SCOTT/job=ANALYST/mgr=7566/hireDate=1982-12-09 00:00:00.0/sal=3000.0/comm=null/deptNo=20/tstamp=2005-01-18 13:09:32.213/versionno=1]deptTableEntity[/deptId=20/dname=RESEARCH/loc=DALLAS/versionno=0/active=true], [/empNo=7839/ename=KING/job=PRESIDENT/mgr=null/hireDate=1981-11-17 00:00:00.0/sal=5000/comm=null/deptNo=10/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=10/dname=ACCOUNTING/loc=NEW YORK/versionno=0/active=true], [/empNo=7844/ename=TURNER/job=SALESMAN/mgr=7698/hireDate=1981-09-08 00:00:00.0/sal=1500/comm=0/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=30/dname=SALES/loc=CHICAGO/versionno=0/active=true]]
DEBUG 2011-02-04 12:31:05,791 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableWithRelation(7369)
DEBUG 2011-02-04 12:31:05,792 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP, deptTableEntity.VERSIONNO AS VERSIONNO_0, deptTableEntity.DEPT_ID AS DEPT_ID_0, deptTableEntity.DNAME AS DNAME_0, deptTableEntity.LOC AS LOC_0, deptTableEntity.ACTIVE AS ACTIVE_0 FROM EMP_TABLE LEFT OUTER JOIN DEPT_TABLE deptTableEntity ON EMP_TABLE.DEPT_NO = deptTableEntity.DEPT_ID WHERE EMP_NO  = 7369 ORDER BY EMP_NO
DEBUG 2011-02-04 12:31:05,794 [main] END org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableWithRelation(7369) : [/empNo=7369/ename=SMITH/job=CLERK/mgr=7902/hireDate=1980-12-17 00:00:00.0/sal=800/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=20/dname=RESEARCH/loc=DALLAS/versionno=0/active=true]
DEBUG 2011-02-04 12:31:05,794 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIdsWithRelation([7566, 7654])
DEBUG 2011-02-04 12:31:05,794 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP, deptTableEntity.VERSIONNO AS VERSIONNO_0, deptTableEntity.DEPT_ID AS DEPT_ID_0, deptTableEntity.DNAME AS DNAME_0, deptTableEntity.LOC AS LOC_0, deptTableEntity.ACTIVE AS ACTIVE_0 FROM EMP_TABLE LEFT OUTER JOIN DEPT_TABLE deptTableEntity ON EMP_TABLE.DEPT_NO = deptTableEntity.DEPT_ID WHERE EMP_NO in (7566, 7654) ORDER BY EMP_NO
DEBUG 2011-02-04 12:31:05,795 [main] END org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIdsWithRelation([7566, 7654]) : [[/empNo=7566/ename=JONES/job=MANAGER/mgr=7839/hireDate=1981-04-02 00:00:00.0/sal=2975/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=20/dname=RESEARCH/loc=DALLAS/versionno=0/active=true], [/empNo=7654/ename=MARTIN/job=SALESMAN/mgr=7698/hireDate=1981-09-28 00:00:00.0/sal=1250/comm=1400/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=30/dname=SALES/loc=CHICAGO/versionno=0/active=true]]
DEBUG 2011-02-04 12:31:05,795 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIdsWithRelation([7566, 7654])
DEBUG 2011-02-04 12:31:05,796 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP, deptTableEntity.VERSIONNO AS VERSIONNO_0, deptTableEntity.DEPT_ID AS DEPT_ID_0, deptTableEntity.DNAME AS DNAME_0, deptTableEntity.LOC AS LOC_0, deptTableEntity.ACTIVE AS ACTIVE_0 FROM EMP_TABLE LEFT OUTER JOIN DEPT_TABLE deptTableEntity ON EMP_TABLE.DEPT_NO = deptTableEntity.DEPT_ID WHERE EMP_NO in (7566, 7654) ORDER BY EMP_NO
DEBUG 2011-02-04 12:31:05,797 [main] END org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIdsWithRelation([7566, 7654]) : [[/empNo=7566/ename=JONES/job=MANAGER/mgr=7839/hireDate=1981-04-02 00:00:00.0/sal=2975/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=20/dname=RESEARCH/loc=DALLAS/versionno=0/active=true], [/empNo=7654/ename=MARTIN/job=SALESMAN/mgr=7698/hireDate=1981-09-28 00:00:00.0/sal=1250/comm=1400/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=30/dname=SALES/loc=CHICAGO/versionno=0/active=true]]
DEBUG 2011-02-04 12:31:05,797 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#soleMatchWithRelation(/EMP_TABLE.EMP_NO=7654/offset=0/limit=-1)
DEBUG 2011-02-04 12:31:05,797 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP, deptTableEntity.VERSIONNO AS VERSIONNO_0, deptTableEntity.DEPT_ID AS DEPT_ID_0, deptTableEntity.DNAME AS DNAME_0, deptTableEntity.LOC AS LOC_0, deptTableEntity.ACTIVE AS ACTIVE_0 FROM EMP_TABLE LEFT OUTER JOIN DEPT_TABLE deptTableEntity ON EMP_TABLE.DEPT_NO = deptTableEntity.DEPT_ID WHERE EMP_TABLE.EMP_NO =7654
DEBUG 2011-02-04 12:31:05,798 [main] END org.seasar.codegen.sample.dao.EmpTableDao#soleMatchWithRelation(/EMP_TABLE.EMP_NO=7654/offset=0/limit=-1) : [/empNo=7654/ename=MARTIN/job=SALESMAN/mgr=7698/hireDate=1981-09-28 00:00:00.0/sal=1250/comm=1400/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=30/dname=SALES/loc=CHICAGO/versionno=0/active=true]
DEBUG 2011-02-04 12:31:05,798 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getAllEmpTableWithRelation()
DEBUG 2011-02-04 12:31:05,798 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP, deptTableEntity.VERSIONNO AS VERSIONNO_0, deptTableEntity.DEPT_ID AS DEPT_ID_0, deptTableEntity.DNAME AS DNAME_0, deptTableEntity.LOC AS LOC_0, deptTableEntity.ACTIVE AS ACTIVE_0 FROM EMP_TABLE LEFT OUTER JOIN DEPT_TABLE deptTableEntity ON EMP_TABLE.DEPT_NO = deptTableEntity.DEPT_ID ORDER BY EMP_NO
DEBUG 2011-02-04 12:31:05,801 [main] END org.seasar.codegen.sample.dao.EmpTableDao#getAllEmpTableWithRelation() : [[/empNo=7369/ename=SMITH/job=CLERK/mgr=7902/hireDate=1980-12-17 00:00:00.0/sal=800/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=20/dname=RESEARCH/loc=DALLAS/versionno=0/active=true], [/empNo=7499/ename=ALLEN/job=SALESMAN/mgr=7698/hireDate=1981-02-20 00:00:00.0/sal=1600/comm=300/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=30/dname=SALES/loc=CHICAGO/versionno=0/active=true], [/empNo=7521/ename=WARD/job=SALESMAN/mgr=7698/hireDate=1981-02-22 00:00:00.0/sal=1250/comm=500/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=30/dname=SALES/loc=CHICAGO/versionno=0/active=true], [/empNo=7566/ename=JONES/job=MANAGER/mgr=7839/hireDate=1981-04-02 00:00:00.0/sal=2975/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=20/dname=RESEARCH/loc=DALLAS/versionno=0/active=true], [/empNo=7654/ename=MARTIN/job=SALESMAN/mgr=7698/hireDate=1981-09-28 00:00:00.0/sal=1250/comm=1400/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=30/dname=SALES/loc=CHICAGO/versionno=0/active=true], [/empNo=7698/ename=BLAKE/job=MANAGER/mgr=7839/hireDate=1981-05-01 00:00:00.0/sal=2850/comm=null/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=30/dname=SALES/loc=CHICAGO/versionno=0/active=true], [/empNo=7782/ename=CLARK/job=MANAGER/mgr=7839/hireDate=1981-06-09 00:00:00.0/sal=2450/comm=null/deptNo=10/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=10/dname=ACCOUNTING/loc=NEW YORK/versionno=0/active=true], [/empNo=7788/ename=SCOTT/job=ANALYST/mgr=7566/hireDate=1982-12-09 00:00:00.0/sal=3000.0/comm=null/deptNo=20/tstamp=2005-01-18 13:09:32.213/versionno=1]deptTableEntity[/deptId=20/dname=RESEARCH/loc=DALLAS/versionno=0/active=true], [/empNo=7839/ename=KING/job=PRESIDENT/mgr=null/hireDate=1981-11-17 00:00:00.0/sal=5000/comm=null/deptNo=10/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=10/dname=ACCOUNTING/loc=NEW YORK/versionno=0/active=true], [/empNo=7844/ename=TURNER/job=SALESMAN/mgr=7698/hireDate=1981-09-08 00:00:00.0/sal=1500/comm=0/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=30/dname=SALES/loc=CHICAGO/versionno=0/active=true]]
DEBUG 2011-02-04 12:31:05,912 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#selectByUtf8SqlFile()
DEBUG 2011-02-04 12:31:05,957 [main] SELECT * FROM EMP_TABLE WHERE ENAME &lt;&gt; '文字列'
DEBUG 2011-02-04 12:31:05,957 [main] END org.seasar.codegen.sample.dao.EmpTableDao#selectByUtf8SqlFile() : []
DEBUG 2011-02-04 12:31:06,101 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-04 12:31:06,101 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-04 12:31:06,104 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-04 12:31:06,104 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-04 12:31:06,105 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-04 12:31:06,105 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-04 12:31:06,108 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:06,109 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:06,110 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:06,110 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:06,111 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:06,111 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:06,112 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:06,112 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1)
DEBUG 2011-02-04 12:31:06,113 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:06,114 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:06,114 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:06,115 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:06,115 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:06,116 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1)
DEBUG 2011-02-04 12:31:06,117 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#select(org.seasar.codegen.sample.dao.EmpTableDaoTest$1@7c7ba849)
DEBUG 2011-02-04 12:31:06,129 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE
DEBUG 2011-02-04 12:31:06,131 [main] END org.seasar.codegen.sample.dao.EmpTableDao#select(org.seasar.codegen.sample.dao.EmpTableDaoTest$1@7c7ba849) : 1
Tests run: 23, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.484 sec
Running org.seasar.codegen.lib.impl.DateConditionElementImplTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec
Running org.seasar.codegen.unit.AbstractCodeGenExtensionTestCase
DEBUG 2011-02-04 12:31:06,198 [main] SELECT * FROM DEPT_TABLE ORDER BY dept_id
DEBUG 2011-02-04 12:31:06,258 [main] SELECT * FROM DEPT_TABLE ORDER BY dept_id
DEBUG 2011-02-04 12:31:06,263 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 10
DEBUG 2011-02-04 12:31:06,263 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 20
DEBUG 2011-02-04 12:31:06,264 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 30
DEBUG 2011-02-04 12:31:06,264 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 60
DEBUG 2011-02-04 12:31:06,318 [main] SELECT * FROM DEPT_TABLE ORDER BY dept_id
DEBUG 2011-02-04 12:31:06,323 [main] SELECT dept_id, dname, loc, versionno, active FROM DEPT_TABLE WHERE dept_id = 10
DEBUG 2011-02-04 12:31:06,324 [main] SELECT dept_id, dname, loc, versionno, active FROM DEPT_TABLE WHERE dept_id = 20
DEBUG 2011-02-04 12:31:06,324 [main] SELECT dept_id, dname, loc, versionno, active FROM DEPT_TABLE WHERE dept_id = 30
DEBUG 2011-02-04 12:31:06,324 [main] SELECT dept_id, dname, loc, versionno, active FROM DEPT_TABLE WHERE dept_id = 50
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.186 sec
Running org.seasar.codegen.unit.AbstractXlsWriterExtTestCase
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.026 sec
Running org.seasar.codegen.lib.impl.StringConditionElementImplTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running org.seasar.codegen.sample.dao.NoPkDaoTest
DEBUG 2011-02-04 12:31:06,951 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト])
DEBUG 2011-02-04 12:31:06,982 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (1, 'テスト')
DEBUG 2011-02-04 12:31:06,983 [main] END org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト]) : 1
DEBUG 2011-02-04 12:31:07,076 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト])
DEBUG 2011-02-04 12:31:07,106 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (1, 'テスト')
DEBUG 2011-02-04 12:31:07,107 [main] END org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト]) : 1
DEBUG 2011-02-04 12:31:07,107 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=2/col2=テスト2])
DEBUG 2011-02-04 12:31:07,107 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (2, 'テスト2')
DEBUG 2011-02-04 12:31:07,107 [main] END org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=2/col2=テスト2]) : 1
DEBUG 2011-02-04 12:31:07,107 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insertBatch([[/col1=1/col2=テスト], [/col1=2/col2=テスト2]])
DEBUG 2011-02-04 12:31:07,107 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (1, 'テスト')
DEBUG 2011-02-04 12:31:07,107 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (2, 'テスト2')
DEBUG 2011-02-04 12:31:07,108 [main] END org.seasar.codegen.sample.dao.NoPkDao#insertBatch([[/col1=1/col2=テスト], [/col1=2/col2=テスト2]]) : [1, 1]
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.755 sec
Running org.seasar.codegen.lib.internal.impl.FromToOptionTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec
Running org.seasar.codegen.lib.impl.ConditionResultImplTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec

Results :

Tests run: 81, Failures: 0, Errors: 0, Skipped: 0

[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESSFUL
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 17 seconds
[INFO] Finished at: Fri Feb 04 12:31:07 JST 2011
[INFO] Final Memory: 29M/212M
[INFO] ------------------------------------------------------------------------
Finished: SUCCESS