Inspectopedia
 
2024.3

Call to 'Connection.prepare*()' with non-constant string

Warning
New
Last modified: 03 December 2024

Reports calls to java.sql.Connection.prepareStatement(), java.sql.Connection.prepareCall(), or any of their variants which take a dynamically-constructed string as the statement to prepare.

Constructed SQL statements are a common source of security breaches. By default, this inspection ignores compile-time constants.

Example:

Use the inspection settings to consider any static final fields as constants. Be careful, because strings like the following will be ignored when the option is enabled: