作者的應(yīng)用有多個(gè)數(shù)據(jù)源,兩個(gè)pg和释漆,一個(gè)mysql
如果應(yīng)用第一個(gè)初始化的數(shù)據(jù)源是pg悲没,那應(yīng)用就會(huì)一直使用pg的dialect繼續(xù)初始化之后的數(shù)據(jù)源
必須在mysql的數(shù)據(jù)源配置類中手動(dòng)指定為mysql的dialect
網(wǎng)上大多數(shù)是在配置文件中指定
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
如果你的數(shù)據(jù)源都是同一類型,就不會(huì)有問(wèn)題
private Map<String, Object> getVendorProperties() {
Map<String, Object> ret = jpaProperties.getHibernateProperties(new HibernateSettings());
ret.put("hibernate.dialect", "org.hibernate.dialect.MySQL5InnoDBDialect");
return ret;
}
/**
* 設(shè)置實(shí)體類所在位置
*/
@Bean(name = "entityManagerFactoryJeecms")
public LocalContainerEntityManagerFactoryBean entityManagerFactoryJeecms(EntityManagerFactoryBuilder builder) {
return builder.dataSource(jeecmsDataSource).packages("com.zupu.core.jeecms.domain")
.persistenceUnit("jeecmsPersistenceUnit").properties(getVendorProperties()).build();
}