![[Jenkins]](/ci/static/7db7b3a3/images/svgs/logo.svg){kind=logo}
上流プロジェクト"s2container-2.4-s2tiger"の#1700が実行 originally caused by: 上流プロジェクト"s2container-2.4-seasar2"の#1669が実行 originally caused by: 定期的に実行 ビルドします。 ワークスペース: /home/services/jenkins/jobs/codegen-lib/workspace Updating https://www.seasar.org/svn/sandbox/s2dao-codegen/trunk/codegen-lib to revision '2013-01-06T01:06:41.145 +0900' 'https://www.seasar.org/svn/sandbox/s2dao-codegen/trunk/codegen-core'のリビジョン-1を'/home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/codegen-core'へ取得中 At revision 856 At revision 856 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 Parsing POMs Modules changed, recalculating dependency graph [codegen-lib] $ /usr/local/java/jdk-1.5/bin/java -cp /home/services/jenkins/plugins/maven-plugin/WEB-INF/lib/maven3-agent-1.2.jar:/usr/local/java/maven/boot/plexus-classworlds-2.4.jar org.jvnet.hudson.maven3.agent.Maven3Main /usr/local/java/maven /var/cache/jenkins/war/WEB-INF/lib/remoting-2.17.jar /home/services/jenkins/plugins/maven-plugin/WEB-INF/lib/maven3-interceptor-1.2.jar 50807 <===[JENKINS REMOTING CAPACITY]===> channel started log4j:WARN No appenders could be found for logger (org.apache.commons.beanutils.converters.BooleanConverter). log4j:WARN Please initialize the log4j system properly. Executing Maven: -B -f /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/pom.xml clean install [INFO] Scanning for projects... [WARNING] [WARNING] Some problems were encountered while building the effective model for org.seasar.dao-codegen:codegen-lib:jar:0.4.2.1-SNAPSHOT [WARNING] 'build.plugins.plugin.version' for org.apache.maven.plugins:maven-javadoc-plugin is missing. @ line 109, column 12 [WARNING] 'build.plugins.plugin.version' for org.apache.maven.plugins:maven-compiler-plugin is missing. @ line 89, column 12 [WARNING] 'build.plugins.plugin.version' for org.codehaus.mojo:build-helper-maven-plugin is missing. @ line 137, column 12 [WARNING] 'build.plugins.plugin.version' for org.apache.maven.plugins:maven-source-plugin is missing. @ line 97, column 12 [WARNING] 'build.plugins.plugin.version' for org.apache.maven.plugins:maven-eclipse-plugin is missing. @ line 155, column 12 [WARNING] [WARNING] It is highly recommended to fix these problems because they threaten the stability of your build. [WARNING] [WARNING] For this reason, future Maven versions might no longer support building such malformed projects. [WARNING] Projects to build: [MavenProject: org.seasar.dao-codegen:codegen-lib:0.4.2.1-SNAPSHOT @ /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/pom.xml] projectStarted org.seasar.dao-codegen:codegen-lib:0.4.2.1-SNAPSHOT [INFO] [INFO] ------------------------------------------------------------------------ [INFO] Building codegen-lib 0.4.2.1-SNAPSHOT [INFO] ------------------------------------------------------------------------ mojoStarted org.apache.maven.plugins:maven-clean-plugin:2.4.1(default-clean) [INFO] [INFO] --- maven-clean-plugin:2.4.1:clean (default-clean) @ codegen-lib --- [INFO] Deleting /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/target mojoSucceeded org.apache.maven.plugins:maven-clean-plugin:2.4.1(default-clean) mojoStarted org.codehaus.mojo:build-helper-maven-plugin:1.2(add-test-source) [INFO] [INFO] --- build-helper-maven-plugin:1.2:add-test-source (add-test-source) @ codegen-lib --- [INFO] Test Source directory: /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/src/sample/java added. mojoSucceeded org.codehaus.mojo:build-helper-maven-plugin:1.2(add-test-source) mojoStarted org.apache.maven.plugins:maven-resources-plugin:2.5(default-resources) [INFO] [INFO] --- maven-resources-plugin:2.5:resources (default-resources) @ codegen-lib --- [debug] execute contextualize [WARNING] Using platform encoding (UTF-8 actually) to copy filtered resources, i.e. build is platform dependent! [INFO] Copying 4 resources mojoSucceeded org.apache.maven.plugins:maven-resources-plugin:2.5(default-resources) mojoStarted org.apache.maven.plugins:maven-compiler-plugin:2.3.2(default-compile) [INFO] [INFO] --- maven-compiler-plugin:2.3.2:compile (default-compile) @ codegen-lib --- [INFO] Compiling 25 source files to /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/target/classes mojoSucceeded org.apache.maven.plugins:maven-compiler-plugin:2.3.2(default-compile) mojoStarted org.apache.maven.plugins:maven-resources-plugin:2.5(default-testResources)[debug] execute contextualize [WARNING] Using platform encoding (UTF-8 actually) to copy filtered resources, i.e. build is platform dependent! [INFO] [INFO] --- maven-resources-plugin:2.5:testResources (default-testResources) @ codegen-lib --- [INFO] Copying 11 resources [INFO] Copying 1 resource [INFO] Copying 11 resources mojoSucceeded org.apache.maven.plugins:maven-resources-plugin:2.5(default-testResources) mojoStarted org.apache.maven.plugins:maven-compiler-plugin:2.3.2(default-testCompile) [INFO] [INFO] --- maven-compiler-plugin:2.3.2:testCompile (default-testCompile) @ codegen-lib --- [INFO] Compiling 44 source files to /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/target/test-classes mojoSucceeded org.apache.maven.plugins:maven-compiler-plugin:2.3.2(default-testCompile) mojoStarted org.apache.maven.plugins:maven-surefire-plugin:2.10(default-test) [INFO] [INFO] --- maven-surefire-plugin:2.10:test (default-test) @ codegen-lib --- [INFO] Surefire report directory: /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/target/surefire-reports ------------------------------------------------------- T E S T S ------------------------------------------------------- Running org.seasar.codegen.sample.dao.ShiftJISDaoTest DEBUG 2013-01-06 01:07:01,752 [main] BEGIN org.seasar.codegen.sample.dao.ShiftJISDao#selectByShiftJISFile() DEBUG 2013-01-06 01:07:02,177 [main] SELECT * FROM EMP_TABLE WHERE ENAME <> '文字列' DEBUG 2013-01-06 01:07:02,200 [main] END org.seasar.codegen.sample.dao.ShiftJISDao#selectByShiftJISFile() : [] Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.127 sec Running org.seasar.codegen.sample.dao.EmpTableDaoTest DEBUG 2013-01-06 01:07:03,595 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:03,595 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:03,646 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:03,649 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:03,650 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:03,655 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:03,682 [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 2013-01-06 01:07:03,693 [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 2013-01-06 01:07:03,698 [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 2013-01-06 01:07:03,703 [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 2013-01-06 01:07:03,704 [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 2013-01-06 01:07:03,708 [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 2013-01-06 01:07:03,713 [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 2013-01-06 01:07:03,718 [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 2013-01-06 01:07:03,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 2013-01-06 01:07:03,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 2013-01-06 01:07:03,730 [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 2013-01-06 01:07:03,731 [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 2013-01-06 01:07:03,733 [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 2013-01-06 01:07:03,734 [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 2013-01-06 01:07:03,743 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getAllEmpTable() DEBUG 2013-01-06 01:07:03,881 [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 2013-01-06 01:07:03,899 [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 2013-01-06 01:07:05,578 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:05,579 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:05,602 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:05,604 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:05,624 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:05,624 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:05,640 [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 2013-01-06 01:07:05,642 [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 2013-01-06 01:07:05,648 [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 2013-01-06 01:07:05,650 [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 2013-01-06 01:07:05,651 [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 2013-01-06 01:07:05,657 [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 2013-01-06 01:07:05,659 [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 2013-01-06 01:07:05,660 [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 2013-01-06 01:07:05,661 [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 2013-01-06 01:07:05,663 [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 2013-01-06 01:07:05,667 [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 2013-01-06 01:07:05,668 [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 2013-01-06 01:07:05,669 [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 2013-01-06 01:07:05,677 [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 2013-01-06 01:07:05,678 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7521) DEBUG 2013-01-06 01:07:05,697 [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 2013-01-06 01:07:05,699 [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 2013-01-06 01:07:05,993 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:05,994 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:06,010 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:06,017 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:06,017 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:06,018 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:06,033 [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 2013-01-06 01:07:06,035 [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 2013-01-06 01:07:06,038 [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 2013-01-06 01:07:06,044 [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 2013-01-06 01:07:06,045 [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 2013-01-06 01:07:06,047 [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 2013-01-06 01:07:06,048 [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 2013-01-06 01:07:06,049 [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 2013-01-06 01:07:06,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 2013-01-06 01:07:06,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 2013-01-06 01:07:06,056 [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 2013-01-06 01:07:06,062 [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 2013-01-06 01:07:06,064 [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 2013-01-06 01:07:06,065 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:06,066 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIds([7566, 7654]) DEBUG 2013-01-06 01:07:06,085 [main] SELECT EMP_TABLE.ENAME, EMP_TABLE.JOB, EMP_TABLE.MGR, EMP_TABLE.HIRE_DATE, EMP_TABLE.SAL, EMP_TABLE.COMM, EMP_TABLE.DEPT_NO, EMP_TABLE.VERSIONNO, EMP_TABLE.EMP_NO, EMP_TABLE.TSTAMP FROM EMP_TABLE WHERE EMP_NO in (7566, 7654) ORDER BY EMP_NO DEBUG 2013-01-06 01:07:06,091 [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 2013-01-06 01:07:06,386 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:06,386 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:06,396 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:06,397 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:06,398 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:06,398 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:06,414 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7369', 'SMITH', 'CLERK', '7902', '1980-12-17 00.00.00', '800', null, '20', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:06,421 [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 2013-01-06 01:07:06,422 [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 2013-01-06 01:07:06,423 [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 2013-01-06 01:07:06,424 [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 2013-01-06 01:07:06,425 [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 2013-01-06 01:07:06,432 [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 2013-01-06 01:07:06,433 [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 2013-01-06 01:07:06,434 [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 2013-01-06 01:07:06,435 [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 2013-01-06 01:07:06,436 [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 2013-01-06 01:07:06,437 [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 2013-01-06 01:07:06,438 [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 2013-01-06 01:07:06,443 [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 2013-01-06 01:07:06,444 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableWithRelation(7369) DEBUG 2013-01-06 01:07:06,475 [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 2013-01-06 01:07:06,485 [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 2013-01-06 01:07:06,947 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:06,947 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:06,956 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:06,956 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:06,956 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:06,965 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:06,986 [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 2013-01-06 01:07:06,987 [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 2013-01-06 01:07:06,988 [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 2013-01-06 01:07:06,988 [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 2013-01-06 01:07:06,989 [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 2013-01-06 01:07:06,994 [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 2013-01-06 01:07:07,004 [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 2013-01-06 01:07:07,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 2013-01-06 01:07:07,015 [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 2013-01-06 01:07:07,016 [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 2013-01-06 01:07:07,017 [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 2013-01-06 01:07:07,019 [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 2013-01-06 01:07:07,022 [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 2013-01-06 01:07:07,030 [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 2013-01-06 01:07:07,031 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#insert([/empNo=null/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 01:07:07 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]) DEBUG 2013-01-06 01:07:07,094 [main] CALL NEXTVAL('EMPNO') DEBUG 2013-01-06 01:07:07,107 [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 2013-01-06 01:07:07,108 [main] END org.seasar.codegen.sample.dao.EmpTableDao#insert([/empNo=null/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 01:07:07 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]) : 1 DEBUG 2013-01-06 01:07:07,122 [main] SELECT * FROM EMP_TABLE ORDER BY emp_no DEBUG 2013-01-06 01:07:07,615 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:07,615 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:07,627 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:07,628 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:07,629 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:07,630 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:07,650 [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 2013-01-06 01:07:07,652 [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 2013-01-06 01:07:07,653 [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 2013-01-06 01:07:07,655 [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 2013-01-06 01:07:07,656 [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 2013-01-06 01:07:07,663 [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 2013-01-06 01:07:07,664 [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 2013-01-06 01:07:07,665 [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 2013-01-06 01:07:07,666 [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 2013-01-06 01:07:07,667 [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 2013-01-06 01:07:07,674 [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 2013-01-06 01:07:07,675 [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 2013-01-06 01:07:07,676 [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 2013-01-06 01:07:07,677 [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 2013-01-06 01:07:07,678 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7369) DEBUG 2013-01-06 01:07:07,744 [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 2013-01-06 01:07:07,755 [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 2013-01-06 01:07:07,755 [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 2013-01-06 01:07:07,756 [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 2013-01-06 01:07:07,757 [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 2013-01-06 01:07:07,804 [main] SELECT * FROM emp_table ORDER BY emp_no DEBUG 2013-01-06 01:07:07,863 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7369' DEBUG 2013-01-06 01:07:07,872 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7499' DEBUG 2013-01-06 01:07:07,873 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7521' DEBUG 2013-01-06 01:07:07,874 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7566' DEBUG 2013-01-06 01:07:07,874 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7654' DEBUG 2013-01-06 01:07:07,875 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7698' DEBUG 2013-01-06 01:07:07,876 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7782' DEBUG 2013-01-06 01:07:07,885 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7788' DEBUG 2013-01-06 01:07:07,885 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7839' DEBUG 2013-01-06 01:07:07,886 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7844' DEBUG 2013-01-06 01:07:07,887 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7876' DEBUG 2013-01-06 01:07:07,896 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7900' DEBUG 2013-01-06 01:07:07,896 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7902' DEBUG 2013-01-06 01:07:07,897 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7934' DEBUG 2013-01-06 01:07:08,461 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:08,462 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:08,475 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:08,477 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:08,477 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:08,477 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:08,494 [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 2013-01-06 01:07:08,499 [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 2013-01-06 01:07:08,500 [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 2013-01-06 01:07:08,505 [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 2013-01-06 01:07:08,510 [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 2013-01-06 01:07:08,511 [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 2013-01-06 01:07:08,516 [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 2013-01-06 01:07:08,517 [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 2013-01-06 01:07:08,518 [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 2013-01-06 01:07:08,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 2013-01-06 01:07:08,524 [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 2013-01-06 01:07:08,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 2013-01-06 01:07:08,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 2013-01-06 01:07:08,530 [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 2013-01-06 01:07:08,530 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7369) DEBUG 2013-01-06 01:07:08,571 [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 2013-01-06 01:07:08,577 [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 2013-01-06 01:07:08,577 [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 2013-01-06 01:07:08,577 [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 2013-01-06 01:07:08,578 [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 2013-01-06 01:07:08,582 [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 2013-01-06 01:07:08,583 [main] UPDATE EMP_TABLE SET ENAME = null, VERSIONNO = 12 WHERE EMP_NO = 7369 AND VERSIONNO = 11 DEBUG 2013-01-06 01:07:08,583 [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 2013-01-06 01:07:09,136 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:09,136 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:09,150 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:09,150 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:09,151 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:09,151 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:09,172 [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 2013-01-06 01:07:09,173 [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 2013-01-06 01:07:09,174 [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 2013-01-06 01:07:09,175 [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 2013-01-06 01:07:09,185 [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 2013-01-06 01:07:09,186 [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 2013-01-06 01:07:09,187 [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 2013-01-06 01:07:09,188 [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 2013-01-06 01:07:09,189 [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 2013-01-06 01:07:09,189 [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 2013-01-06 01:07:09,190 [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 2013-01-06 01:07:09,200 [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 2013-01-06 01:07:09,201 [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 2013-01-06 01:07:09,205 [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 2013-01-06 01:07:09,210 [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 2013-01-06 01:07:09,251 [main] DELETE FROM EMP_TABLE WHERE EMP_NO = 7369 AND VERSIONNO = 1 DEBUG 2013-01-06 01:07:09,252 [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 2013-01-06 01:07:09,268 [main] SELECT * FROM emp_table ORDER BY emp_no DEBUG 2013-01-06 01:07:09,294 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7499' DEBUG 2013-01-06 01:07:09,301 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7521' DEBUG 2013-01-06 01:07:09,302 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7566' DEBUG 2013-01-06 01:07:09,302 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7654' DEBUG 2013-01-06 01:07:09,303 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7698' DEBUG 2013-01-06 01:07:09,304 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7782' DEBUG 2013-01-06 01:07:09,304 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7788' DEBUG 2013-01-06 01:07:09,305 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7839' DEBUG 2013-01-06 01:07:09,306 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7844' DEBUG 2013-01-06 01:07:09,306 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7876' DEBUG 2013-01-06 01:07:09,307 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7900' DEBUG 2013-01-06 01:07:09,307 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7902' DEBUG 2013-01-06 01:07:09,312 [main] SELECT EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO FROM EMP_TABLE WHERE EMP_NO = '7934' DEBUG 2013-01-06 01:07:09,855 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:09,856 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:09,867 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:09,878 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:09,879 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:09,879 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:09,892 [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 2013-01-06 01:07:09,894 [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 2013-01-06 01:07:09,903 [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 2013-01-06 01:07:09,904 [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 2013-01-06 01:07:09,905 [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 2013-01-06 01:07:09,905 [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 2013-01-06 01:07:09,911 [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 2013-01-06 01:07:09,915 [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 2013-01-06 01:07:09,916 [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 2013-01-06 01:07:09,916 [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 2013-01-06 01:07:09,921 [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 2013-01-06 01:07:09,921 [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 2013-01-06 01:07:09,925 [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 2013-01-06 01:07:09,930 [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 2013-01-06 01:07:09,962 [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 2013-01-06 01:07:10,018 [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 2013-01-06 01:07:10,027 [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 2013-01-06 01:07:10,412 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:10,413 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:10,416 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:10,417 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:10,417 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:10,418 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:10,429 [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 2013-01-06 01:07:10,430 [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 2013-01-06 01:07:10,431 [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 2013-01-06 01:07:10,438 [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 2013-01-06 01:07:10,439 [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 2013-01-06 01:07:10,440 [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 2013-01-06 01:07:10,441 [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 2013-01-06 01:07:10,441 [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 2013-01-06 01:07:10,442 [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 2013-01-06 01:07:10,444 [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 2013-01-06 01:07:10,445 [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 2013-01-06 01:07:10,452 [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 2013-01-06 01:07:10,453 [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 2013-01-06 01:07:10,455 [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 2013-01-06 01:07:10,456 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#find(/EMP_TABLE.EMP_NO<>7500/offset=0/limit=-1) DEBUG 2013-01-06 01:07:10,484 [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 2013-01-06 01:07:10,494 [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 2013-01-06 01:07:10,841 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:10,842 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:10,844 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:10,851 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:10,852 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:10,852 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:10,870 [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 2013-01-06 01:07:10,872 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:10,873 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:10,874 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:10,874 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:10,875 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:10,876 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7782', 'CLARK', 'MANAGER', '7839', '1981-06-09 00.00.00', '2450', null, '10', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:10,884 [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 2013-01-06 01:07:10,884 [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 2013-01-06 01:07:10,885 [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 2013-01-06 01:07:10,886 [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 2013-01-06 01:07:10,887 [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 2013-01-06 01:07:10,887 [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 2013-01-06 01:07:10,888 [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 2013-01-06 01:07:10,890 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#find(/offset=0/limit=-1) DEBUG 2013-01-06 01:07:10,918 [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 2013-01-06 01:07:10,924 [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 2013-01-06 01:07:11,349 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:11,350 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:11,353 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:11,353 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:11,354 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:11,354 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:11,358 [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 2013-01-06 01:07:11,360 [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 2013-01-06 01:07:11,361 [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 2013-01-06 01:07:11,367 [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 2013-01-06 01:07:11,368 [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 2013-01-06 01:07:11,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 2013-01-06 01:07:11,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 2013-01-06 01:07:11,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 2013-01-06 01:07:11,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 2013-01-06 01:07:11,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 2013-01-06 01:07:11,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 2013-01-06 01:07:11,379 [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 2013-01-06 01:07:11,380 [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 2013-01-06 01:07:11,381 [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 2013-01-06 01:07:11,383 [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<>2013-01-06 01:07:11.383/EMP_TABLE.VERSIONNOnot in1/EMP_TABLE.EMP_NOnot in99/offset=0/limit=-1) DEBUG 2013-01-06 01:07:11,430 [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 <>'2013-01-06 01.07.11' AND EMP_TABLE.VERSIONNO not in(1) AND EMP_TABLE.EMP_NO not in(99) DEBUG 2013-01-06 01:07:11,432 [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<>2013-01-06 01:07:11.383/EMP_TABLE.VERSIONNOnot in1/EMP_TABLE.EMP_NOnot in99/offset=0/limit=-1) : [] DEBUG 2013-01-06 01:07:11,795 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:11,796 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:11,800 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:11,800 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:11,801 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:11,802 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:11,807 [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 2013-01-06 01:07:11,808 [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 2013-01-06 01:07:11,809 [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 2013-01-06 01:07:11,810 [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 2013-01-06 01:07:11,811 [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 2013-01-06 01:07:11,812 [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 2013-01-06 01:07:11,813 [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 2013-01-06 01:07:11,814 [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 2013-01-06 01:07:11,815 [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 2013-01-06 01:07:11,816 [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 2013-01-06 01:07:11,817 [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 2013-01-06 01:07:11,818 [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 2013-01-06 01:07:11,826 [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 2013-01-06 01:07:11,827 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1) /EMP_TABLE.EMP_NO>=7934/EMP_TABLE.HIRE_DATE>Mon Jan 01 00:00:00 JST 1900/offset=0/limit=-1 DEBUG 2013-01-06 01:07:11,835 [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 2013-01-06 01:07:11,873 [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 2013-01-06 01:07:11,877 [main] END org.seasar.codegen.sample.dao.EmpTableDao#soleMatch(/EMP_TABLE.EMP_NO>=7934/EMP_TABLE.HIRE_DATE>Mon Jan 01 00:00:00 JST 1900/offset=0/limit=-1) : [/empNo=7934/ename=MILLER/job=CLERK/mgr=7782/hireDate=1982-01-23 00:00:00.0/sal=1300/comm=null/deptNo=10/tstamp=2000-01-01 00:00:00.0/versionno=1] /ORDER BY EMP_TABLE.EMP_NO ,EMP_TABLE.DEPT_NO DESC/offset=0/limit=-1 DEBUG 2013-01-06 01:07:12,352 [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 2013-01-06 01:07:12,445 [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 2013-01-06 01:07:12,455 [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 2013-01-06 01:07:12,896 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#findWithRelation(/deptTableEntity.LOC=DALLAS/offset=0/limit=-1) DEBUG 2013-01-06 01:07:12,974 [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 2013-01-06 01:07:12,978 [main] END org.seasar.codegen.sample.dao.EmpTableDao#findWithRelation(/deptTableEntity.LOC=DALLAS/offset=0/limit=-1) : [] DEBUG 2013-01-06 01:07:13,487 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:13,487 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:13,490 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:13,495 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:13,495 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:13,496 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:13,499 [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 2013-01-06 01:07:13,506 [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 2013-01-06 01:07:13,507 [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 2013-01-06 01:07:13,511 [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 2013-01-06 01:07:13,512 [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 2013-01-06 01:07:13,512 [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 2013-01-06 01:07:13,513 [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 2013-01-06 01:07:13,520 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7788', 'SCOTT', 'ANALYST', '7566', '1982-12-09 00.00.00', '3000.0', null, '20', '2005-01-18 13.09.32', 1) DEBUG 2013-01-06 01:07:13,521 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7839', 'KING', 'PRESIDENT', null, '1981-11-17 00.00.00', '5000', null, '10', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:13,521 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:13,522 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7876', 'ADAMS', 'CLERK', '7788', '1983-01-12 00.00.00', '1100', null, '20', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:13,523 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7900', 'JAMES', 'CLERK', '7698', '1981-12-03 00.00.00', '950', null, '30', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:13,524 [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 2013-01-06 01:07:13,526 [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 2013-01-06 01:07:13,527 [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 2013-01-06 01:07:13,564 [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 2013-01-06 01:07:13,569 [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 2013-01-06 01:07:13,577 [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 2013-01-06 01:07:13,989 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:13,989 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:13,993 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:14,003 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:14,003 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:14,003 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:14,016 [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 2013-01-06 01:07:14,017 [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 2013-01-06 01:07:14,018 [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 2013-01-06 01:07:14,027 [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 2013-01-06 01:07:14,028 [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 2013-01-06 01:07:14,028 [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 2013-01-06 01:07:14,029 [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 2013-01-06 01:07:14,034 [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 2013-01-06 01:07:14,034 [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 2013-01-06 01:07:14,035 [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 2013-01-06 01:07:14,036 [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 2013-01-06 01:07:14,037 [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 2013-01-06 01:07:14,041 [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 2013-01-06 01:07:14,047 [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 2013-01-06 01:07:14,047 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTable(7654) DEBUG 2013-01-06 01:07:14,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 = 7654 DEBUG 2013-01-06 01:07:14,072 [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 2013-01-06 01:07:14,073 [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 2013-01-06 01:07:14,073 [main] UPDATE EMP_TABLE SET ENAME = 'せとあずさ', VERSIONNO = 2 WHERE EMP_NO = 7654 AND VERSIONNO = 1 DEBUG 2013-01-06 01:07:14,074 [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 2013-01-06 01:07:14,391 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:14,391 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:14,394 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:14,403 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:14,403 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:14,403 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:14,407 [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 2013-01-06 01:07:14,408 [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 2013-01-06 01:07:14,414 [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 2013-01-06 01:07:14,416 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7566', 'JONES', 'MANAGER', '7839', '1981-04-02 00.00.00', '2975', null, '20', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:14,416 [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 2013-01-06 01:07:14,417 [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 2013-01-06 01:07:14,418 [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 2013-01-06 01:07:14,419 [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 2013-01-06 01:07:14,419 [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 2013-01-06 01:07:14,421 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:14,421 [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 2013-01-06 01:07:14,424 [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 2013-01-06 01:07:14,425 [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 2013-01-06 01:07:14,427 [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 2013-01-06 01:07:14,427 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#insertBatch([[/empNo=9990/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 01:07:14 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=9991/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 01:07:14 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) DEBUG 2013-01-06 01:07:14,455 [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 2013-01-06 01:07:14,455 [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 2013-01-06 01:07:14,463 [main] END org.seasar.codegen.sample.dao.EmpTableDao#insertBatch([[/empNo=9990/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 01:07:14 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=9991/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 01:07:14 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) : [1, 1] DEBUG 2013-01-06 01:07:14,464 [main] SELECT * FROM EMP_TABLE ORDER BY emp_no DEBUG 2013-01-06 01:07:14,926 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:14,926 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:14,929 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:14,930 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:14,930 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:14,939 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:14,943 [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 2013-01-06 01:07:14,952 [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 2013-01-06 01:07:14,953 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:14,953 [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 2013-01-06 01:07:14,954 [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 2013-01-06 01:07:14,955 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7698', 'BLAKE', 'MANAGER', '7839', '1981-05-01 00.00.00', '2850', null, '30', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:14,955 [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 2013-01-06 01:07:14,964 [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 2013-01-06 01:07:14,965 [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 2013-01-06 01:07:14,965 [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 2013-01-06 01:07:14,966 [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 2013-01-06 01:07:14,967 [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 2013-01-06 01:07:14,972 [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 2013-01-06 01:07:14,977 [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 2013-01-06 01:07:14,978 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#updateBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 01:07:14 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=7499/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 01:07:14 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) DEBUG 2013-01-06 01:07:15,015 [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 2013-01-06 01:07:15,015 [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 2013-01-06 01:07:15,016 [main] END org.seasar.codegen.sample.dao.EmpTableDao#updateBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 01:07:14 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=7499/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 01:07:14 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) : [0, 0] DEBUG 2013-01-06 01:07:15,365 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:15,366 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:15,368 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:15,369 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:15,369 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:15,370 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:15,373 [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 2013-01-06 01:07:15,377 [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 2013-01-06 01:07:15,378 [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 2013-01-06 01:07:15,378 [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 2013-01-06 01:07:15,379 [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 2013-01-06 01:07:15,382 [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 2013-01-06 01:07:15,383 [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 2013-01-06 01:07:15,383 [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 2013-01-06 01:07:15,384 [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 2013-01-06 01:07:15,384 [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 2013-01-06 01:07:15,396 [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 2013-01-06 01:07:15,396 [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 2013-01-06 01:07:15,398 [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 2013-01-06 01:07:15,398 [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 2013-01-06 01:07:15,400 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#deleteBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 01:07:15 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=7499/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 01:07:15 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) DEBUG 2013-01-06 01:07:15,438 [main] DELETE FROM EMP_TABLE WHERE EMP_NO = 7369 AND VERSIONNO = null DEBUG 2013-01-06 01:07:15,438 [main] DELETE FROM EMP_TABLE WHERE EMP_NO = 7499 AND VERSIONNO = null DEBUG 2013-01-06 01:07:15,438 [main] END org.seasar.codegen.sample.dao.EmpTableDao#deleteBatch([[/empNo=7369/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 01:07:15 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null], [/empNo=7499/ename=せとあずさ/job=MANAGER/mgr=7902/hireDate=Wed Nov 01 01:07:15 JST 2006/sal=10000/comm=1000/deptNo=10/tstamp=null/versionno=null]]) : [0, 0] DEBUG 2013-01-06 01:07:15,445 [main] SELECT * FROM EMP_TABLE ORDER BY emp_no DEBUG 2013-01-06 01:07:15,828 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:15,828 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:15,831 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:15,840 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:15,840 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:15,840 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:15,854 [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 2013-01-06 01:07:15,855 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7499', 'ALLEN', 'SALESMAN', '7698', '1981-02-20 00.00.00', '1600', '300', '30', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:15,856 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7521', 'WARD', 'SALESMAN', '7698', '1981-02-22 00.00.00', '1250', '500', '30', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:15,857 [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 2013-01-06 01:07:15,857 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7654', 'MARTIN', 'SALESMAN', '7698', '1981-09-28 00.00.00', '1250', '1400', '30', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:15,864 [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 2013-01-06 01:07:15,864 [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 2013-01-06 01:07:15,865 [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 2013-01-06 01:07:15,866 [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 2013-01-06 01:07:15,876 [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 2013-01-06 01:07:15,877 [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 2013-01-06 01:07:15,877 [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 2013-01-06 01:07:15,878 [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 2013-01-06 01:07:15,879 [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 2013-01-06 01:07:15,883 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#findWithRelation(/offset=0/limit=-1) DEBUG 2013-01-06 01:07:15,919 [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 2013-01-06 01:07:15,931 [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 2013-01-06 01:07:15,937 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableWithRelation(7369) DEBUG 2013-01-06 01:07:15,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, 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 2013-01-06 01:07:15,940 [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 2013-01-06 01:07:15,947 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIdsWithRelation([7566, 7654]) DEBUG 2013-01-06 01:07:15,948 [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 2013-01-06 01:07:15,949 [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 2013-01-06 01:07:15,950 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getEmpTableByIdsWithRelation([7566, 7654]) DEBUG 2013-01-06 01:07:15,950 [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 2013-01-06 01:07:15,953 [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 2013-01-06 01:07:15,961 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#soleMatchWithRelation(/EMP_TABLE.EMP_NO=7654/offset=0/limit=-1) DEBUG 2013-01-06 01:07:15,962 [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 2013-01-06 01:07:15,963 [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 2013-01-06 01:07:15,963 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#getAllEmpTableWithRelation() DEBUG 2013-01-06 01:07:15,963 [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 2013-01-06 01:07:15,971 [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 2013-01-06 01:07:16,311 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#selectByUtf8SqlFile() DEBUG 2013-01-06 01:07:16,398 [main] SELECT * FROM EMP_TABLE WHERE ENAME <> '文字列' DEBUG 2013-01-06 01:07:16,399 [main] END org.seasar.codegen.sample.dao.EmpTableDao#selectByUtf8SqlFile() : [] DEBUG 2013-01-06 01:07:16,705 [main] DELETE FROM EMP_TABLE DEBUG 2013-01-06 01:07:16,705 [main] DELETE FROM DEPT_TABLE DEBUG 2013-01-06 01:07:16,709 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('10', 'ACCOUNTING', 'NEW YORK', '0', '1') DEBUG 2013-01-06 01:07:16,717 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('20', 'RESEARCH', 'DALLAS', '0', '1') DEBUG 2013-01-06 01:07:16,718 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('30', 'SALES', 'CHICAGO', '0', '1') DEBUG 2013-01-06 01:07:16,719 [main] INSERT INTO DEPT_TABLE (DEPT_ID, DNAME, LOC, VERSIONNO, ACTIVE) VALUES ('40', 'OPERATIONS', 'BOSTON', '0', '1') DEBUG 2013-01-06 01:07:16,722 [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 2013-01-06 01:07:16,731 [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 2013-01-06 01:07:16,732 [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 2013-01-06 01:07:16,733 [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 2013-01-06 01:07:16,733 [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 2013-01-06 01:07:16,741 [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 2013-01-06 01:07:16,742 [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 2013-01-06 01:07:16,742 [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 2013-01-06 01:07:16,745 [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 2013-01-06 01:07:16,746 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7844', 'TURNER', 'SALESMAN', '7698', '1981-09-08 00.00.00', '1500', '0', '30', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:16,752 [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 2013-01-06 01:07:16,753 [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 2013-01-06 01:07:16,758 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7902', 'FORD', 'ANALYST', '7566', '1981-12-03 00.00.00', '3000', null, '20', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:16,758 [main] INSERT INTO EMP_TABLE (EMP_NO, ENAME, JOB, MGR, HIRE_DATE, SAL, COMM, DEPT_NO, TSTAMP, VERSIONNO) VALUES ('7934', 'MILLER', 'CLERK', '7782', '1982-01-23 00.00.00', '1300', null, '10', '2000-01-01 00.00.00', 1) DEBUG 2013-01-06 01:07:16,759 [main] BEGIN org.seasar.codegen.sample.dao.EmpTableDao#select(org.seasar.codegen.sample.dao.EmpTableDaoTest$1@1f517997) DEBUG 2013-01-06 01:07:16,793 [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 2013-01-06 01:07:16,799 [main] END org.seasar.codegen.sample.dao.EmpTableDao#select(org.seasar.codegen.sample.dao.EmpTableDaoTest$1@1f517997) : 1 Tests run: 23, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 14.57 sec Running org.seasar.codegen.sample.dao.NoPkDaoTest DEBUG 2013-01-06 01:07:16,919 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト]) DEBUG 2013-01-06 01:07:16,965 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (1, 'テスト') DEBUG 2013-01-06 01:07:16,966 [main] END org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト]) : 1 DEBUG 2013-01-06 01:07:17,344 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト]) DEBUG 2013-01-06 01:07:17,385 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (1, 'テスト') DEBUG 2013-01-06 01:07:17,386 [main] END org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=1/col2=テスト]) : 1 DEBUG 2013-01-06 01:07:17,386 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=2/col2=テスト2]) DEBUG 2013-01-06 01:07:17,386 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (2, 'テスト2') DEBUG 2013-01-06 01:07:17,386 [main] END org.seasar.codegen.sample.dao.NoPkDao#insert([/col1=2/col2=テスト2]) : 1 DEBUG 2013-01-06 01:07:17,392 [main] BEGIN org.seasar.codegen.sample.dao.NoPkDao#insertBatch([[/col1=1/col2=テスト], [/col1=2/col2=テスト2]]) DEBUG 2013-01-06 01:07:17,393 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (1, 'テスト') DEBUG 2013-01-06 01:07:17,393 [main] INSERT INTO NO_PK (COL_1, COL_2) VALUES (2, 'テスト2') DEBUG 2013-01-06 01:07:17,393 [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.578 sec Running org.seasar.codegen.lib.internal.impl.FindSqlCommandTest DEBUG 2013-01-06 01:07:17,508 [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 2013-01-06 01:07:17,654 [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: 1.317 sec Running org.seasar.codegen.lib.internal.impl.CodeGenDaoMetaDataImplTest Tests run: 14, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 2.449 sec Running org.seasar.codegen.lib.internal.impl.FromToOptionTest Tests run: 2, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.001 sec Running org.seasar.codegen.lib.impl.StringConditionElementImplTest Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.008 sec Running org.seasar.codegen.lib.impl.ConditionResultImplTest Tests run: 4, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.009 sec Running org.seasar.codegen.lib.impl.DateConditionElementImplTest Tests run: 3, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.006 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.009 sec Running org.seasar.codegen.unit.AbstractCodeGenExtensionTestCase DEBUG 2013-01-06 01:07:21,297 [main] SELECT * FROM DEPT_TABLE ORDER BY dept_id DEBUG 2013-01-06 01:07:21,409 [main] SELECT * FROM DEPT_TABLE ORDER BY dept_id DEBUG 2013-01-06 01:07:21,418 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 10 DEBUG 2013-01-06 01:07:21,418 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 20 DEBUG 2013-01-06 01:07:21,418 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 30 DEBUG 2013-01-06 01:07:21,422 [main] SELECT dept_id, dname, loc, versionno, active FROM dept_TABLE WHERE dept_id = 60 DEBUG 2013-01-06 01:07:21,521 [main] SELECT * FROM DEPT_TABLE ORDER BY dept_id DEBUG 2013-01-06 01:07:21,528 [main] SELECT dept_id, dname, loc, versionno, active FROM DEPT_TABLE WHERE dept_id = 10 DEBUG 2013-01-06 01:07:21,529 [main] SELECT dept_id, dname, loc, versionno, active FROM DEPT_TABLE WHERE dept_id = 20 DEBUG 2013-01-06 01:07:21,529 [main] SELECT dept_id, dname, loc, versionno, active FROM DEPT_TABLE WHERE dept_id = 30 DEBUG 2013-01-06 01:07:21,529 [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.31 sec Running org.seasar.codegen.unit.AbstractXlsWriterExtTestCase Tests run: 1, Failures: 0, Errors: 0, Skipped: 0, Time elapsed: 0.078 sec Results : Tests run: 81, Failures: 0, Errors: 0, Skipped: 0 mojoSucceeded org.apache.maven.plugins:maven-surefire-plugin:2.10(default-test) [JENKINS] テスト結果の記録 mojoStarted org.apache.maven.plugins:maven-jar-plugin:2.3.2(default-jar) [INFO] [INFO] --- maven-jar-plugin:2.3.2:jar (default-jar) @ codegen-lib --- [INFO] Building jar: /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/target/codegen-lib-0.4.2.1-SNAPSHOT.jar mojoSucceeded org.apache.maven.plugins:maven-jar-plugin:2.3.2(default-jar) forkedProjectStarted org.seasar.dao-codegen:codegen-lib:0.4.2.1-SNAPSHOT mojoStarted org.codehaus.mojo:build-helper-maven-plugin:1.2(add-test-source) [INFO] [INFO] --- build-helper-maven-plugin:1.2:add-test-source (add-test-source) @ codegen-lib --- [INFO] Test Source directory: /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/src/sample/java added. mojoSucceeded org.codehaus.mojo:build-helper-maven-plugin:1.2(add-test-source) forkedProjectSucceeded org.seasar.dao-codegen:codegen-lib:0.4.2.1-SNAPSHOT 2013/01/06 1:07:26 hudson.maven.ExecutedMojo <init> 警告: Failed to getClass for org.apache.maven.plugin.source.SourceJarMojo mojoStarted org.apache.maven.plugins:maven-source-plugin:2.2.1(source-jar) [INFO] [INFO] --- maven-source-plugin:2.2.1:jar (source-jar) @ codegen-lib --- [INFO] Building jar: /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/target/codegen-lib-0.4.2.1-SNAPSHOT-sources.jar mojoSucceeded org.apache.maven.plugins:maven-source-plugin:2.2.1(source-jar) mojoStarted org.apache.maven.plugins:maven-install-plugin:2.3.1(default-install) [INFO] [INFO] --- maven-install-plugin:2.3.1:install (default-install) @ codegen-lib --- [INFO] Installing /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/target/codegen-lib-0.4.2.1-SNAPSHOT.jar to /home/services/jenkins/.m2/repository/org/seasar/dao-codegen/codegen-lib/0.4.2.1-SNAPSHOT/codegen-lib-0.4.2.1-SNAPSHOT.jar [INFO] Installing /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/pom.xml to /home/services/jenkins/.m2/repository/org/seasar/dao-codegen/codegen-lib/0.4.2.1-SNAPSHOT/codegen-lib-0.4.2.1-SNAPSHOT.pom [INFO] Installing /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/target/codegen-lib-0.4.2.1-SNAPSHOT-sources.jar to /home/services/jenkins/.m2/repository/org/seasar/dao-codegen/codegen-lib/0.4.2.1-SNAPSHOT/codegen-lib-0.4.2.1-SNAPSHOT-sources.jar mojoSucceeded org.apache.maven.plugins:maven-install-plugin:2.3.1(default-install) projectSucceeded org.seasar.dao-codegen:codegen-lib:0.4.2.1-SNAPSHOT sessionEnded [INFO] ------------------------------------------------------------------------ [INFO] BUILD SUCCESS [INFO] ------------------------------------------------------------------------ [INFO] Total time: 38.225s [INFO] Finished at: Sun Jan 06 01:07:28 JST 2013 [INFO] Final Memory: 18M/234M [INFO] ------------------------------------------------------------------------ Projects to build: [MavenProject: org.seasar.dao-codegen:codegen-lib:0.4.2.1-SNAPSHOT @ /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/pom.xml] [JENKINS] Archiving /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/pom.xml to /home/services/jenkins/jobs/codegen-lib/modules/org.seasar.dao-codegen$codegen-lib/builds/2013-01-06_01-06-43/archive/org.seasar.dao-codegen/codegen-lib/0.4.2.1-SNAPSHOT/codegen-lib-0.4.2.1-SNAPSHOT.pom [JENKINS] Archiving /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/target/codegen-lib-0.4.2.1-SNAPSHOT.jar to /home/services/jenkins/jobs/codegen-lib/modules/org.seasar.dao-codegen$codegen-lib/builds/2013-01-06_01-06-43/archive/org.seasar.dao-codegen/codegen-lib/0.4.2.1-SNAPSHOT/codegen-lib-0.4.2.1-SNAPSHOT.jar [JENKINS] Archiving /home/services/jenkins/jobs/codegen-lib/workspace/codegen-lib/target/codegen-lib-0.4.2.1-SNAPSHOT-sources.jar to /home/services/jenkins/jobs/codegen-lib/modules/org.seasar.dao-codegen$codegen-lib/builds/2013-01-06_01-06-43/archive/org.seasar.dao-codegen/codegen-lib/0.4.2.1-SNAPSHOT/codegen-lib-0.4.2.1-SNAPSHOT-sources.jar channel stopped Finished: SUCCESS