How to use

createQueryKey

method

in

org.postgresql.core.QueryExecutor

private boolean executeCachedSql(String sql, int flags, String[] columnNames) throws SQLException {
 PreferQueryMode preferQueryMode = connection.getPreferQueryMode();
 // Simple statements should not replace ?, ? with $1, $2
 boolean shouldUseParameterized = false;
 QueryExecutor queryExecutor = connection.getQueryExecutor();
 Object key = queryExecutor
   .createQueryKey(sql, replaceProcessingEnabled, shouldUseParameterized, columnNames);
 CachedQuery cachedQuery;
 boolean shouldCache = preferQueryMode == PreferQueryMode.EXTENDED_CACHE_EVERYTHING;
 if (shouldCache) {
  cachedQuery = queryExecutor.borrowQueryByKey(key);
 } else {
  cachedQuery = queryExecutor.createQueryByKey(key);
 }
 if (wantsGeneratedKeysOnce) {
  SqlCommand sqlCommand = cachedQuery.query.getSqlCommand();
  wantsGeneratedKeysOnce = sqlCommand != null && sqlCommand.isReturningKeywordPresent();
 }
 boolean res;
 try {
  res = executeWithFlags(cachedQuery, flags);
 } finally {
  if (shouldCache) {
   queryExecutor.releaseQuery(cachedQuery);
  }
 }
 return res;
}