Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →Use when you need to write or review programmatic JDBC with Spring — including JdbcClient (Spring Framework 7+) as the default API, JdbcTemplate only where batch/streaming APIs require JdbcOperations, NamedParameterJdbcTemplate for legacy named-param code, parameterized SQL, RowMapper mapping to records, batch operations, transactions, safe handling of generated keys, DataAccessException handling, read-only transactions, streaming large result sets, and @JdbcTest slice testing. This should trigg
.claude/skills/jabrena-311-frameworks-spring-jdbc/SKILL.md| Test case | Without → With | Effect | Δ tokens | Δ turns |
|---|---|---|---|---|
| case-07 | ✗→✓ | ▲ Improved | -9% | 0% |
| case-09 | ✗→✓ | ▲ Improved | 44% | 0% |
| case-11 | ✗→✓ | ▲ Improved | -2% | 0% |
| case-13 | ✗→✓ | ▲ Improved | -18% | 0% |
| case-02 | ✓→✗ | ▼ Worse | -68% | 0% |
Apply Spring JDBC guidelines with JdbcClient as the default; use JdbcTemplate / NamedParameterJdbcTemplate only for legacy code or APIs not covered by JdbcClient (batch updates, KeyHolder, RowCallbackHandler streaming).
What is covered in this Skill?
Scope: Apply recommendations based on the reference rules and good/bad code examples.
Before applying any Spring JDBC changes, ensure the project compiles. If compilation fails, stop immediately. After applying improvements, run full verification.
./mvnw compile or mvn compile before applying any change./mvnw clean verify or mvn clean verify after applying improvementsRead references/311-frameworks-spring-jdbc.md and inspect the current project setup before proposing changes.
Identify requested outcomes, constraints, and the minimum safe set of changes to apply.
Implement or refactor configuration/code following the reference patterns and project conventions.
Execute appropriate build/tests and summarize what changed, what was verified, and any follow-up actions.
For detailed guidance, examples, and constraints, see references/311-frameworks-spring-jdbc.md.
| Case | Status | Duration (ms) | Turns | Tokens | Tool calls | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Without | With | Δ | Without | With | Δ | Without | With | Δ | Without | With | Δ | ||
case-10 | pass→pass | 13,288 | 10,193 | -23% | 1 | 1 | 0% | 2,568 | 2,602 | +1% | 0 | 0 | — |
case-19 | pass→pass | 13,534 | 9,056 | -33% | 1 | 1 | 0% | 2,354 | 2,120 | -10% | 0 | 0 | — |
case-01 | fail→fail | 17,156 | 4,968 | -71% | 1 | 1 | 0% | 2,963 | 903 | -70% | 0 | 0 | — |
case-02 | pass→fail | 16,629 | 19,789 | +19% | 1 | 1 | 0% | 2,958 | 956 | -68% | 0 | 0 | — |
case-03 | pass→pass | 13,408 | 6,794 | -49% | 1 | 1 | 0% | 2,539 | 1,738 | -32% | 0 | 0 | — |
case-04 | pass→pass | 12,318 | 10,598 | -14% | 1 | 1 | 0% | 1,997 | 2,495 | +25% | 0 | 0 | — |
case-05 | pass→pass | 14,857 | 7,681 | -48% | 1 | 1 | 0% | 2,738 | 1,954 | -29% | 0 | 0 | — |
case-06 | pass→pass | 17,407 | 8,595 | -51% | 1 | 1 | 0% | 2,599 | 2,091 | -20% | 0 | 0 | — |
case-07 | fail→pass | 15,503 | 9,852 | -36% | 1 | 1 | 0% | 2,534 | 2,297 | -9% | 0 | 0 | — |
case-08 | pass→pass | 14,888 | 8,837 | -41% | 1 | 1 | 0% | 2,505 | 2,175 | -13% | 0 | 0 | — |
case-09 | fail→pass | 12,444 | 14,793 | +19% | 1 | 1 | 0% | 2,467 | 3,543 | +44% | 0 | 0 | — |
case-11 | fail→pass | 11,036 | 6,758 | -39% | 1 | 1 | 0% | 1,840 | 1,810 | -2% | 0 | 0 | — |
case-12 | pass→pass | 7,524 | 7,450 | -1% | 1 | 1 | 0% | 1,205 | 2,017 | +67% | 0 | 0 | — |
case-13 | fail→pass | 6,419 | 1,847 | -71% | 1 | 1 | 0% | 1,068 | 879 | -18% | 0 | 0 | — |
case-14 | pass→pass | 8,636 | 2,604 | -70% | 1 | 1 | 0% | 1,312 | 909 | -31% | 0 | 0 | — |
case-15 | pass→pass | 11,623 | 8,531 | -27% | 1 | 1 | 0% | 1,789 | 1,919 | +7% | 0 | 0 | — |
case-16 | pass→pass | 7,169 | 5,927 | -17% | 1 | 1 | 0% | 1,271 | 1,669 | +31% | 0 | 0 | — |
case-17 | pass→pass | 4,371 | 4,066 | -7% | 1 | 1 | 0% | 696 | 1,256 | +80% | 0 | 0 | — |
case-18 | pass→pass | 10,390 | 9,038 | -13% | 1 | 1 | 0% | 1,983 | 2,374 | +20% | 0 | 0 | — |
case-20 | pass→pass | 12,748 | 10,812 | -15% | 1 | 1 | 0% | 2,381 | 2,673 | +12% | 0 | 0 | — |
case-21 | pass→pass | 6,755 | 4,796 | -29% | 1 | 1 | 0% | 1,152 | 1,629 | +41% | 0 | 0 | — |
case-22 | pass→pass | 9,514 | 10,315 | +8% | 1 | 1 | 0% | 1,642 | 2,388 | +45% | 0 | 0 | — |
DecimalAI ran this skill against gemini-3.6-flash twice over the same eval suite — once with the skill loaded and once without — and compared the two runs case by case. 22 cases were attempted, and 20 counted toward the lift figure. The other 2 produced results that are not comparable between the two arms, so they are excluded from the headline rather than averaged into it. The headline lift of +14 percentage points is the difference between those two pass rates over the 20 comparable cases. 2 cases got worse with the skill loaded, and they are included in that figure.
Without the skill loaded, the model failed this case. With it loaded, the same prompt on the same model passed. This is one improved case from the latest verified run; every case, including any that regressed, is in the table above.
Other measured skills in the registry, with their headline benchmark lift.