定期的に実行 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 826 At revision 826 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 73 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: Sat Feb 05 06:30:45 JST 2011 [INFO] Final Memory: 23M/155M [INFO] ------------------------------------------------------------------------ [codegen-lib] $ /usr/local/java/ant/bin/ant Buildfile: build.xml gen: [java] 06:30:48.074 JST [main] INFO o.s.f.c.f.SingletonS2ContainerFactory - s2-frameworkのバージョンは2.4.40です。 [java] 06:30:48.079 JST [main] INFO o.s.f.c.f.SingletonS2ContainerFactory - s2-extensionのバージョンは2.4.40です。 [java] 06:30:48.080 JST [main] INFO o.s.f.c.f.SingletonS2ContainerFactory - s2-tigerのバージョンは2.4.40です。 [java] 06:30:48.912 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] 06:30:49.783 JST [main] WARN o.s.codegen.impl.DDLOutputCodeImpl - テンプレートが存在しないのでDDLを生成しません(createTable_h2.ftl)。 [java] 06:30:49.795 JST [main] WARN o.s.codegen.impl.DDLOutputCodeImpl - テンプレートが存在しないのでDDLを生成しません(dropTable_h2.ftl)。 BUILD SUCCESSFUL Total time: 3 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 4 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 44 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: 3.863 sec Running org.seasar.codegen.lib.internal.impl.FindSqlCommandTest DEBUG 2011-02-05 06:30:58,783 [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-05 06:30:58,900 [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.58 sec Running org.seasar.codegen.sample.dao.ShiftJISDaoTest DEBUG 2011-02-05 06:30:59,460 [main] BEGIN org.seasar.codegen.sample.dao.ShiftJISDao#selectByShiftJISFile() DEBUG 2011-02-05 06:30:59,493 [main] SELECT * FROM EMP_TABLE WHERE ENAME <> '文字列' DEBUG 2011-02-05 06:30:59,494 [main] END org.seasar.codegen.sample.dao.ShiftJISDao#selectByShiftJISFile() : [] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.21 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.058 sec Running org.seasar.codegen.sample.dao.EmpTableDaoTest DEBUG 2011-02-05 06:30:59,996 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:30:59,996 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:00,020 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:00,022 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:00,023 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:00,023 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:00,030 [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-05 06:31:00,032 [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-05 06:31:00,033 [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-05 06:31:00,034 [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-05 06:31:00,035 [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-05 06:31:00,036 [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-05 06:31:00,037 [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-05 06:31:00,038 [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-05 06:31:00,038 [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-05 06:31:00,039 [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-05 06:31:00,040 [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-05 06:31:00,041 [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-05 06:31:00,042 [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-05 06:31:00,042 [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-05 06:31:00,043 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getAllEmpTable() DEBUG 2011-02-05 06:31:00,056 [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-05 06:31:00,060 [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-05 06:31:00,267 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:00,268 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:00,273 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:00,274 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:00,274 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:00,274 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:00,281 [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-05 06:31:00,282 [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-05 06:31:00,283 [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-05 06:31:00,284 [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-05 06:31:00,285 [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-05 06:31:00,285 [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-05 06:31:00,286 [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-05 06:31:00,287 [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-05 06:31:00,288 [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-05 06:31:00,288 [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-05 06:31:00,289 [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-05 06:31:00,290 [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-05 06:31:00,291 [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-05 06:31:00,292 [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-05 06:31:00,292 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7521) DEBUG 2011-02-05 06:31:00,305 [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-05 06:31:00,307 [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-05 06:31:00,515 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:00,515 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:00,521 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:00,521 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:00,521 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:00,522 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:00,531 [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-05 06:31:00,544 [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-05 06:31:00,545 [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-05 06:31:00,546 [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-05 06:31:00,547 [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-05 06:31:00,547 [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-05 06:31:00,548 [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-05 06:31:00,549 [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-05 06:31:00,550 [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-05 06:31:00,551 [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-05 06:31:00,552 [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-05 06:31:00,553 [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-05 06:31:00,553 [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-05 06:31:00,554 [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-05 06:31:00,555 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIds([7566, 7654]) DEBUG 2011-02-05 06:31:00,567 [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-05 06:31:00,572 [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-05 06:31:00,867 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:00,867 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:00,874 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:00,875 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:00,875 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:00,875 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:00,882 [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-05 06:31:00,883 [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-05 06:31:00,884 [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-05 06:31:00,885 [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-05 06:31:00,886 [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-05 06:31:00,886 [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-05 06:31:00,887 [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-05 06:31:00,888 [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-05 06:31:00,888 [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-05 06:31:00,889 [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-05 06:31:00,890 [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-05 06:31:00,891 [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-05 06:31:00,891 [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-05 06:31:00,892 [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-05 06:31:00,893 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableWithRelation(7369) DEBUG 2011-02-05 06:31:00,904 [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-05 06:31:00,907 [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-05 06:31:01,079 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:01,079 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:01,085 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:01,085 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:01,086 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:01,086 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:01,092 [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-05 06:31:01,093 [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-05 06:31:01,094 [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-05 06:31:01,095 [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-05 06:31:01,096 [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-05 06:31:01,096 [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-05 06:31:01,097 [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-05 06:31:01,098 [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-05 06:31:01,099 [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-05 06:31:01,099 [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-05 06:31:01,100 [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-05 06:31:01,101 [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-05 06:31:01,102 [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-05 06:31:01,102 [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-05 06:31:01,103 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#insert([/empNo=null/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 06:31:01 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]) DEBUG 2011-02-05 06:31:01,115 [main] CALL NEXTVAL('EMPNO') DEBUG 2011-02-05 06:31:01,116 [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-05 06:31:01,116 [main] END org.seasar.codegen.sample.dao.EmpTableDao#insert([/empNo=null/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 06:31:01 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]) : 1 DEBUG 2011-02-05 06:31:01,121 [main] SELECT * FROM EMP_TABLE ORDER BY emp_no DEBUG 2011-02-05 06:31:01,287 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:01,287 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:01,291 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:01,292 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:01,292 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:01,292 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:01,299 [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-05 06:31:01,300 [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-05 06:31:01,301 [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-05 06:31:01,302 [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-05 06:31:01,302 [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-05 06:31:01,303 [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-05 06:31:01,304 [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-05 06:31:01,305 [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-05 06:31:01,305 [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-05 06:31:01,306 [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-05 06:31:01,307 [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-05 06:31:01,307 [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-05 06:31:01,308 [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-05 06:31:01,309 [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-05 06:31:01,309 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7369) DEBUG 2011-02-05 06:31:01,320 [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-05 06:31:01,321 [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-05 06:31:01,321 [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-05 06:31:01,322 [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-05 06:31:01,323 [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-05 06:31:01,332 [main] SELECT * FROM emp_table ORDER BY emp_no DEBUG 2011-02-05 06:31:01,346 [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-05 06:31:01,346 [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-05 06:31:01,347 [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-05 06:31:01,347 [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-05 06:31:01,348 [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-05 06:31:01,348 [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-05 06:31:01,348 [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-05 06:31:01,349 [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-05 06:31:01,349 [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-05 06:31:01,350 [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-05 06:31:01,350 [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-05 06:31:01,351 [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-05 06:31:01,351 [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-05 06:31:01,351 [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-05 06:31:01,555 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:01,555 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:01,560 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:01,561 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:01,563 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:01,563 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:01,570 [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-05 06:31:01,571 [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-05 06:31:01,571 [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-05 06:31:01,572 [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-05 06:31:01,573 [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-05 06:31:01,574 [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-05 06:31:01,575 [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-05 06:31:01,575 [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-05 06:31:01,576 [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-05 06:31:01,577 [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-05 06:31:01,578 [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-05 06:31:01,578 [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-05 06:31:01,579 [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-05 06:31:01,580 [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-05 06:31:01,581 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7369) DEBUG 2011-02-05 06:31:01,596 [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-05 06:31:01,597 [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-05 06:31:01,598 [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-05 06:31:01,598 [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-05 06:31:01,598 [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-05 06:31:01,599 [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-05 06:31:01,599 [main] UPDATE EMP_TABLE SET ENAME = null, VERSIONNO = 12 WHERE EMP_NO = 7369 AND VERSIONNO = 11 DEBUG 2011-02-05 06:31:01,599 [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-05 06:31:01,857 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:01,857 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:01,861 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:01,864 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:01,865 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:01,865 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:01,871 [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-05 06:31:01,872 [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-05 06:31:01,873 [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-05 06:31:01,873 [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-05 06:31:01,874 [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-05 06:31:01,875 [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-05 06:31:01,876 [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-05 06:31:01,877 [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-05 06:31:01,877 [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-05 06:31:01,878 [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-05 06:31:01,879 [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-05 06:31:01,880 [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-05 06:31:01,880 [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-05 06:31:01,881 [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-05 06:31:01,882 [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-05 06:31:01,894 [main] DELETE FROM EMP_TABLE WHERE EMP_NO = 7369 AND VERSIONNO = 1 DEBUG 2011-02-05 06:31:01,895 [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-05 06:31:01,912 [main] SELECT * FROM emp_table ORDER BY emp_no DEBUG 2011-02-05 06:31:01,923 [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-05 06:31:01,924 [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-05 06:31:01,924 [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-05 06:31:01,925 [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-05 06:31:01,925 [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-05 06:31:01,926 [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-05 06:31:01,926 [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-05 06:31:01,926 [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-05 06:31:01,927 [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-05 06:31:01,927 [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-05 06:31:01,928 [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-05 06:31:01,928 [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-05 06:31:01,929 [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-05 06:31:02,141 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:02,141 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:02,149 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:02,150 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:02,150 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:02,151 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:02,156 [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-05 06:31:02,157 [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-05 06:31:02,158 [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-05 06:31:02,159 [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-05 06:31:02,160 [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-05 06:31:02,160 [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-05 06:31:02,161 [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-05 06:31:02,162 [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-05 06:31:02,164 [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-05 06:31:02,165 [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-05 06:31:02,166 [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-05 06:31:02,167 [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-05 06:31:02,167 [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-05 06:31:02,168 [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-05 06:31:02,170 [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-05 06:31:02,184 [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-05 06:31:02,187 [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-05 06:31:02,403 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:02,404 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:02,408 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:02,408 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:02,409 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:02,409 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:02,414 [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-05 06:31:02,415 [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-05 06:31:02,416 [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-05 06:31:02,416 [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-05 06:31:02,417 [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-05 06:31:02,418 [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-05 06:31:02,419 [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-05 06:31:02,420 [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-05 06:31:02,420 [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-05 06:31:02,421 [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-05 06:31:02,422 [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-05 06:31:02,423 [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-05 06:31:02,423 [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-05 06:31:02,424 [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-05 06:31:02,425 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.EMP_NO<>7500/offset=0/limit=-1) DEBUG 2011-02-05 06:31:02,436 [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-05 06:31:02,440 [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-05 06:31:02,627 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:02,627 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:02,633 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:02,633 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:02,634 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:02,634 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:02,638 [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-05 06:31:02,639 [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-05 06:31:02,640 [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-05 06:31:02,641 [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-05 06:31:02,642 [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-05 06:31:02,642 [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-05 06:31:02,643 [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-05 06:31:02,644 [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-05 06:31:02,644 [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-05 06:31:02,645 [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-05 06:31:02,646 [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-05 06:31:02,647 [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-05 06:31:02,648 [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-05 06:31:02,649 [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-05 06:31:02,650 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#find(/offset=0/limit=-1) DEBUG 2011-02-05 06:31:02,662 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE WHERE DEPT_NO <> 10 DEBUG 2011-02-05 06:31:02,664 [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-05 06:31:02,835 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:02,835 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:02,838 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:02,838 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:02,838 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:02,839 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:02,871 [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-05 06:31:02,872 [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-05 06:31:02,873 [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-05 06:31:02,874 [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-05 06:31:02,874 [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-05 06:31:02,875 [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-05 06:31:02,876 [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-05 06:31:02,877 [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-05 06:31:02,877 [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-05 06:31:02,878 [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-05 06:31:02,879 [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-05 06:31:02,880 [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-05 06:31:02,880 [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-05 06:31:02,881 [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-05 06:31:02,882 [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-05 06:31:02.882/EMP_TABLE.VERSIONNOnot in1/EMP_TABLE.EMP_NOnot in99/offset=0/limit=-1) DEBUG 2011-02-05 06:31:02,893 [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-05 06.31.02' AND EMP_TABLE.VERSIONNO not in(1) AND EMP_TABLE.EMP_NO not in(99) DEBUG 2011-02-05 06:31:02,895 [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-05 06:31:02.882/EMP_TABLE.VERSIONNOnot in1/EMP_TABLE.EMP_NOnot in99/offset=0/limit=-1) : [] DEBUG 2011-02-05 06:31:03,051 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:03,051 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:03,054 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:03,055 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:03,055 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:03,055 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:03,059 [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-05 06:31:03,060 [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-05 06:31:03,061 [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-05 06:31:03,062 [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-05 06:31:03,062 [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-05 06:31:03,063 [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-05 06:31:03,064 [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-05 06:31:03,064 [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-05 06:31:03,065 [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-05 06:31:03,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-05 06:31:03,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-05 06:31:03,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-05 06:31:03,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-05 06:31:03,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) /EMP_TABLE.EMP_NO>=7934/EMP_TABLE.HIRE_DATE>Mon Jan 01 00:00:00 JST 1900/offset=0/limit=-1 DEBUG 2011-02-05 06:31:03,094 [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-05 06:31:03,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_TABLE.EMP_NO >=7934 AND EMP_TABLE.HIRE_DATE >'1900-01-01' DEBUG 2011-02-05 06:31:03,105 [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-05 06:31:03,222 [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-05 06:31:03,261 [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-05 06:31:03,261 [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-05 06:31:03,375 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#findWithRelation(/deptTableEntity.LOC=DALLAS/offset=0/limit=-1) DEBUG 2011-02-05 06:31:03,419 [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-05 06:31:03,419 [main] END org.seasar.codegen.sample.dao.EmpTableDao#findWithRelation(/deptTableEntity.LOC=DALLAS/offset=0/limit=-1) : [] DEBUG 2011-02-05 06:31:03,571 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:03,571 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:03,574 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:03,574 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:03,575 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:03,575 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:03,578 [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-05 06:31:03,579 [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-05 06:31:03,580 [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-05 06:31:03,580 [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-05 06:31:03,581 [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-05 06:31:03,582 [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-05 06:31:03,582 [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-05 06:31:03,583 [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-05 06:31:03,583 [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-05 06:31:03,584 [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-05 06:31:03,585 [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-05 06:31:03,585 [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-05 06:31:03,586 [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-05 06:31:03,587 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1) /EMP_TABLE.HIRE_DATE>Mon Jan 01 00:00:00 JST 1900/ORDER BY EMP_TABLE.EMP_NO /offset=5/limit=5 DEBUG 2011-02-05 06:31:03,587 [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-05 06:31:03,599 [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-05 06:31:03,604 [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-05 06:31:03,606 [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-05 06:31:03,783 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:03,783 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:03,786 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:03,786 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:03,787 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:03,787 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:03,790 [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-05 06:31:03,791 [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-05 06:31:03,792 [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-05 06:31:03,792 [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-05 06:31:03,793 [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-05 06:31:03,794 [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-05 06:31:03,794 [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-05 06:31:03,795 [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-05 06:31:03,795 [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-05 06:31:03,796 [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-05 06:31:03,797 [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-05 06:31:03,797 [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-05 06:31:03,798 [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-05 06:31:03,798 [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-05 06:31:03,799 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7654) DEBUG 2011-02-05 06:31:03,809 [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-05 06:31:03,810 [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-05 06:31:03,810 [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-05 06:31:03,810 [main] UPDATE EMP_TABLE SET ENAME = 'せとあずさ', VERSIONNO = 2 WHERE EMP_NO = 7654 AND VERSIONNO = 1 DEBUG 2011-02-05 06:31:03,811 [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-05 06:31:03,954 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:03,954 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:03,957 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:03,958 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:03,958 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:03,958 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:03,962 [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-05 06:31:03,962 [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-05 06:31:03,963 [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-05 06:31:03,964 [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-05 06:31:03,964 [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-05 06:31:03,965 [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-05 06:31:03,965 [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-05 06:31:03,966 [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-05 06:31:03,967 [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-05 06:31:03,967 [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-05 06:31:03,968 [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-05 06:31:03,968 [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-05 06:31:03,969 [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-05 06:31:03,970 [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-05 06:31:03,970 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#insertBatch([[/empNo=9990/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 06:31:03 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=9991/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 06:31:03 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) DEBUG 2011-02-05 06:31:03,981 [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-05 06:31:03,982 [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-05 06:31:03,983 [main] END org.seasar.codegen.sample.dao.EmpTableDao#insertBatch([[/empNo=9990/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 06:31:03 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=9991/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 06:31:03 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) : [1, 1] DEBUG 2011-02-05 06:31:03,984 [main] SELECT * FROM EMP_TABLE ORDER BY emp_no DEBUG 2011-02-05 06:31:04,194 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:04,194 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:04,197 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:04,197 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:04,197 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:04,198 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:04,201 [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-05 06:31:04,202 [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-05 06:31:04,203 [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-05 06:31:04,203 [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-05 06:31:04,204 [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-05 06:31:04,204 [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-05 06:31:04,205 [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-05 06:31:04,206 [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-05 06:31:04,206 [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-05 06:31:04,207 [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-05 06:31:04,208 [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-05 06:31:04,208 [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-05 06:31:04,209 [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-05 06:31:04,209 [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-05 06:31:04,210 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#updateBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 06:31:04 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=7499/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 06:31:04 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) DEBUG 2011-02-05 06:31:04,226 [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-05 06:31:04,227 [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-05 06:31:04,227 [main] END org.seasar.codegen.sample.dao.EmpTableDao#updateBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 06:31:04 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=7499/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 06:31:04 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) : [0, 0] DEBUG 2011-02-05 06:31:04,527 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:04,527 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:04,529 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:04,530 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:04,530 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:04,530 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:04,533 [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-05 06:31:04,534 [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-05 06:31:04,535 [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-05 06:31:04,536 [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-05 06:31:04,536 [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-05 06:31:04,537 [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-05 06:31:04,537 [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-05 06:31:04,538 [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-05 06:31:04,538 [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-05 06:31:04,539 [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-05 06:31:04,541 [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-05 06:31:04,542 [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-05 06:31:04,543 [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-05 06:31:04,543 [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-05 06:31:04,544 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#deleteBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 06:31:04 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=7499/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 06:31:04 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) DEBUG 2011-02-05 06:31:04,557 [main] DELETE FROM EMP_TABLE WHERE EMP_NO = 7369 AND VERSIONNO = null DEBUG 2011-02-05 06:31:04,557 [main] DELETE FROM EMP_TABLE WHERE EMP_NO = 7499 AND VERSIONNO = null DEBUG 2011-02-05 06:31:04,558 [main] END org.seasar.codegen.sample.dao.EmpTableDao#deleteBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 06:31:04 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=7499/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 06:31:04 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) : [0, 0] DEBUG 2011-02-05 06:31:04,559 [main] SELECT * FROM EMP_TABLE ORDER BY emp_no DEBUG 2011-02-05 06:31:04,743 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:04,743 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:04,746 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:04,747 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:04,748 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:04,748 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:04,751 [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-05 06:31:04,752 [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-05 06:31:04,752 [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-05 06:31:04,753 [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-05 06:31:04,754 [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-05 06:31:04,754 [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-05 06:31:04,755 [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-05 06:31:04,755 [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-05 06:31:04,756 [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-05 06:31:04,756 [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-05 06:31:04,757 [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-05 06:31:04,757 [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-05 06:31:04,758 [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-05 06:31:04,758 [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-05 06:31:04,761 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#findWithRelation(/offset=0/limit=-1) DEBUG 2011-02-05 06:31:04,785 [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-05 06:31:04,789 [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-05 06:31:04,789 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableWithRelation(7369) DEBUG 2011-02-05 06:31:04,789 [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-05 06:31:04,791 [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-05 06:31:04,791 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIdsWithRelation([7566, 7654]) DEBUG 2011-02-05 06:31:04,792 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP, deptTableEntity.VERSIONNO AS VERSIONNO_0, deptTableEntity.DEPT_ID AS DEPT_ID_0, deptTableEntity.DNAME AS DNAME_0, deptTableEntity.LOC AS LOC_0, deptTableEntity.ACTIVE AS ACTIVE_0 FROM EMP_TABLE LEFT OUTER JOIN DEPT_TABLE deptTableEntity ON EMP_TABLE.DEPT_NO = deptTableEntity.DEPT_ID WHERE EMP_NO in (7566, 7654) ORDER BY EMP_NO DEBUG 2011-02-05 06:31:04,793 [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-05 06:31:04,793 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIdsWithRelation([7566, 7654]) DEBUG 2011-02-05 06:31:04,794 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP, deptTableEntity.VERSIONNO AS VERSIONNO_0, deptTableEntity.DEPT_ID AS DEPT_ID_0, deptTableEntity.DNAME AS DNAME_0, deptTableEntity.LOC AS LOC_0, deptTableEntity.ACTIVE AS ACTIVE_0 FROM EMP_TABLE LEFT OUTER JOIN DEPT_TABLE deptTableEntity ON EMP_TABLE.DEPT_NO = deptTableEntity.DEPT_ID WHERE EMP_NO in (7566, 7654) ORDER BY EMP_NO DEBUG 2011-02-05 06:31:04,795 [main] END org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIdsWithRelation([7566, 7654]) : [[/empNo=7566/ename=JONES/job=MANAGER/mgr=7839/hireDate=1981-04-02 00:00:00.0/sal=2975/comm=null/deptNo=20/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=20/dname=RESEARCH/loc=DALLAS/versionno=0/active=true], [/empNo=7654/ename=MARTIN/job=SALESMAN/mgr=7698/hireDate=1981-09-28 00:00:00.0/sal=1250/comm=1400/deptNo=30/tstamp=2000-01-01 00:00:00.0/versionno=1]deptTableEntity[/deptId=30/dname=SALES/loc=CHICAGO/versionno=0/active=true]] DEBUG 2011-02-05 06:31:04,795 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#soleMatchWithRelation(/EMP_TABLE.EMP_NO=7654/offset=0/limit=-1) DEBUG 2011-02-05 06:31:04,795 [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-05 06:31:04,796 [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-05 06:31:04,796 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getAllEmpTableWithRelation() DEBUG 2011-02-05 06:31:04,796 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP, deptTableEntity.VERSIONNO AS VERSIONNO_0, deptTableEntity.DEPT_ID AS DEPT_ID_0, deptTableEntity.DNAME AS DNAME_0, deptTableEntity.LOC AS LOC_0, deptTableEntity.ACTIVE AS ACTIVE_0 FROM EMP_TABLE LEFT OUTER JOIN DEPT_TABLE deptTableEntity ON EMP_TABLE.DEPT_NO = deptTableEntity.DEPT_ID ORDER BY EMP_NO DEBUG 2011-02-05 06:31:04,799 [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-05 06:31:04,931 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#selectByUtf8SqlFile() DEBUG 2011-02-05 06:31:04,982 [main] SELECT * FROM EMP_TABLE WHERE ENAME <> '文字列' DEBUG 2011-02-05 06:31:04,983 [main] END org.seasar.codegen.sample.dao.EmpTableDao#selectByUtf8SqlFile() : [] DEBUG 2011-02-05 06:31:05,114 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 06:31:05,114 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 06:31:05,116 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 06:31:05,117 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 06:31:05,117 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 06:31:05,117 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 06:31:05,120 [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-05 06:31:05,121 [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-05 06:31:05,121 [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-05 06:31:05,122 [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-05 06:31:05,122 [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-05 06:31:05,123 [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-05 06:31:05,123 [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-05 06:31:05,124 [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-05 06:31:05,124 [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-05 06:31:05,124 [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-05 06:31:05,125 [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-05 06:31:05,125 [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-05 06:31:05,126 [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-05 06:31:05,126 [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-05 06:31:05,137 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#select(org.seasar.codegen.sample.dao.EmpTableDaoTest$1@33d626a4) DEBUG 2011-02-05 06:31:05,148 [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-05 06:31:05,149 [main] END org.seasar.codegen.sample.dao.EmpTableDao#select(org.seasar.codegen.sample.dao.EmpTableDaoTest$1@33d626a4) : 1 Tests run: 23, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 5.621 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-05 06:31:05,240 [main] SELECT * FROM DEPT_TABLE ORDER BY dept_id DEBUG 2011-02-05 06:31:05,299 [main] SELECT * FROM DEPT_TABLE ORDER BY dept_id DEBUG 2011-02-05 06:31:05,304 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 10 DEBUG 2011-02-05 06:31:05,304 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 20 DEBUG 2011-02-05 06:31:05,304 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 30 DEBUG 2011-02-05 06:31:05,305 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 60 DEBUG 2011-02-05 06:31:05,404 [main] SELECT * FROM DEPT_TABLE ORDER BY dept_id DEBUG 2011-02-05 06:31:05,410 [main] SELECT dept_id, dname, loc, versionno, active FROM DEPT_TABLE WHERE dept_id = 10 DEBUG 2011-02-05 06:31:05,410 [main] SELECT dept_id, dname, loc, versionno, active FROM DEPT_TABLE WHERE dept_id = 20 DEBUG 2011-02-05 06:31:05,410 [main] SELECT dept_id, dname, loc, versionno, active FROM DEPT_TABLE WHERE dept_id = 30 DEBUG 2011-02-05 06:31:05,411 [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.232 sec Running org.seasar.codegen.unit.AbstractXlsWriterExtTestCase Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.061 sec Running org.seasar.codegen.lib.impl.StringConditionElementImplTest Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec Running org.seasar.codegen.sample.dao.NoPkDaoTest DEBUG 2011-02-05 06:31:05,578 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト]) DEBUG 2011-02-05 06:31:05,613 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (1, 'テスト') DEBUG 2011-02-05 06:31:05,613 [main] END org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト]) : 1 DEBUG 2011-02-05 06:31:05,740 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト]) DEBUG 2011-02-05 06:31:05,772 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (1, 'テスト') DEBUG 2011-02-05 06:31:05,772 [main] END org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト]) : 1 DEBUG 2011-02-05 06:31:05,772 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=2/col2=テスト2]) DEBUG 2011-02-05 06:31:05,773 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (2, 'テスト2') DEBUG 2011-02-05 06:31:05,773 [main] END org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=2/col2=テスト2]) : 1 DEBUG 2011-02-05 06:31:05,773 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insertBatch([[/col1=1/col2=テスト], [/col1=2/col2=テスト2]]) DEBUG 2011-02-05 06:31:05,773 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (1, 'テスト') DEBUG 2011-02-05 06:31:05,773 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (2, 'テスト2') DEBUG 2011-02-05 06:31:05,773 [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.301 sec Running org.seasar.codegen.lib.internal.impl.FromToOptionTest Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec Running org.seasar.codegen.lib.impl.ConditionResultImplTest Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec Results : Tests run: 81, Failures: 0, Errors: 0, Skipped: 0 [INFO] ------------------------------------------------------------------------ [INFO] BUILD SUCCESSFUL [INFO] ------------------------------------------------------------------------ [INFO] Total time: 15 seconds [INFO] Finished at: Sat Feb 05 06:31:06 JST 2011 [INFO] Final Memory: 29M/203M [INFO] ------------------------------------------------------------------------ Finished: SUCCESS