How to use

org.springframework.orm.jpa.vendor.HibernateJpaDialect

constructor

HibernateJpaDialect hibernateJpaDialect =new HibernateJpaDialect();

@Bean
public JpaDialect jpaDialect() {
  return new HibernateJpaDialect();
}

@Primary
@Bean(name = TRANSACTION_MANAGER_BEAN)
public PlatformTransactionManager accountRepoTransactionManager(
  @Qualifier(ACCOUNT_REPO_ENTITY_MANAGER_FACTORY_BEAN) EntityManagerFactory entityManagerFactory) {
  JpaTransactionManager tm =
    new JpaTransactionManager(entityManagerFactory);
  tm.setJpaDialect(new HibernateJpaDialect());
  return tm;
}

@Bean(name=TRANSACTION_MANAGER_BEAN)
@Primary
public PlatformTransactionManager
  snapshotTransactionManager(@Qualifier(ENTITY_MANAGER_FACTORY_BEAN) EntityManagerFactory entityManagerFactory) {
  JpaTransactionManager tm =
    new JpaTransactionManager(entityManagerFactory);
  tm.setJpaDialect(new HibernateJpaDialect());
  return tm;
}

 @Bean
public PlatformTransactionManager transactionManager() {
  JpaTransactionManager jpaTransactionManager = new JpaTransactionManager(entityManagerFactory().getObject());
  jpaTransactionManager.setDataSource(dataSource());
  jpaTransactionManager.setJpaDialect(new HibernateJpaDialect());
  return jpaTransactionManager;
}

 @Configuration
@EnableTransactionManagement
@PropertySource("classpath:/db.properties")
public class EntityManagerConfig implements TransactionManagementConfigurer {

  ...

  @Override
  public PlatformTransactionManager annotationDrivenTransactionManager() {
    return transactionManager();
  }

  @Bean
  public PlatformTransactionManager transactionManager() {
    JpaTransactionManager transactionManager = new JpaTransactionManager(entityManagerFactory());
    transactionManager.setDataSource(dataSource);
    transactionManager.setJpaDialect(new HibernateJpaDialect());
    return transactionManager;
  }

  ...
}

factory.setJpaVendorAdapter(vendorAdapter);
factory.setPackagesToScan(packageScan.split(","));
factory.setJpaDialect(new HibernateJpaDialect());

private final HibernateJpaDialect jpaDialect = new HibernateJpaDialect();

@Bean
public PlatformTransactionManager transactionManager() throws URISyntaxException {
  JpaTransactionManager transactionManager = new JpaTransactionManager(entityManagerFactory());
  transactionManager.setDataSource(dataSource());
  transactionManager.setJpaDialect(new HibernateJpaDialect());
  return transactionManager;
}

  @Bean
  LocalContainerEntityManagerFactoryBean writeEntityManagerFactory() {

    HibernateJpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
    vendorAdapter.setGenerateDdl(false);
    vendorAdapter.setShowSql(true);
    vendorAdapter.setDatabasePlatform("org.hibernate.dialect.MySQLInnoDBDialect");
    // vendorAdapter.setDatabasePlatform("org.springframework.boot.orm.jpa.hibernate.SpringJtaPlatform");

    LocalContainerEntityManagerFactoryBean factoryBean = new LocalContainerEntityManagerFactoryBean();
    factoryBean.setDataSource(writeDataSource);
    factoryBean.setJpaVendorAdapter(vendorAdapter);
    factoryBean.setPackagesToScan("com.cml.learn.jpa.db.bean", "com.cml.learn.jpa.dto");

    Map<String, Object> jpaProperties = new HashMap<>();
    jpaProperties.put("hibernate.physical_naming_strategy", new SpringPhysicalNamingStrategy());
    jpaProperties.put("hibernate.implicit_naming_strategy", new SpringImplicitNamingStrategy());
    factoryBean.setJpaPropertyMap(jpaProperties);

    factoryBean.setJpaDialect(new HibernateJpaDialect());

    return factoryBean;
  }
}

  @Bean
  LocalContainerEntityManagerFactoryBean readEntityManagerFactory() {

    HibernateJpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();
    vendorAdapter.setGenerateDdl(false);
    vendorAdapter.setShowSql(true);
    vendorAdapter.setDatabasePlatform("org.hibernate.dialect.MySQLInnoDBDialect");
    // vendorAdapter.setDatabasePlatform("org.springframework.boot.orm.jpa.hibernate.SpringJtaPlatform");

    LocalContainerEntityManagerFactoryBean factoryBean = new LocalContainerEntityManagerFactoryBean();
    factoryBean.setDataSource(readDataSource);
    factoryBean.setJpaVendorAdapter(vendorAdapter);
    factoryBean.setPackagesToScan("com.cml.learn.jpa.db.bean", "com.cml.learn.jpa.dto");

    Map<String, Object> jpaProperties = new HashMap<>();
    jpaProperties.put("hibernate.physical_naming_strategy", new SpringPhysicalNamingStrategy());
    jpaProperties.put("hibernate.implicit_naming_strategy", new SpringImplicitNamingStrategy());
    factoryBean.setJpaPropertyMap(jpaProperties);

    factoryBean.setJpaDialect(new HibernateJpaDialect());

    return factoryBean;
  }
}

em.setPersistenceUnitName("MyTestPU");
em.setPackagesToScan(new String[]{"com.model"});
em.setJpaDialect(new HibernateJpaDialect());
em.setJpaPropertyMap(jpaProperties());
em.setJpaVendorAdapter(jpaVendorAdapter());
jpaTransactionManager.setEntityManagerFactory(entityManagerFactory().getObject());
jpaTransactionManager.setDataSource(dataSource());
jpaTransactionManager.setJpaDialect(new HibernateJpaDialect());
return jpaTransactionManager;

JpaTransactionManager transactionManager = new JpaTransactionManager(entityManagerFactory());
transactionManager.setDataSource(dataSource());
transactionManager.setJpaDialect(new HibernateJpaDialect());
return transactionManager;