DATETIME  == DATETIME(0)  : fractional seconds rounded
DATETIME  -> DATETIME(3)  : support milliseconds
DATETIME  -> DATETIME(6)  : support nano seconds


@Bean
@Primary
public PlatformTransactionManager transactionManager() {

    JpaTransactionManager transactionManager
      = new JpaTransactionManager();
    transactionManager.setEntityManagerFactory(
            entityManagerFactory().getObject());
    return transactionManager;
}

@Bean
@Primary
public LocalContainerEntityManagerFactoryBean entityManagerFactory() {
    LocalContainerEntityManagerFactoryBean em
            = new LocalContainerEntityManagerFactoryBean();
    em.setDataSource(dataSource());
    em.setPackagesToScan(
            new String[] { "{entitiy classes ex=> com.entity.Entity1}" });
    HibernateJpaVendorAdapter vendorAdapter
            = new HibernateJpaVendorAdapter();
    em.setJpaVendorAdapter(vendorAdapter);
    HashMap<String, Object> properties = new HashMap<>();
    properties.put("hibernate.hbm2ddl.auto", "validate" );
    properties.put("hibernate.dialect", "org.hibernate.dialect.MariaDB53Dialect" );
    properties.put("hibernate.show_sql", "true" );
    properties.put("hibernate.implicit_naming_strategy", "org.hibernate.boot.model.naming.ImplicitNamingStrategyJpaCompliantImpl" );
    
    // for spring data compatibility
    properties.put("hibernate.physical_naming_strategy", "org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy" );
    em.setJpaPropertyMap(properties);
    return em;
}

@Primary
@Bean
public DataSource dataSource() {
    HikariDataSource ds = new HikariDataSource();
    ds.setDataSourceProperties(this.getProperties());

    ds.setPoolName("my-pool");
    ds.setConnectionTestQuery("select now() from dual");

    // DataSource Class Name for MariaDB 
    ds.setDataSourceClassName( "org.mariadb.jdbc.MariaDbDataSource");
    //ds.setIdleTimeout(datasourceProperties.getIdleTimeout());
    ds.setMaximumPoolSize( 10 );
    ds.setConnectionTimeout(5000);
    //ds.setMinimumIdle(minIdle);
    ds.setConnectionTestQuery("SELECT 1 FROM DUAL");
    return ds;
}

private Properties getProperties()
{
    Properties prop = new Properties();
    prop.put("serverName", "${HOST IP}");
    prop.put("databaseName", "${DATA BASE NAME}");
    prop.put("user", "${Account ID}");
    prop.put("password", "${Account Password}");


    // Mariadb Clinet Do Not User Below
    // prop.put("cachePrepStmts", "true");
    // prop.put("prepStmtCacheSize", "250");
    // prop.put("prepStmtCacheSqlLimit", "2048");
    // prop.put("encoding", "UTF-8");
    return prop;
}