SQL injection in Hibernate

문서 > 코드 분석 > Static Analysis Rules > SQL injection in Hibernate

이 페이지는 아직 한국어로 제공되지 않으며 번역 작업 중입니다. 번역에 관한 질문이나 의견이 있으시면 언제든지 저희에게 연락해 주십시오.

Metadata

ID: java-security/sql-injection-hibernate

Language: Java

Severity: Warning

Category: Security

CWE: 89

Description

Never build a SQL query by concatenating string. Instead, make sure that you use Hibernate functionalities to prevent SQL Injection.

Learn More

Non-Compliant Code Examples

class Foobar {

    public void test() {
        Session session = sessionFactory.openSession();
        Query q = session.createQuery("select t from UserEntity t where id = " + input);
        q.execute();
    }
}

Compliant Code Examples

class Foobar {

    public void test() {
        Session session = sessionFactory.openSession();
        Query q = session.createQuery("select t from UserEntity t where id = :userId");
        q.setString("userId",input);
        q.execute();
    }
}