Spring + JPA + Mysql数据库没有返回本机生成的标识值

lsmepo6l  于 2023-06-28  发布在  Mysql
关注(0)|答案(1)|浏览(123)

我是Spring的初学者，我尝试了一个简单的java-mysql持久化示例。

pom.xml

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3.     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  4.     <modelVersion>4.0.0</modelVersion>
  6.     <groupId>com.example</groupId>
  7.     <artifactId>mysqlConnect</artifactId>
  8.     <version>0.0.1-SNAPSHOT</version>
  9.     <packaging>jar</packaging>
  11.     <name>mysqlConnect</name>
  12.     <description>Demo project for Spring Boot</description>
  14.     <parent>
  15.         <groupId>org.springframework.boot</groupId>
  16.         <artifactId>spring-boot-starter-parent</artifactId>
  17.         <version>1.4.3.RELEASE</version>
  18.         <relativePath/> <!-- lookup parent from repository -->
  19.     </parent>
  21.     <properties>
  22.         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  23.         <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
  24.         <java.version>1.8</java.version>
  25.     </properties>
  27.     <dependencies>
  28.         <dependency>
  29.             <groupId>org.springframework.boot</groupId>
  30.             <artifactId>spring-boot-starter-data-jpa</artifactId>
  31.         </dependency>
  33.         <dependency>
  34.             <groupId>mysql</groupId>
  35.             <artifactId>mysql-connector-java</artifactId>
  36.             <scope>runtime</scope>
  37.         </dependency>
  38.         <!--<dependency>
  39.             <groupId>org.springframework.boot</groupId>
  40.             <artifactId>spring-boot-starter-test</artifactId>
  41.             <scope>test</scope>
  42.         </dependency>-->
  43.     </dependencies>
  45.     <build>
  46.         <plugins>
  47.             <plugin>
  48.                 <groupId>org.springframework.boot</groupId>
  49.                 <artifactId>spring-boot-maven-plugin</artifactId>
  50.             </plugin>
  51.         </plugins>
  52.     </build>
  54. </project>

application.properties

  1. spring.datasource.url=jdbc:mysql://localhost:3306/demo
  2. spring.datasource.username=user
  3. spring.datasource.password=password
  4. spring.datasource.driver-class-name=com.mysql.jdbc.Driver

Student.java

  1. package com.example.models;
  3. import javax.persistence.*;
  5. @Entity
  6. @Table(name = "Student")
  7. public class Student {
  9.     @Id
  10.     @GeneratedValue(strategy = GenerationType.AUTO)
  11.     private Long id;
  12.     private String name;
  13.     private String town;
  15.     protected Student() {
  16.     }
  18.     public Student(String name, String town) {
  19.         this.name = name;
  20.         this.town = town;
  21.     }
  23.     @Column(name = "id")
  24.     public Long getId() {
  25.         return id;
  26.     }
  28.     public void setId(Long id) {
  29.         this.id = id;
  30.     }
  32.     @Column(name = "name")
  33.     public String getName() {
  34.         return name;
  35.     }
  37.     public void setName(String name) {
  38.         this.name = name;
  39.     }
  41.     @Column(name = "town")
  42.     public String getTown() {
  43.         return town;
  44.     }
  46.     public void setTown(String town) {
  47.         this.town = town;
  48.     }
  50.     @Override
  51.     public String toString() {
  52.         return "Student{" +
  53.                 "town='" + town + '\'' +
  54.                 ", name='" + name + '\'' +
  55.                 '}';
  56.     }
  57. }

StudnetsServices.java

  1. package com.example.services;
  3. import com.example.models.Student;
  4. import org.springframework.data.repository.CrudRepository;
  6. import java.util.List;
  8. public interface StudentsServices extends CrudRepository<Student, Long> {
  9.         List<Student> findByName(String name);
  10. }

application.java

  1. package com.example;
  3. import com.example.models.Student;
  4. import com.example.services.StudentsServices;
  5. import org.slf4j.Logger;
  6. import org.slf4j.LoggerFactory;
  7. import org.springframework.boot.CommandLineRunner;
  8. import org.springframework.boot.SpringApplication;
  9. import org.springframework.boot.autoconfigure.SpringBootApplication;
  10. import org.springframework.context.annotation.Bean;
  12. @SpringBootApplication
  13. public class MysqlConnectApplication {
  15.     private static final Logger log = LoggerFactory.getLogger(MysqlConnectApplication.class);
  17.     public static void main(String[] args) {
  18.         SpringApplication.run(MysqlConnectApplication.class, args);
  19.     }
  21.     @Bean
  22.     public CommandLineRunner demo(StudentsServices repository){
  23.         return args -> {
  24.             log.info("Saving Tom");
  25.             repository.save(new Student("Tom", "London"));
  26.             log.info("****************************************************");
  27.             log.info("Saving Jerry");
  28.             repository.save(new Student("Jerry", "New-york"));
  29.             log.info("****************************************************");
  30.             log.info("Reeding All");
  31.             for (Student student : repository.findAll()){log.info(student.toString());}
  32.             log.info("****************************************************");
  33.             log.info("Found by name");
  34.             for (Student student : repository.findByName("Thuwarakesh")){
  35.                 log.info(student.toString());
  36.             }
  37.             log.info("****************************************************");
  39.         };
  40.     }
  41. }

Mysql中的表

  1. CREATE TABLE IF NOT EXISTS Student(
  2.   id INT AUTO_INCREMENT,
  3.   name VARCHAR(25),
  4.   town VARCHAR(26),
  5.   PRIMARY KEY (id)
  6. );

当我完成这个并运行jar文件时，我得到了下面的异常。

  1. java.lang.IllegalStateException: Failed to execute CommandLineRunner
  2.     at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:803) [spring-boot-1.4.3.RELEASE.jar!/:1.4.3.RELEASE]
  3.     at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:784) [spring-boot-1.4.3.RELEASE.jar!/:1.4.3.RELEASE]
  4.     at org.springframework.boot.SpringApplication.afterRefresh(SpringApplication.java:771) [spring-boot-1.4.3.RELEASE.jar!/:1.4.3.RELEASE]
  5.     at org.springframework.boot.SpringApplication.run(SpringApplication.java:316) [spring-boot-1.4.3.RELEASE.jar!/:1.4.3.RELEASE]
  6.     at org.springframework.boot.SpringApplication.run(SpringApplication.java:1186) [spring-boot-1.4.3.RELEASE.jar!/:1.4.3.RELEASE]
  7.     at org.springframework.boot.SpringApplication.run(SpringApplication.java:1175) [spring-boot-1.4.3.RELEASE.jar!/:1.4.3.RELEASE]
  8.     at com.example.MysqlConnectApplication.main(MysqlConnectApplication.java:18) [classes!/:0.0.1-SNAPSHOT]
  9.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_45]
  10.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_45]
  11.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_45]
  12.     at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_45]
  13.     at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:48) [mysqlConnect-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
  14.     at org.springframework.boot.loader.Launcher.launch(Launcher.java:87) [mysqlConnect-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
  15.     at org.springframework.boot.loader.Launcher.launch(Launcher.java:50) [mysqlConnect-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
  16.     at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:51) [mysqlConnect-0.0.1-SNAPSHOT.jar:0.0.1-SNAPSHOT]
  17. Caused by: org.springframework.orm.jpa.JpaSystemException: The database returned no natively generated identity value; nested exception is org.hibernate.HibernateException: The database returned no natively generated identity value
  18.     at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:333) ~[spring-orm-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  19.     at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:244) ~[spring-orm-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  20.     at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:491) ~[spring-orm-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  21.     at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:59) ~[spring-tx-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  22.     at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:213) ~[spring-tx-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  23.     at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:147) ~[spring-tx-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  24.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  25.     at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:133) ~[spring-data-jpa-1.10.6.RELEASE.jar!/:na]
  26.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  27.     at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) ~[spring-aop-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  28.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  29.     at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) ~[spring-aop-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  30.     at com.sun.proxy.$Proxy59.save(Unknown Source) ~[na:na]
  31.     at com.example.MysqlConnectApplication.lambda$demo$0(MysqlConnectApplication.java:25) [classes!/:0.0.1-SNAPSHOT]
  32.     at com.example.MysqlConnectApplication$$Lambda$7/889729797.run(Unknown Source) ~[na:na]
  33.     at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:800) [spring-boot-1.4.3.RELEASE.jar!/:1.4.3.RELEASE]
  34.     ... 14 common frames omitted
  35. Caused by: org.hibernate.HibernateException: The database returned no natively generated identity value
  36.     at org.hibernate.id.IdentifierGeneratorHelper.getGeneratedIdentity(IdentifierGeneratorHelper.java:71) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  37.     at org.hibernate.dialect.identity.GetGeneratedKeysDelegate.executeAndExtract(GetGeneratedKeysDelegate.java:61) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  38.     at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:42) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  39.     at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2803) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  40.     at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3374) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  41.     at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  42.     at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:619) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  43.     at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:273) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  44.     at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:254) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  45.     at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:299) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  46.     at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:317) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  47.     at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:272) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  48.     at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:178) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  49.     at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:109) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  50.     at org.hibernate.jpa.event.internal.core.JpaPersistEventListener.saveWithGeneratedId(JpaPersistEventListener.java:67) ~[hibernate-entitymanager-5.0.11.Final.jar!/:5.0.11.Final]
  51.     at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:189) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  52.     at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:132) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  53.     at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:58) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  54.     at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:775) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  55.     at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:748) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  56.     at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:753) ~[hibernate-core-5.0.11.Final.jar!/:5.0.11.Final]
  57.     at org.hibernate.jpa.spi.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:1146) ~[hibernate-entitymanager-5.0.11.Final.jar!/:5.0.11.Final]
  58.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_45]
  59.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_45]
  60.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_45]
  61.     at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_45]
  62.     at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:298) ~[spring-orm-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  63.     at com.sun.proxy.$Proxy57.persist(Unknown Source) ~[na:na]
  64.     at org.springframework.data.jpa.repository.support.SimpleJpaRepository.save(SimpleJpaRepository.java:506) ~[spring-data-jpa-1.10.6.RELEASE.jar!/:na]
  65.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_45]
  66.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_45]
  67.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_45]
  68.     at java.lang.reflect.Method.invoke(Method.java:497) ~[na:1.8.0_45]
  69.     at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.executeMethodOn(RepositoryFactorySupport.java:503) ~[spring-data-commons-1.12.6.RELEASE.jar!/:na]
  70.     at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:488) ~[spring-data-commons-1.12.6.RELEASE.jar!/:na]
  71.     at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:460) ~[spring-data-commons-1.12.6.RELEASE.jar!/:na]
  72.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  73.     at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:61) ~[spring-data-commons-1.12.6.RELEASE.jar!/:na]
  74.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  75.     at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) ~[spring-tx-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  76.     at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:282) ~[spring-tx-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  77.     at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) ~[spring-tx-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  78.     at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  79.     at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136) ~[spring-tx-4.3.5.RELEASE.jar!/:4.3.5.RELEASE]
  80.     ... 24 common frames omitted
mysql

1条答案

按热度按时间
pxq42qpu

pxq42qpu1#

检查mysql数据库，这个特定的列可能没有设置为自动增量，只要将其设置为自动增量，它就会开始正常工作

赞(0）分享  回复(0）举报  2023-06-28
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com