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

[my-veracode]

Description:

This database query contains a SQL injection flaw. The call to java.sql.PreparedStatement.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. executeQuery() was called on the blabberQuery object, which contains tainted data. The tainted data originated from an earlier call to AnnotationVirtualController.vc_annotation_entry.

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.

• Veracode issue ID: 291
• Severity: High
• Location: com/veracode/verademo/controller/BlabController.java:490
• Issue found on build: 11171357
• Issue first found at: Tue, 05 Jan 2021 04:12:30 GMT
• Scanner: Veracode Static Application Security Testing

Identifiers:

• CWE
• OWASP
• WASC