JHipster: SQL Injection in the Parameter of JHipster-Generated Reactive (WebFlux + R2DBC) Applicationssort

{
  "id": "4445a21d67db7167b7729e2376e96ac405c6766a6f265846f6a215fdabdd6e99",
  "url": "https://osv.dev/vulnerability/GHSA-r223-96jv-q533",
  "method": "structured",
  "payload": {
    "kind": "advisory",
    "title": "JHipster: SQL Injection in the Parameter of JHipster-Generated Reactive (WebFlux + R2DBC) Applicationssort",
    "summary": "# SQL Injection in the `sort` Parameter of JHipster-Generated Reactive (WebFlux + R2DBC) Applications - **Product**: jhipster/generator-jhipster (npm package `generator-jhipster`) - **Affected versions**: v7.0.0 through v9.2.0 - **Component**: generated reactive-application code, template `EntityManager_reactive.java.ejs` - **Report date**: 2026-08-29 --- ## 1. Summary Every reactive (Spring WebFlux + Spring Data R2DBC + SQL) application generated by `generator-jhipster` contains an SQL injection in the paginated entity list endpoints (`GET /api/?sort=...`). The `sort` request parameter is taken verbatim from the user and concatenated into the SQL `ORDER BY` clause without quoting or validation. Because the generated query has no bound parameters, the R2DBC drivers execute it via the **simple query protocol**, so `;`-separated extra statements are run against the database. A single authenticated low-privileged user (including an account obtained through the default self-registration flow) can therefore **execute arbitrary SQL**: read any table (including `jhi_user` password hashes), modify or delete data, and drop tables (full C/I/A impact). Independently reproduced end-to-end on the default dev database (H2) and the default production database (PostgreSQL 16). The JPA (non-reactive) path is **not** affected: Spring Data JPA validates sort property names against the entity metamodel. NoSQL backends are out of scope of this root cause. ## 2. Root Cause The generator template `",
    "evidence": "osv:GHSA-r223-96jv-q533",
    "products": [
      {
        "name": {
          "value": "generator-jhipster",
          "evidence": "/affected/0/package/name"
        },
        "prerequisites": [],
        "fixed_versions": [
          {
            "value": "9.4.0",
            "evidence": "/affected/0/ranges"
          }
        ],
        "affected_versions": []
      }
    ],
    "severity": "high",
    "structured": {
      "id": "GHSA-r223-96jv-q533",
      "aliases": [
        "CVE-2026-107375",
        "GHSA-r223-96jv-q533"
      ],
      "metrics": [
        {
          "type": "CVSS_V3",
          "score": "CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H"
        }
      ],
      "affected": [
        {
          "ranges": [
            {
              "type": "SEMVER",
              "events": [
                {
                  "introduced": "7.0.0"
                },
                {
                  "fixed": "9.4.0"
                }
              ]
            }
          ],
          "package": {
            "name": "generator-jhipster",
            "purl": "pkg:npm/generator-jhipster",
            "ecosystem": "npm"
          },
          "database_specific": {
            "source": "https://github.com/github/advisory-database/blob/main/advisories/github-reviewed/2026/10/GHSA-r223-96jv-q533/GHSA-r223-96jv-q533.json"
          }
        }
      ],
      "modified": "2026-10-08T18:00:09.697394064Z",
      "provider": "osv",
      "references": [
        "https://github.com/jhipster/generator-jhipster/security/advisories/GHSA-r223-96jv-q533",
        "https://github.com/jhipster/generator-jhipster/commit/f6f1579581da8db0d1b8bd28dd473b56951c83af",
        "https://github.com/jhipster/generator-jhipster",
        "https://github.com/jhipster/generator-jhipster/releases/tag/v9.4.0"
      ],
      "provider_metadata": {
        "cwe_ids": [
          "CWE-89"
        ],
        "severity": "HIGH",
        "github_reviewed": true,
        "nvd_published_at": null,
        "github_reviewed_at": "2026-10-08T17:40:37Z"
      }
    },
    "related_cves": [
      {
        "value": "CVE-2026-107375",
        "evidence": "/aliases"
      }
    ],
    "security_relevant": true,
    "severity_evidence": "/database_specific/severity"
  },
  "source_id": "core-osv",
  "document_id": 104436,
  "published_at": "2026-10-08T17:40:37+00:00"
}