code: @SuppressWarnings("unchecked")
      @Override
      protected boolean executeOneCompleteStmt(final String _complStmt,
                                               final List<OneSelect> _oneSelects)
          throws EFapsException
      {
          boolean ret = false;
          ConnectionResource con = null;
          try {
              LinkFromSelect.LOG.debug("Executing SQLL: {}", _complStmt);
              List<Object[]> rows = null;
              boolean cached = false;
              if (isCacheEnabled()) {
                  final QueryKey querykey = QueryKey.get(getKey(), _complStmt);
                  final Cache<QueryKey, Object> cache = QueryCache.getSqlCache();
                  if (cache.containsKey(querykey)) {
                      final Object object = cache.get(querykey);
                      if (object instanceof List) {
                          rows = (List<Object[]>) object;
                      }
                      cached = true;
                  }
              }
              if (!cached) {
                  con = Context.getThreadContext().getConnectionResource();
                  final Statement stmt = con.createStatement();
  
                  final ResultSet rs = stmt.executeQuery(_complStmt.toString());
                  final ArrayListHandler handler = new ArrayListHandler(Context.getDbType().getRowProcessor());
                  rows = handler.handle(rs);
                  rs.close();
                  stmt.close();
                  if (isCacheEnabled()) {
                      final QueryKey querykey = QueryKey.get(getKey(), _complStmt);
                      final Cache<QueryKey, Object> cache = QueryCache.getSqlCache();
                      cache.put(querykey, rows);
                  }
              }
              for (final Object[] row : rows) {
                  for (final OneSelect onesel : _oneSelects) {
                      onesel.addObject(row);
                  }
                  ret = true;
              }
          } catch (final SQLException e) {
              throw new EFapsException(InstanceQuery.class, "executeOneCompleteStmt", e);
          }
          return ret;
      }
docs: {@inheritDoc}