SQL injection in BasePeer

Docs > Code Analysis > Static Analysis Rules > SQL injection in BasePeer

Cette page n'est pas encore disponible en français, sa traduction est en cours.
Si vous avez des questions ou des retours sur notre projet de traduction actuel, n'hésitez pas à nous contacter.

Metadata

ID: java-security/sql-injection-turbine

Language: Java

Severity: Warning

Category: Security

Description

When issuing a SQL query with Turbine, make sure you do not build your query manually and use all the utility functions available with the library.

Learn More

CWE-89: Improper Neutralization of Special Elements used in an SQL Command
Potential SQL Injection with Turbine

Non-Compliant Code Examples

class Foobar {

    public void test() {
        List<Record> BasePeer.executeQuery( "select * from Customer where id=" + inputId );
    }
}

Compliant Code Examples

class Foobar {

    public void test() {
        Criteria c = new Criteria();
        c.add( CustomerPeer.ID, inputId );

        List<Customer> customers = CustomerPeer.doSelect( c );
    }
}