定期的に実行
Updating https://www.seasar.org/svn/sandbox/s2dao-codegen/trunk/codegen-lib
'https://www.seasar.org/svn/sandbox/s2dao-codegen/trunk/codegen-core'のリビジョン-1を'/home/services/hudson/jobs/codegen-lib-generate/workspace/codegen-lib/codegen-core'へ取得中
At revision 811
At revision 811
no change for https://www.seasar.org/svn/sandbox/s2dao-codegen/trunk/codegen-lib since the previous build
no change for https://www.seasar.org/svn/sandbox/s2dao-codegen/trunk/codegen-core 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: Wed Feb 02 21:30:46 JST 2011
[INFO] Final Memory: 23M/155M
[INFO] ------------------------------------------------------------------------
[codegen-lib] $ /usr/local/java/ant/bin/ant
Buildfile: build.xml

gen:
     [java] 21:30:48.146 JST [main] INFO  o.s.f.c.f.SingletonS2ContainerFactory - s2-frameworkのバージョンは2.4.40です。
     [java] 21:30:48.151 JST [main] INFO  o.s.f.c.f.SingletonS2ContainerFactory - s2-extensionのバージョンは2.4.40です。
     [java] 21:30:48.152 JST [main] INFO  o.s.f.c.f.SingletonS2ContainerFactory - s2-tigerのバージョンは2.4.40です。
     [java] 21:30:48.704 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] 21:30:49.372 JST [main] WARN  o.s.codegen.impl.DDLOutputCodeImpl - テンプレートが存在しないのでDDLを生成しません(createTable_h2.ftl)。
     [java] 21:30:49.379 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: 2.316 sec
Running org.seasar.codegen.lib.internal.impl.FindSqlCommandTest
DEBUG 2011-02-02 21:30:57,776 [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-02 21:30:57,890 [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 <>? AND ENAME = ?
Tests run: 12, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.635 sec
Running org.seasar.codegen.sample.dao.ShiftJISDaoTest
DEBUG 2011-02-02 21:30:58,442 [main] BEGIN org.seasar.codegen.sample.dao.ShiftJISDao#selectByShiftJISFile()
DEBUG 2011-02-02 21:30:58,474 [main] SELECT * FROM EMP_TABLE WHERE ENAME <> '文字列'
DEBUG 2011-02-02 21:30:58,475 [main] END org.seasar.codegen.sample.dao.ShiftJISDao#selectByShiftJISFile() : []
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.163 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.015 sec
Running org.seasar.codegen.sample.dao.EmpTableDaoTest
DEBUG 2011-02-02 21:30:58,830 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:30:58,831 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:30:58,842 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:30:58,844 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:30:58,844 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:30:58,845 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:30:58,852 [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-02 21:30:58,855 [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-02 21:30:58,856 [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-02 21:30:58,856 [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-02 21:30:58,857 [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-02 21:30:58,858 [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-02 21:30:58,859 [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-02 21:30:58,860 [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-02 21:30:58,860 [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-02 21:30:58,861 [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-02 21:30:58,862 [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-02 21:30:58,863 [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-02 21:30:58,863 [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-02 21:30:58,864 [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-02 21:30:58,865 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getAllEmpTable()
DEBUG 2011-02-02 21:30:58,876 [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-02 21:30:58,880 [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-02 21:30:59,070 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:30:59,070 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:30:59,075 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:30:59,075 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:30:59,076 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:30:59,076 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:30:59,083 [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-02 21:30:59,084 [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-02 21:30:59,084 [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-02 21:30:59,085 [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-02 21:30:59,086 [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-02 21:30:59,087 [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-02 21:30:59,088 [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-02 21:30:59,088 [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-02 21:30:59,089 [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-02 21:30:59,090 [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-02 21:30:59,091 [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-02 21:30:59,091 [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-02 21:30:59,092 [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-02 21:30:59,093 [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-02 21:30:59,093 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7521)
DEBUG 2011-02-02 21:30:59,105 [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-02 21:30:59,106 [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-02 21:30:59,309 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:30:59,309 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:30:59,314 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:30:59,314 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:30:59,315 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:30:59,315 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:30:59,322 [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-02 21:30:59,323 [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-02 21:30:59,323 [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-02 21:30:59,324 [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-02 21:30:59,325 [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-02 21:30:59,326 [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-02 21:30:59,326 [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-02 21:30:59,327 [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-02 21:30:59,328 [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-02 21:30:59,328 [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-02 21:30:59,329 [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-02 21:30:59,330 [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-02 21:30:59,331 [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-02 21:30:59,331 [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-02 21:30:59,332 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIds([7566, 7654])
DEBUG 2011-02-02 21:30:59,344 [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-02 21:30:59,348 [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-02 21:30:59,533 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:30:59,533 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:30:59,538 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:30:59,538 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:30:59,539 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:30:59,539 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:30:59,546 [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-02 21:30:59,547 [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-02 21:30:59,547 [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-02 21:30:59,548 [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-02 21:30:59,549 [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-02 21:30:59,550 [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-02 21:30:59,550 [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-02 21:30:59,551 [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-02 21:30:59,552 [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-02 21:30:59,552 [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-02 21:30:59,553 [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-02 21:30:59,554 [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-02 21:30:59,555 [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-02 21:30:59,555 [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-02 21:30:59,556 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableWithRelation(7369)
DEBUG 2011-02-02 21:30:59,568 [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-02 21:30:59,571 [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-02 21:30:59,729 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:30:59,729 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:30:59,735 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:30:59,735 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:30:59,735 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:30:59,736 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:30:59,743 [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-02 21:30:59,744 [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-02 21:30:59,744 [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-02 21:30:59,745 [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-02 21:30:59,746 [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-02 21:30:59,747 [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-02 21:30:59,747 [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-02 21:30:59,748 [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-02 21:30:59,749 [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-02 21:30:59,749 [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-02 21:30:59,750 [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-02 21:30:59,751 [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-02 21:30:59,752 [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-02 21:30:59,752 [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-02 21:30:59,753 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#insert([/empNo=null/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 21:30:59 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null])
DEBUG 2011-02-02 21:30:59,766 [main] CALL NEXTVAL('EMPNO')
DEBUG 2011-02-02 21:30:59,767 [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-02 21:30:59,768 [main] END org.seasar.codegen.sample.dao.EmpTableDao#insert([/empNo=null/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 21:30:59 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]) : 1
DEBUG 2011-02-02 21:30:59,773 [main] SELECT * FROM EMP_TABLE ORDER BY emp_no
DEBUG 2011-02-02 21:30:59,965 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:30:59,965 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:30:59,970 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:30:59,971 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:30:59,971 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:30:59,971 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:30:59,978 [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-02 21:30:59,979 [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-02 21:30:59,980 [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-02 21:30:59,981 [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-02 21:30:59,982 [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-02 21:30:59,983 [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-02 21:30:59,984 [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-02 21:30:59,984 [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-02 21:30:59,985 [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-02 21:30:59,986 [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-02 21:30:59,987 [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-02 21:30:59,987 [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-02 21:30:59,988 [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-02 21:30:59,989 [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-02 21:30:59,989 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7369)
DEBUG 2011-02-02 21:31:00,001 [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-02 21:31:00,002 [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-02 21:31:00,002 [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-02 21:31:00,003 [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-02 21:31:00,004 [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-02 21:31:00,013 [main] SELECT * FROM emp_table ORDER BY emp_no
DEBUG 2011-02-02 21:31:00,030 [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-02 21:31:00,031 [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-02 21:31:00,031 [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-02 21:31:00,032 [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-02 21:31:00,032 [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-02 21:31:00,033 [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-02 21:31:00,033 [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-02 21:31:00,033 [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-02 21:31:00,034 [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-02 21:31:00,034 [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-02 21:31:00,035 [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-02 21:31:00,035 [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-02 21:31:00,035 [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-02 21:31:00,036 [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-02 21:31:00,209 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:31:00,209 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:31:00,216 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:31:00,216 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:31:00,217 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:31:00,217 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:31:00,224 [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-02 21:31:00,225 [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-02 21:31:00,226 [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-02 21:31:00,227 [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-02 21:31:00,228 [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-02 21:31:00,229 [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-02 21:31:00,230 [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-02 21:31:00,231 [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-02 21:31:00,231 [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-02 21:31:00,232 [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-02 21:31:00,233 [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-02 21:31:00,234 [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-02 21:31:00,235 [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-02 21:31:00,236 [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-02 21:31:00,236 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7369)
DEBUG 2011-02-02 21:31:00,255 [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-02 21:31:00,257 [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-02 21:31:00,257 [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-02 21:31:00,257 [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-02 21:31:00,258 [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-02 21:31:00,258 [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-02 21:31:00,258 [main] UPDATE EMP_TABLE SET ENAME = null, VERSIONNO = 12 WHERE EMP_NO = 7369 AND VERSIONNO = 11
DEBUG 2011-02-02 21:31:00,259 [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-02 21:31:00,462 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:31:00,462 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:31:00,470 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:31:00,471 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:31:00,471 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:31:00,471 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:31:00,478 [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-02 21:31:00,479 [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-02 21:31:00,480 [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-02 21:31:00,481 [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-02 21:31:00,481 [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-02 21:31:00,482 [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-02 21:31:00,483 [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-02 21:31:00,484 [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-02 21:31:00,484 [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-02 21:31:00,485 [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-02 21:31:00,486 [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-02 21:31:00,487 [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-02 21:31:00,487 [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-02 21:31:00,488 [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-02 21:31:00,489 [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-02 21:31:00,506 [main] DELETE FROM EMP_TABLE WHERE EMP_NO = 7369 AND VERSIONNO = 1
DEBUG 2011-02-02 21:31:00,507 [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-02 21:31:00,516 [main] SELECT * FROM emp_table ORDER BY emp_no
DEBUG 2011-02-02 21:31:00,531 [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-02 21:31:00,531 [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-02 21:31:00,532 [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-02 21:31:00,532 [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-02 21:31:00,532 [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-02 21:31:00,533 [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-02 21:31:00,533 [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-02 21:31:00,534 [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-02 21:31:00,534 [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-02 21:31:00,535 [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-02 21:31:00,535 [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-02 21:31:00,535 [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-02 21:31:00,536 [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-02 21:31:00,727 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:31:00,727 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:31:00,731 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:31:00,732 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:31:00,732 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:31:00,732 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:31:00,740 [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-02 21:31:00,741 [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-02 21:31:00,742 [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-02 21:31:00,742 [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-02 21:31:00,743 [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-02 21:31:00,744 [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-02 21:31:00,744 [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-02 21:31:00,745 [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-02 21:31:00,746 [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-02 21:31:00,746 [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-02 21:31:00,747 [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-02 21:31:00,748 [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-02 21:31:00,748 [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-02 21:31:00,749 [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-02 21:31:00,751 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.EMP_NO>7500/EMP_TABLE.HIRE_DATE>=Mon Jan 01 00:00:00 JST 1900/offset=0/limit=-1)
DEBUG 2011-02-02 21:31:00,765 [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 >7500 AND EMP_TABLE.HIRE_DATE >='1900-01-01'
DEBUG 2011-02-02 21:31:00,769 [main] END org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.EMP_NO>7500/EMP_TABLE.HIRE_DATE>=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-02 21:31:00,972 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:31:00,972 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:31:00,977 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:31:00,978 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:31:00,978 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:31:00,978 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:31:00,984 [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-02 21:31:00,984 [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-02 21:31:00,985 [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-02 21:31:00,986 [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-02 21:31:00,986 [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-02 21:31:00,987 [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-02 21:31:00,988 [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-02 21:31:00,988 [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-02 21:31:00,989 [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-02 21:31:00,989 [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-02 21:31:00,990 [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-02 21:31:00,991 [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-02 21:31:00,991 [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-02 21:31:00,992 [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-02 21:31:00,993 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.EMP_NO<>7500/offset=0/limit=-1)
DEBUG 2011-02-02 21:31:01,004 [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 <>7500 AND DEPT_NO <> 10
DEBUG 2011-02-02 21:31:01,007 [main] END org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.EMP_NO<>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-02 21:31:01,160 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:31:01,160 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:31:01,164 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:31:01,164 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:31:01,164 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:31:01,165 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:31:01,170 [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-02 21:31:01,170 [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-02 21:31:01,171 [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-02 21:31:01,172 [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-02 21:31:01,172 [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-02 21:31:01,173 [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-02 21:31:01,174 [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-02 21:31:01,174 [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-02 21:31:01,175 [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-02 21:31:01,176 [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-02 21:31:01,176 [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-02 21:31:01,177 [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-02 21:31:01,177 [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-02 21:31:01,178 [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-02 21:31:01,179 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#find(/offset=0/limit=-1)
DEBUG 2011-02-02 21:31:01,190 [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 <> 10
DEBUG 2011-02-02 21:31:01,192 [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-02 21:31:01,348 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:31:01,348 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:31:01,351 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:31:01,352 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:31:01,352 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:31:01,352 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:31:01,357 [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-02 21:31:01,358 [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-02 21:31:01,358 [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-02 21:31:01,359 [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-02 21:31:01,360 [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-02 21:31:01,360 [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-02 21:31:01,361 [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-02 21:31:01,361 [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-02 21:31:01,362 [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-02 21:31:01,362 [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-02 21:31:01,363 [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-02 21:31:01,364 [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-02 21:31:01,364 [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-02 21:31:01,365 [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-02 21:31:01,366 [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<1000/EMP_TABLE.SAL<=100/EMP_TABLE.MGR>0/EMP_TABLE.SAL>=0/EMP_TABLE.TSTAMP<>2011-02-02 21:31:01.366/EMP_TABLE.VERSIONNOnot in1/EMP_TABLE.EMP_NOnot in99/offset=0/limit=-1)
DEBUG 2011-02-02 21:31:01,378 [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 <1000 AND EMP_TABLE.SAL <=100 AND EMP_TABLE.MGR >0 AND EMP_TABLE.SAL >=0 AND EMP_TABLE.TSTAMP <>'2011-02-02 21.31.01' AND EMP_TABLE.VERSIONNO not in(1) AND EMP_TABLE.EMP_NO not in(99)
DEBUG 2011-02-02 21:31:01,380 [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<1000/EMP_TABLE.SAL<=100/EMP_TABLE.MGR>0/EMP_TABLE.SAL>=0/EMP_TABLE.TSTAMP<>2011-02-02 21:31:01.366/EMP_TABLE.VERSIONNOnot in1/EMP_TABLE.EMP_NOnot in99/offset=0/limit=-1) : []
DEBUG 2011-02-02 21:31:01,532 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:31:01,533 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:31:01,536 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:31:01,536 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:31:01,537 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:31:01,537 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:31:01,541 [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-02 21:31:01,541 [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-02 21:31:01,542 [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-02 21:31:01,543 [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-02 21:31:01,543 [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-02 21:31:01,544 [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-02 21:31:01,544 [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-02 21:31:01,545 [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-02 21:31:01,546 [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-02 21:31:01,546 [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-02 21:31:01,547 [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-02 21:31:01,547 [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-02 21:31:01,548 [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-02 21:31:01,549 [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-02 21:31:01,549 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#soleMatch(/EMP_TABLE.EMP_NO>=7934/EMP_TABLE.HIRE_DATE>Mon Jan 01 00:00:00 JST 1900/offset=0/limit=-1)
DEBUG 2011-02-02 21:31:01,561 [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 >=7934 AND EMP_TABLE.HIRE_DATE >'1900-01-01'
/EMP_TABLE.EMP_NO>=7934/EMP_TABLE.HIRE_DATE>Mon Jan 01 00:00:00 JST 1900/offset=0/limit=-1
DEBUG 2011-02-02 21:31:01,562 [main] END org.seasar.codegen.sample.dao.EmpTableDao#soleMatch(/EMP_TABLE.EMP_NO>=7934/EMP_TABLE.HIRE_DATE>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-02 21:31:01,679 [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-02 21:31:01,739 [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-02 21:31:01,740 [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-02 21:31:01,849 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#findWithRelation(/deptTableEntity.LOC=DALLAS/offset=0/limit=-1)
DEBUG 2011-02-02 21:31:01,892 [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-02 21:31:01,893 [main] END org.seasar.codegen.sample.dao.EmpTableDao#findWithRelation(/deptTableEntity.LOC=DALLAS/offset=0/limit=-1) : []
DEBUG 2011-02-02 21:31:02,048 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:31:02,048 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:31:02,052 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:31:02,052 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:31:02,053 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:31:02,053 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:31:02,057 [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)
/EMP_TABLE.HIRE_DATE>Mon Jan 01 00:00:00 JST 1900/ORDER BY EMP_TABLE.EMP_NO /offset=5/limit=5
DEBUG 2011-02-02 21:31:02,058 [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-02 21:31:02,059 [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-02 21:31:02,059 [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-02 21:31:02,060 [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-02 21:31:02,060 [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-02 21:31:02,061 [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-02 21:31:02,062 [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-02 21:31:02,062 [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-02 21:31:02,063 [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-02 21:31:02,064 [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-02 21:31:02,064 [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-02 21:31:02,065 [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-02 21:31:02,065 [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-02 21:31:02,066 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.HIRE_DATE>Mon Jan 01 00:00:00 JST 1900/ORDER BY EMP_TABLE.EMP_NO /offset=5/limit=5)
DEBUG 2011-02-02 21:31:02,079 [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 >'1900-01-01' ) AS total
DEBUG 2011-02-02 21:31:02,085 [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 >'1900-01-01' ORDER BY EMP_TABLE.EMP_NO LIMIT 5 OFFSET 5
DEBUG 2011-02-02 21:31:02,086 [main] END org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.HIRE_DATE>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-02 21:31:02,248 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:31:02,248 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:31:02,251 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:31:02,252 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:31:02,252 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:31:02,252 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:31:02,256 [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-02 21:31:02,257 [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-02 21:31:02,258 [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-02 21:31:02,258 [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-02 21:31:02,259 [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-02 21:31:02,260 [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-02 21:31:02,260 [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-02 21:31:02,261 [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-02 21:31:02,261 [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-02 21:31:02,262 [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-02 21:31:02,262 [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-02 21:31:02,263 [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-02 21:31:02,264 [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-02 21:31:02,264 [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-02 21:31:02,265 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7654)
DEBUG 2011-02-02 21:31:02,276 [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-02 21:31:02,276 [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-02 21:31:02,276 [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-02 21:31:02,277 [main] UPDATE EMP_TABLE SET ENAME = 'せとあずさ', VERSIONNO = 2 WHERE EMP_NO = 7654 AND VERSIONNO = 1
DEBUG 2011-02-02 21:31:02,277 [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-02 21:31:02,440 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:31:02,440 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:31:02,444 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:31:02,444 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:31:02,444 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:31:02,445 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:31:02,448 [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-02 21:31:02,449 [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-02 21:31:02,449 [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-02 21:31:02,450 [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-02 21:31:02,451 [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-02 21:31:02,451 [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-02 21:31:02,452 [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-02 21:31:02,452 [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-02 21:31:02,453 [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-02 21:31:02,453 [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-02 21:31:02,454 [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-02 21:31:02,455 [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-02 21:31:02,455 [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-02 21:31:02,456 [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-02 21:31:02,457 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#insertBatch([[/empNo=9990/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 21:31:02 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=9991/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 21:31:02 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]])
DEBUG 2011-02-02 21:31:02,468 [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-02 21:31:02,468 [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-02 21:31:02,470 [main] END org.seasar.codegen.sample.dao.EmpTableDao#insertBatch([[/empNo=9990/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 21:31:02 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=9991/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 21:31:02 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) : [1, 1]
DEBUG 2011-02-02 21:31:02,471 [main] SELECT * FROM EMP_TABLE ORDER BY emp_no
DEBUG 2011-02-02 21:31:02,620 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:31:02,620 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:31:02,623 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:31:02,624 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:31:02,624 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:31:02,625 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:31:02,628 [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-02 21:31:02,629 [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-02 21:31:02,630 [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-02 21:31:02,631 [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-02 21:31:02,631 [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-02 21:31:02,632 [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-02 21:31:02,632 [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-02 21:31:02,633 [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-02 21:31:02,634 [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-02 21:31:02,634 [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-02 21:31:02,635 [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-02 21:31:02,635 [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-02 21:31:02,636 [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-02 21:31:02,637 [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-02 21:31:02,637 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#updateBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 21:31:02 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=7499/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 21:31:02 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]])
DEBUG 2011-02-02 21:31:02,650 [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-02 21:31:02,650 [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-02 21:31:02,651 [main] END org.seasar.codegen.sample.dao.EmpTableDao#updateBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 21:31:02 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=7499/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 21:31:02 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) : [0, 0]
DEBUG 2011-02-02 21:31:02,788 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:31:02,788 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:31:02,791 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:31:02,791 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:31:02,792 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:31:02,792 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:31:02,795 [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-02 21:31:02,796 [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-02 21:31:02,797 [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-02 21:31:02,798 [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-02 21:31:02,798 [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-02 21:31:02,799 [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-02 21:31:02,799 [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-02 21:31:02,800 [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-02 21:31:02,800 [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-02 21:31:02,801 [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-02 21:31:02,802 [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-02 21:31:02,802 [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-02 21:31:02,803 [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-02 21:31:02,803 [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-02 21:31:02,804 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#deleteBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 21:31:02 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=7499/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 21:31:02 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]])
DEBUG 2011-02-02 21:31:02,815 [main] DELETE FROM EMP_TABLE WHERE EMP_NO = 7369 AND VERSIONNO = null
DEBUG 2011-02-02 21:31:02,815 [main] DELETE FROM EMP_TABLE WHERE EMP_NO = 7499 AND VERSIONNO = null
DEBUG 2011-02-02 21:31:02,815 [main] END org.seasar.codegen.sample.dao.EmpTableDao#deleteBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 21:31:02 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=7499/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 21:31:02 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) : [0, 0]
DEBUG 2011-02-02 21:31:02,816 [main] SELECT * FROM EMP_TABLE ORDER BY emp_no
DEBUG 2011-02-02 21:31:02,964 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:31:02,964 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:31:02,967 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:31:02,968 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:31:02,968 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:31:02,968 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:31:02,972 [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-02 21:31:02,972 [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-02 21:31:02,973 [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-02 21:31:02,974 [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-02 21:31:02,974 [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-02 21:31:02,975 [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-02 21:31:02,975 [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-02 21:31:02,976 [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-02 21:31:02,976 [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-02 21:31:02,977 [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-02 21:31:02,977 [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-02 21:31:02,978 [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-02 21:31:02,979 [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-02 21:31:02,979 [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-02 21:31:02,980 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#findWithRelation(/offset=0/limit=-1)
DEBUG 2011-02-02 21:31:02,990 [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-02 21:31:02,993 [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-02 21:31:02,994 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableWithRelation(7369)
DEBUG 2011-02-02 21:31:02,994 [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-02 21:31:02,996 [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-02 21:31:02,996 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIdsWithRelation([7566, 7654])
DEBUG 2011-02-02 21:31:02,996 [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-02 21:31:02,998 [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-02 21:31:02,998 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIdsWithRelation([7566, 7654])
DEBUG 2011-02-02 21:31:02,998 [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-02 21:31:03,000 [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-02 21:31:03,000 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#soleMatchWithRelation(/EMP_TABLE.EMP_NO=7654/offset=0/limit=-1)
DEBUG 2011-02-02 21:31:03,000 [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-02 21:31:03,001 [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-02 21:31:03,001 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getAllEmpTableWithRelation()
DEBUG 2011-02-02 21:31:03,001 [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-02 21:31:03,004 [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-02 21:31:03,125 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#selectByUtf8SqlFile()
DEBUG 2011-02-02 21:31:03,170 [main] SELECT * FROM EMP_TABLE WHERE ENAME <> '文字列'
DEBUG 2011-02-02 21:31:03,171 [main] END org.seasar.codegen.sample.dao.EmpTableDao#selectByUtf8SqlFile() : []
DEBUG 2011-02-02 21:31:03,300 [main] DELETE FROM EMP_TABLE
DEBUG 2011-02-02 21:31:03,300 [main] DELETE FROM DEPT_TABLE
DEBUG 2011-02-02 21:31:03,303 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1')
DEBUG 2011-02-02 21:31:03,304 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1')
DEBUG 2011-02-02 21:31:03,304 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1')
DEBUG 2011-02-02 21:31:03,305 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1')
DEBUG 2011-02-02 21:31:03,308 [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-02 21:31:03,309 [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-02 21:31:03,310 [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-02 21:31:03,311 [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-02 21:31:03,311 [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-02 21:31:03,312 [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-02 21:31:03,313 [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-02 21:31:03,313 [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-02 21:31:03,314 [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-02 21:31:03,315 [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-02 21:31:03,315 [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-02 21:31:03,316 [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-02 21:31:03,317 [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-02 21:31:03,317 [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-02 21:31:03,318 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#select(org.seasar.codegen.sample.dao.EmpTableDaoTest$1@7981c4eb)
DEBUG 2011-02-02 21:31:03,329 [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-02 21:31:03,331 [main] END org.seasar.codegen.sample.dao.EmpTableDao#select(org.seasar.codegen.sample.dao.EmpTableDaoTest$1@7981c4eb) : 1
Tests run: 23, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 4.844 sec
Running org.seasar.codegen.lib.impl.DateConditionElementImplTest
Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec
Running org.seasar.codegen.unit.AbstractCodeGenExtensionTestCase
DEBUG 2011-02-02 21:31:03,397 [main] SELECT * FROM DEPT_TABLE ORDER BY dept_id
DEBUG 2011-02-02 21:31:03,453 [main] SELECT * FROM DEPT_TABLE ORDER BY dept_id
DEBUG 2011-02-02 21:31:03,457 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 10
DEBUG 2011-02-02 21:31:03,458 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 20
DEBUG 2011-02-02 21:31:03,458 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 30
DEBUG 2011-02-02 21:31:03,458 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 60
DEBUG 2011-02-02 21:31:03,508 [main] SELECT * FROM DEPT_TABLE ORDER BY dept_id
DEBUG 2011-02-02 21:31:03,513 [main] SELECT dept_id, dname, loc, versionno, active FROM DEPT_TABLE WHERE dept_id = 10
DEBUG 2011-02-02 21:31:03,514 [main] SELECT dept_id, dname, loc, versionno, active FROM DEPT_TABLE WHERE dept_id = 20
DEBUG 2011-02-02 21:31:03,514 [main] SELECT dept_id, dname, loc, versionno, active FROM DEPT_TABLE WHERE dept_id = 30
DEBUG 2011-02-02 21:31:03,514 [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.176 sec
Running org.seasar.codegen.unit.AbstractXlsWriterExtTestCase
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.045 sec
Running org.seasar.codegen.lib.impl.StringConditionElementImplTest
Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec
Running org.seasar.codegen.sample.dao.NoPkDaoTest
DEBUG 2011-02-02 21:31:03,663 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト])
DEBUG 2011-02-02 21:31:03,703 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (1, 'テスト')
DEBUG 2011-02-02 21:31:03,703 [main] END org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト]) : 1
DEBUG 2011-02-02 21:31:03,806 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト])
DEBUG 2011-02-02 21:31:03,843 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (1, 'テスト')
DEBUG 2011-02-02 21:31:03,843 [main] END org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト]) : 1
DEBUG 2011-02-02 21:31:03,844 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=2/col2=テスト2])
DEBUG 2011-02-02 21:31:03,844 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (2, 'テスト2')
DEBUG 2011-02-02 21:31:03,844 [main] END org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=2/col2=テスト2]) : 1
DEBUG 2011-02-02 21:31:03,844 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insertBatch([[/col1=1/col2=テスト], [/col1=2/col2=テスト2]])
DEBUG 2011-02-02 21:31:03,844 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (1, 'テスト')
DEBUG 2011-02-02 21:31:03,845 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (2, 'テスト2')
DEBUG 2011-02-02 21:31:03,845 [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.282 sec
Running org.seasar.codegen.lib.internal.impl.FromToOptionTest
Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec
Running org.seasar.codegen.lib.impl.ConditionResultImplTest
Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.004 sec

Results :

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

[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESSFUL
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 13 seconds
[INFO] Finished at: Wed Feb 02 21:31:04 JST 2011
[INFO] Final Memory: 29M/200M
[INFO] ------------------------------------------------------------------------
Finished: SUCCESS