1 .param(v).param(v) ? placeholders -> [Mechanical Keyboard] 2 .param(1, v) by index -> [Mechanical Keyboard] 3 .params(List.of(..)) ? placeholders -> [Wireless Mouse, Headset] 4 .param("sku", v) :named -> [Mechanical Keyboard] 5 .params(Map.of(..)) :named -> [Mechanical Keyboard] 6 .paramSource(record) :named, record -> [Mechanical Keyboard] 7 :p used twice, one .param("p", 10) :named -> [KB-001, MS-002] 8 IN (:skus) with a 3-element list expanded -> [KB-001, WC-005] (NOPE matched nothing) 9 LIKE :q with "%o%" wildcard in value -> [Mechanical Keyboard, Wireless Mouse, Monitor 27 inch] 10 :named and ? in one statement -> java.lang.IllegalStateException: Configure either named or indexed parameters, not both 11 typo in the parameter name (:sku, supplied skuu) -> org.springframework.dao.InvalidDataAccessApiUsageException: No value supplied for the SQL parameter 'sku': No value registered for key 'sku' 12 two ? but one value -> org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [SELECT name FROM product WHERE sku = ? AND in_stock = ?]; Parameter "#2" is not set; SQL statement: SELECT name FROM product WHERE sku = ? AND in_stock = ? [90012-240] [root cause: JdbcSQLDataException: Parameter "#2" is not set; SQL statement: SELECT name FROM product WHERE sku = ? AND in_stock = ? [90012-240]] 13 .param("sku", null) -> ran, rows: 0 (= NULL is never true) .param("sku", null, Types.VARCHAR) -> ran, rows: 0 (= NULL is never true)