{"id":40266,"date":"2022-12-25T03:00:18","date_gmt":"2023-04-22T11:50:03","guid":{"rendered":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8springboot%e5%92%8cspring-jpa%e8%bf%9e%e6%8e%a5%e5%88%b0%e6%95%b0%e6%8d%ae%e5%ba%93\/"},"modified":"2024-04-29T06:51:37","modified_gmt":"2024-04-28T22:51:37","slug":"%e4%bd%bf%e7%94%a8springboot%e5%92%8cspring-jpa%e8%bf%9e%e6%8e%a5%e5%88%b0%e6%95%b0%e6%8d%ae%e5%ba%93","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8springboot%e5%92%8cspring-jpa%e8%bf%9e%e6%8e%a5%e5%88%b0%e6%95%b0%e6%8d%ae%e5%ba%93\/","title":{"rendered":"\u4f7f\u7528SpringBoot\u548cSpring JPA\u8fde\u63a5\u5230\u6570\u636e\u5e93"},"content":{"rendered":"<h2>\u6211\u5c06\u5c1d\u8bd5\u8bbf\u95ee\u6570\u636e\u5e93\u4f7f\u7528SpringBoot\u3002<\/h2>\n<p>\u4e3a\u4e86\u4f7f\u7528JPA\uff0c\u9700\u8981\u8fdb\u884c\u4ee5\u4e0b\u64cd\u4f5c\u3002<\/p>\n<p>\u8fdb\u884c\u6570\u636e\u5e93\u8fde\u63a5\u7684\u8bbe\u7f6e\u5728application.properties\u6587\u4ef6\u5185\u8fdb\u884c<br \/>\n\u521b\u5efa\u540d\u4e3aEntity\u548cRepository\u7684\u7c7b<\/p>\n<p>1. \u7ec4\u6210<\/p>\n<pre class=\"post-pre\"><code>sample-jpa\r\n\u2502  build.gradle\r\n\u2514\u2500src\r\n    \u2514\u2500main\r\n        \u251c\u2500java\r\n        \u2502  \u2514\u2500com\r\n        \u2502      \u2514\u2500jpasample\r\n        \u2502              Employee.java\r\n        \u2502              EmployeeRepository.java\r\n        \u2502              HeloController.java\r\n        \u2502              SamplePrj004JpaApplication.java\r\n        \u2502              ServletInitializer.java\r\n        \u2514\u2500resources\r\n            \u2502  application.properties\r\n            \u251c\u2500static\r\n            \u2514\u2500templates\r\n                    index.html\r\n<\/code><\/pre>\n<p>2. \u8bbe\u7f6e\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f\uff0c\u5c06\u5176\u914d\u7f6e\u5728application.properties\u6587\u4ef6\u4e2d\uff0c\u5982\u4e0b\u6240\u793a\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"py\">spring.datasource.url<\/span><span class=\"p\">=<\/span><span class=\"s\">jdbc:mysql:\/\/localhost:3306\/sampledb<\/span>\r\n<span class=\"py\">spring.datasource.username<\/span><span class=\"p\">=<\/span><span class=\"s\">testuser<\/span>\r\n<span class=\"py\">spring.datasource.password<\/span><span class=\"p\">=<\/span><span class=\"s\">testuser<\/span>\r\n<span class=\"py\">spring.datasource.driverClassName<\/span><span class=\"p\">=<\/span><span class=\"s\">com.mysql.jdbc.Driver<\/span>\r\n<span class=\"py\">spring.jpa.database<\/span><span class=\"p\">=<\/span><span class=\"s\">MYSQL<\/span>\r\n<span class=\"py\">spring.jpa.hibernate.ddl-auto<\/span><span class=\"p\">=<\/span><span class=\"s\">update<\/span>\r\n<\/code><\/pre>\n<p>\u8bbe\u5b9aspring.jpa.hibernate.ddl-auto=update\u540e\uff0c\u5373\u4f7f\u6570\u636e\u5e93\u4e2d\u6ca1\u6709\u5b9a\u4e49\u8868\uff0c\u4e5f\u4f1a\u521b\u5efa\u8868\u3002<\/p>\n<p>3. \u4e92\u76f8\u4f9d\u8d56\u5173\u7cfb<\/p>\n<pre class=\"post-pre\"><code><span class=\"k\">dependencies<\/span> <span class=\"o\">{<\/span>\r\n    <span class=\"n\">compile<\/span><span class=\"o\">(<\/span><span class=\"s1\">'org.springframework.boot:spring-boot-starter-data-jpa'<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"n\">compile<\/span><span class=\"o\">(<\/span><span class=\"s1\">'org.springframework.boot:spring-boot-starter-thymeleaf'<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"n\">compile<\/span><span class=\"o\">(<\/span><span class=\"s1\">'org.springframework.boot:spring-boot-starter-web'<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"n\">runtime<\/span><span class=\"o\">(<\/span><span class=\"s1\">'org.springframework.boot:spring-boot-devtools'<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"n\">runtime<\/span><span class=\"o\">(<\/span><span class=\"s1\">'mysql:mysql-connector-java'<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"n\">compileOnly<\/span><span class=\"o\">(<\/span><span class=\"s1\">'org.projectlombok:lombok'<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"n\">providedRuntime<\/span><span class=\"o\">(<\/span><span class=\"s1\">'org.springframework.boot:spring-boot-starter-tomcat'<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"n\">testCompile<\/span><span class=\"o\">(<\/span><span class=\"s1\">'org.springframework.boot:spring-boot-starter-test'<\/span><span class=\"o\">)<\/span>\r\n<span class=\"o\">}<\/span>\r\n<\/code><\/pre>\n<p>4. \u5728\u6570\u636e\u5e93\u4e2d\u5b9a\u4e49\u8868\u683c\u3002<\/p>\n<p>\u6211\u6b63\u5728\u63d0\u4f9b\u4e00\u4e2a\u4f5c\u4e3a\u641c\u7d22\u5458\u5de5\u4e3b\u6587\u4ef6\u7684\u793a\u4f8b\u3002<\/p>\n<pre class=\"post-pre\"><code>\r\n<span class=\"k\">CREATE<\/span> <span class=\"k\">TABLE<\/span> <span class=\"nv\">`m_emp`<\/span> <span class=\"p\">(<\/span>\r\n  <span class=\"nv\">`empno`<\/span> <span class=\"nb\">bigint<\/span><span class=\"p\">(<\/span><span class=\"mi\">20<\/span><span class=\"p\">)<\/span> <span class=\"k\">NOT<\/span> <span class=\"k\">NULL<\/span> <span class=\"n\">AUTO_INCREMENT<\/span><span class=\"p\">,<\/span>\r\n  <span class=\"nv\">`empname`<\/span> <span class=\"nb\">varchar<\/span><span class=\"p\">(<\/span><span class=\"mi\">255<\/span><span class=\"p\">)<\/span> <span class=\"k\">DEFAULT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\r\n  <span class=\"nv\">`departmentid`<\/span> <span class=\"nb\">varchar<\/span><span class=\"p\">(<\/span><span class=\"mi\">10<\/span><span class=\"p\">)<\/span> <span class=\"k\">DEFAULT<\/span> <span class=\"k\">NULL<\/span><span class=\"p\">,<\/span>\r\n  <span class=\"k\">PRIMARY<\/span> <span class=\"k\">KEY<\/span> <span class=\"p\">(<\/span><span class=\"nv\">`empno`<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">)<\/span> <span class=\"n\">ENGINE<\/span><span class=\"o\">=<\/span><span class=\"n\">InnoDB<\/span> <span class=\"n\">AUTO_INCREMENT<\/span><span class=\"o\">=<\/span><span class=\"mi\">5<\/span> <span class=\"k\">DEFAULT<\/span> <span class=\"n\">CHARSET<\/span><span class=\"o\">=<\/span><span class=\"n\">utf8<\/span>\r\n<\/code><\/pre>\n<pre class=\"post-pre\"><code><span class=\"k\">INSERT<\/span> <span class=\"k\">INTO<\/span> <span class=\"n\">sampledb<\/span><span class=\"p\">.<\/span><span class=\"n\">m_emp<\/span>\r\n<span class=\"p\">(<\/span><span class=\"n\">empname<\/span><span class=\"p\">,<\/span><span class=\"n\">departmentid<\/span><span class=\"p\">)<\/span>\r\n<span class=\"k\">VALUES<\/span>\r\n <span class=\"p\">(<\/span><span class=\"s1\">'\u5f93\u696d\u54e1A'<\/span><span class=\"p\">,<\/span><span class=\"s1\">'10101001'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">,(<\/span><span class=\"s1\">'\u5f93\u696d\u54e1B'<\/span><span class=\"p\">,<\/span><span class=\"s1\">'10101001'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">,(<\/span><span class=\"s1\">'\u5f93\u696d\u54e1C'<\/span><span class=\"p\">,<\/span><span class=\"s1\">'10101002'<\/span><span class=\"p\">)<\/span>\r\n<span class=\"p\">,(<\/span><span class=\"s1\">'\u5f93\u696d\u54e1D'<\/span><span class=\"p\">,<\/span><span class=\"s1\">'10101003'<\/span><span class=\"p\">)<\/span>\r\n<\/code><\/pre>\n<p>\u521b\u5efa\u4e00\u4e2a\u540d\u4e3aEntity\u7684\u7c7b\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"kn\">import<\/span> <span class=\"nn\">javax.persistence.Column<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">javax.persistence.Entity<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">javax.persistence.GeneratedValue<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">javax.persistence.GenerationType<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">javax.persistence.Id<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">javax.persistence.Table<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"nd\">@Entity<\/span>\r\n<span class=\"nd\">@Table<\/span><span class=\"o\">(<\/span><span class=\"n\">name<\/span><span class=\"o\">=<\/span><span class=\"s\">\"m_emp\"<\/span><span class=\"o\">)<\/span>\r\n<span class=\"kd\">public<\/span> <span class=\"kd\">class<\/span> <span class=\"nc\">Employee<\/span> <span class=\"o\">{<\/span>\r\n    <span class=\"nd\">@Id<\/span>\r\n    <span class=\"nd\">@Column<\/span><span class=\"o\">(<\/span><span class=\"n\">name<\/span><span class=\"o\">=<\/span><span class=\"s\">\"empno\"<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"nd\">@GeneratedValue<\/span><span class=\"o\">(<\/span><span class=\"n\">strategy<\/span><span class=\"o\">=<\/span><span class=\"nc\">GenerationType<\/span><span class=\"o\">.<\/span><span class=\"na\">IDENTITY<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">Long<\/span> <span class=\"n\">id<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"kd\">private<\/span> <span class=\"nc\">String<\/span> <span class=\"n\">empname<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">Long<\/span> <span class=\"nf\">getId<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">id<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">setId<\/span><span class=\"o\">(<\/span><span class=\"nc\">Long<\/span> <span class=\"n\">id<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">id<\/span> <span class=\"o\">=<\/span> <span class=\"n\">id<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">String<\/span> <span class=\"nf\">getEmpname<\/span><span class=\"o\">()<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"n\">empname<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"kt\">void<\/span> <span class=\"nf\">setEmpname<\/span><span class=\"o\">(<\/span><span class=\"nc\">String<\/span> <span class=\"n\">empname<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"k\">this<\/span><span class=\"o\">.<\/span><span class=\"na\">empname<\/span> <span class=\"o\">=<\/span> <span class=\"n\">empname<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n<span class=\"o\">}<\/span>\r\n<\/code><\/pre>\n<p>6. \u5b58\u50a8\u5e93 ch\u00fa k\u00f9)<\/p>\n<pre class=\"post-pre\"><code><span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.data.jpa.repository.JpaRepository<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.stereotype.Repository<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"nd\">@Repository<\/span>\r\n<span class=\"kd\">public<\/span> <span class=\"kd\">interface<\/span> <span class=\"nc\">EmployeeRepository<\/span> <span class=\"kd\">extends<\/span> <span class=\"nc\">JpaRepository<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Employee<\/span><span class=\"o\">,<\/span> <span class=\"nc\">Long<\/span><span class=\"o\">&gt;<\/span> <span class=\"o\">{}<\/span>\r\n\r\n<\/code><\/pre>\n<p>7.\u63a7\u5236\u5668<\/p>\n<p>\u6b63\u5728\u5168\u9762\u67e5\u627e\u5458\u5de5\u4e3b\u6570\u636e\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"kn\">import<\/span> <span class=\"nn\">java.util.List<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">javax.transaction.Transactional<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.beans.factory.annotation.Autowired<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.stereotype.Controller<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.ui.Model<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.web.bind.annotation.RequestMapping<\/span><span class=\"o\">;<\/span>\r\n<span class=\"kn\">import<\/span> <span class=\"nn\">org.springframework.web.bind.annotation.RequestMethod<\/span><span class=\"o\">;<\/span>\r\n\r\n<span class=\"nd\">@Controller<\/span>\r\n<span class=\"kd\">public<\/span> <span class=\"kd\">class<\/span> <span class=\"nc\">HeloController<\/span> <span class=\"o\">{<\/span>\r\n    <span class=\"nd\">@Autowired<\/span>\r\n    <span class=\"nc\">EmployeeRepository<\/span> <span class=\"n\">empRepository<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"nd\">@RequestMapping<\/span><span class=\"o\">(<\/span><span class=\"n\">value<\/span> <span class=\"o\">=<\/span> <span class=\"s\">\"\/\"<\/span><span class=\"o\">,<\/span> <span class=\"n\">method<\/span> <span class=\"o\">=<\/span> <span class=\"nc\">RequestMethod<\/span><span class=\"o\">.<\/span><span class=\"na\">GET<\/span><span class=\"o\">)<\/span>\r\n    <span class=\"kd\">public<\/span> <span class=\"nc\">String<\/span> <span class=\"nf\">index<\/span><span class=\"o\">(<\/span><span class=\"nc\">Model<\/span> <span class=\"n\">model<\/span><span class=\"o\">)<\/span> <span class=\"o\">{<\/span>\r\n        <span class=\"nc\">List<\/span><span class=\"o\">&lt;<\/span><span class=\"nc\">Employee<\/span><span class=\"o\">&gt;<\/span> <span class=\"n\">emplist<\/span><span class=\"o\">=<\/span><span class=\"n\">empRepository<\/span><span class=\"o\">.<\/span><span class=\"na\">findAll<\/span><span class=\"o\">();<\/span>\r\n        <span class=\"n\">model<\/span><span class=\"o\">.<\/span><span class=\"na\">addAttribute<\/span><span class=\"o\">(<\/span><span class=\"s\">\"emplist\"<\/span><span class=\"o\">,<\/span> <span class=\"n\">emplist<\/span><span class=\"o\">);<\/span>\r\n        <span class=\"k\">return<\/span> <span class=\"s\">\"index\"<\/span><span class=\"o\">;<\/span>\r\n    <span class=\"o\">}<\/span>\r\n<span class=\"o\">}<\/span>\r\n<\/code><\/pre>\n<p>\u8bf7\u63d0\u4f9b\u66f4\u591a\u80cc\u666f\u4fe1\u606f\uff0c\u5e76\u660e\u786e\u60a8\u6240\u9700\u8981\u7684\u7ffb\u8bd1\u5185\u5bb9\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"cp\">&lt;!DOCTYPE html&gt;<\/span>\r\n<span class=\"nt\">&lt;html<\/span> <span class=\"na\">xmlns=<\/span><span class=\"s\">\"http:\/\/www.w3.org\/1999\/xhtml\"<\/span> <span class=\"na\">xmlns:th=<\/span><span class=\"s\">\"http:\/\/www.thymeleaf.org\"<\/span><span class=\"nt\">&gt;<\/span>\r\n    <span class=\"nt\">&lt;head&gt;<\/span>\r\n        <span class=\"nt\">&lt;title&gt;<\/span>Springboot<span class=\"nt\">&lt;\/title&gt;<\/span>\r\n        <span class=\"nt\">&lt;meta<\/span> <span class=\"na\">charset=<\/span><span class=\"s\">\"utf-8\"<\/span> <span class=\"nt\">\/&gt;<\/span>\r\n    <span class=\"nt\">&lt;\/head&gt;<\/span>\r\n    <span class=\"nt\">&lt;body&gt;<\/span>\r\n        <span class=\"nt\">&lt;h1<\/span> <span class=\"na\">th:text=<\/span><span class=\"s\">\"${title}\"<\/span><span class=\"nt\">&gt;&lt;\/h1&gt;<\/span>\r\n        <span class=\"nt\">&lt;table&gt;<\/span>\r\n            <span class=\"nt\">&lt;tr<\/span> <span class=\"na\">th:each=<\/span><span class=\"s\">\"emp : ${emplist}\"<\/span> <span class=\"na\">th:object=<\/span><span class=\"s\">\"${emp}\"<\/span><span class=\"nt\">&gt;<\/span>\r\n                <span class=\"nt\">&lt;td<\/span> <span class=\"na\">th:text=<\/span><span class=\"s\">\"*{id}\"<\/span><span class=\"nt\">&gt;&lt;\/td&gt;<\/span>\r\n                <span class=\"nt\">&lt;td<\/span> <span class=\"na\">th:text=<\/span><span class=\"s\">\"*{empname}\"<\/span><span class=\"nt\">&gt;&lt;\/td&gt;<\/span>\r\n            <span class=\"nt\">&lt;\/tr&gt;<\/span>\r\n        <span class=\"nt\">&lt;\/table&gt;<\/span>\r\n    <span class=\"nt\">&lt;\/body&gt;<\/span>\r\n<span class=\"nt\">&lt;\/html&gt;<\/span>\r\n<\/code><\/pre>\n<p>\u6211\u5c06\u8fd0\u884cSpringboot\u5e76\u5c1d\u8bd5\u8bbf\u95eeURL\u3002<br \/>\nhttp:\/\/localhost:8080\/<\/p>\n<div><img decoding=\"async\" class=\"post-images\" title=\"\" src=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fa937434c4406c8f7c4\/24-0.png\" alt=\"image.png\" \/><\/div>\n<p>\u88ab\u5ba3\u5e03\u65e0\u4e8b\u3002<\/p>\n<h1>2019\u5e7410\u67088\u65e5 \u6dfb\u52a0\u8865\u5145<\/h1>\n<p>\u5982\u679c\u8981\u8fde\u63a5\u5230PostgreSQL<\/p>\n<p>application.properties\u7684\u5185\u5bb9\u5982\u4e0b\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"py\">spring.jpa.database<\/span><span class=\"p\">=<\/span><span class=\"s\">POSTGRESQL<\/span>\r\n<span class=\"py\">spring.datasource.url<\/span><span class=\"p\">=<\/span><span class=\"s\">jdbc:postgresql:\/\/localhost:5432\/testdb<\/span>\r\n<span class=\"py\">spring.datasource.username<\/span><span class=\"p\">=<\/span><span class=\"s\">testuser<\/span>\r\n<span class=\"py\">spring.datasource.password<\/span><span class=\"p\">=<\/span><span class=\"s\">secret<\/span>\r\n<span class=\"py\">spring.jpa.hibernate.ddl-auto<\/span><span class=\"p\">=<\/span><span class=\"s\">validate<\/span>\r\n<span class=\"py\">spring.jpa.properties.hibernate.format_sql<\/span><span class=\"p\">=<\/span><span class=\"s\">true<\/span>\r\n<span class=\"py\">logging.level.org.hibernate.SQL<\/span><span class=\"p\">=<\/span><span class=\"s\">DEBUG<\/span>\r\n<span class=\"py\">logging.level.org.hibernate.type.descriptor.sql.BasicBinder<\/span><span class=\"p\">=<\/span><span class=\"s\">TRACE<\/span>\r\n<\/code><\/pre>\n<p>\u7136\u800c\uff0c\u4ec5\u4ec5\u8fd9\u6837\u505a\u4f1a\u5bfc\u81f4\u4ee5\u4e0b\u9519\u8bef\u7684\u53d1\u751f\u3002<\/p>\n<pre class=\"post-pre\"><code>Caused by: java.sql.SQLFeatureNotSupportedException: org.postgresql.jdbc.PgConnection.createClob() \u30e1\u30bd\u30c3\u30c9\u306f\u307e\u3060\u5b9f\u88c5\u3055\u308c\u3066\u3044\u307e\u305b\u3093\u3002\r\n    at org.postgresql.Driver.notImplemented(Driver.java:688) ~[postgresql-42.2.5.jar:42.2.5]\r\n    at org.postgresql.jdbc.PgConnection.createClob(PgConnection.java:1269) ~[postgresql-42.2.5.jar:42.2.5]\r\n<\/code><\/pre>\n<p>\u89e3\u51b3\u529e\u6cd5<\/p>\n<p>\u5c06hibernate.properties\u6587\u4ef6\u521b\u5efa\u5728resources\u6587\u4ef6\u5939\u7684\u76f4\u63a5\u4e0b\u7ea7\uff08\u4e0eapplication.properties\u6587\u4ef6\u76f8\u540c\u7684\u5c42\u7ea7\uff09\u4e0a\u3002<\/p>\n<pre class=\"post-pre\"><code><span class=\"py\">hibernate.jdbc.lob.non_contextual_creation<\/span> <span class=\"p\">=<\/span> <span class=\"s\">true<\/span>\r\n<\/code><\/pre>\n<p>\u6ca1\u95ee\u9898\uff0c\u8fde\u63a5\u6210\u529f\u3002<\/p>\n<pre class=\"post-pre\"><code>2019-10-08 23:37:42.626  INFO 5464 --- [           main] org.hibernate.Version                    : HHH000412: Hibernate Core {5.3.7.Final}\r\n2019-10-08 23:37:42.626  INFO 5464 --- [           main] org.hibernate.cfg.Environment            : HHH000205: Loaded properties from resource hibernate.properties: {hibernate.bytecode.use_reflection_optimizer=false, hibernate.jdbc.lob.non_contextual_creation=true}\r\n2019-10-08 23:37:42.876  INFO 5464 --- [           main] o.hibernate.annotations.common.Version   : HCANN000001: Hibernate Commons Annotations {5.0.4.Final}\r\n2019-10-08 23:37:43.485  INFO 5464 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Starting...\r\n2019-10-08 23:37:43.641  INFO 5464 --- [           main] com.zaxxer.hikari.HikariDataSource       : HikariPool-1 - Start completed.\r\n2019-10-08 23:37:43.657  INFO 5464 --- [           main] org.hibernate.dialect.Dialect            : HHH000400: Using dialect: org.hibernate.dialect.PostgreSQL95Dialect\r\n2019-10-08 23:37:43.891  INFO 5464 --- [           main] o.h.e.j.e.i.LobCreatorBuilderImpl        : HHH000421: Disabling contextual LOB creation as hibernate.jdbc.lob.non_contextual_creation is true\r\n2019-10-08 23:37:43.907  INFO 5464 --- [           main] org.hibernate.type.BasicTypeRegistry     : HHH000270: Type registration [java.util.UUID] overrides previous : org.hibernate.type.UUIDBinaryType@2e590b\r\n2019-10-08 23:37:44.289  INFO 5464 --- [           main] j.LocalContainerEntityManagerFactoryBean : Initialized JPA EntityManagerFactory for persistence unit 'default'\r\n2019-10-08 23:37:47.675  INFO 5464 --- [           main] o.s.b.web.embedded.netty.NettyWebServer  : Netty started on port(s): 8080\r\n2019-10-08 23:37:47.686  INFO 5464 --- [           main] com.example.SecurityExampleApplication   : Started SecurityExampleApplication in 9.322 seconds (JVM running for 10.28)\r\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u6211\u5c06\u5c1d\u8bd5\u8bbf\u95ee\u6570\u636e\u5e93\u4f7f\u7528SpringBoot\u3002 \u4e3a\u4e86\u4f7f\u7528JPA\uff0c\u9700\u8981\u8fdb\u884c\u4ee5\u4e0b\u64cd\u4f5c\u3002 \u8fdb\u884c\u6570\u636e\u5e93\u8fde\u63a5\u7684\u8bbe\u7f6e\u5728app [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-40266","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u4f7f\u7528SpringBoot\u548cSpring JPA\u8fde\u63a5\u5230\u6570\u636e\u5e93 - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528springboot\u548cspring-jpa\u8fde\u63a5\u5230\u6570\u636e\u5e93\/\" \/>\n<meta property=\"og:locale\" content=\"zh_CN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u4f7f\u7528SpringBoot\u548cSpring JPA\u8fde\u63a5\u5230\u6570\u636e\u5e93\" \/>\n<meta property=\"og:description\" content=\"\u6211\u5c06\u5c1d\u8bd5\u8bbf\u95ee\u6570\u636e\u5e93\u4f7f\u7528SpringBoot\u3002 \u4e3a\u4e86\u4f7f\u7528JPA\uff0c\u9700\u8981\u8fdb\u884c\u4ee5\u4e0b\u64cd\u4f5c\u3002 \u8fdb\u884c\u6570\u636e\u5e93\u8fde\u63a5\u7684\u8bbe\u7f6e\u5728app [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528springboot\u548cspring-jpa\u8fde\u63a5\u5230\u6570\u636e\u5e93\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-22T11:50:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-28T22:51:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fa937434c4406c8f7c4\/24-0.png\" \/>\n<meta name=\"author\" content=\"\u6e05, \u626c\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u4f5c\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u6e05, \u626c\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 \u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8springboot%e5%92%8cspring-jpa%e8%bf%9e%e6%8e%a5%e5%88%b0%e6%95%b0%e6%8d%ae%e5%ba%93\/\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8springboot%e5%92%8cspring-jpa%e8%bf%9e%e6%8e%a5%e5%88%b0%e6%95%b0%e6%8d%ae%e5%ba%93\/\",\"name\":\"\u4f7f\u7528SpringBoot\u548cSpring JPA\u8fde\u63a5\u5230\u6570\u636e\u5e93 - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\"},\"datePublished\":\"2023-04-22T11:50:03+00:00\",\"dateModified\":\"2024-04-28T22:51:37+00:00\",\"author\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8springboot%e5%92%8cspring-jpa%e8%bf%9e%e6%8e%a5%e5%88%b0%e6%95%b0%e6%8d%ae%e5%ba%93\/#breadcrumb\"},\"inLanguage\":\"zh-Hans\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8springboot%e5%92%8cspring-jpa%e8%bf%9e%e6%8e%a5%e5%88%b0%e6%95%b0%e6%8d%ae%e5%ba%93\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8springboot%e5%92%8cspring-jpa%e8%bf%9e%e6%8e%a5%e5%88%b0%e6%95%b0%e6%8d%ae%e5%ba%93\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9875\",\"item\":\"https:\/\/www.silicloud.com\/zh\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u4f7f\u7528SpringBoot\u548cSpring JPA\u8fde\u63a5\u5230\u6570\u636e\u5e93\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/\",\"name\":\"Blog - Silicon Cloud\",\"description\":\"\",\"inLanguage\":\"zh-Hans\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461\",\"name\":\"\u6e05, \u626c\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g\",\"caption\":\"\u6e05, \u626c\"},\"url\":\"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/\"},{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-Hans\",\"@id\":\"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8springboot%e5%92%8cspring-jpa%e8%bf%9e%e6%8e%a5%e5%88%b0%e6%95%b0%e6%8d%ae%e5%ba%93\/#local-main-organization-logo\",\"url\":\"\",\"contentUrl\":\"\",\"caption\":\"Blog - Silicon Cloud\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u4f7f\u7528SpringBoot\u548cSpring JPA\u8fde\u63a5\u5230\u6570\u636e\u5e93 - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528springboot\u548cspring-jpa\u8fde\u63a5\u5230\u6570\u636e\u5e93\/","og_locale":"zh_CN","og_type":"article","og_title":"\u4f7f\u7528SpringBoot\u548cSpring JPA\u8fde\u63a5\u5230\u6570\u636e\u5e93","og_description":"\u6211\u5c06\u5c1d\u8bd5\u8bbf\u95ee\u6570\u636e\u5e93\u4f7f\u7528SpringBoot\u3002 \u4e3a\u4e86\u4f7f\u7528JPA\uff0c\u9700\u8981\u8fdb\u884c\u4ee5\u4e0b\u64cd\u4f5c\u3002 \u8fdb\u884c\u6570\u636e\u5e93\u8fde\u63a5\u7684\u8bbe\u7f6e\u5728app [&hellip;]","og_url":"https:\/\/www.silicloud.com\/zh\/blog\/\u4f7f\u7528springboot\u548cspring-jpa\u8fde\u63a5\u5230\u6570\u636e\u5e93\/","og_site_name":"Blog - Silicon Cloud","article_published_time":"2023-04-22T11:50:03+00:00","article_modified_time":"2024-04-28T22:51:37+00:00","og_image":[{"url":"https:\/\/cdn.silicloud.com\/blog-img\/blog\/img\/657d3fa937434c4406c8f7c4\/24-0.png"}],"author":"\u6e05, \u626c","twitter_card":"summary_large_image","twitter_misc":{"\u4f5c\u8005":"\u6e05, \u626c","\u9884\u8ba1\u9605\u8bfb\u65f6\u95f4":"4 \u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8springboot%e5%92%8cspring-jpa%e8%bf%9e%e6%8e%a5%e5%88%b0%e6%95%b0%e6%8d%ae%e5%ba%93\/","url":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8springboot%e5%92%8cspring-jpa%e8%bf%9e%e6%8e%a5%e5%88%b0%e6%95%b0%e6%8d%ae%e5%ba%93\/","name":"\u4f7f\u7528SpringBoot\u548cSpring JPA\u8fde\u63a5\u5230\u6570\u636e\u5e93 - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website"},"datePublished":"2023-04-22T11:50:03+00:00","dateModified":"2024-04-28T22:51:37+00:00","author":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461"},"breadcrumb":{"@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8springboot%e5%92%8cspring-jpa%e8%bf%9e%e6%8e%a5%e5%88%b0%e6%95%b0%e6%8d%ae%e5%ba%93\/#breadcrumb"},"inLanguage":"zh-Hans","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8springboot%e5%92%8cspring-jpa%e8%bf%9e%e6%8e%a5%e5%88%b0%e6%95%b0%e6%8d%ae%e5%ba%93\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8springboot%e5%92%8cspring-jpa%e8%bf%9e%e6%8e%a5%e5%88%b0%e6%95%b0%e6%8d%ae%e5%ba%93\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9875","item":"https:\/\/www.silicloud.com\/zh\/blog\/"},{"@type":"ListItem","position":2,"name":"\u4f7f\u7528SpringBoot\u548cSpring JPA\u8fde\u63a5\u5230\u6570\u636e\u5e93"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#website","url":"https:\/\/www.silicloud.com\/zh\/blog\/","name":"Blog - Silicon Cloud","description":"","inLanguage":"zh-Hans"},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/cb5556d2501da73d864cac945e8d9461","name":"\u6e05, \u626c","image":{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/32a4239de8ff29adace466261d309424a1e5fe9f7e3036bf89fe03f2e3dbe717?s=96&d=mm&r=g","caption":"\u6e05, \u626c"},"url":"https:\/\/www.silicloud.com\/zh\/blog\/author\/qingyang\/"},{"@type":"ImageObject","inLanguage":"zh-Hans","@id":"https:\/\/www.silicloud.com\/zh\/blog\/%e4%bd%bf%e7%94%a8springboot%e5%92%8cspring-jpa%e8%bf%9e%e6%8e%a5%e5%88%b0%e6%95%b0%e6%8d%ae%e5%ba%93\/#local-main-organization-logo","url":"","contentUrl":"","caption":"Blog - Silicon Cloud"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/40266","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/comments?post=40266"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/40266\/revisions"}],"predecessor-version":[{"id":83709,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/posts\/40266\/revisions\/83709"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/media?parent=40266"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/categories?post=40266"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/zh\/blog\/wp-json\/wp\/v2\/tags?post=40266"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}