SpringBoot05 数据操作03 -> JPA查询方法的规则定义
请参见《springboot详解》springjpa部分知识
1 按照方法命名来进行查询
待更新...
package cn.xiangxu.springboot.repository; import cn.xiangxu.springboot.entity.dataObject.Girl; import org.springframework.data.jpa.repository.JpaRepository; import java.util.List; public interface GirlRepository extends JpaRepository<Girl, Integer> { // where name like ?% and age < ? public List<Girl> findByNameStartingWithAndAgeLessThan(String name, Integer age); }
弊端：方法名很长而且对于复杂的查询很难实现
2 利用@Query注解实现复杂查询
可以利用实体对象进行查询，也可以利用原生的SQL语句进行查询；利用原生的SQL语句进行查询时需要设置nativeQuery的值为True
2.1 利用实体类进行查询
@Query("select g from Girl g where id = (select max(id) from Girl g1)") // 利用实体类进行查询，可以用别名代替*
Girl findByMaxId();
2.2 利用原生SQL语句进行查询
@Query(nativeQuery = true, value = "select * from girl g") // 利用原生的SQL进行查询，不能用别名代替* List<Girl> findAllGirl();
2.3 利用索引参数进行查询
@Query(nativeQuery = true, value = "select * from girl o where o.girl_id=?1 ") // 索引参数 Girl findOneById(Integer id);
2.4 利用命名参数进行查询
@Query(value = "select o from Girl o where o.id=:id") // 命名参数 Girl findGirlById02(@Param("id") Integer girlId);
// // Source code recreated from a .class file by IntelliJ IDEA // (powered by Fernflower decompiler) // package org.springframework.data.jpa.repository; import java.lang.annotation.Documented; import java.lang.annotation.ElementType; import java.lang.annotation.Retention; import java.lang.annotation.RetentionPolicy; import java.lang.annotation.Target; import org.springframework.data.annotation.QueryAnnotation; @Retention(RetentionPolicy.RUNTIME) @Target({ElementType.METHOD, ElementType.ANNOTATION_TYPE}) @QueryAnnotation @Documented public @interface Query { String value() default ""; String countQuery() default ""; String countProjection() default ""; boolean nativeQuery() default false; String name() default ""; String countName() default ""; }
知识点总汇：点击前往
3 利用@Modifying实现更新操作
在进行更新操作时必须添加这个注解
3.1 不添加该注解时的报错信息
C:\tool\jdk8\bin\java -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:C:\tool\IntelliJ IDEA 2017.2.5\lib\idea_rt.jar=51226:C:\tool\IntelliJ IDEA 2017.2.5\bin" -Dfile.encoding=UTF-8 -classpath "C:\tool\IntelliJ IDEA 2017.2.5\lib\idea_rt.jar;C:\tool\IntelliJ IDEA 2017.2.5\plugins\junit\lib\junit-rt.jar;C:\tool\IntelliJ IDEA 2017.2.5\plugins\junit\lib\junit5-rt.jar;C:\tool\jdk8\jre\lib\charsets.jar;C:\tool\jdk8\jre\lib\deploy.jar;C:\tool\jdk8\jre\lib\ext\access-bridge-64.jar;C:\tool\jdk8\jre\lib\ext\cldrdata.jar;C:\tool\jdk8\jre\lib\ext\dnsns.jar;C:\tool\jdk8\jre\lib\ext\jaccess.jar;C:\tool\jdk8\jre\lib\ext\jfxrt.jar;C:\tool\jdk8\jre\lib\ext\localedata.jar;C:\tool\jdk8\jre\lib\ext\nashorn.jar;C:\tool\jdk8\jre\lib\ext\sunec.jar;C:\tool\jdk8\jre\lib\ext\sunjce_provider.jar;C:\tool\jdk8\jre\lib\ext\sunmscapi.jar;C:\tool\jdk8\jre\lib\ext\sunpkcs11.jar;C:\tool\jdk8\jre\lib\ext\zipfs.jar;C:\tool\jdk8\jre\lib\javaws.jar;C:\tool\jdk8\jre\lib\jce.jar;C:\tool\jdk8\jre\lib\jfr.jar;C:\tool\jdk8\jre\lib\jfxswt.jar;C:\tool\jdk8\jre\lib\jsse.jar;C:\tool\jdk8\jre\lib\management-agent.jar;C:\tool\jdk8\jre\lib\plugin.jar;C:\tool\jdk8\jre\lib\resources.jar;C:\tool\jdk8\jre\lib\rt.jar;F:\javaProgramming\springBoot\springbootTest\target\test-classes;F:\javaProgramming\springBoot\springbootTest\target\classes;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-web\1.5.8.RELEASE\spring-boot-starter-web-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter\1.5.8.RELEASE\spring-boot-starter-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot\1.5.8.RELEASE\spring-boot-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-autoconfigure\1.5.8.RELEASE\spring-boot-autoconfigure-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-logging\1.5.8.RELEASE\spring-boot-starter-logging-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\ch\qos\logback\logback-classic\1.1.11\logback-classic-1.1.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\ch\qos\logback\logback-core\1.1.11\logback-core-1.1.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\jul-to-slf4j\1.7.25\jul-to-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\log4j-over-slf4j\1.7.25\log4j-over-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\yaml\snakeyaml\1.17\snakeyaml-1.17.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-tomcat\1.5.8.RELEASE\spring-boot-starter-tomcat-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-core\8.5.23\tomcat-embed-core-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-annotations-api\8.5.23\tomcat-annotations-api-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-el\8.5.23\tomcat-embed-el-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.23\tomcat-embed-websocket-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-validator\5.3.5.Final\hibernate-validator-5.3.5.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\javax\validation\validation-api\1.1.0.Final\validation-api-1.1.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\jboss\logging\jboss-logging\3.3.1.Final\jboss-logging-3.3.1.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\classmate\1.3.4\classmate-1.3.4.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-databind\2.8.10\jackson-databind-2.8.10.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-annotations\2.8.0\jackson-annotations-2.8.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-core\2.8.10\jackson-core-2.8.10.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-web\4.3.12.RELEASE\spring-web-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-aop\4.3.12.RELEASE\spring-aop-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-beans\4.3.12.RELEASE\spring-beans-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-context\4.3.12.RELEASE\spring-context-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-webmvc\4.3.12.RELEASE\spring-webmvc-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-expression\4.3.12.RELEASE\spring-expression-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-test\1.5.8.RELEASE\spring-boot-starter-test-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-test\1.5.8.RELEASE\spring-boot-test-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-test-autoconfigure\1.5.8.RELEASE\spring-boot-test-autoconfigure-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\jayway\jsonpath\json-path\2.2.0\json-path-2.2.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\net\minidev\json-smart\2.2.1\json-smart-2.2.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\net\minidev\accessors-smart\1.1\accessors-smart-1.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\ow2\asm\asm\5.0.3\asm-5.0.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\slf4j-api\1.7.25\slf4j-api-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\junit\junit\4.12\junit-4.12.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\assertj\assertj-core\2.6.0\assertj-core-2.6.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\mockito\mockito-core\1.10.19\mockito-core-1.10.19.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\objenesis\objenesis\2.1\objenesis-2.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hamcrest\hamcrest-library\1.3\hamcrest-library-1.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\skyscreamer\jsonassert\1.4.0\jsonassert-1.4.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\vaadin\external\google\android-json\0.0.20131108.vaadin1\android-json-0.0.20131108.vaadin1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-core\4.3.12.RELEASE\spring-core-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-test\4.3.12.RELEASE\spring-test-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\mysql\mysql-connector-java\5.1.44\mysql-connector-java-5.1.44.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-data-jpa\1.5.8.RELEASE\spring-boot-starter-data-jpa-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-aop\1.5.8.RELEASE\spring-boot-starter-aop-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\aspectj\aspectjweaver\1.8.11\aspectjweaver-1.8.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-jdbc\1.5.8.RELEASE\spring-boot-starter-jdbc-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-jdbc\8.5.23\tomcat-jdbc-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-juli\8.5.23\tomcat-juli-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-jdbc\4.3.12.RELEASE\spring-jdbc-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-core\5.0.12.Final\hibernate-core-5.0.12.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\javax\persistence\hibernate-jpa-2.1-api\1.0.0.Final\hibernate-jpa-2.1-api-1.0.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\javassist\javassist\3.21.0-GA\javassist-3.21.0-GA.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\antlr\antlr\2.7.7\antlr-2.7.7.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\jboss\jandex\2.0.0.Final\jandex-2.0.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\dom4j\dom4j\1.6.1\dom4j-1.6.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\common\hibernate-commons-annotations\5.0.1.Final\hibernate-commons-annotations-5.0.1.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-entitymanager\5.0.12.Final\hibernate-entitymanager-5.0.12.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\javax\transaction\javax.transaction-api\1.2\javax.transaction-api-1.2.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\data\spring-data-jpa\1.11.8.RELEASE\spring-data-jpa-1.11.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\data\spring-data-commons\1.13.8.RELEASE\spring-data-commons-1.13.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-orm\4.3.12.RELEASE\spring-orm-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-tx\4.3.12.RELEASE\spring-tx-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\jcl-over-slf4j\1.7.25\jcl-over-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-aspects\4.3.12.RELEASE\spring-aspects-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\alibaba\druid\1.0.19\druid-1.0.19.jar;C:\tool\jdk8\lib\jconsole.jar;C:\tool\jdk8\lib\tools.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\projectlombok\lombok\1.16.18\lombok-1.16.18.jar" com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 -junit4 cn.xiangxu.springboot.repository.GirlRepositoryTest,updateAgeById 22:01:20.542 [main] DEBUG org.springframework.test.context.junit4.SpringJUnit4ClassRunner - SpringJUnit4ClassRunner constructor called with [class cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:01:20.549 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating CacheAwareContextLoaderDelegate from class [org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate] 22:01:20.563 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating BootstrapContext using constructor [public org.springframework.test.context.support.DefaultBootstrapContext(java.lang.Class,org.springframework.test.context.CacheAwareContextLoaderDelegate)] 22:01:20.589 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating TestContextBootstrapper for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest] from class [org.springframework.boot.test.context.SpringBootTestContextBootstrapper] 22:01:20.611 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Neither @ContextConfiguration nor @ContextHierarchy found for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest], using SpringBootContextLoader 22:01:20.617 [main] DEBUG org.springframework.test.context.support.AbstractContextLoader - Did not detect default resource location for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest]: class path resource [cn/xiangxu/springboot/repository/GirlRepositoryTest-context.xml] does not exist 22:01:20.618 [main] DEBUG org.springframework.test.context.support.AbstractContextLoader - Did not detect default resource location for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest]: class path resource [cn/xiangxu/springboot/repository/GirlRepositoryTestContext.groovy] does not exist 22:01:20.618 [main] INFO org.springframework.test.context.support.AbstractContextLoader - Could not detect default resource locations for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest]: no resource found for suffixes {-context.xml, Context.groovy}. 22:01:20.620 [main] INFO org.springframework.test.context.support.AnnotationConfigContextLoaderUtils - Could not detect default configuration classes for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest]: GirlRepositoryTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration. 22:01:20.663 [main] DEBUG org.springframework.test.context.support.ActiveProfilesUtils - Could not find an 'annotation declaring class' for annotation type [org.springframework.test.context.ActiveProfiles] and class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:01:20.679 [main] DEBUG org.springframework.core.env.StandardEnvironment - Adding PropertySource 'systemProperties' with lowest search precedence 22:01:20.679 [main] DEBUG org.springframework.core.env.StandardEnvironment - Adding PropertySource 'systemEnvironment' with lowest search precedence 22:01:20.679 [main] DEBUG org.springframework.core.env.StandardEnvironment - Initialized StandardEnvironment with PropertySources [MapPropertySource@1468303011 {name='systemProperties', properties={java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\tool\jdk8\jre\bin, java.vm.version=25.101-b13, java.vm.vendor=Oracle Corporation, java.vendor.url=http://java.oracle.com/, path.separator=;, java.vm.name=Java HotSpot(TM) 64-Bit Server VM, file.encoding.pkg=sun.io, user.country=CN, user.script=, sun.java.launcher=SUN_STANDARD, sun.os.patch.level=, java.vm.specification.name=Java Virtual Machine Specification, user.dir=F:\javaProgramming\springBoot\springbootTest, java.runtime.version=1.8.0_101-b13, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\tool\jdk8\jre\lib\endorsed, os.arch=amd64, java.io.tmpdir=C:\Users\a\AppData\Local\Temp\, line.separator= , java.vm.specification.vendor=Oracle Corporation, user.variant=, os.name=Windows 10, sun.jnu.encoding=GBK, java.library.path=C:\tool\jdk8\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;D:\PTool\mysql505\bin;D:\PTool\maven\apache-maven-3.5.0\bin;C:\tool\jdk8\bin;C:\tool\node\;D:\PTool\TortoiseGit\bin;C:\tool\python3\Scripts\;C:\tool\python3\;C:\Users\a\AppData\Local\Microsoft\WindowsApps;C:\Users\a\AppData\Roaming\npm;;., java.specification.name=Java Platform API Specification, java.class.version=52.0, sun.management.compiler=HotSpot 64-Bit Tiered Compilers, os.version=10.0, user.home=C:\Users\a, user.timezone=Asia/Shanghai, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=UTF-8, java.specification.version=1.8, java.class.path=C:\tool\IntelliJ IDEA 2017.2.5\lib\idea_rt.jar;C:\tool\IntelliJ IDEA 2017.2.5\plugins\junit\lib\junit-rt.jar;C:\tool\IntelliJ IDEA 2017.2.5\plugins\junit\lib\junit5-rt.jar;C:\tool\jdk8\jre\lib\charsets.jar;C:\tool\jdk8\jre\lib\deploy.jar;C:\tool\jdk8\jre\lib\ext\access-bridge-64.jar;C:\tool\jdk8\jre\lib\ext\cldrdata.jar;C:\tool\jdk8\jre\lib\ext\dnsns.jar;C:\tool\jdk8\jre\lib\ext\jaccess.jar;C:\tool\jdk8\jre\lib\ext\jfxrt.jar;C:\tool\jdk8\jre\lib\ext\localedata.jar;C:\tool\jdk8\jre\lib\ext\nashorn.jar;C:\tool\jdk8\jre\lib\ext\sunec.jar;C:\tool\jdk8\jre\lib\ext\sunjce_provider.jar;C:\tool\jdk8\jre\lib\ext\sunmscapi.jar;C:\tool\jdk8\jre\lib\ext\sunpkcs11.jar;C:\tool\jdk8\jre\lib\ext\zipfs.jar;C:\tool\jdk8\jre\lib\javaws.jar;C:\tool\jdk8\jre\lib\jce.jar;C:\tool\jdk8\jre\lib\jfr.jar;C:\tool\jdk8\jre\lib\jfxswt.jar;C:\tool\jdk8\jre\lib\jsse.jar;C:\tool\jdk8\jre\lib\management-agent.jar;C:\tool\jdk8\jre\lib\plugin.jar;C:\tool\jdk8\jre\lib\resources.jar;C:\tool\jdk8\jre\lib\rt.jar;F:\javaProgramming\springBoot\springbootTest\target\test-classes;F:\javaProgramming\springBoot\springbootTest\target\classes;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-web\1.5.8.RELEASE\spring-boot-starter-web-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter\1.5.8.RELEASE\spring-boot-starter-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot\1.5.8.RELEASE\spring-boot-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-autoconfigure\1.5.8.RELEASE\spring-boot-autoconfigure-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-logging\1.5.8.RELEASE\spring-boot-starter-logging-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\ch\qos\logback\logback-classic\1.1.11\logback-classic-1.1.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\ch\qos\logback\logback-core\1.1.11\logback-core-1.1.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\jul-to-slf4j\1.7.25\jul-to-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\log4j-over-slf4j\1.7.25\log4j-over-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\yaml\snakeyaml\1.17\snakeyaml-1.17.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-tomcat\1.5.8.RELEASE\spring-boot-starter-tomcat-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-core\8.5.23\tomcat-embed-core-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-annotations-api\8.5.23\tomcat-annotations-api-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-el\8.5.23\tomcat-embed-el-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.23\tomcat-embed-websocket-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-validator\5.3.5.Final\hibernate-validator-5.3.5.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\javax\validation\validation-api\1.1.0.Final\validation-api-1.1.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\jboss\logging\jboss-logging\3.3.1.Final\jboss-logging-3.3.1.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\classmate\1.3.4\classmate-1.3.4.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-databind\2.8.10\jackson-databind-2.8.10.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-annotations\2.8.0\jackson-annotations-2.8.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-core\2.8.10\jackson-core-2.8.10.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-web\4.3.12.RELEASE\spring-web-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-aop\4.3.12.RELEASE\spring-aop-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-beans\4.3.12.RELEASE\spring-beans-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-context\4.3.12.RELEASE\spring-context-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-webmvc\4.3.12.RELEASE\spring-webmvc-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-expression\4.3.12.RELEASE\spring-expression-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-test\1.5.8.RELEASE\spring-boot-starter-test-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-test\1.5.8.RELEASE\spring-boot-test-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-test-autoconfigure\1.5.8.RELEASE\spring-boot-test-autoconfigure-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\jayway\jsonpath\json-path\2.2.0\json-path-2.2.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\net\minidev\json-smart\2.2.1\json-smart-2.2.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\net\minidev\accessors-smart\1.1\accessors-smart-1.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\ow2\asm\asm\5.0.3\asm-5.0.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\slf4j-api\1.7.25\slf4j-api-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\junit\junit\4.12\junit-4.12.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\assertj\assertj-core\2.6.0\assertj-core-2.6.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\mockito\mockito-core\1.10.19\mockito-core-1.10.19.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\objenesis\objenesis\2.1\objenesis-2.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hamcrest\hamcrest-library\1.3\hamcrest-library-1.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\skyscreamer\jsonassert\1.4.0\jsonassert-1.4.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\vaadin\external\google\android-json\0.0.20131108.vaadin1\android-json-0.0.20131108.vaadin1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-core\4.3.12.RELEASE\spring-core-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-test\4.3.12.RELEASE\spring-test-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\mysql\mysql-connector-java\5.1.44\mysql-connector-java-5.1.44.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-data-jpa\1.5.8.RELEASE\spring-boot-starter-data-jpa-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-aop\1.5.8.RELEASE\spring-boot-starter-aop-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\aspectj\aspectjweaver\1.8.11\aspectjweaver-1.8.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-jdbc\1.5.8.RELEASE\spring-boot-starter-jdbc-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-jdbc\8.5.23\tomcat-jdbc-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-juli\8.5.23\tomcat-juli-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-jdbc\4.3.12.RELEASE\spring-jdbc-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-core\5.0.12.Final\hibernate-core-5.0.12.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\javax\persistence\hibernate-jpa-2.1-api\1.0.0.Final\hibernate-jpa-2.1-api-1.0.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\javassist\javassist\3.21.0-GA\javassist-3.21.0-GA.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\antlr\antlr\2.7.7\antlr-2.7.7.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\jboss\jandex\2.0.0.Final\jandex-2.0.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\dom4j\dom4j\1.6.1\dom4j-1.6.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\common\hibernate-commons-annotations\5.0.1.Final\hibernate-commons-annotations-5.0.1.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-entitymanager\5.0.12.Final\hibernate-entitymanager-5.0.12.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\javax\transaction\javax.transaction-api\1.2\javax.transaction-api-1.2.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\data\spring-data-jpa\1.11.8.RELEASE\spring-data-jpa-1.11.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\data\spring-data-commons\1.13.8.RELEASE\spring-data-commons-1.13.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-orm\4.3.12.RELEASE\spring-orm-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-tx\4.3.12.RELEASE\spring-tx-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\jcl-over-slf4j\1.7.25\jcl-over-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-aspects\4.3.12.RELEASE\spring-aspects-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\alibaba\druid\1.0.19\druid-1.0.19.jar;C:\tool\jdk8\lib\jconsole.jar;C:\tool\jdk8\lib\tools.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\projectlombok\lombok\1.16.18\lombok-1.16.18.jar;C:\tool\IntelliJ IDEA 2017.2.5\lib\idea_rt.jar, user.name=a, java.vm.specification.version=1.8, sun.java.command=com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 -junit4 cn.xiangxu.springboot.repository.GirlRepositoryTest,updateAgeById, java.home=C:\tool\jdk8\jre, sun.arch.data.model=64, user.language=zh, java.specification.vendor=Oracle Corporation, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.8.0_101, java.ext.dirs=C:\tool\jdk8\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext, sun.boot.class.path=C:\tool\jdk8\jre\lib\resources.jar;C:\tool\jdk8\jre\lib\rt.jar;C:\tool\jdk8\jre\lib\sunrsasign.jar;C:\tool\jdk8\jre\lib\jsse.jar;C:\tool\jdk8\jre\lib\jce.jar;C:\tool\jdk8\jre\lib\charsets.jar;C:\tool\jdk8\jre\lib\jfr.jar;C:\tool\jdk8\jre\classes, java.vendor=Oracle Corporation, file.separator=\, java.vendor.url.bug=http://bugreport.sun.com/bugreport/, idea.test.cyclic.buffer.size=1048576, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=amd64}}, SystemEnvironmentPropertySource@1427810650 {name='systemEnvironment', properties={configsetroot=C:\WINDOWS\ConfigSetRoot, USERDOMAIN_ROAMINGPROFILE=LAPTOP-RB0UQVAC, LOCALAPPDATA=C:\Users\a\AppData\Local, PROCESSOR_LEVEL=6, USERDOMAIN=LAPTOP-RB0UQVAC, LOGONSERVER=\\LAPTOP-RB0UQVAC, JAVA_HOME=C:\tool\jdk8, SESSIONNAME=Console, ALLUSERSPROFILE=C:\ProgramData, PROCESSOR_ARCHITECTURE=AMD64, PSModulePath=C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules, SystemDrive=C:, MAVEN_HOME=D:\PTool\maven\apache-maven-3.5.0, OneDrive=C:\Users\a\OneDrive, APPDATA=C:\Users\a\AppData\Roaming, USERNAME=a, ProgramFiles(x86)=C:\Program Files (x86), VBOX_MSI_INSTALL_PATH=D:\PTool\dev\virtualBox\, CommonProgramFiles=C:\Program Files\Common Files, Path=C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;D:\PTool\mysql505\bin;D:\PTool\maven\apache-maven-3.5.0\bin;C:\tool\jdk8\bin;C:\tool\node\;D:\PTool\TortoiseGit\bin;C:\tool\python3\Scripts\;C:\tool\python3\;C:\Users\a\AppData\Local\Microsoft\WindowsApps;C:\Users\a\AppData\Roaming\npm;, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, OS=Windows_NT, COMPUTERNAME=LAPTOP-RB0UQVAC, PROCESSOR_REVISION=4e03, CLASSPATH=.;C:\tool\jdk8\lib\tools.jar;C:\tool\jdk8\lib\dt.jar, CommonProgramW6432=C:\Program Files\Common Files, ComSpec=C:\WINDOWS\system32\cmd.exe, ProgramData=C:\ProgramData, ProgramW6432=C:\Program Files, HOMEPATH=\Users\a, SystemRoot=C:\WINDOWS, TEMP=C:\Users\a\AppData\Local\Temp, HOMEDRIVE=C:, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 78 Stepping 3, GenuineIntel, USERPROFILE=C:\Users\a, TMP=C:\Users\a\AppData\Local\Temp, CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files, ProgramFiles=C:\Program Files, PUBLIC=C:\Users\Public, NUMBER_OF_PROCESSORS=4, windir=C:\WINDOWS, =::=::\}}] 22:01:20.710 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Resolved classpath location [cn/xiangxu/springboot/repository/] to resources [URL [file:/F:/javaProgramming/springBoot/springbootTest/target/test-classes/cn/xiangxu/springboot/repository/], URL [file:/F:/javaProgramming/springBoot/springbootTest/target/classes/cn/xiangxu/springboot/repository/]] 22:01:20.710 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Looking for matching resources in directory tree [F:\javaProgramming\springBoot\springbootTest\target\test-classes\cn\xiangxu\springboot\repository] 22:01:20.710 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Searching directory [F:\javaProgramming\springBoot\springbootTest\target\test-classes\cn\xiangxu\springboot\repository] for files matching pattern [F:/javaProgramming/springBoot/springbootTest/target/test-classes/cn/xiangxu/springboot/repository/*.class] 22:01:20.710 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Looking for matching resources in directory tree [F:\javaProgramming\springBoot\springbootTest\target\classes\cn\xiangxu\springboot\repository] 22:01:20.710 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Searching directory [F:\javaProgramming\springBoot\springbootTest\target\classes\cn\xiangxu\springboot\repository] for files matching pattern [F:/javaProgramming/springBoot/springbootTest/target/classes/cn/xiangxu/springboot/repository/*.class] 22:01:20.710 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Resolved location pattern [classpath*:cn/xiangxu/springboot/repository/*.class] to resources [file [F:\javaProgramming\springBoot\springbootTest\target\test-classes\cn\xiangxu\springboot\repository\GirlRepositoryTest.class], file [F:\javaProgramming\springBoot\springbootTest\target\classes\cn\xiangxu\springboot\repository\GirlRepository.class]] 22:01:20.748 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Resolved classpath location [cn/xiangxu/springboot/] to resources [URL [file:/F:/javaProgramming/springBoot/springbootTest/target/test-classes/cn/xiangxu/springboot/], URL [file:/F:/javaProgramming/springBoot/springbootTest/target/classes/cn/xiangxu/springboot/]] 22:01:20.748 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Looking for matching resources in directory tree [F:\javaProgramming\springBoot\springbootTest\target\test-classes\cn\xiangxu\springboot] 22:01:20.748 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Searching directory [F:\javaProgramming\springBoot\springbootTest\target\test-classes\cn\xiangxu\springboot] for files matching pattern [F:/javaProgramming/springBoot/springbootTest/target/test-classes/cn/xiangxu/springboot/*.class] 22:01:20.748 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Looking for matching resources in directory tree [F:\javaProgramming\springBoot\springbootTest\target\classes\cn\xiangxu\springboot] 22:01:20.748 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Searching directory [F:\javaProgramming\springBoot\springbootTest\target\classes\cn\xiangxu\springboot] for files matching pattern [F:/javaProgramming/springBoot/springbootTest/target/classes/cn/xiangxu/springboot/*.class] 22:01:20.748 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Resolved location pattern [classpath*:cn/xiangxu/springboot/*.class] to resources [file [F:\javaProgramming\springBoot\springbootTest\target\test-classes\cn\xiangxu\springboot\SpringbootApplicationTests.class], file [F:\javaProgramming\springBoot\springbootTest\target\classes\cn\xiangxu\springboot\SpringbootApplication.class]] 22:01:20.859 [main] DEBUG org.springframework.context.annotation.ClassPathScanningCandidateComponentProvider - Identified candidate component class: file [F:\javaProgramming\springBoot\springbootTest\target\classes\cn\xiangxu\springboot\SpringbootApplication.class] 22:01:20.860 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Found @SpringBootConfiguration cn.xiangxu.springboot.SpringbootApplication for test class cn.xiangxu.springboot.repository.GirlRepositoryTest 22:01:20.866 [main] DEBUG org.springframework.boot.test.context.SpringBootTestContextBootstrapper - @TestExecutionListeners is not present for class [cn.xiangxu.springboot.repository.GirlRepositoryTest]: using defaults. 22:01:20.874 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener, org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener] 22:01:20.907 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@74294adb, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@70a9f84e, org.springframework.boot.test.autoconfigure.SpringBootDependencyInjectionTestExecutionListener@130f889, org.springframework.test.context.support.DirtiesContextTestExecutionListener@1188e820, org.springframework.test.context.transaction.TransactionalTestExecutionListener@2f490758, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@101df177, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener@166fa74d, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener@40f08448, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener@276438c9, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener@588df31b, org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener@33b37288, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener@77a57272] 22:01:20.909 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:01:20.910 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [cn.xiangxu.springboot.repository.GirlRepositoryTest]22:01:20.918 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:01:20.918 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [cn.xiangxu.springboot.repository.GirlRepositoryTest]22:01:20.918 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:01:20.918 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:01:20.918 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:01:20.918 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:01:20.918 [main] DEBUG org.springframework.test.context.support.AbstractDirtiesContextTestExecutionListener - Before test class: context [DefaultTestContext@12405818 testClass = GirlRepositoryTest, testInstance = [null], testMethod = [null], testException = [null], mergedContextConfiguration = [WebMergedContextConfiguration@314c508a testClass = GirlRepositoryTest, locations = '{}', classes = '{class cn.xiangxu.springboot.SpringbootApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.SpringBootTestContextCustomizer@cb644e, org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@4566e5bd, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@25bbe1b6, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@20398b7c], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]]], class annotated with @DirtiesContext [false] with mode [null]. 22:01:20.934 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:01:20.934 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:01:21.018 [main] DEBUG org.springframework.core.env.StandardEnvironment - Adding PropertySource 'systemProperties' with lowest search precedence 22:01:21.018 [main] DEBUG org.springframework.core.env.StandardEnvironment - Adding PropertySource 'systemEnvironment' with lowest search precedence 22:01:21.018 [main] DEBUG org.springframework.core.env.StandardEnvironment - Initialized StandardEnvironment with PropertySources [MapPropertySource@769429195 {name='systemProperties', properties={java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\tool\jdk8\jre\bin, java.vm.version=25.101-b13, java.vm.vendor=Oracle Corporation, java.vendor.url=http://java.oracle.com/, path.separator=;, java.vm.name=Java HotSpot(TM) 64-Bit Server VM, file.encoding.pkg=sun.io, user.country=CN, user.script=, sun.java.launcher=SUN_STANDARD, sun.os.patch.level=, java.vm.specification.name=Java Virtual Machine Specification, user.dir=F:\javaProgramming\springBoot\springbootTest, java.runtime.version=1.8.0_101-b13, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\tool\jdk8\jre\lib\endorsed, os.arch=amd64, java.io.tmpdir=C:\Users\a\AppData\Local\Temp\, line.separator= , java.vm.specification.vendor=Oracle Corporation, user.variant=, os.name=Windows 10, sun.jnu.encoding=GBK, java.library.path=C:\tool\jdk8\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;D:\PTool\mysql505\bin;D:\PTool\maven\apache-maven-3.5.0\bin;C:\tool\jdk8\bin;C:\tool\node\;D:\PTool\TortoiseGit\bin;C:\tool\python3\Scripts\;C:\tool\python3\;C:\Users\a\AppData\Local\Microsoft\WindowsApps;C:\Users\a\AppData\Roaming\npm;;., java.specification.name=Java Platform API Specification, java.class.version=52.0, sun.management.compiler=HotSpot 64-Bit Tiered Compilers, os.version=10.0, user.home=C:\Users\a, user.timezone=Asia/Shanghai, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=UTF-8, java.specification.version=1.8, java.class.path=C:\tool\IntelliJ IDEA 2017.2.5\lib\idea_rt.jar;C:\tool\IntelliJ IDEA 2017.2.5\plugins\junit\lib\junit-rt.jar;C:\tool\IntelliJ IDEA 2017.2.5\plugins\junit\lib\junit5-rt.jar;C:\tool\jdk8\jre\lib\charsets.jar;C:\tool\jdk8\jre\lib\deploy.jar;C:\tool\jdk8\jre\lib\ext\access-bridge-64.jar;C:\tool\jdk8\jre\lib\ext\cldrdata.jar;C:\tool\jdk8\jre\lib\ext\dnsns.jar;C:\tool\jdk8\jre\lib\ext\jaccess.jar;C:\tool\jdk8\jre\lib\ext\jfxrt.jar;C:\tool\jdk8\jre\lib\ext\localedata.jar;C:\tool\jdk8\jre\lib\ext\nashorn.jar;C:\tool\jdk8\jre\lib\ext\sunec.jar;C:\tool\jdk8\jre\lib\ext\sunjce_provider.jar;C:\tool\jdk8\jre\lib\ext\sunmscapi.jar;C:\tool\jdk8\jre\lib\ext\sunpkcs11.jar;C:\tool\jdk8\jre\lib\ext\zipfs.jar;C:\tool\jdk8\jre\lib\javaws.jar;C:\tool\jdk8\jre\lib\jce.jar;C:\tool\jdk8\jre\lib\jfr.jar;C:\tool\jdk8\jre\lib\jfxswt.jar;C:\tool\jdk8\jre\lib\jsse.jar;C:\tool\jdk8\jre\lib\management-agent.jar;C:\tool\jdk8\jre\lib\plugin.jar;C:\tool\jdk8\jre\lib\resources.jar;C:\tool\jdk8\jre\lib\rt.jar;F:\javaProgramming\springBoot\springbootTest\target\test-classes;F:\javaProgramming\springBoot\springbootTest\target\classes;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-web\1.5.8.RELEASE\spring-boot-starter-web-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter\1.5.8.RELEASE\spring-boot-starter-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot\1.5.8.RELEASE\spring-boot-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-autoconfigure\1.5.8.RELEASE\spring-boot-autoconfigure-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-logging\1.5.8.RELEASE\spring-boot-starter-logging-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\ch\qos\logback\logback-classic\1.1.11\logback-classic-1.1.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\ch\qos\logback\logback-core\1.1.11\logback-core-1.1.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\jul-to-slf4j\1.7.25\jul-to-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\log4j-over-slf4j\1.7.25\log4j-over-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\yaml\snakeyaml\1.17\snakeyaml-1.17.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-tomcat\1.5.8.RELEASE\spring-boot-starter-tomcat-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-core\8.5.23\tomcat-embed-core-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-annotations-api\8.5.23\tomcat-annotations-api-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-el\8.5.23\tomcat-embed-el-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.23\tomcat-embed-websocket-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-validator\5.3.5.Final\hibernate-validator-5.3.5.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\javax\validation\validation-api\1.1.0.Final\validation-api-1.1.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\jboss\logging\jboss-logging\3.3.1.Final\jboss-logging-3.3.1.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\classmate\1.3.4\classmate-1.3.4.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-databind\2.8.10\jackson-databind-2.8.10.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-annotations\2.8.0\jackson-annotations-2.8.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-core\2.8.10\jackson-core-2.8.10.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-web\4.3.12.RELEASE\spring-web-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-aop\4.3.12.RELEASE\spring-aop-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-beans\4.3.12.RELEASE\spring-beans-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-context\4.3.12.RELEASE\spring-context-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-webmvc\4.3.12.RELEASE\spring-webmvc-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-expression\4.3.12.RELEASE\spring-expression-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-test\1.5.8.RELEASE\spring-boot-starter-test-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-test\1.5.8.RELEASE\spring-boot-test-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-test-autoconfigure\1.5.8.RELEASE\spring-boot-test-autoconfigure-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\jayway\jsonpath\json-path\2.2.0\json-path-2.2.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\net\minidev\json-smart\2.2.1\json-smart-2.2.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\net\minidev\accessors-smart\1.1\accessors-smart-1.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\ow2\asm\asm\5.0.3\asm-5.0.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\slf4j-api\1.7.25\slf4j-api-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\junit\junit\4.12\junit-4.12.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\assertj\assertj-core\2.6.0\assertj-core-2.6.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\mockito\mockito-core\1.10.19\mockito-core-1.10.19.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\objenesis\objenesis\2.1\objenesis-2.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hamcrest\hamcrest-library\1.3\hamcrest-library-1.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\skyscreamer\jsonassert\1.4.0\jsonassert-1.4.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\vaadin\external\google\android-json\0.0.20131108.vaadin1\android-json-0.0.20131108.vaadin1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-core\4.3.12.RELEASE\spring-core-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-test\4.3.12.RELEASE\spring-test-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\mysql\mysql-connector-java\5.1.44\mysql-connector-java-5.1.44.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-data-jpa\1.5.8.RELEASE\spring-boot-starter-data-jpa-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-aop\1.5.8.RELEASE\spring-boot-starter-aop-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\aspectj\aspectjweaver\1.8.11\aspectjweaver-1.8.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-jdbc\1.5.8.RELEASE\spring-boot-starter-jdbc-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-jdbc\8.5.23\tomcat-jdbc-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-juli\8.5.23\tomcat-juli-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-jdbc\4.3.12.RELEASE\spring-jdbc-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-core\5.0.12.Final\hibernate-core-5.0.12.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\javax\persistence\hibernate-jpa-2.1-api\1.0.0.Final\hibernate-jpa-2.1-api-1.0.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\javassist\javassist\3.21.0-GA\javassist-3.21.0-GA.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\antlr\antlr\2.7.7\antlr-2.7.7.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\jboss\jandex\2.0.0.Final\jandex-2.0.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\dom4j\dom4j\1.6.1\dom4j-1.6.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\common\hibernate-commons-annotations\5.0.1.Final\hibernate-commons-annotations-5.0.1.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-entitymanager\5.0.12.Final\hibernate-entitymanager-5.0.12.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\javax\transaction\javax.transaction-api\1.2\javax.transaction-api-1.2.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\data\spring-data-jpa\1.11.8.RELEASE\spring-data-jpa-1.11.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\data\spring-data-commons\1.13.8.RELEASE\spring-data-commons-1.13.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-orm\4.3.12.RELEASE\spring-orm-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-tx\4.3.12.RELEASE\spring-tx-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\jcl-over-slf4j\1.7.25\jcl-over-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-aspects\4.3.12.RELEASE\spring-aspects-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\alibaba\druid\1.0.19\druid-1.0.19.jar;C:\tool\jdk8\lib\jconsole.jar;C:\tool\jdk8\lib\tools.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\projectlombok\lombok\1.16.18\lombok-1.16.18.jar;C:\tool\IntelliJ IDEA 2017.2.5\lib\idea_rt.jar, user.name=a, java.vm.specification.version=1.8, sun.java.command=com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 -junit4 cn.xiangxu.springboot.repository.GirlRepositoryTest,updateAgeById, java.home=C:\tool\jdk8\jre, sun.arch.data.model=64, user.language=zh, java.specification.vendor=Oracle Corporation, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.8.0_101, java.ext.dirs=C:\tool\jdk8\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext, sun.boot.class.path=C:\tool\jdk8\jre\lib\resources.jar;C:\tool\jdk8\jre\lib\rt.jar;C:\tool\jdk8\jre\lib\sunrsasign.jar;C:\tool\jdk8\jre\lib\jsse.jar;C:\tool\jdk8\jre\lib\jce.jar;C:\tool\jdk8\jre\lib\charsets.jar;C:\tool\jdk8\jre\lib\jfr.jar;C:\tool\jdk8\jre\classes, java.vendor=Oracle Corporation, file.separator=\, java.vendor.url.bug=http://bugreport.sun.com/bugreport/, idea.test.cyclic.buffer.size=1048576, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=amd64}}, SystemEnvironmentPropertySource@580718781 {name='systemEnvironment', properties={configsetroot=C:\WINDOWS\ConfigSetRoot, USERDOMAIN_ROAMINGPROFILE=LAPTOP-RB0UQVAC, LOCALAPPDATA=C:\Users\a\AppData\Local, PROCESSOR_LEVEL=6, USERDOMAIN=LAPTOP-RB0UQVAC, LOGONSERVER=\\LAPTOP-RB0UQVAC, JAVA_HOME=C:\tool\jdk8, SESSIONNAME=Console, ALLUSERSPROFILE=C:\ProgramData, PROCESSOR_ARCHITECTURE=AMD64, PSModulePath=C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules, SystemDrive=C:, MAVEN_HOME=D:\PTool\maven\apache-maven-3.5.0, OneDrive=C:\Users\a\OneDrive, APPDATA=C:\Users\a\AppData\Roaming, USERNAME=a, ProgramFiles(x86)=C:\Program Files (x86), VBOX_MSI_INSTALL_PATH=D:\PTool\dev\virtualBox\, CommonProgramFiles=C:\Program Files\Common Files, Path=C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;D:\PTool\mysql505\bin;D:\PTool\maven\apache-maven-3.5.0\bin;C:\tool\jdk8\bin;C:\tool\node\;D:\PTool\TortoiseGit\bin;C:\tool\python3\Scripts\;C:\tool\python3\;C:\Users\a\AppData\Local\Microsoft\WindowsApps;C:\Users\a\AppData\Roaming\npm;, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, OS=Windows_NT, COMPUTERNAME=LAPTOP-RB0UQVAC, PROCESSOR_REVISION=4e03, CLASSPATH=.;C:\tool\jdk8\lib\tools.jar;C:\tool\jdk8\lib\dt.jar, CommonProgramW6432=C:\Program Files\Common Files, ComSpec=C:\WINDOWS\system32\cmd.exe, ProgramData=C:\ProgramData, ProgramW6432=C:\Program Files, HOMEPATH=\Users\a, SystemRoot=C:\WINDOWS, TEMP=C:\Users\a\AppData\Local\Temp, HOMEDRIVE=C:, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 78 Stepping 3, GenuineIntel, USERPROFILE=C:\Users\a, TMP=C:\Users\a\AppData\Local\Temp, CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files, ProgramFiles=C:\Program Files, PUBLIC=C:\Users\Public, NUMBER_OF_PROCESSORS=4, windir=C:\WINDOWS, =::=::\}}] 22:01:21.034 [main] DEBUG org.springframework.core.env.MutablePropertySources - Adding PropertySource 'inline' with highest search precedence 22:01:21.034 [main] DEBUG org.springframework.test.context.support.TestPropertySourceUtils - Adding inlined properties to environment: {spring.jmx.enabled=false, org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true, server.port=-1} 22:01:21.034 [main] DEBUG org.springframework.core.env.StandardEnvironment - Adding PropertySource 'Inlined Test Properties' with highest search precedence . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v1.5.8.RELEASE) 2017-11-27 22:01:22,047 - Starting GirlRepositoryTest on LAPTOP-RB0UQVAC with PID 11728 (started by a in F:\javaProgramming\springBoot\springbootTest) - 2017-11-27 22:01:22,048 - No active profile set, falling back to default profiles: default - 2017-11-27 22:01:22,118 - Refreshing org.springframework.web.context.support.GenericWebApplicationContext@5149d738: startup date [Mon Nov 27 22:01:22 CST 2017]; root of context hierarchy - 2017-11-27 22:01:24,375 - {dataSource-1} inited - 2017-11-27 22:01:24,745 - Building JPA container EntityManagerFactory for persistence unit 'default' - 2017-11-27 22:01:24,776 - HHH000204: Processing PersistenceUnitInfo [ name: default ...] - 2017-11-27 22:01:24,914 - HHH000412: Hibernate Core {5.0.12.Final} - 2017-11-27 22:01:24,914 - HHH000206: hibernate.properties not found - 2017-11-27 22:01:24,930 - HHH000021: Bytecode provider name : javassist - 2017-11-27 22:01:24,976 - HCANN000001: Hibernate Commons Annotations {5.0.1.Final} - 2017-11-27 22:01:25,161 - HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect - 2017-11-27 22:01:25,900 - HHH000228: Running hbm2ddl schema update - 2017-11-27 22:01:26,097 - Initialized JPA EntityManagerFactory for persistence unit 'default' - 2017-11-27 22:01:26,402 - HHH000397: Using ASTQueryTranslatorFactory - 2017-11-27 22:01:27,449 - Looking for @ControllerAdvice: org.springframework.web.context.support.GenericWebApplicationContext@5149d738: startup date [Mon Nov 27 22:01:22 CST 2017]; root of context hierarchy - 2017-11-27 22:01:27,560 - Mapped "{[/error]}" onto public org.springframework.http.ResponseEntity<java.util.Map<java.lang.String, java.lang.Object>> org.springframework.boot.autoconfigure.web.BasicErrorController.error(javax.servlet.http.HttpServletRequest) - 2017-11-27 22:01:27,563 - Mapped "{[/error],produces=[text/html]}" onto public org.springframework.web.servlet.ModelAndView org.springframework.boot.autoconfigure.web.BasicErrorController.errorHtml(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse) - 2017-11-27 22:01:27,607 - Mapped URL path [/webjars/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler] - 2017-11-27 22:01:27,608 - Mapped URL path [/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler] - 2017-11-27 22:01:27,676 - Mapped URL path [/**/favicon.ico] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler] - 2017-11-27 22:01:28,017 - Started GirlRepositoryTest in 6.966 seconds (JVM running for 8.111) - org.springframework.dao.InvalidDataAccessApiUsageException: org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML operations [update cn.xiangxu.springboot.entity.dataObject.Girl o set o.age = ?2 where o.id = ?1]; nested exception is java.lang.IllegalStateException: org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML operations [update cn.xiangxu.springboot.entity.dataObject.Girl o set o.age = ?2 where o.id = ?1] at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:381) at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:246) at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:488) at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59) at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213) at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) at com.sun.proxy.$Proxy79.updateAgeById(Unknown Source) at cn.xiangxu.springboot.repository.GirlRepositoryTest.updateAgeById(GirlRepositoryTest.java:60) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75) at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86) at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:252) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61) at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191) at org.junit.runner.JUnitCore.run(JUnitCore.java:137) at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68) at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47) at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242) at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70) Caused by: java.lang.IllegalStateException: org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML operations [update cn.xiangxu.springboot.entity.dataObject.Girl o set o.age = ?2 where o.id = ?1] at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:554) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:372) at com.sun.proxy.$Proxy89.getSingleResult(Unknown Source) at org.springframework.data.jpa.repository.query.JpaQueryExecution$SingleEntityExecution.doExecute(JpaQueryExecution.java:208) at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:87) at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:116) at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:106) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:483) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:461) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136) ... 38 more Caused by: org.hibernate.hql.internal.QueryExecutionRequestException: Not supported for DML operations [update cn.xiangxu.springboot.entity.dataObject.Girl o set o.age = ?2 where o.id = ?1] at org.hibernate.hql.internal.ast.QueryTranslatorImpl.errorIfDML(QueryTranslatorImpl.java:302) at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:353) at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:216) at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1326) at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87) at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:606) at org.hibernate.jpa.internal.QueryImpl.getSingleResult(QueryImpl.java:529) ... 58 more 2017-11-27 22:01:28,112 - Closing org.springframework.web.context.support.GenericWebApplicationContext@5149d738: startup date [Mon Nov 27 22:01:22 CST 2017]; root of context hierarchy - 2017-11-27 22:01:28,116 - Closing JPA EntityManagerFactory for persistence unit 'default' - 2017-11-27 22:01:28,127 - {dataSource-1} closed - Process finished with exit code -1
3.2 添加了该注解后还是报错
原因：更新操作需要事务支持
C:\tool\jdk8\bin\java -ea -Didea.test.cyclic.buffer.size=1048576 "-javaagent:C:\tool\IntelliJ IDEA 2017.2.5\lib\idea_rt.jar=51582:C:\tool\IntelliJ IDEA 2017.2.5\bin" -Dfile.encoding=UTF-8 -classpath "C:\tool\IntelliJ IDEA 2017.2.5\lib\idea_rt.jar;C:\tool\IntelliJ IDEA 2017.2.5\plugins\junit\lib\junit-rt.jar;C:\tool\IntelliJ IDEA 2017.2.5\plugins\junit\lib\junit5-rt.jar;C:\tool\jdk8\jre\lib\charsets.jar;C:\tool\jdk8\jre\lib\deploy.jar;C:\tool\jdk8\jre\lib\ext\access-bridge-64.jar;C:\tool\jdk8\jre\lib\ext\cldrdata.jar;C:\tool\jdk8\jre\lib\ext\dnsns.jar;C:\tool\jdk8\jre\lib\ext\jaccess.jar;C:\tool\jdk8\jre\lib\ext\jfxrt.jar;C:\tool\jdk8\jre\lib\ext\localedata.jar;C:\tool\jdk8\jre\lib\ext\nashorn.jar;C:\tool\jdk8\jre\lib\ext\sunec.jar;C:\tool\jdk8\jre\lib\ext\sunjce_provider.jar;C:\tool\jdk8\jre\lib\ext\sunmscapi.jar;C:\tool\jdk8\jre\lib\ext\sunpkcs11.jar;C:\tool\jdk8\jre\lib\ext\zipfs.jar;C:\tool\jdk8\jre\lib\javaws.jar;C:\tool\jdk8\jre\lib\jce.jar;C:\tool\jdk8\jre\lib\jfr.jar;C:\tool\jdk8\jre\lib\jfxswt.jar;C:\tool\jdk8\jre\lib\jsse.jar;C:\tool\jdk8\jre\lib\management-agent.jar;C:\tool\jdk8\jre\lib\plugin.jar;C:\tool\jdk8\jre\lib\resources.jar;C:\tool\jdk8\jre\lib\rt.jar;F:\javaProgramming\springBoot\springbootTest\target\test-classes;F:\javaProgramming\springBoot\springbootTest\target\classes;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-web\1.5.8.RELEASE\spring-boot-starter-web-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter\1.5.8.RELEASE\spring-boot-starter-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot\1.5.8.RELEASE\spring-boot-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-autoconfigure\1.5.8.RELEASE\spring-boot-autoconfigure-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-logging\1.5.8.RELEASE\spring-boot-starter-logging-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\ch\qos\logback\logback-classic\1.1.11\logback-classic-1.1.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\ch\qos\logback\logback-core\1.1.11\logback-core-1.1.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\jul-to-slf4j\1.7.25\jul-to-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\log4j-over-slf4j\1.7.25\log4j-over-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\yaml\snakeyaml\1.17\snakeyaml-1.17.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-tomcat\1.5.8.RELEASE\spring-boot-starter-tomcat-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-core\8.5.23\tomcat-embed-core-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-annotations-api\8.5.23\tomcat-annotations-api-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-el\8.5.23\tomcat-embed-el-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.23\tomcat-embed-websocket-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-validator\5.3.5.Final\hibernate-validator-5.3.5.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\javax\validation\validation-api\1.1.0.Final\validation-api-1.1.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\jboss\logging\jboss-logging\3.3.1.Final\jboss-logging-3.3.1.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\classmate\1.3.4\classmate-1.3.4.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-databind\2.8.10\jackson-databind-2.8.10.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-annotations\2.8.0\jackson-annotations-2.8.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-core\2.8.10\jackson-core-2.8.10.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-web\4.3.12.RELEASE\spring-web-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-aop\4.3.12.RELEASE\spring-aop-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-beans\4.3.12.RELEASE\spring-beans-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-context\4.3.12.RELEASE\spring-context-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-webmvc\4.3.12.RELEASE\spring-webmvc-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-expression\4.3.12.RELEASE\spring-expression-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-test\1.5.8.RELEASE\spring-boot-starter-test-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-test\1.5.8.RELEASE\spring-boot-test-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-test-autoconfigure\1.5.8.RELEASE\spring-boot-test-autoconfigure-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\jayway\jsonpath\json-path\2.2.0\json-path-2.2.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\net\minidev\json-smart\2.2.1\json-smart-2.2.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\net\minidev\accessors-smart\1.1\accessors-smart-1.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\ow2\asm\asm\5.0.3\asm-5.0.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\slf4j-api\1.7.25\slf4j-api-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\junit\junit\4.12\junit-4.12.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\assertj\assertj-core\2.6.0\assertj-core-2.6.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\mockito\mockito-core\1.10.19\mockito-core-1.10.19.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\objenesis\objenesis\2.1\objenesis-2.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hamcrest\hamcrest-library\1.3\hamcrest-library-1.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\skyscreamer\jsonassert\1.4.0\jsonassert-1.4.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\vaadin\external\google\android-json\0.0.20131108.vaadin1\android-json-0.0.20131108.vaadin1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-core\4.3.12.RELEASE\spring-core-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-test\4.3.12.RELEASE\spring-test-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\mysql\mysql-connector-java\5.1.44\mysql-connector-java-5.1.44.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-data-jpa\1.5.8.RELEASE\spring-boot-starter-data-jpa-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-aop\1.5.8.RELEASE\spring-boot-starter-aop-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\aspectj\aspectjweaver\1.8.11\aspectjweaver-1.8.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-jdbc\1.5.8.RELEASE\spring-boot-starter-jdbc-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-jdbc\8.5.23\tomcat-jdbc-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-juli\8.5.23\tomcat-juli-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-jdbc\4.3.12.RELEASE\spring-jdbc-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-core\5.0.12.Final\hibernate-core-5.0.12.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\javax\persistence\hibernate-jpa-2.1-api\1.0.0.Final\hibernate-jpa-2.1-api-1.0.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\javassist\javassist\3.21.0-GA\javassist-3.21.0-GA.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\antlr\antlr\2.7.7\antlr-2.7.7.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\jboss\jandex\2.0.0.Final\jandex-2.0.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\dom4j\dom4j\1.6.1\dom4j-1.6.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\common\hibernate-commons-annotations\5.0.1.Final\hibernate-commons-annotations-5.0.1.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-entitymanager\5.0.12.Final\hibernate-entitymanager-5.0.12.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\javax\transaction\javax.transaction-api\1.2\javax.transaction-api-1.2.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\data\spring-data-jpa\1.11.8.RELEASE\spring-data-jpa-1.11.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\data\spring-data-commons\1.13.8.RELEASE\spring-data-commons-1.13.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-orm\4.3.12.RELEASE\spring-orm-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-tx\4.3.12.RELEASE\spring-tx-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\jcl-over-slf4j\1.7.25\jcl-over-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-aspects\4.3.12.RELEASE\spring-aspects-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\alibaba\druid\1.0.19\druid-1.0.19.jar;C:\tool\jdk8\lib\jconsole.jar;C:\tool\jdk8\lib\tools.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\projectlombok\lombok\1.16.18\lombok-1.16.18.jar" com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 -junit4 cn.xiangxu.springboot.repository.GirlRepositoryTest,updateAgeById 22:07:07.267 [main] DEBUG org.springframework.test.context.junit4.SpringJUnit4ClassRunner - SpringJUnit4ClassRunner constructor called with [class cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:07:07.275 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating CacheAwareContextLoaderDelegate from class [org.springframework.test.context.cache.DefaultCacheAwareContextLoaderDelegate] 22:07:07.287 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating BootstrapContext using constructor [public org.springframework.test.context.support.DefaultBootstrapContext(java.lang.Class,org.springframework.test.context.CacheAwareContextLoaderDelegate)] 22:07:07.315 [main] DEBUG org.springframework.test.context.BootstrapUtils - Instantiating TestContextBootstrapper for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest] from class [org.springframework.boot.test.context.SpringBootTestContextBootstrapper] 22:07:07.339 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Neither @ContextConfiguration nor @ContextHierarchy found for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest], using SpringBootContextLoader 22:07:07.346 [main] DEBUG org.springframework.test.context.support.AbstractContextLoader - Did not detect default resource location for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest]: class path resource [cn/xiangxu/springboot/repository/GirlRepositoryTest-context.xml] does not exist 22:07:07.346 [main] DEBUG org.springframework.test.context.support.AbstractContextLoader - Did not detect default resource location for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest]: class path resource [cn/xiangxu/springboot/repository/GirlRepositoryTestContext.groovy] does not exist 22:07:07.346 [main] INFO org.springframework.test.context.support.AbstractContextLoader - Could not detect default resource locations for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest]: no resource found for suffixes {-context.xml, Context.groovy}. 22:07:07.347 [main] INFO org.springframework.test.context.support.AnnotationConfigContextLoaderUtils - Could not detect default configuration classes for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest]: GirlRepositoryTest does not declare any static, non-private, non-final, nested classes annotated with @Configuration. 22:07:07.407 [main] DEBUG org.springframework.test.context.support.ActiveProfilesUtils - Could not find an 'annotation declaring class' for annotation type [org.springframework.test.context.ActiveProfiles] and class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:07:07.422 [main] DEBUG org.springframework.core.env.StandardEnvironment - Adding PropertySource 'systemProperties' with lowest search precedence 22:07:07.422 [main] DEBUG org.springframework.core.env.StandardEnvironment - Adding PropertySource 'systemEnvironment' with lowest search precedence 22:07:07.423 [main] DEBUG org.springframework.core.env.StandardEnvironment - Initialized StandardEnvironment with PropertySources [MapPropertySource@1468303011 {name='systemProperties', properties={java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\tool\jdk8\jre\bin, java.vm.version=25.101-b13, java.vm.vendor=Oracle Corporation, java.vendor.url=http://java.oracle.com/, path.separator=;, java.vm.name=Java HotSpot(TM) 64-Bit Server VM, file.encoding.pkg=sun.io, user.country=CN, user.script=, sun.java.launcher=SUN_STANDARD, sun.os.patch.level=, java.vm.specification.name=Java Virtual Machine Specification, user.dir=F:\javaProgramming\springBoot\springbootTest, java.runtime.version=1.8.0_101-b13, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\tool\jdk8\jre\lib\endorsed, os.arch=amd64, java.io.tmpdir=C:\Users\a\AppData\Local\Temp\, line.separator= , java.vm.specification.vendor=Oracle Corporation, user.variant=, os.name=Windows 10, sun.jnu.encoding=GBK, java.library.path=C:\tool\jdk8\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;D:\PTool\mysql505\bin;D:\PTool\maven\apache-maven-3.5.0\bin;C:\tool\jdk8\bin;C:\tool\node\;D:\PTool\TortoiseGit\bin;C:\tool\python3\Scripts\;C:\tool\python3\;C:\Users\a\AppData\Local\Microsoft\WindowsApps;C:\Users\a\AppData\Roaming\npm;;., java.specification.name=Java Platform API Specification, java.class.version=52.0, sun.management.compiler=HotSpot 64-Bit Tiered Compilers, os.version=10.0, user.home=C:\Users\a, user.timezone=Asia/Shanghai, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=UTF-8, java.specification.version=1.8, java.class.path=C:\tool\IntelliJ IDEA 2017.2.5\lib\idea_rt.jar;C:\tool\IntelliJ IDEA 2017.2.5\plugins\junit\lib\junit-rt.jar;C:\tool\IntelliJ IDEA 2017.2.5\plugins\junit\lib\junit5-rt.jar;C:\tool\jdk8\jre\lib\charsets.jar;C:\tool\jdk8\jre\lib\deploy.jar;C:\tool\jdk8\jre\lib\ext\access-bridge-64.jar;C:\tool\jdk8\jre\lib\ext\cldrdata.jar;C:\tool\jdk8\jre\lib\ext\dnsns.jar;C:\tool\jdk8\jre\lib\ext\jaccess.jar;C:\tool\jdk8\jre\lib\ext\jfxrt.jar;C:\tool\jdk8\jre\lib\ext\localedata.jar;C:\tool\jdk8\jre\lib\ext\nashorn.jar;C:\tool\jdk8\jre\lib\ext\sunec.jar;C:\tool\jdk8\jre\lib\ext\sunjce_provider.jar;C:\tool\jdk8\jre\lib\ext\sunmscapi.jar;C:\tool\jdk8\jre\lib\ext\sunpkcs11.jar;C:\tool\jdk8\jre\lib\ext\zipfs.jar;C:\tool\jdk8\jre\lib\javaws.jar;C:\tool\jdk8\jre\lib\jce.jar;C:\tool\jdk8\jre\lib\jfr.jar;C:\tool\jdk8\jre\lib\jfxswt.jar;C:\tool\jdk8\jre\lib\jsse.jar;C:\tool\jdk8\jre\lib\management-agent.jar;C:\tool\jdk8\jre\lib\plugin.jar;C:\tool\jdk8\jre\lib\resources.jar;C:\tool\jdk8\jre\lib\rt.jar;F:\javaProgramming\springBoot\springbootTest\target\test-classes;F:\javaProgramming\springBoot\springbootTest\target\classes;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-web\1.5.8.RELEASE\spring-boot-starter-web-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter\1.5.8.RELEASE\spring-boot-starter-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot\1.5.8.RELEASE\spring-boot-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-autoconfigure\1.5.8.RELEASE\spring-boot-autoconfigure-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-logging\1.5.8.RELEASE\spring-boot-starter-logging-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\ch\qos\logback\logback-classic\1.1.11\logback-classic-1.1.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\ch\qos\logback\logback-core\1.1.11\logback-core-1.1.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\jul-to-slf4j\1.7.25\jul-to-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\log4j-over-slf4j\1.7.25\log4j-over-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\yaml\snakeyaml\1.17\snakeyaml-1.17.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-tomcat\1.5.8.RELEASE\spring-boot-starter-tomcat-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-core\8.5.23\tomcat-embed-core-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-annotations-api\8.5.23\tomcat-annotations-api-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-el\8.5.23\tomcat-embed-el-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.23\tomcat-embed-websocket-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-validator\5.3.5.Final\hibernate-validator-5.3.5.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\javax\validation\validation-api\1.1.0.Final\validation-api-1.1.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\jboss\logging\jboss-logging\3.3.1.Final\jboss-logging-3.3.1.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\classmate\1.3.4\classmate-1.3.4.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-databind\2.8.10\jackson-databind-2.8.10.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-annotations\2.8.0\jackson-annotations-2.8.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-core\2.8.10\jackson-core-2.8.10.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-web\4.3.12.RELEASE\spring-web-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-aop\4.3.12.RELEASE\spring-aop-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-beans\4.3.12.RELEASE\spring-beans-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-context\4.3.12.RELEASE\spring-context-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-webmvc\4.3.12.RELEASE\spring-webmvc-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-expression\4.3.12.RELEASE\spring-expression-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-test\1.5.8.RELEASE\spring-boot-starter-test-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-test\1.5.8.RELEASE\spring-boot-test-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-test-autoconfigure\1.5.8.RELEASE\spring-boot-test-autoconfigure-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\jayway\jsonpath\json-path\2.2.0\json-path-2.2.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\net\minidev\json-smart\2.2.1\json-smart-2.2.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\net\minidev\accessors-smart\1.1\accessors-smart-1.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\ow2\asm\asm\5.0.3\asm-5.0.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\slf4j-api\1.7.25\slf4j-api-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\junit\junit\4.12\junit-4.12.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\assertj\assertj-core\2.6.0\assertj-core-2.6.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\mockito\mockito-core\1.10.19\mockito-core-1.10.19.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\objenesis\objenesis\2.1\objenesis-2.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hamcrest\hamcrest-library\1.3\hamcrest-library-1.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\skyscreamer\jsonassert\1.4.0\jsonassert-1.4.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\vaadin\external\google\android-json\0.0.20131108.vaadin1\android-json-0.0.20131108.vaadin1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-core\4.3.12.RELEASE\spring-core-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-test\4.3.12.RELEASE\spring-test-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\mysql\mysql-connector-java\5.1.44\mysql-connector-java-5.1.44.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-data-jpa\1.5.8.RELEASE\spring-boot-starter-data-jpa-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-aop\1.5.8.RELEASE\spring-boot-starter-aop-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\aspectj\aspectjweaver\1.8.11\aspectjweaver-1.8.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-jdbc\1.5.8.RELEASE\spring-boot-starter-jdbc-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-jdbc\8.5.23\tomcat-jdbc-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-juli\8.5.23\tomcat-juli-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-jdbc\4.3.12.RELEASE\spring-jdbc-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-core\5.0.12.Final\hibernate-core-5.0.12.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\javax\persistence\hibernate-jpa-2.1-api\1.0.0.Final\hibernate-jpa-2.1-api-1.0.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\javassist\javassist\3.21.0-GA\javassist-3.21.0-GA.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\antlr\antlr\2.7.7\antlr-2.7.7.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\jboss\jandex\2.0.0.Final\jandex-2.0.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\dom4j\dom4j\1.6.1\dom4j-1.6.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\common\hibernate-commons-annotations\5.0.1.Final\hibernate-commons-annotations-5.0.1.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-entitymanager\5.0.12.Final\hibernate-entitymanager-5.0.12.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\javax\transaction\javax.transaction-api\1.2\javax.transaction-api-1.2.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\data\spring-data-jpa\1.11.8.RELEASE\spring-data-jpa-1.11.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\data\spring-data-commons\1.13.8.RELEASE\spring-data-commons-1.13.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-orm\4.3.12.RELEASE\spring-orm-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-tx\4.3.12.RELEASE\spring-tx-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\jcl-over-slf4j\1.7.25\jcl-over-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-aspects\4.3.12.RELEASE\spring-aspects-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\alibaba\druid\1.0.19\druid-1.0.19.jar;C:\tool\jdk8\lib\jconsole.jar;C:\tool\jdk8\lib\tools.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\projectlombok\lombok\1.16.18\lombok-1.16.18.jar;C:\tool\IntelliJ IDEA 2017.2.5\lib\idea_rt.jar, user.name=a, java.vm.specification.version=1.8, sun.java.command=com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 -junit4 cn.xiangxu.springboot.repository.GirlRepositoryTest,updateAgeById, java.home=C:\tool\jdk8\jre, sun.arch.data.model=64, user.language=zh, java.specification.vendor=Oracle Corporation, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.8.0_101, java.ext.dirs=C:\tool\jdk8\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext, sun.boot.class.path=C:\tool\jdk8\jre\lib\resources.jar;C:\tool\jdk8\jre\lib\rt.jar;C:\tool\jdk8\jre\lib\sunrsasign.jar;C:\tool\jdk8\jre\lib\jsse.jar;C:\tool\jdk8\jre\lib\jce.jar;C:\tool\jdk8\jre\lib\charsets.jar;C:\tool\jdk8\jre\lib\jfr.jar;C:\tool\jdk8\jre\classes, java.vendor=Oracle Corporation, file.separator=\, java.vendor.url.bug=http://bugreport.sun.com/bugreport/, idea.test.cyclic.buffer.size=1048576, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=amd64}}, SystemEnvironmentPropertySource@1427810650 {name='systemEnvironment', properties={configsetroot=C:\WINDOWS\ConfigSetRoot, USERDOMAIN_ROAMINGPROFILE=LAPTOP-RB0UQVAC, LOCALAPPDATA=C:\Users\a\AppData\Local, PROCESSOR_LEVEL=6, USERDOMAIN=LAPTOP-RB0UQVAC, LOGONSERVER=\\LAPTOP-RB0UQVAC, JAVA_HOME=C:\tool\jdk8, SESSIONNAME=Console, ALLUSERSPROFILE=C:\ProgramData, PROCESSOR_ARCHITECTURE=AMD64, PSModulePath=C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules, SystemDrive=C:, MAVEN_HOME=D:\PTool\maven\apache-maven-3.5.0, OneDrive=C:\Users\a\OneDrive, APPDATA=C:\Users\a\AppData\Roaming, USERNAME=a, ProgramFiles(x86)=C:\Program Files (x86), VBOX_MSI_INSTALL_PATH=D:\PTool\dev\virtualBox\, CommonProgramFiles=C:\Program Files\Common Files, Path=C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;D:\PTool\mysql505\bin;D:\PTool\maven\apache-maven-3.5.0\bin;C:\tool\jdk8\bin;C:\tool\node\;D:\PTool\TortoiseGit\bin;C:\tool\python3\Scripts\;C:\tool\python3\;C:\Users\a\AppData\Local\Microsoft\WindowsApps;C:\Users\a\AppData\Roaming\npm;, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, OS=Windows_NT, COMPUTERNAME=LAPTOP-RB0UQVAC, PROCESSOR_REVISION=4e03, CLASSPATH=.;C:\tool\jdk8\lib\tools.jar;C:\tool\jdk8\lib\dt.jar, CommonProgramW6432=C:\Program Files\Common Files, ComSpec=C:\WINDOWS\system32\cmd.exe, ProgramData=C:\ProgramData, ProgramW6432=C:\Program Files, HOMEPATH=\Users\a, SystemRoot=C:\WINDOWS, TEMP=C:\Users\a\AppData\Local\Temp, HOMEDRIVE=C:, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 78 Stepping 3, GenuineIntel, USERPROFILE=C:\Users\a, TMP=C:\Users\a\AppData\Local\Temp, CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files, ProgramFiles=C:\Program Files, PUBLIC=C:\Users\Public, NUMBER_OF_PROCESSORS=4, windir=C:\WINDOWS, =::=::\}}] 22:07:07.456 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Resolved classpath location [cn/xiangxu/springboot/repository/] to resources [URL [file:/F:/javaProgramming/springBoot/springbootTest/target/test-classes/cn/xiangxu/springboot/repository/], URL [file:/F:/javaProgramming/springBoot/springbootTest/target/classes/cn/xiangxu/springboot/repository/]] 22:07:07.457 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Looking for matching resources in directory tree [F:\javaProgramming\springBoot\springbootTest\target\test-classes\cn\xiangxu\springboot\repository] 22:07:07.457 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Searching directory [F:\javaProgramming\springBoot\springbootTest\target\test-classes\cn\xiangxu\springboot\repository] for files matching pattern [F:/javaProgramming/springBoot/springbootTest/target/test-classes/cn/xiangxu/springboot/repository/*.class] 22:07:07.462 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Looking for matching resources in directory tree [F:\javaProgramming\springBoot\springbootTest\target\classes\cn\xiangxu\springboot\repository] 22:07:07.462 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Searching directory [F:\javaProgramming\springBoot\springbootTest\target\classes\cn\xiangxu\springboot\repository] for files matching pattern [F:/javaProgramming/springBoot/springbootTest/target/classes/cn/xiangxu/springboot/repository/*.class] 22:07:07.463 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Resolved location pattern [classpath*:cn/xiangxu/springboot/repository/*.class] to resources [file [F:\javaProgramming\springBoot\springbootTest\target\test-classes\cn\xiangxu\springboot\repository\GirlRepositoryTest.class], file [F:\javaProgramming\springBoot\springbootTest\target\classes\cn\xiangxu\springboot\repository\GirlRepository.class]] 22:07:07.508 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Resolved classpath location [cn/xiangxu/springboot/] to resources [URL [file:/F:/javaProgramming/springBoot/springbootTest/target/test-classes/cn/xiangxu/springboot/], URL [file:/F:/javaProgramming/springBoot/springbootTest/target/classes/cn/xiangxu/springboot/]] 22:07:07.508 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Looking for matching resources in directory tree [F:\javaProgramming\springBoot\springbootTest\target\test-classes\cn\xiangxu\springboot] 22:07:07.509 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Searching directory [F:\javaProgramming\springBoot\springbootTest\target\test-classes\cn\xiangxu\springboot] for files matching pattern [F:/javaProgramming/springBoot/springbootTest/target/test-classes/cn/xiangxu/springboot/*.class] 22:07:07.510 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Looking for matching resources in directory tree [F:\javaProgramming\springBoot\springbootTest\target\classes\cn\xiangxu\springboot] 22:07:07.510 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Searching directory [F:\javaProgramming\springBoot\springbootTest\target\classes\cn\xiangxu\springboot] for files matching pattern [F:/javaProgramming/springBoot/springbootTest/target/classes/cn/xiangxu/springboot/*.class] 22:07:07.518 [main] DEBUG org.springframework.core.io.support.PathMatchingResourcePatternResolver - Resolved location pattern [classpath*:cn/xiangxu/springboot/*.class] to resources [file [F:\javaProgramming\springBoot\springbootTest\target\test-classes\cn\xiangxu\springboot\SpringbootApplicationTests.class], file [F:\javaProgramming\springBoot\springbootTest\target\classes\cn\xiangxu\springboot\SpringbootApplication.class]] 22:07:07.591 [main] DEBUG org.springframework.context.annotation.ClassPathScanningCandidateComponentProvider - Identified candidate component class: file [F:\javaProgramming\springBoot\springbootTest\target\classes\cn\xiangxu\springboot\SpringbootApplication.class] 22:07:07.592 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Found @SpringBootConfiguration cn.xiangxu.springboot.SpringbootApplication for test class cn.xiangxu.springboot.repository.GirlRepositoryTest 22:07:07.598 [main] DEBUG org.springframework.boot.test.context.SpringBootTestContextBootstrapper - @TestExecutionListeners is not present for class [cn.xiangxu.springboot.repository.GirlRepositoryTest]: using defaults. 22:07:07.607 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Loaded default TestExecutionListener class names from location [META-INF/spring.factories]: [org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener, org.springframework.test.context.web.ServletTestExecutionListener, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener, org.springframework.test.context.support.DependencyInjectionTestExecutionListener, org.springframework.test.context.support.DirtiesContextTestExecutionListener, org.springframework.test.context.transaction.TransactionalTestExecutionListener, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener] 22:07:07.643 [main] INFO org.springframework.boot.test.context.SpringBootTestContextBootstrapper - Using TestExecutionListeners: [org.springframework.test.context.web.ServletTestExecutionListener@1188e820, org.springframework.test.context.support.DirtiesContextBeforeModesTestExecutionListener@2f490758, org.springframework.boot.test.autoconfigure.SpringBootDependencyInjectionTestExecutionListener@101df177, org.springframework.test.context.support.DirtiesContextTestExecutionListener@166fa74d, org.springframework.test.context.transaction.TransactionalTestExecutionListener@40f08448, org.springframework.test.context.jdbc.SqlScriptsTestExecutionListener@276438c9, org.springframework.boot.test.mock.mockito.ResetMocksTestExecutionListener@588df31b, org.springframework.boot.test.autoconfigure.web.servlet.MockMvcPrintOnlyOnFailureTestExecutionListener@33b37288, org.springframework.boot.test.mock.mockito.MockitoTestExecutionListener@77a57272, org.springframework.boot.test.autoconfigure.restdocs.RestDocsTestExecutionListener@7181ae3f, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverTestExecutionListener@46238e3f, org.springframework.boot.test.autoconfigure.web.client.MockRestServiceServerResetTestExecutionListener@6e2c9341] 22:07:07.645 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:07:07.646 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [cn.xiangxu.springboot.repository.GirlRepositoryTest]22:07:07.656 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:07:07.656 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [cn.xiangxu.springboot.repository.GirlRepositoryTest]22:07:07.656 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:07:07.656 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:07:07.656 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:07:07.656 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:07:07.656 [main] DEBUG org.springframework.test.context.support.AbstractDirtiesContextTestExecutionListener - Before test class: context [DefaultTestContext@6b67034 testClass = GirlRepositoryTest, testInstance = [null], testMethod = [null], testException = [null], mergedContextConfiguration = [WebMergedContextConfiguration@16267862 testClass = GirlRepositoryTest, locations = '{}', classes = '{class cn.xiangxu.springboot.SpringbootApplication}', contextInitializerClasses = '[]', activeProfiles = '{}', propertySourceLocations = '{}', propertySourceProperties = '{org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true}', contextCustomizers = set[org.springframework.boot.test.context.SpringBootTestContextCustomizer@cb644e, org.springframework.boot.test.context.filter.ExcludeFilterContextCustomizer@4566e5bd, org.springframework.boot.test.json.DuplicateJsonObjectContextCustomizerFactory$DuplicateJsonObjectContextCustomizer@25bbe1b6, org.springframework.boot.test.mock.mockito.MockitoContextCustomizer@0, org.springframework.boot.test.autoconfigure.properties.PropertyMappingContextCustomizer@0, org.springframework.boot.test.autoconfigure.web.servlet.WebDriverContextCustomizerFactory$Customizer@20398b7c], resourceBasePath = 'src/main/webapp', contextLoader = 'org.springframework.boot.test.context.SpringBootContextLoader', parent = [null]]], class annotated with @DirtiesContext [false] with mode [null]. 22:07:07.656 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved @ProfileValueSourceConfiguration [null] for test class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:07:07.656 [main] DEBUG org.springframework.test.annotation.ProfileValueUtils - Retrieved ProfileValueSource type [class org.springframework.test.annotation.SystemProfileValueSource] for class [cn.xiangxu.springboot.repository.GirlRepositoryTest] 22:07:07.752 [main] DEBUG org.springframework.core.env.StandardEnvironment - Adding PropertySource 'systemProperties' with lowest search precedence 22:07:07.752 [main] DEBUG org.springframework.core.env.StandardEnvironment - Adding PropertySource 'systemEnvironment' with lowest search precedence 22:07:07.753 [main] DEBUG org.springframework.core.env.StandardEnvironment - Initialized StandardEnvironment with PropertySources [MapPropertySource@867148091 {name='systemProperties', properties={java.runtime.name=Java(TM) SE Runtime Environment, sun.boot.library.path=C:\tool\jdk8\jre\bin, java.vm.version=25.101-b13, java.vm.vendor=Oracle Corporation, java.vendor.url=http://java.oracle.com/, path.separator=;, java.vm.name=Java HotSpot(TM) 64-Bit Server VM, file.encoding.pkg=sun.io, user.country=CN, user.script=, sun.java.launcher=SUN_STANDARD, sun.os.patch.level=, java.vm.specification.name=Java Virtual Machine Specification, user.dir=F:\javaProgramming\springBoot\springbootTest, java.runtime.version=1.8.0_101-b13, java.awt.graphicsenv=sun.awt.Win32GraphicsEnvironment, java.endorsed.dirs=C:\tool\jdk8\jre\lib\endorsed, os.arch=amd64, java.io.tmpdir=C:\Users\a\AppData\Local\Temp\, line.separator= , java.vm.specification.vendor=Oracle Corporation, user.variant=, os.name=Windows 10, sun.jnu.encoding=GBK, java.library.path=C:\tool\jdk8\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;D:\PTool\mysql505\bin;D:\PTool\maven\apache-maven-3.5.0\bin;C:\tool\jdk8\bin;C:\tool\node\;D:\PTool\TortoiseGit\bin;C:\tool\python3\Scripts\;C:\tool\python3\;C:\Users\a\AppData\Local\Microsoft\WindowsApps;C:\Users\a\AppData\Roaming\npm;;., java.specification.name=Java Platform API Specification, java.class.version=52.0, sun.management.compiler=HotSpot 64-Bit Tiered Compilers, os.version=10.0, user.home=C:\Users\a, user.timezone=Asia/Shanghai, java.awt.printerjob=sun.awt.windows.WPrinterJob, file.encoding=UTF-8, java.specification.version=1.8, java.class.path=C:\tool\IntelliJ IDEA 2017.2.5\lib\idea_rt.jar;C:\tool\IntelliJ IDEA 2017.2.5\plugins\junit\lib\junit-rt.jar;C:\tool\IntelliJ IDEA 2017.2.5\plugins\junit\lib\junit5-rt.jar;C:\tool\jdk8\jre\lib\charsets.jar;C:\tool\jdk8\jre\lib\deploy.jar;C:\tool\jdk8\jre\lib\ext\access-bridge-64.jar;C:\tool\jdk8\jre\lib\ext\cldrdata.jar;C:\tool\jdk8\jre\lib\ext\dnsns.jar;C:\tool\jdk8\jre\lib\ext\jaccess.jar;C:\tool\jdk8\jre\lib\ext\jfxrt.jar;C:\tool\jdk8\jre\lib\ext\localedata.jar;C:\tool\jdk8\jre\lib\ext\nashorn.jar;C:\tool\jdk8\jre\lib\ext\sunec.jar;C:\tool\jdk8\jre\lib\ext\sunjce_provider.jar;C:\tool\jdk8\jre\lib\ext\sunmscapi.jar;C:\tool\jdk8\jre\lib\ext\sunpkcs11.jar;C:\tool\jdk8\jre\lib\ext\zipfs.jar;C:\tool\jdk8\jre\lib\javaws.jar;C:\tool\jdk8\jre\lib\jce.jar;C:\tool\jdk8\jre\lib\jfr.jar;C:\tool\jdk8\jre\lib\jfxswt.jar;C:\tool\jdk8\jre\lib\jsse.jar;C:\tool\jdk8\jre\lib\management-agent.jar;C:\tool\jdk8\jre\lib\plugin.jar;C:\tool\jdk8\jre\lib\resources.jar;C:\tool\jdk8\jre\lib\rt.jar;F:\javaProgramming\springBoot\springbootTest\target\test-classes;F:\javaProgramming\springBoot\springbootTest\target\classes;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-web\1.5.8.RELEASE\spring-boot-starter-web-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter\1.5.8.RELEASE\spring-boot-starter-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot\1.5.8.RELEASE\spring-boot-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-autoconfigure\1.5.8.RELEASE\spring-boot-autoconfigure-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-logging\1.5.8.RELEASE\spring-boot-starter-logging-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\ch\qos\logback\logback-classic\1.1.11\logback-classic-1.1.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\ch\qos\logback\logback-core\1.1.11\logback-core-1.1.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\jul-to-slf4j\1.7.25\jul-to-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\log4j-over-slf4j\1.7.25\log4j-over-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\yaml\snakeyaml\1.17\snakeyaml-1.17.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-tomcat\1.5.8.RELEASE\spring-boot-starter-tomcat-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-core\8.5.23\tomcat-embed-core-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-annotations-api\8.5.23\tomcat-annotations-api-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-el\8.5.23\tomcat-embed-el-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\embed\tomcat-embed-websocket\8.5.23\tomcat-embed-websocket-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-validator\5.3.5.Final\hibernate-validator-5.3.5.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\javax\validation\validation-api\1.1.0.Final\validation-api-1.1.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\jboss\logging\jboss-logging\3.3.1.Final\jboss-logging-3.3.1.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\classmate\1.3.4\classmate-1.3.4.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-databind\2.8.10\jackson-databind-2.8.10.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-annotations\2.8.0\jackson-annotations-2.8.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\fasterxml\jackson\core\jackson-core\2.8.10\jackson-core-2.8.10.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-web\4.3.12.RELEASE\spring-web-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-aop\4.3.12.RELEASE\spring-aop-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-beans\4.3.12.RELEASE\spring-beans-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-context\4.3.12.RELEASE\spring-context-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-webmvc\4.3.12.RELEASE\spring-webmvc-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-expression\4.3.12.RELEASE\spring-expression-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-test\1.5.8.RELEASE\spring-boot-starter-test-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-test\1.5.8.RELEASE\spring-boot-test-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-test-autoconfigure\1.5.8.RELEASE\spring-boot-test-autoconfigure-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\jayway\jsonpath\json-path\2.2.0\json-path-2.2.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\net\minidev\json-smart\2.2.1\json-smart-2.2.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\net\minidev\accessors-smart\1.1\accessors-smart-1.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\ow2\asm\asm\5.0.3\asm-5.0.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\slf4j-api\1.7.25\slf4j-api-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\junit\junit\4.12\junit-4.12.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\assertj\assertj-core\2.6.0\assertj-core-2.6.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\mockito\mockito-core\1.10.19\mockito-core-1.10.19.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\objenesis\objenesis\2.1\objenesis-2.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hamcrest\hamcrest-library\1.3\hamcrest-library-1.3.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\skyscreamer\jsonassert\1.4.0\jsonassert-1.4.0.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\vaadin\external\google\android-json\0.0.20131108.vaadin1\android-json-0.0.20131108.vaadin1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-core\4.3.12.RELEASE\spring-core-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-test\4.3.12.RELEASE\spring-test-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\mysql\mysql-connector-java\5.1.44\mysql-connector-java-5.1.44.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-data-jpa\1.5.8.RELEASE\spring-boot-starter-data-jpa-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-aop\1.5.8.RELEASE\spring-boot-starter-aop-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\aspectj\aspectjweaver\1.8.11\aspectjweaver-1.8.11.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\boot\spring-boot-starter-jdbc\1.5.8.RELEASE\spring-boot-starter-jdbc-1.5.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-jdbc\8.5.23\tomcat-jdbc-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\apache\tomcat\tomcat-juli\8.5.23\tomcat-juli-8.5.23.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-jdbc\4.3.12.RELEASE\spring-jdbc-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-core\5.0.12.Final\hibernate-core-5.0.12.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\javax\persistence\hibernate-jpa-2.1-api\1.0.0.Final\hibernate-jpa-2.1-api-1.0.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\javassist\javassist\3.21.0-GA\javassist-3.21.0-GA.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\antlr\antlr\2.7.7\antlr-2.7.7.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\jboss\jandex\2.0.0.Final\jandex-2.0.0.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\dom4j\dom4j\1.6.1\dom4j-1.6.1.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\common\hibernate-commons-annotations\5.0.1.Final\hibernate-commons-annotations-5.0.1.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\hibernate\hibernate-entitymanager\5.0.12.Final\hibernate-entitymanager-5.0.12.Final.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\javax\transaction\javax.transaction-api\1.2\javax.transaction-api-1.2.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\data\spring-data-jpa\1.11.8.RELEASE\spring-data-jpa-1.11.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\data\spring-data-commons\1.13.8.RELEASE\spring-data-commons-1.13.8.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-orm\4.3.12.RELEASE\spring-orm-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-tx\4.3.12.RELEASE\spring-tx-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\slf4j\jcl-over-slf4j\1.7.25\jcl-over-slf4j-1.7.25.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\springframework\spring-aspects\4.3.12.RELEASE\spring-aspects-4.3.12.RELEASE.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\com\alibaba\druid\1.0.19\druid-1.0.19.jar;C:\tool\jdk8\lib\jconsole.jar;C:\tool\jdk8\lib\tools.jar;D:\PTool\maven\apache-maven-3.5.0\conf\bdck\org\projectlombok\lombok\1.16.18\lombok-1.16.18.jar;C:\tool\IntelliJ IDEA 2017.2.5\lib\idea_rt.jar, user.name=a, java.vm.specification.version=1.8, sun.java.command=com.intellij.rt.execution.junit.JUnitStarter -ideVersion5 -junit4 cn.xiangxu.springboot.repository.GirlRepositoryTest,updateAgeById, java.home=C:\tool\jdk8\jre, sun.arch.data.model=64, user.language=zh, java.specification.vendor=Oracle Corporation, awt.toolkit=sun.awt.windows.WToolkit, java.vm.info=mixed mode, java.version=1.8.0_101, java.ext.dirs=C:\tool\jdk8\jre\lib\ext;C:\WINDOWS\Sun\Java\lib\ext, sun.boot.class.path=C:\tool\jdk8\jre\lib\resources.jar;C:\tool\jdk8\jre\lib\rt.jar;C:\tool\jdk8\jre\lib\sunrsasign.jar;C:\tool\jdk8\jre\lib\jsse.jar;C:\tool\jdk8\jre\lib\jce.jar;C:\tool\jdk8\jre\lib\charsets.jar;C:\tool\jdk8\jre\lib\jfr.jar;C:\tool\jdk8\jre\classes, java.vendor=Oracle Corporation, file.separator=\, java.vendor.url.bug=http://bugreport.sun.com/bugreport/, idea.test.cyclic.buffer.size=1048576, sun.io.unicode.encoding=UnicodeLittle, sun.cpu.endian=little, sun.desktop=windows, sun.cpu.isalist=amd64}}, SystemEnvironmentPropertySource@2051853139 {name='systemEnvironment', properties={configsetroot=C:\WINDOWS\ConfigSetRoot, USERDOMAIN_ROAMINGPROFILE=LAPTOP-RB0UQVAC, LOCALAPPDATA=C:\Users\a\AppData\Local, PROCESSOR_LEVEL=6, USERDOMAIN=LAPTOP-RB0UQVAC, LOGONSERVER=\\LAPTOP-RB0UQVAC, JAVA_HOME=C:\tool\jdk8, SESSIONNAME=Console, ALLUSERSPROFILE=C:\ProgramData, PROCESSOR_ARCHITECTURE=AMD64, PSModulePath=C:\Program Files\WindowsPowerShell\Modules;C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules, SystemDrive=C:, MAVEN_HOME=D:\PTool\maven\apache-maven-3.5.0, OneDrive=C:\Users\a\OneDrive, APPDATA=C:\Users\a\AppData\Roaming, USERNAME=a, ProgramFiles(x86)=C:\Program Files (x86), VBOX_MSI_INSTALL_PATH=D:\PTool\dev\virtualBox\, CommonProgramFiles=C:\Program Files\Common Files, Path=C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;D:\PTool\mysql505\bin;D:\PTool\maven\apache-maven-3.5.0\bin;C:\tool\jdk8\bin;C:\tool\node\;D:\PTool\TortoiseGit\bin;C:\tool\python3\Scripts\;C:\tool\python3\;C:\Users\a\AppData\Local\Microsoft\WindowsApps;C:\Users\a\AppData\Roaming\npm;, PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC, OS=Windows_NT, COMPUTERNAME=LAPTOP-RB0UQVAC, PROCESSOR_REVISION=4e03, CLASSPATH=.;C:\tool\jdk8\lib\tools.jar;C:\tool\jdk8\lib\dt.jar, CommonProgramW6432=C:\Program Files\Common Files, ComSpec=C:\WINDOWS\system32\cmd.exe, ProgramData=C:\ProgramData, ProgramW6432=C:\Program Files, HOMEPATH=\Users\a, SystemRoot=C:\WINDOWS, TEMP=C:\Users\a\AppData\Local\Temp, HOMEDRIVE=C:, PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 78 Stepping 3, GenuineIntel, USERPROFILE=C:\Users\a, TMP=C:\Users\a\AppData\Local\Temp, CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files, ProgramFiles=C:\Program Files, PUBLIC=C:\Users\Public, NUMBER_OF_PROCESSORS=4, windir=C:\WINDOWS, =::=::\}}] 22:07:07.757 [main] DEBUG org.springframework.core.env.MutablePropertySources - Adding PropertySource 'inline' with highest search precedence 22:07:07.757 [main] DEBUG org.springframework.test.context.support.TestPropertySourceUtils - Adding inlined properties to environment: {spring.jmx.enabled=false, org.springframework.boot.test.context.SpringBootTestContextBootstrapper=true, server.port=-1} 22:07:07.757 [main] DEBUG org.springframework.core.env.StandardEnvironment - Adding PropertySource 'Inlined Test Properties' with highest search precedence . ____ _ __ _ _ /\\ / ___'_ __ _ _(_)_ __ __ _ \ \ \ \ ( ( )\___ | '_ | '_| | '_ \/ _` | \ \ \ \ \\/ ___)| |_)| | | | | || (_| | ) ) ) ) ' |____| .__|_| |_|_| |_\__, | / / / / =========|_|==============|___/=/_/_/_/ :: Spring Boot :: (v1.5.8.RELEASE) 2017-11-27 22:07:08,806 - Starting GirlRepositoryTest on LAPTOP-RB0UQVAC with PID 10408 (started by a in F:\javaProgramming\springBoot\springbootTest) - 2017-11-27 22:07:08,808 - No active profile set, falling back to default profiles: default - 2017-11-27 22:07:08,951 - Refreshing org.springframework.web.context.support.GenericWebApplicationContext@4be29ed9: startup date [Mon Nov 27 22:07:08 CST 2017]; root of context hierarchy - 2017-11-27 22:07:11,426 - {dataSource-1} inited - 2017-11-27 22:07:11,774 - Building JPA container EntityManagerFactory for persistence unit 'default' - 2017-11-27 22:07:11,796 - HHH000204: Processing PersistenceUnitInfo [ name: default ...] - 2017-11-27 22:07:11,912 - HHH000412: Hibernate Core {5.0.12.Final} - 2017-11-27 22:07:11,912 - HHH000206: hibernate.properties not found - 2017-11-27 22:07:11,912 - HHH000021: Bytecode provider name : javassist - 2017-11-27 22:07:11,975 - HCANN000001: Hibernate Commons Annotations {5.0.1.Final} - 2017-11-27 22:07:12,144 - HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect - 2017-11-27 22:07:13,015 - HHH000228: Running hbm2ddl schema update - 2017-11-27 22:07:13,177 - Initialized JPA EntityManagerFactory for persistence unit 'default' - 2017-11-27 22:07:13,500 - HHH000397: Using ASTQueryTranslatorFactory - 2017-11-27 22:07:14,518 - Looking for @ControllerAdvice: org.springframework.web.context.support.GenericWebApplicationContext@4be29ed9: startup date [Mon Nov 27 22:07:08 CST 2017]; root of context hierarchy - 2017-11-27 22:07:14,643 - Mapped "{[/error]}" onto public org.springframework.http.ResponseEntity<java.util.Map<java.lang.String, java.lang.Object>> org.springframework.boot.autoconfigure.web.BasicErrorController.error(javax.servlet.http.HttpServletRequest) - 2017-11-27 22:07:14,646 - Mapped "{[/error],produces=[text/html]}" onto public org.springframework.web.servlet.ModelAndView org.springframework.boot.autoconfigure.web.BasicErrorController.errorHtml(javax.servlet.http.HttpServletRequest,javax.servlet.http.HttpServletResponse) - 2017-11-27 22:07:14,779 - Mapped URL path [/webjars/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler] - 2017-11-27 22:07:14,783 - Mapped URL path [/**] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler] - 2017-11-27 22:07:14,883 - Mapped URL path [/**/favicon.ico] onto handler of type [class org.springframework.web.servlet.resource.ResourceHttpRequestHandler] - 2017-11-27 22:07:15,266 - Started GirlRepositoryTest in 7.494 seconds (JVM running for 8.674) - org.springframework.dao.InvalidDataAccessApiUsageException: Executing an update/delete query; nested exception is javax.persistence.TransactionRequiredException: Executing an update/delete query at org.springframework.orm.jpa.EntityManagerFactoryUtils.convertJpaAccessExceptionIfPossible(EntityManagerFactoryUtils.java:413) at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:246) at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:488) at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59) at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213) at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.data.repository.core.support.SurroundingTransactionDetectorMethodInterceptor.invoke(SurroundingTransactionDetectorMethodInterceptor.java:57) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) at com.sun.proxy.$Proxy80.updateAgeById(Unknown Source) at cn.xiangxu.springboot.repository.GirlRepositoryTest.updateAgeById(GirlRepositoryTest.java:60) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) at org.springframework.test.context.junit4.statements.RunBeforeTestMethodCallbacks.evaluate(RunBeforeTestMethodCallbacks.java:75) at org.springframework.test.context.junit4.statements.RunAfterTestMethodCallbacks.evaluate(RunAfterTestMethodCallbacks.java:86) at org.springframework.test.context.junit4.statements.SpringRepeat.evaluate(SpringRepeat.java:84) at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:252) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.runChild(SpringJUnit4ClassRunner.java:94) at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) at org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) at org.springframework.test.context.junit4.statements.RunBeforeTestClassCallbacks.evaluate(RunBeforeTestClassCallbacks.java:61) at org.springframework.test.context.junit4.statements.RunAfterTestClassCallbacks.evaluate(RunAfterTestClassCallbacks.java:70) at org.junit.runners.ParentRunner.run(ParentRunner.java:363) at org.springframework.test.context.junit4.SpringJUnit4ClassRunner.run(SpringJUnit4ClassRunner.java:191) at org.junit.runner.JUnitCore.run(JUnitCore.java:137) at com.intellij.junit4.JUnit4IdeaTestRunner.startRunnerWithArgs(JUnit4IdeaTestRunner.java:68) at com.intellij.rt.execution.junit.IdeaTestRunner$Repeater.startRunnerWithArgs(IdeaTestRunner.java:47) at com.intellij.rt.execution.junit.JUnitStarter.prepareStreamsAndStart(JUnitStarter.java:242) at com.intellij.rt.execution.junit.JUnitStarter.main(JUnitStarter.java:70) Caused by: javax.persistence.TransactionRequiredException: Executing an update/delete query at org.hibernate.jpa.spi.AbstractQueryImpl.executeUpdate(AbstractQueryImpl.java:54) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:372) at com.sun.proxy.$Proxy90.executeUpdate(Unknown Source) at org.springframework.data.jpa.repository.query.JpaQueryExecution$ModifyingExecution.doExecute(JpaQueryExecution.java:240) at org.springframework.data.jpa.repository.query.JpaQueryExecution.execute(JpaQueryExecution.java:87) at org.springframework.data.jpa.repository.query.AbstractJpaQuery.doExecute(AbstractJpaQuery.java:116) at org.springframework.data.jpa.repository.query.AbstractJpaQuery.execute(AbstractJpaQuery.java:106) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:483) at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:461) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136) ... 38 more 2017-11-27 22:07:15,373 - Closing org.springframework.web.context.support.GenericWebApplicationContext@4be29ed9: startup date [Mon Nov 27 22:07:08 CST 2017]; root of context hierarchy - 2017-11-27 22:07:15,382 - Closing JPA EntityManagerFactory for persistence unit 'default' - 2017-11-27 22:07:15,390 - {dataSource-1} closed - Process finished with exit code -1
3.3 添加@Transactional注解实现事务支持
注意：@Transactional一般都是放在服务层的相关方法中的
@Transactional @Modifying @Query(value = "update Girl o set o.age = ?2 where o.id = ?1") void updateAgeById(Integer id, Integer age);
// // Source code recreated from a .class file by IntelliJ IDEA // (powered by Fernflower decompiler) // package org.springframework.data.jpa.repository; import java.lang.annotation.Documented; import java.lang.annotation.ElementType; import java.lang.annotation.Retention; import java.lang.annotation.RetentionPolicy; import java.lang.annotation.Target; @Retention(RetentionPolicy.RUNTIME) @Target({ElementType.METHOD, ElementType.ANNOTATION_TYPE}) @Documented public @interface Modifying { boolean clearAutomatically() default false; }
package cn.xiangxu.springboot.repository; import cn.xiangxu.springboot.entity.dataObject.Girl; import org.springframework.data.jpa.repository.JpaRepository; import org.springframework.data.jpa.repository.Modifying; import org.springframework.data.jpa.repository.Query; import org.springframework.data.repository.query.Param; import org.springframework.transaction.annotation.Transactional; import java.util.List; public interface GirlRepository extends JpaRepository<Girl, Integer> { // where name like ?% and age < ? List<Girl> findByNameStartingWithAndAgeLessThan(String name, Integer age); @Query("select g from Girl g where id = (select max(id) from Girl g1)") // 利用实体类进行查询，可以用别名代替* Girl findByMaxId(); @Query(nativeQuery = true, value = "select * from girl g") // 利用原生的SQL进行查询，不能用别名代替* List<Girl> findAllGirl(); @Query(nativeQuery = true, value = "select * from girl o where o.girl_id=?1 ") // 索引参数 Girl findOneById(Integer id); @Query(value = "select o from Girl o where o.id=:id") // 命名参数 Girl findGirlById02(@Param("id") Integer girlId); @Transactional @Modifying @Query(value = "update Girl o set o.age = ?2 where o.id = ?1") void updateAgeById(Integer id, Integer age); }
