How to use

setHeartbeatSql

method

in

com.avaje.ebean.config.DataSourceConfig

private DataSource getDataSourceFromConfig(ServerConfig config) {
 DataSource ds = null;
 if (config.getDataSourceJndiName() != null) {
  ds = jndiDataSourceFactory.lookup(config.getDataSourceJndiName());
  if (ds == null) {
   String m = "JNDI lookup for DataSource " + config.getDataSourceJndiName() + " returned null.";
   throw new PersistenceException(m);
  } else {
   return ds;
  }
 }
 DataSourceConfig dsConfig = config.getDataSourceConfig();
 if (dsConfig == null) {
  String m = "No DataSourceConfig definded for " + config.getName();
  throw new PersistenceException(m);
 }
 if (dsConfig.isOffline()) {
  if (config.getDatabasePlatformName() == null) {
   String m = "You MUST specify a DatabasePlatformName on ServerConfig when offline";
   throw new PersistenceException(m);
  }
  return null;
 }
 if (dsConfig.getHeartbeatSql() == null) {
  // use default heartbeatSql from the DatabasePlatform
  String heartbeatSql = getHeartbeatSql(dsConfig.getDriver());
  dsConfig.setHeartbeatSql(heartbeatSql);
 }
 return DataSourceGlobalManager.getDataSource(config.getName(), dsConfig);
}

private DataSource getDataSourceFromConfig(ServerConfig config) {
 DataSource ds = null;
 if (config.getDataSourceJndiName() != null) {
  ds = jndiDataSourceFactory.lookup(config.getDataSourceJndiName());
  if (ds == null) {
   String m = "JNDI lookup for DataSource " + config.getDataSourceJndiName() + " returned null.";
   throw new PersistenceException(m);
  } else {
   return ds;
  }
 }
 DataSourceConfig dsConfig = config.getDataSourceConfig();
 if (dsConfig == null) {
  String m = "No DataSourceConfig definded for " + config.getName();
  throw new PersistenceException(m);
 }
 if (dsConfig.isOffline()) {
  if (config.getDatabasePlatformName() == null) {
   String m = "You MUST specify a DatabasePlatformName on ServerConfig when offline";
   throw new PersistenceException(m);
  }
  return null;
 }
 if (dsConfig.getHeartbeatSql() == null) {
  // use default heartbeatSql from the DatabasePlatform
  String heartbeatSql = getHeartbeatSql(dsConfig.getDriver());
  dsConfig.setHeartbeatSql(heartbeatSql);
 }
 return DataSourceGlobalManager.getDataSource(config.getName(), dsConfig);
}