Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') ('SQL Injection') [VID:10] #30

veracode-workflow-app-preprod · 2024-07-17T11:48:23Z

verademo/src/main/java/com/veracode/verademo/controller/UserController.java

Lines 501 to 511 in 14e93bf

    
           // Get the users information 
        
           String sql = "SELECT username, real_name, blab_name FROM users WHERE username = '" + username + "'"; 
        
           logger.info(sql); 
        
           myInfo = connect.prepareStatement(sql); 
        
           ResultSet myInfoResults = myInfo.executeQuery(); 
        
           myInfoResults.next(); 
        
           // Send these values to our View 
        
           model.addAttribute("hecklers", hecklers); 
        
           model.addAttribute("events", events);

Filename: UserController.java

Line: 506

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

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 myInfo object, which contains tainted data. The tainted data originated from earlier calls to AnnotationVirtualController.vc_annotation_entry, and java.sql.Statement.executeQuery. 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

veracode-workflow-app-preprod bot added Veracode Policy Scan A Veracode Flaw found during a Policy or Sandbox Scan VeracodeFlaw: High A Veracode Flaw, High severity labels Jul 17, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') ('SQL Injection') [VID:10] #30

Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') ('SQL Injection') [VID:10] #30

Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') ('SQL Injection') [VID:10] #30

Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection') ('SQL Injection') [VID:10] #30

Comments