CVE-2019-15563: OHDSI WebAPI vulnerable to SQL Injection
9.8
CVSS Score
3.0
Basic Information
CVE ID
GHSA ID
EPSS Score
0.58588%
CWE
Published
5/24/2022
Updated
4/17/2023
KEV Status
No
Technology
Java
Technical Details
CVSS Vector
CVSS:3.0/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
Package Name | Ecosystem | Vulnerable Versions | First Patched Version |
---|---|---|---|
org.ohdsi:WebAPI | maven | < 2.7.2 | 2.7.2 |
Vulnerability Intelligence
Miggo AI
Root Cause Analysis
The vulnerability stems from unsafe string concatenation in SQL query construction:
- The original code used String.format() with raw user inputs like searchTerm and timeWindow in WHERE clauses
- Parameters were embedded directly into SQL strings without parameterization or proper escaping
- The patch adds QuoteUtils.escapeSql() to sanitize inputs, confirming these were injection points
- The CWE-89 classification and commit message explicitly reference SQL injection in this service class
- Vulnerable patterns match classic SQL injection vectors in JDBC-free string interpolation contexts