code: @Override
  	public Object getNextID(NormalJdbcTool jdbc, Dialect dialect, Type dataType) {
  		int countOfRec = ((Number) jdbc // NOSONAR
  				.nQueryForObject("select count(*) from " + table + " where " + pkColumnName + "=?", pkColumnValue))
  						.intValue();
  		if (countOfRec == 0) {
  			jdbc.nUpdate("insert into " + table + "( " + pkColumnName + "," + valueColumnName + " )  values(?,?)",
  					pkColumnValue, initialValue);
  			return initialValue;
  		} else {
  			jdbc.nUpdate("update " + table + " set " + valueColumnName + "=" + valueColumnName + "+" + allocationSize
  					+ "  where " + pkColumnName + " =?", pkColumnValue);
  
  			int last = ((Number) jdbc.nQueryForObject( // NOSONAR
  					"select " + valueColumnName + " from " + table + " where " + pkColumnName + "=?", pkColumnValue))
  							.intValue();
  			return last;
  		}
  	}
docs: Get the next Table Generator ID