我被春季 冬眠的奇怪问题。
我有一些实体:
package arthur.khusnutdinov.mysitev2.pub.mods.db;
// Generated 05.09.2017 23:23:19 by Hibernate Tools 5.2.5.Final
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import static javax.persistence.GenerationType.IDENTITY;
import javax.persistence.Id;
import javax.persistence.Table;
/**
* SitePages generated by hbm2java
*/
@Entity
@Table(name = "site_pages", catalog = "artfunpw")
public class SitePages implements java.io.Serializable {
private Integer id;
private String pageUrl;
private String pageHtmlContent;
和会话配置代码:
@Bean
public LocalSessionFactoryBean sessionFactory() {
LocalSessionFactoryBean factoryBean = new LocalSessionFactoryBean();
factoryBean.setDataSource(dbDataSource);
Properties props = new Properties();
props.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQLDialect");
props.setProperty("hibernate.format_sql", "true");
props.setProperty("hibernate.show_sql", "true");
props.setProperty("net.sf.ehcache.configurationResourceName", "/ehcache.xml");
props.setProperty("hibernate.cache.provider_class", "org.hibernate.cache.EhCacheProvider");
props.setProperty("hibernate.cache.region.factory_class", "org.hibernate.cache.ehcache.EhCacheRegionFactory");
props.setProperty("hibernate.cache.use_second_level_cache", "true");
props.setProperty("hibernate.cache.use_query_cache", "true");
factoryBean.setHibernateProperties(props);
factoryBean.setPackagesToScan("arthur.khusnutdinov");
return factoryBean;
}
一切正常,直到mySQL数据库中的表名是 sitepages ,但是它不起作用,如果表名是 site_pages - 我有Java.sql.sql。似乎Hibernate忽略了@Table(name = "site_pages", catalog = "artfunpw")
。
我在做什么错,如何使Hibernate尊重@Table注释?
非常感谢!
更新1 :试图添加
spring.jpa.hibernate.naming.physical-strategy=org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl
进入 application.properties - 没有帮助。
hibernate.implicit_naming_strategy
也无法解决问题。
更新2 :我使用Hibernate 5:)。
已解决!
问题是在休眠5的变化中。
找到答案后,我更改了sessionFactory()
-我添加了factoryBean.setPhysicalNamingStrategy(new PhysicalNamingStrategyStandardImpl());
-代码:
@Bean
public LocalSessionFactoryBean sessionFactory() {
LocalSessionFactoryBean factoryBean = new LocalSessionFactoryBean();
factoryBean.setDataSource(dbDataSource);
Properties props = new Properties();
props.setProperty("hibernate.dialect", "org.hibernate.dialect.MySQL5Dialect");
props.setProperty("hibernate.format_sql", "true");
props.setProperty("hibernate.show_sql", "true");
props.setProperty("net.sf.ehcache.configurationResourceName", "/ehcache.xml");
props.setProperty("hibernate.cache.provider_class", "org.hibernate.cache.EhCacheProvider");
props.setProperty("hibernate.cache.region.factory_class", "org.hibernate.cache.ehcache.EhCacheRegionFactory");
props.setProperty("hibernate.cache.use_second_level_cache", "true");
props.setProperty("hibernate.cache.use_query_cache", "true");
factoryBean.setHibernateProperties(props);
factoryBean.setPhysicalNamingStrategy(new PhysicalNamingStrategyStandardImpl());
return factoryBean;
}
我还更改了select
语句的代码。现在看起来像
List<SitePages> filmList = new ArrayList<>();
filmList = sessionFactory.getCurrentSession()
.createNativeQuery("select * from site_pages")
.setCacheable(false)
.list();
System.out.println(filmList.size());
在这些更改之后,一切正常:)。