API

SQL injection in BasePeer

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

Metadata

ID: java-security/sql-injection-turbine

Language: Java

Severity: Warning

Category: Security

CWE: 89

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

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 );
    }
}

How to use this rule

1
2
rulesets:
  - java-security     # Rules to enforce Java security.

Create a static-analysis.datadog.yml with the content above at the root of your repository
Use our free IDE Plugins or add Code Analysis scans to your CI pipelines
Get feedback on your code

For more information, please read the Code Analysis documentation

VS Code Extension

Identify code vulnerabilities directly in your
VS Code editor

JetBrains Plugin

Identify code vulnerabilities directly in
JetBrains products