Discuss / Java / 老师，为什么这章使用hsqldb数据库不用创建表就能工作，换成MySQL数据库后报错表不存在
Back

老师，为什么这章使用hsqldb数据库不用创建表就能工作，换成MySQL数据库后报错表不存在

Topic source

格格巫92190

#1 Created at ... [Delete] [Delete and Lock User]

老师，为什么这章使用hsqldb数据库不用创建表就能工作，换成MySQL数据库后报错表不存在

ERROR: Table 'learnjdbc.user' doesn't exist

格格巫92190

#2 Created at ... [Delete] [Delete and Lock User]

找到原因了，为下边参数设置问题

props.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQLDialect");

Its a Dialect related issue, instead of org.hibernate.dialect.MySQLDialect you can go with org.hibernate.dialect.MySQL5Dialect. It will work happily.

Best of Me

#3 Created at ... [Delete] [Delete and Lock User]

`hibernate.hbm2ddl.auto=update`：表示自动创建数据库的表结构，注意不要在生产环境中启用

  • 1

Reply