code: private void getGeneralID(final String _complStmt)
          throws EFapsException
      {
          ConnectionResource con = null;
          try {
              con = Context.getThreadContext().getConnectionResource();
  
              final Statement stmt = con.createStatement();
  
              final ResultSet rs = stmt.executeQuery(_complStmt.toString());
  
              while (rs.next()) {
                  this.generalID = rs.getLong(1);
                  this.fileName = rs.getString(2);
                  if (this.fileName != null && !this.fileName.isEmpty()) {
                      this.fileName = this.fileName.trim();
                  }
                  this.fileLength = rs.getLong(3);
                  for (int i = 0; i < this.exist.length; i++) {
                      this.exist[i] = rs.getLong(4 + i) > 0;
                  }
                  getAdditionalInfo(rs);
              }
              rs.close();
              stmt.close();
          } catch (final SQLException e) {
              throw new EFapsException(InstanceQuery.class, "executeOneCompleteStmt", e);
          }
      }
docs: Get the generalID etc. from the eFasp DataBase.
  @param _complStmt Statement to be executed
  @throws EFapsException on error