@Configuration
@ComponentScan(basePackages = { "config","controller","dao","entity","service"})
@EnableWebMvc
@EnableTransactionManagement
public class HibernateConfig {
    private static Logger logger=LoggerFactory.getLogger(HibernateConfig.class);
 
    @Bean
    public DataSource getDataSource() {
        DriverManagerDataSource dataSource = null;
        try {
            dataSource = new DriverManagerDataSource();
            dataSource.setDriverClassName("com.mysql.jdbc.Driver");
            dataSource.setUrl("jdbc:mysql://localhost:3306/dbfastwater?useSSL=false");//"jdbc:mysql://localhost:3306/dbfastwater?useSSL=false"
            dataSource.setUsername("root");
            dataSource.setPassword("root");
        } catch (Exception e) {
            logger.error("MysqlDataSource bean cannot be created!", e);
        }
        return dataSource;
    }
    org.springframework.jndi.JndiObjectFactoryBean dataSourseJndi=new org.springframework.jndi.JndiObjectFactoryBean();
 
    private Properties hibernateProperties() {
        Properties hibernateProp = new Properties();
        hibernateProp.put("hibernate.dialect", "org.hibernate.spatial.dialect.mysql.MySQL56SpatialDialect");
        hibernateProp.put("connection.driver_class", "com.mysql.jdbc.Driver");
        hibernateProp.put("current_session_context_class","thread");
        hibernateProp.put("hibernate.connection.datasource","jdbc_dbfastwater");
        hibernateProp.put("hibernate.format_sql", true);
        hibernateProp.put("hibernate.use_sql_comments", true);
        hibernateProp.put("hibernate.show_sql", true);
        hibernateProp.put("hibernate.max_fetch_depth", 3);
        hibernateProp.put("hibernate.jdbc.batch_size", 10);
        hibernateProp.put("hibernate.jdbc.fetch_size", 50);
        hibernateProp.put("hibernate.hbm2ddl.auto","update");
        return hibernateProp;
    }
 
    @Bean
    public SessionFactory sessionFactory() throws IOException {
        LocalSessionFactoryBean sessionFactoryBean = new LocalSessionFactoryBean();
        sessionFactoryBean.setDataSource(getDataSource());
        sessionFactoryBean.setPackagesToScan("entity","dao","service");
        sessionFactoryBean.afterPropertiesSet();
        sessionFactoryBean.setHibernateProperties(hibernateProperties());
        return sessionFactoryBean.getObject();
    }
 
    @Bean
    public PlatformTransactionManager transactionManager() throws IOException {
        HibernateTransactionManager transactionManager=new HibernateTransactionManager();
        transactionManager.setSessionFactory(sessionFactory());
        return transactionManager;
    }
}

dataSource.setUrl("jdbc:mysql://localhost:4848/jdbc_dbfastwater");

[2019-04-13T20:44:07.780+0500] [glassfish 5.0] [WARNING] [] [java.util.prefs] [tid: _ThreadID=46 _ThreadName=admin-listener(4)] [timeMillis: 1555170247780] [levelValue: 900] [[
Could not open/create prefs root node Software\JavaSoft\Prefs at root 0x80000002. Windows RegCreateKeyEx(...) returned error code 5.]]

dataSource.setUrl("jdbc:mysql://localhost:3306/dbfastwater?useSSL=false");

hibernateProp.put("current_session_context_class","thread");
hibernateProp.put("hibernate.connection.datasource","jdbc_dbfastwater");

dataSource.setUrl("jdbc:mysql://localhost:4848/jdbc_dbfastwater");

hibernateProp.put("current_session_context_class","thread");
hibernateProp.put("hibernate.connection.datasource","jdbc_dbfastwater");