网站开发心得500字,线上建模培训班哪个好,营销型网站建设集装箱液袋,分析网页设计我希望每次应用程序运行时自动删除表并创建一个新表,并自动插入预定义数据.我已经在import.sql中准备数据了.我已经在application.properties中设置了spring.jpa.hibernate.ddl-auto create-drop.但是,为什么我会收到以下错误#xff1f;我可以手动插入它.2015-11-20 20:53:5…我希望每次应用程序运行时自动删除表并创建一个新表,并自动插入预定义数据.我已经在import.sql中准备数据了.我已经在application.properties中设置了spring.jpa.hibernate.ddl-auto create-drop.但是,为什么我会收到以下错误我可以手动插入它.2015-11-20 20:53:57.242 ERROR 7092 --- [ost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaExport : HHH000388: Unsuccessful: INSERT INTO gender2015-11-20 20:53:57.242 ERROR 7092 --- [ost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaExport : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near at line 12015-11-20 20:53:57.242 ERROR 7092 --- [ost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaExport : HHH000388: Unsuccessful: (gender_id, gender_name)2015-11-20 20:53:57.257 ERROR 7092 --- [ost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaExport : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near gender_id, gender_name) at line 12015-11-20 20:53:57.257 ERROR 7092 --- [ost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaExport : HHH000388: Unsuccessful: VALUES2015-11-20 20:53:57.257 ERROR 7092 --- [ost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaExport : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near VALUES at line 12015-11-20 20:53:57.257 ERROR 7092 --- [ost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaExport : HHH000388: Unsuccessful: (1, Male),2015-11-20 20:53:57.257 ERROR 7092 --- [ost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaExport : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 1, Male), at line 12015-11-20 20:53:57.257 ERROR 7092 --- [ost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaExport : HHH000388: Unsuccessful: (2, Female)2015-11-20 20:53:57.257 ERROR 7092 --- [ost-startStop-1] org.hibernate.tool.hbm2ddl.SchemaExport : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 2, Female) at line 1这是我的实体Entitypublic class Gender {IdColumn(name gender_id)GeneratedValue(strategy GenerationType.IDENTITY)private long id;Column(name gender_name)private String name;}这是我在import.sql中的查询INSERT INTO gender(gender_id, gender_name)VALUES(1, Male),(2, Female);解决方法:根据错误的模式,您的行结尾似乎包含无法处理的字符(隐藏字符,如LF或类似的东西).我这样说是因为你所有的错误都与行尾有关.尝试将import.sql放在一行中,如下所示INSERT INTO gender (gender_id, gender_name) VALUES (1, Male), (2, Female);注意在关键字之间只留出空格并删除所有不可打印的字符.您可以使用自己喜欢的文本编辑器并使用“显示所有字符”选项.标签java,spring,jpa,hibernate来源 https://codeday.me/bug/20190623/1271436.html
