***POM.XML***

jdbc.driver.class.name      =com.mysql.jdbc.Driver
jdbc.url                    =jdbc:mysql://localhost:3306/web_users?useSSL=false&characterEncoding=UTF-8
jdbc.user.name              =root
jdbc.password               =root

hibernate.hbm2ddl.auto      =update
hibernate.show_sql          =true
hibernate.format_sql        =true
hibernate.generate_statistics=false


***HibernateConfig.java***

 @Configuration
@PropertySource(value = {"classpath:hibernate.properties"})
@EnableJpaRepositories(basePackages = "com.website.dao")
public class HibernateConfig {

@Autowired
private Environment environment;

// 1. create DataSource

@Bean
public DataSource dataSource() {
    DriverManagerDataSource dataSource = new DriverManagerDataSource();
    dataSource.setDriverClassName(environment.getRequiredProperty("jdbc.driver.class.name"));
    dataSource.setPassword(environment.getRequiredProperty("jdbc.password"));
    dataSource.setUsername(environment.getRequiredProperty("jdbc.user.name"));
    dataSource.setUrl(environment.getRequiredProperty("jdbc.url"));

    return dataSource;
}

// 2. EntityManagerFactory

    @Bean
    public EntityManagerFactory entityManagerFactory() {

    HibernateJpaVendorAdapter vendorAdapter = new HibernateJpaVendorAdapter();

    Properties properties = new Properties();
    properties.put("hibernate.hbm2ddl.auto", environment.getProperty("hibernate.hbm2ddl.auto"));
    properties.put("hibernate.show_sql", environment.getProperty("hibernate.show_sql"));
    properties.put("hibernate.format_sql", environment.getProperty("hibernate.format_sql"));
    properties.put("hibernate.generate_statistics", environment.getProperty("hibernate.generate_statistics"));

    LocalContainerEntityManagerFactoryBean factoryBean = new LocalContainerEntityManagerFactoryBean();
    factoryBean.setPackagesToScan("com.website.model");
    factoryBean.setJpaVendorAdapter(vendorAdapter);
    factoryBean.setJpaProperties(properties);
    factoryBean.setDataSource(dataSource());
    factoryBean.afterPropertiesSet();

    return factoryBean.getObject();
}