![[Jenkins]](/ci/static/7db7b3a3/images/svgs/logo.svg){kind=logo}
定期的に実行 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 832 At revision 832 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: 2 seconds [INFO] Finished at: Sat Feb 05 14:30:44 JST 2011 [INFO] Final Memory: 23M/154M [INFO] ------------------------------------------------------------------------ [codegen-lib] $ /usr/local/java/ant/bin/ant Buildfile: build.xml gen: [java] 14:30:45.823 JST [main] INFO o.s.f.c.f.SingletonS2ContainerFactory - s2-frameworkのバージョンは2.4.40です。 [java] 14:30:45.828 JST [main] INFO o.s.f.c.f.SingletonS2ContainerFactory - s2-extensionのバージョンは2.4.40です。 [java] 14:30:45.828 JST [main] INFO o.s.f.c.f.SingletonS2ContainerFactory - s2-tigerのバージョンは2.4.40です。 [java] 14:30:46.387 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] 14:30:47.146 JST [main] WARN o.s.codegen.impl.DDLOutputCodeImpl - テンプレートが存在しないのでDDLを生成しません(createTable_h2.ftl)。 [java] 14:30:47.158 JST [main] WARN o.s.codegen.impl.DDLOutputCodeImpl - テンプレートが存在しないのでDDLを生成しません(dropTable_h2.ftl)。 BUILD SUCCESSFUL Total time: 2 seconds [codegen-lib] $ /usr/local/java/maven/bin/mvn clean test [INFO] Scanning for projects... [INFO] ------------------------------------------------------------------------ [INFO] Building codegen-lib [INFO] task-segment: [clean, test] [INFO] ------------------------------------------------------------------------ [INFO] [clean:clean {execution: default-clean}] [INFO] Deleting directory /home/services/hudson/jobs/codegen-lib-generate/workspace/codegen-lib/target [INFO] [build-helper:add-test-source {execution: add-test-source}] [INFO] Test Source directory: /home/services/hudson/jobs/codegen-lib-generate/workspace/codegen-lib/src/sample/java added. [INFO] [resources:resources {execution: default-resources}] [WARNING] Using platform encoding (UTF-8 actually) to copy filtered resources, i.e. build is platform dependent! [INFO] Copying 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: 7.316 sec Running org.seasar.codegen.lib.internal.impl.FindSqlCommandTest DEBUG 2011-02-05 14:30:59,543 [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 14:30:59,660 [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.588 sec Running org.seasar.codegen.sample.dao.ShiftJISDaoTest DEBUG 2011-02-05 14:31:00,217 [main] BEGIN org.seasar.codegen.sample.dao.ShiftJISDao#selectByShiftJISFile() DEBUG 2011-02-05 14:31:00,257 [main] SELECT * FROM EMP_TABLE WHERE ENAME <> '文字列' DEBUG 2011-02-05 14:31:00,258 [main] END org.seasar.codegen.sample.dao.ShiftJISDao#selectByShiftJISFile() : [] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.209 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.01 sec Running org.seasar.codegen.sample.dao.EmpTableDaoTest DEBUG 2011-02-05 14:31:00,659 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:00,659 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:00,670 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:00,672 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:00,672 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:00,673 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:00,680 [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 14:31:00,682 [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 14:31:00,683 [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 14:31:00,684 [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 14:31:00,685 [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 14:31:00,685 [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 14:31:00,686 [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 14:31:00,687 [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 14:31:00,688 [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 14:31:00,688 [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 14:31:00,689 [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 14:31:00,690 [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 14:31:00,691 [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 14:31:00,691 [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 14:31:00,692 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getAllEmpTable() DEBUG 2011-02-05 14:31:00,705 [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 14:31:00,709 [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 14:31:00,900 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:00,900 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:00,906 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:00,907 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:00,907 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:00,907 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:00,915 [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 14:31:00,916 [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 14:31:00,917 [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 14:31:00,917 [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 14:31:00,918 [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 14:31:00,919 [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 14:31:00,920 [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 14:31:00,920 [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 14:31:00,921 [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 14:31:00,922 [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 14:31:00,923 [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 14:31:00,923 [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 14:31:00,924 [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 14:31:00,925 [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 14:31:00,925 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7521) DEBUG 2011-02-05 14:31:00,938 [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 14:31:00,940 [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 14:31:01,144 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:01,145 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:01,149 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:01,150 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:01,150 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:01,150 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:01,157 [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 14:31:01,158 [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 14:31:01,159 [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 14:31:01,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 14:31:01,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 14:31:01,161 [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 14:31:01,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 14:31:01,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 14:31:01,163 [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 14:31:01,164 [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 14:31:01,164 [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 14:31:01,165 [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 14:31:01,166 [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 14:31:01,166 [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 14:31:01,167 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIds([7566, 7654]) DEBUG 2011-02-05 14:31:01,179 [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 14:31:01,183 [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 14:31:01,361 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:01,362 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:01,367 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:01,367 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:01,367 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:01,368 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:01,374 [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 14:31:01,375 [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 14:31:01,376 [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 14:31:01,377 [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 14:31:01,377 [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 14:31:01,378 [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 14:31:01,379 [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 14:31:01,379 [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 14:31:01,380 [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 14:31:01,381 [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 14:31:01,381 [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 14:31:01,382 [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 14:31:01,383 [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 14:31:01,383 [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 14:31:01,384 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableWithRelation(7369) DEBUG 2011-02-05 14:31:01,395 [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 14:31:01,398 [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 14:31:01,573 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:01,574 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:01,579 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:01,579 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:01,580 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:01,580 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:01,586 [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 14:31:01,587 [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 14:31:01,588 [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 14:31:01,588 [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 14:31:01,589 [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 14:31:01,590 [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 14:31:01,590 [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 14:31:01,591 [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 14:31:01,592 [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 14:31:01,592 [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 14:31:01,593 [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 14:31:01,594 [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 14:31:01,595 [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 14:31:01,595 [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 14:31:01,596 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#insert([/empNo=null/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 14:31:01 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]) DEBUG 2011-02-05 14:31:01,609 [main] CALL NEXTVAL('EMPNO') DEBUG 2011-02-05 14:31:01,609 [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 14:31:01,610 [main] END org.seasar.codegen.sample.dao.EmpTableDao#insert([/empNo=null/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 14:31:01 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]) : 1 DEBUG 2011-02-05 14:31:01,614 [main] SELECT * FROM EMP_TABLE ORDER BY emp_no DEBUG 2011-02-05 14:31:01,789 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:01,790 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:01,795 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:01,795 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:01,796 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:01,796 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:01,802 [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 14:31:01,803 [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 14:31:01,804 [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 14:31:01,805 [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 14:31:01,805 [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 14:31:01,806 [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 14:31:01,807 [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 14:31:01,808 [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 14:31:01,808 [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 14:31:01,809 [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 14:31:01,810 [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 14:31:01,810 [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 14:31:01,811 [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 14:31:01,812 [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 14:31:01,812 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7369) DEBUG 2011-02-05 14:31:01,824 [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 14:31:01,825 [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 14:31:01,825 [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 14:31:01,825 [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 14:31:01,826 [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 14:31:01,836 [main] SELECT * FROM emp_table ORDER BY emp_no DEBUG 2011-02-05 14:31:01,851 [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 14:31:01,851 [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 14:31:01,852 [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 14:31:01,852 [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 14:31:01,853 [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 14:31:01,853 [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 14:31:01,853 [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 14:31:01,854 [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 14:31:01,854 [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 14:31:01,855 [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 14:31:01,855 [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 14:31:01,855 [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 14:31:01,856 [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 14:31:01,856 [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 14:31:02,034 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:02,034 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:02,039 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:02,039 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:02,040 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:02,040 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:02,047 [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 14:31:02,048 [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 14:31:02,048 [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 14:31:02,051 [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 14:31:02,051 [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 14:31:02,052 [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 14:31:02,053 [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 14:31:02,053 [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 14:31:02,054 [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 14:31:02,055 [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 14:31:02,055 [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 14:31:02,056 [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 14:31:02,057 [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 14:31:02,057 [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 14:31:02,058 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7369) DEBUG 2011-02-05 14:31:02,071 [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 14:31:02,072 [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 14:31:02,072 [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 14:31:02,072 [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 14:31:02,072 [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 14:31:02,073 [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 14:31:02,073 [main] UPDATE EMP_TABLE SET ENAME = null, VERSIONNO = 12 WHERE EMP_NO = 7369 AND VERSIONNO = 11 DEBUG 2011-02-05 14:31:02,073 [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 14:31:02,282 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:02,283 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:02,287 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:02,288 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:02,288 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:02,289 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:02,294 [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 14:31:02,295 [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 14:31:02,296 [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 14:31:02,297 [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 14:31:02,297 [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 14:31:02,298 [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 14:31:02,298 [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 14:31:02,299 [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 14:31:02,300 [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 14:31:02,300 [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 14:31:02,301 [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 14:31:02,302 [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 14:31:02,302 [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 14:31:02,303 [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 14:31:02,303 [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 14:31:02,315 [main] DELETE FROM EMP_TABLE WHERE EMP_NO = 7369 AND VERSIONNO = 1 DEBUG 2011-02-05 14:31:02,316 [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 14:31:02,323 [main] SELECT * FROM emp_table ORDER BY emp_no DEBUG 2011-02-05 14:31:02,334 [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 14:31:02,335 [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 14:31:02,335 [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 14:31:02,335 [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 14:31:02,336 [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 14:31:02,336 [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 14:31:02,336 [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 14:31:02,337 [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 14:31:02,337 [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 14:31:02,337 [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 14:31:02,338 [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 14:31:02,338 [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 14:31:02,339 [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 14:31:02,506 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:02,506 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:02,510 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:02,510 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:02,511 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:02,511 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:02,516 [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 14:31:02,517 [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 14:31:02,518 [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 14:31:02,519 [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 14:31:02,519 [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 14:31:02,520 [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 14:31:02,521 [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 14:31:02,521 [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 14:31:02,522 [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 14:31:02,523 [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 14:31:02,523 [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 14:31:02,524 [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 14:31:02,525 [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 14:31:02,525 [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 14:31:02,527 [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 14:31:02,538 [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 14:31:02,542 [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 14:31:02,706 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:02,706 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:02,709 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:02,710 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:02,710 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:02,710 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:02,714 [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 14:31:02,715 [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 14:31:02,716 [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 14:31:02,716 [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 14:31:02,717 [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 14:31:02,718 [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 14:31:02,718 [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 14:31:02,719 [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 14:31:02,719 [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 14:31:02,720 [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 14:31:02,721 [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 14:31:02,721 [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 14:31:02,722 [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 14:31:02,722 [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 14:31:02,723 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.EMP_NO<>7500/offset=0/limit=-1) DEBUG 2011-02-05 14:31:02,734 [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 14:31:02,737 [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 14:31:02,914 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:02,914 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:02,920 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:02,920 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:02,921 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:02,921 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:02,925 [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 14:31:02,925 [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 14:31:02,926 [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 14:31:02,927 [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 14:31:02,927 [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 14:31:02,928 [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 14:31:02,929 [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 14:31:02,929 [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 14:31:02,930 [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 14:31:02,931 [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 14:31:02,931 [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 14:31:02,932 [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 14:31:02,933 [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 14:31:02,933 [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 14:31:02,934 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#find(/offset=0/limit=-1) DEBUG 2011-02-05 14:31:02,947 [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 14:31:02,949 [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 14:31:03,126 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:03,126 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:03,129 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:03,130 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:03,130 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:03,130 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:03,134 [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 14:31:03,135 [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 14:31:03,135 [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 14:31:03,136 [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 14:31:03,137 [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 14:31:03,137 [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 14:31:03,138 [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 14:31:03,138 [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 14:31:03,139 [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 14:31:03,140 [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 14:31:03,140 [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 14:31:03,141 [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 14:31:03,141 [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 14:31:03,142 [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 14:31:03,143 [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 14:31:03.143/EMP_TABLE.VERSIONNOnot in1/EMP_TABLE.EMP_NOnot in99/offset=0/limit=-1) DEBUG 2011-02-05 14:31:03,155 [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 14.31.03' AND EMP_TABLE.VERSIONNO not in(1) AND EMP_TABLE.EMP_NO not in(99) DEBUG 2011-02-05 14:31:03,156 [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 14:31:03.143/EMP_TABLE.VERSIONNOnot in1/EMP_TABLE.EMP_NOnot in99/offset=0/limit=-1) : [] DEBUG 2011-02-05 14:31:03,355 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:03,355 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:03,358 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:03,358 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:03,359 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:03,359 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:03,363 [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 14:31:03,364 [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 14:31:03,365 [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 14:31:03,366 [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 14:31:03,367 [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 14:31:03,368 [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 14:31:03,369 [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 14:31:03,370 [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 14:31:03,371 [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 14:31:03,372 [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 14:31:03,373 [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 14:31:03,374 [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 14:31:03,375 [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 14:31:03,376 [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 14:31:03,377 [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 14:31:03,390 [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 14:31:03,391 [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] /EMP_TABLE.EMP_NO>=7934/EMP_TABLE.HIRE_DATE>Mon Jan 01 00:00:00 JST 1900/offset=0/limit=-1 /ORDER BY EMP_TABLE.EMP_NO ,EMP_TABLE.DEPT_NO DESC/offset=0/limit=-1 DEBUG 2011-02-05 14:31:03,529 [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 14:31:03,574 [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 14:31:03,574 [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 14:31:03,712 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#findWithRelation(/deptTableEntity.LOC=DALLAS/offset=0/limit=-1) DEBUG 2011-02-05 14:31:03,754 [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 14:31:03,754 [main] END org.seasar.codegen.sample.dao.EmpTableDao#findWithRelation(/deptTableEntity.LOC=DALLAS/offset=0/limit=-1) : [] DEBUG 2011-02-05 14:31:03,942 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:03,942 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:03,945 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:03,945 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:03,946 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:03,946 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:03,950 [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 14:31:03,950 [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 14:31:03,951 [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 14:31:03,952 [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 14:31:03,952 [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 14:31:03,953 [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 14:31:03,954 [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 14:31:03,954 [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 14:31:03,955 [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 14:31:03,955 [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 14:31:03,956 [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 14:31:03,957 [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 14:31:03,957 [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 14:31:03,958 [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 14:31:03,958 [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 14:31:03,971 [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 14:31:03,978 [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 14:31:03,980 [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 14:31:04,157 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:04,158 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:04,161 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:04,161 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:04,162 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:04,162 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:04,166 [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 14:31:04,166 [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 14:31:04,167 [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 14:31:04,168 [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 14:31:04,168 [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 14:31:04,169 [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 14:31:04,169 [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 14:31:04,170 [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 14:31:04,171 [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 14:31:04,171 [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 14:31:04,172 [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 14:31:04,172 [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 14:31:04,173 [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 14:31:04,174 [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 14:31:04,174 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7654) DEBUG 2011-02-05 14:31:04,185 [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 14:31:04,186 [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 14:31:04,186 [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 14:31:04,186 [main] UPDATE EMP_TABLE SET ENAME = 'せとあずさ', VERSIONNO = 2 WHERE EMP_NO = 7654 AND VERSIONNO = 1 DEBUG 2011-02-05 14:31:04,187 [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 14:31:04,350 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:04,350 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:04,356 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:04,357 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:04,357 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:04,357 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:04,361 [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 14:31:04,362 [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 14:31:04,362 [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 14:31:04,363 [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 14:31:04,364 [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 14:31:04,364 [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 14:31:04,365 [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 14:31:04,365 [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 14:31:04,366 [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 14:31:04,366 [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 14:31:04,367 [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 14:31:04,368 [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 14:31:04,368 [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 14:31:04,369 [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 14:31:04,370 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#insertBatch([[/empNo=9990/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 14:31:04 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=9991/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 14:31:04 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) DEBUG 2011-02-05 14:31:04,381 [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 14:31:04,381 [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 14:31:04,383 [main] END org.seasar.codegen.sample.dao.EmpTableDao#insertBatch([[/empNo=9990/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 14:31:04 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=9991/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 14:31:04 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) : [1, 1] DEBUG 2011-02-05 14:31:04,385 [main] SELECT * FROM EMP_TABLE ORDER BY emp_no DEBUG 2011-02-05 14:31:04,566 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:04,566 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:04,570 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:04,570 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:04,571 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:04,571 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:04,575 [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 14:31:04,576 [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 14:31:04,577 [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 14:31:04,577 [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 14:31:04,578 [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 14:31:04,579 [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 14:31:04,579 [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 14:31:04,580 [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 14:31:04,581 [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 14:31:04,581 [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 14:31:04,582 [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 14:31:04,582 [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 14:31:04,583 [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 14:31:04,584 [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 14:31:04,584 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#updateBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 14: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 14:31:04 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) DEBUG 2011-02-05 14:31:04,599 [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 14:31:04,599 [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 14:31:04,599 [main] END org.seasar.codegen.sample.dao.EmpTableDao#updateBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 14: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 14:31:04 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) : [0, 0] DEBUG 2011-02-05 14:31:04,774 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:04,774 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:04,778 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:04,778 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:04,779 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:04,779 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:04,783 [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 14:31:04,784 [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 14:31:04,784 [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 14:31:04,785 [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 14:31:04,786 [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 14:31:04,787 [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 14:31:04,787 [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 14:31:04,788 [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 14:31:04,788 [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 14:31:04,789 [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 14:31:04,790 [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 14:31:04,790 [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 14:31:04,791 [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 14:31:04,792 [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 14:31:04,792 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#deleteBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 14: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 14:31:04 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) DEBUG 2011-02-05 14:31:04,806 [main] DELETE FROM EMP_TABLE WHERE EMP_NO = 7369 AND VERSIONNO = null DEBUG 2011-02-05 14:31:04,806 [main] DELETE FROM EMP_TABLE WHERE EMP_NO = 7499 AND VERSIONNO = null DEBUG 2011-02-05 14:31:04,807 [main] END org.seasar.codegen.sample.dao.EmpTableDao#deleteBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 14: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 14:31:04 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) : [0, 0] DEBUG 2011-02-05 14:31:04,808 [main] SELECT * FROM EMP_TABLE ORDER BY emp_no DEBUG 2011-02-05 14:31:05,001 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:05,001 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:05,004 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:05,005 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:05,005 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:05,005 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:05,009 [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 14:31:05,010 [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 14:31:05,011 [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 14:31:05,011 [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 14:31:05,012 [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 14:31:05,012 [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 14:31:05,013 [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 14:31:05,014 [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 14:31:05,014 [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 14:31:05,015 [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 14:31:05,015 [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 14:31:05,016 [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 14:31:05,017 [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 14:31:05,017 [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 14:31:05,018 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#findWithRelation(/offset=0/limit=-1) DEBUG 2011-02-05 14:31:05,031 [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 14:31:05,034 [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 14:31:05,035 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableWithRelation(7369) DEBUG 2011-02-05 14:31:05,035 [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 14:31:05,037 [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 14:31:05,037 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIdsWithRelation([7566, 7654]) DEBUG 2011-02-05 14:31:05,037 [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 14:31:05,039 [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 14:31:05,039 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIdsWithRelation([7566, 7654]) DEBUG 2011-02-05 14:31:05,039 [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 14:31:05,041 [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 14:31:05,041 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#soleMatchWithRelation(/EMP_TABLE.EMP_NO=7654/offset=0/limit=-1) DEBUG 2011-02-05 14:31:05,041 [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 14:31:05,042 [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 14:31:05,042 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getAllEmpTableWithRelation() DEBUG 2011-02-05 14:31:05,043 [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 14:31:05,046 [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 14:31:05,181 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#selectByUtf8SqlFile() DEBUG 2011-02-05 14:31:05,221 [main] SELECT * FROM EMP_TABLE WHERE ENAME <> '文字列' DEBUG 2011-02-05 14:31:05,221 [main] END org.seasar.codegen.sample.dao.EmpTableDao#selectByUtf8SqlFile() : [] DEBUG 2011-02-05 14:31:05,366 [main] DELETE FROM EMP_TABLE DEBUG 2011-02-05 14:31:05,366 [main] DELETE FROM DEPT_TABLE DEBUG 2011-02-05 14:31:05,369 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2011-02-05 14:31:05,370 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2011-02-05 14:31:05,370 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2011-02-05 14:31:05,370 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2011-02-05 14:31:05,374 [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 14:31:05,374 [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 14:31:05,375 [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 14:31:05,376 [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 14:31:05,376 [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 14:31:05,377 [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 14:31:05,377 [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 14:31:05,378 [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 14:31:05,379 [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 14:31:05,379 [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 14:31:05,380 [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 14:31:05,380 [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 14:31:05,381 [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 14:31:05,382 [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 14:31:05,383 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#select(org.seasar.codegen.sample.dao.EmpTableDaoTest$1@653e4653) DEBUG 2011-02-05 14:31:05,394 [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 14:31:05,396 [main] END org.seasar.codegen.sample.dao.EmpTableDao#select(org.seasar.codegen.sample.dao.EmpTableDaoTest$1@653e4653) : 1 Tests run: 23, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 5.129 sec Running org.seasar.codegen.lib.impl.DateConditionElementImplTest Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.003 sec Running org.seasar.codegen.unit.AbstractCodeGenExtensionTestCase DEBUG 2011-02-05 14:31:05,459 [main] SELECT * FROM DEPT_TABLE ORDER BY dept_id DEBUG 2011-02-05 14:31:05,517 [main] SELECT * FROM DEPT_TABLE ORDER BY dept_id DEBUG 2011-02-05 14:31:05,522 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 10 DEBUG 2011-02-05 14:31:05,523 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 20 DEBUG 2011-02-05 14:31:05,523 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 30 DEBUG 2011-02-05 14:31:05,523 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 60 DEBUG 2011-02-05 14:31:05,574 [main] SELECT * FROM DEPT_TABLE ORDER BY dept_id DEBUG 2011-02-05 14:31:05,579 [main] SELECT dept_id, dname, loc, versionno, active FROM DEPT_TABLE WHERE dept_id = 10 DEBUG 2011-02-05 14:31:05,579 [main] SELECT dept_id, dname, loc, versionno, active FROM DEPT_TABLE WHERE dept_id = 20 DEBUG 2011-02-05 14:31:05,580 [main] SELECT dept_id, dname, loc, versionno, active FROM DEPT_TABLE WHERE dept_id = 30 DEBUG 2011-02-05 14:31:05,580 [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.177 sec Running org.seasar.codegen.unit.AbstractXlsWriterExtTestCase Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.027 sec Running org.seasar.codegen.lib.impl.StringConditionElementImplTest Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.002 sec Running org.seasar.codegen.sample.dao.NoPkDaoTest DEBUG 2011-02-05 14:31:05,729 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト]) DEBUG 2011-02-05 14:31:05,760 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (1, 'テスト') DEBUG 2011-02-05 14:31:05,761 [main] END org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト]) : 1 DEBUG 2011-02-05 14:31:05,873 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト]) DEBUG 2011-02-05 14:31:05,904 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (1, 'テスト') DEBUG 2011-02-05 14:31:05,904 [main] END org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト]) : 1 DEBUG 2011-02-05 14:31:05,904 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=2/col2=テスト2]) DEBUG 2011-02-05 14:31:05,904 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (2, 'テスト2') DEBUG 2011-02-05 14:31:05,905 [main] END org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=2/col2=テスト2]) : 1 DEBUG 2011-02-05 14:31:05,905 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insertBatch([[/col1=1/col2=テスト], [/col1=2/col2=テスト2]]) DEBUG 2011-02-05 14:31:05,905 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (1, 'テスト') DEBUG 2011-02-05 14:31:05,905 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (2, 'テスト2') DEBUG 2011-02-05 14:31:05,905 [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.296 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: 18 seconds [INFO] Finished at: Sat Feb 05 14:31:06 JST 2011 [INFO] Final Memory: 29M/208M [INFO] ------------------------------------------------------------------------ Finished: SUCCESS