飞行路线未创建正确的表

Question

我一直在尝试使用vaadin，Spring boot和flyway创建一个程序。但是，当我尝试访问程序时，JPA没有读取正确的数据库。这是我一直在关注的例子：https://github.com/mstahv/spring-data-vaadin-crud

游戏模板.java

@Entity
@Table(name = "GameTemplate")
public class GameTemplate implements Serializable {
private static final long serialVersionUID = 1L;
@Id
@GeneratedValue(strategy = GenerationType.AUTO)
private long id;
@NotNull(message = "Part number is required")
private String partNum;
private String gameName;
private Double gameCost;
private Double ticketCost;
private Integer numTickets;
private Integer idealGross;
private Integer idealPrizes;
private Integer idealNet;
//omitted
public GameTemplate(){
//JPA
}
//getters/setters

游戏模板回购.java

public interface GameTemplateRepository extends JpaRepository<GameTemplate,    Long> {
List<GameTemplate> findAllBy(Pageable pageable);
List<GameTemplate> findByPartNumLikeIgnoreCase(String partnumFilter);
}

resources/db.migration/V1__Initial_Schema.sql

CREATE TABLE GameTemplate (
`id` bigint auto_increment,
`partNum` varchar(12) NOT NULL,
`gameName` varchar(50) DEFAULT NULL,
`gameCost` double DEFAULT '0',
`ticketCost` double DEFAULT NULL,
`numTickets` int(11) DEFAULT NULL,
`idealGross` mediumint(9) DEFAULT NULL,
`idealPrizes` mediumint(9) DEFAULT NULL,
`idealNet` mediumint(9) DEFAULT NULL,
//omitted, inserted some data as well.

叠：

2016-12-07 20:14:25.818  INFO 18236 --- [  restartedMain] o.f.core.internal.util.VersionPrinter    : Flyway 3.2.1 by Boxfuse
2016-12-07 20:14:25.946  INFO 18236 --- [  restartedMain] o.f.c.i.dbsupport.DbSupportFactory       : Database: jdbc:h2:mem:testdb (H2 1.4)
2016-12-07 20:14:26.057  INFO 18236 --- [  restartedMain] o.f.core.internal.command.DbValidate     : Validated 1 migration (execution time 00:00.082s)
2016-12-07 20:14:26.066  INFO 18236 --- [  restartedMain] o.f.c.i.metadatatable.MetaDataTableImpl  : Creating Metadata table: "PUBLIC"."schema_version"
2016-12-07 20:14:26.080  INFO 18236 --- [  restartedMain] o.f.core.internal.command.DbMigrate      : Current version of schema "PUBLIC": << Empty Schema >>
2016-12-07 20:14:26.080  INFO 18236 --- [  restartedMain] o.f.core.internal.command.DbMigrate      : Migrating schema "PUBLIC" to version 1 - Initial Schema
2016-12-07 20:14:26.095  INFO 18236 --- [  restartedMain] o.f.core.internal.command.DbMigrate      : Successfully applied 1 migration to schema "PUBLIC" (execution time 00:00.030s).

一切似乎都很好，但是在本地主机上访问时：

2016-12-07 20:14:29.680 ERROR 18236 --- [nio-8090-exec-5] o.h.engine.jdbc.spi.SqlExceptionHelper   : Table "GAME_TEMPLATE" not found; SQL statement:

它到底在哪里变得"GAME_TEMPLATE"？

Answer 1

这是因为 Spring 默认使用org.springframework.boot.orm.jpa.SpringNamingStrategy用下划线拆分骆驼大小写名称。有关更多帮助，请参阅此处。

或者，您可以将文件V1__Initial_Schema.sql中的表名更改为Game_Template