Wrap JGroups JDBC_PING with decorator that knows which SQL to use based on db dialect
Description
We made an effort to remove our custom JGroups classes. But we still need to support multiple databases in a simple manner. To use JDBC_PING, an implementer is required to configure SQL to create the table used by JDBC_PING.
For uPortal, a better solution is create a decorator that can set SQL based on the Hiberate dialect in use.
After some research, found another solution that does not require custom Java code. Through system property 'hibernate.dialect' and Spring configuration, the correct init SQL can be selected for JDBC_PING.
We made an effort to remove our custom JGroups classes. But we still need to support multiple databases in a simple manner. To use JDBC_PING, an implementer is required to configure SQL to create the table used by JDBC_PING.
For uPortal, a better solution is create a decorator that can set SQL based on the Hiberate dialect in use.