Skip to content

Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') [VID:89:servlets/module/challenge/SqlInjectionEmail.java:90] #5

Open
@veracode-workflow-app-qa

Description

https://github.com/testingrepo2/SecurityShepherd/blob/145b200a99892a20d7e0d667f2f42bba0fe8cfb1/undefinedservlets/module/challenge/SqlInjectionEmail.java#L85-L95

Filename: servlets/module/challenge/SqlInjectionEmail.java

Line: 90

CWE: 89 (Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection'))

This database query contains a SQL injection flaw. The call to java.sql.Statement.executeQuery() constructs a dynamic SQL query using a variable derived from untrusted input. An attacker could exploit this flaw to execute arbitrary SQL queries against the database. The first argument to executeQuery() contains tainted data. The tainted data originated from an earlier call to javax.servlet.ServletRequest.getParameter. Avoid dynamically constructing SQL queries. Instead, use parameterized prepared statements to prevent the database from interpreting the contents of bind variables as part of the query. Always validate untrusted input to ensure that it conforms to the expected format, using centralized data validation routines when possible. References: CWE OWASP/nDon't know how to fix this? Don't know why this was reported?
Get Assistance from Veracode

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions