Skip to main content

SQL injection - Java SQL API

Description​

Dynamic SQL statements are generated without the required data validation and without using parameterized statements or stored procedures.

Impact​

Inject SQL statements, with the possibility of obtaining information about the database, as well as extract information from it.

Recommendation​

Perform queries to the database through sentences or parameterized procedures. Alternatively, use escape(String) built-in function.

Threat​

Authenticated attacker from the Internet.

Expected Remediation Time​

⌚ minutes.

Score​

Default score using CVSS 3.1. It may change depending on the context of the src.

Base​

  • Attack vector: N
  • Attack complexity: H
  • Privileges required: L
  • User interaction: N
  • Scope: U
  • Confidentiality: L
  • Integrity: L
  • Availability: L

Temporal​

  • Exploit code madurity: P
  • Remediation level: X
  • Report confidence: R

Result​

  • Vector string: CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:L/A:L/E:P/RL:X/RC:R
  • Score:
    • Base: 5.0
    • Temporal: 4.6
  • Severity:
    • Base: Medium
    • Temporal: Medium

Compliant code​

The inputs used to performed queries are either parameterized or correctly validated

param = java.net.URLDecoder.decode(param, ""UTF-8"");

cleanParam = getCleanValue(param)

String sql = ""INSERT INTO users (username, password) VALUES ('foo','""+ cleanParam + ""')"";

try {
  java.sql.Statement statement = org.owasp.benchmark.helpers.DatabaseHelper.getSqlStatement()
  org.owasp.benchmark.helpers.DatabaseHelper.outputUpdateComplete(sql, response);
} catch (java.sql.SQLException e) {
  ...
);

Non compliant code​

There are some unsanitized inputs used to perform queries

param = java.net.URLDecoder.decode(param, ""UTF-8"");

String sql = ""INSERT INTO users (username, password) VALUES ('foo','""+ param + ""')"";

try {
  java.sql.Statement statement = org.owasp.benchmark.helpers.DatabaseHelper.getSqlStatement();
  // Updating db model without filtering user input
  org.owasp.benchmark.helpers.DatabaseHelper.outputUpdateComplete(sql, response);
} catch (java.sql.SQLException e) {
  ...
);

Requirements​

Fixes​

free trial

Search for vulnerabilities in your apps for free with our automated security testing! Start your 21-day free trial and discover the benefits of our Continuous Hacking Machine Plan. If you prefer a full service that includes the expertise of our ethical hackers, don't hesitate to contact us for our Continuous Hacking Squad Plan.

Last updated on