H5W3
当前位置:H5W3 > 问答 > 正文

JPA hibernate 无法自动创建表

配置

spring:
jpa:
open-in-view: true
database: mysql
show-sql: true
properties:
hibernate:
dialect: org.hibernate.dialect.MySQLDialect
ddl:
auto: update
database:
driver-class-name: com.mysql.cj.jdbc.Driver
datasource:
url: jdbc:mysql://localhost:3306/demo?characterEncoding=utf8
username: xxxxxx
password: xxxxxx
test-while-idle: true
validation-query: SELECT 1

POJO类

package com.inaction.licensingservice.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.Id;
import javax.persistence.Table;
import javax.persistence.Transient;
@Entity
@Table(name = "license")
public class License{
@Id
@Column(name = "license_id", nullable = false)
private String licenseId;
@Column(name = "organization_id", nullable = false)
private String organizationId;
@Transient
private String organizationName ="";
@Transient
private String contactName ="";
@Transient
private String contactPhone ="";
@Transient
private String contactEmail ="";
@Column(name = "product_name", nullable = false)
private String productName;
@Column(name = "license_type", nullable = false)
private String licenseType;
@Column(name = "license_max", nullable = false)
private Integer licenseMax;
@Column(name = "license_allocated", nullable = false)
private Integer licenseAllocated;
@Column(name="comment")
private String comment;
public Integer getLicenseMax() {
return licenseMax;
}
public void setLicenseMax(Integer licenseMax) {
this.licenseMax = licenseMax;
}
public Integer getLicenseAllocated() {
return licenseAllocated;
}
public void setLicenseAllocated(Integer licenseAllocated) {
this.licenseAllocated = licenseAllocated;
}
public String getLicenseId() {
return licenseId;
}
public void setLicenseId(String licenseId) {
this.licenseId = licenseId;
}
public String getOrganizationId() {
return organizationId;
}
public void setOrganizationId(String organizationId) {
this.organizationId = organizationId;
}
public String getProductName() {
return productName;
}
public void setProductName(String productName) {
this.productName = productName;
}
public String getLicenseType() {
return licenseType;
}
public void setLicenseType(String licenseType) {
this.licenseType = licenseType;
}
public String getComment() {
return comment;
}
public void setComment(String comment) {
this.comment = comment;
}
public String getOrganizationName() {
return organizationName;
}
public void setOrganizationName(String organizationName) {
this.organizationName = organizationName;
}
public String getContactName() {
return contactName;
}
public void setContactName(String contactName) {
this.contactName = contactName;
}
public String getContactPhone() {
return contactPhone;
}
public void setContactPhone(String contactPhone) {
this.contactPhone = contactPhone;
}
public String getContactEmail() {
return contactEmail;
}
public void setContactEmail(String contactEmail) {
this.contactEmail = contactEmail;
}
public License withId(String id){
this.setLicenseId(id);
return this;
}
public License withOrganizationId(String organizationId){
this.setOrganizationId(organizationId);
return this;
}
public License withProductName(String productName){
this.setProductName(productName);
return this;
}
public License withLicenseType(String licenseType){
this.setLicenseType(licenseType);
return this;
}
public License withLicenseMax(Integer licenseMax){
this.setLicenseMax(licenseMax);
return this;
}
public License withLicenseAllocated(Integer licenseAllocated){
this.setLicenseAllocated(licenseAllocated);
return this;
}
public License withComment(String comment){
this.setComment(comment);
return this;
}
public License withOrganizationName(String organizationName){
this.setOrganizationName(organizationName);
return this;
}
public License withContactName(String contactName){
this.setContactName(contactName);
return this;
}
public License withContactPhone(String contactPhone){
this.setContactPhone(contactPhone);
return this;
}
public License withContactEmail(String contactEmail){
this.setContactEmail(contactEmail);
return this;
}
}

不知道为什么创建不了表

回答

我没测试,但是看官方文档说https://docs.spring.io/spring-boot/docs/1.1.0.M1/reference/html/howto-database-initialization.html的第一章节 Initialize a database using JPA 说是在spring.jpa.hibernate.ddl-auto 配置 你可以试一下,仅做参考

JPA hibernate 无法自动创建表

未经允许不得转载:H5W3 » JPA hibernate 无法自动创建表

赞 (0)

评论 0

  • 昵称 (必填)
  • 邮箱 (必填)
  • 网址