jpa-patterns

Spring Boot中的JPA/Hibernate模式，用于实体设计、关系处理、查询优化、事务管理、审计、索引、分页和连接池。

1.26x

Quality

63%

Does it follow best practices?

Impact

86%

1.26x

Average score across 3 eval scenarios

Securityby

Passed

No findings from the security scan

Fix and improve this skill with Tessl

tessl review fix ./docs/zh-CN/skills/jpa-patterns/SKILL.md

Evaluation results

100%

22%

Healthcare Records Service — Testing and Configuration Setup

Testing with Testcontainers, SQL logging, and schema migrations

Criteria

Without this skill

With this skill

@DataJpaTest annotation

100%

Testcontainers for PostgreSQL

100%

Hibernate SQL logging

100%

Hibernate bind parameter logging

100%

No Hibernate auto DDL

100%

Flyway or Liquibase migration

100%

Additive migration only

100%

PostgreSQL LOB property

100%

HikariCP pool settings

100%

70%

Order Management Service — Repository and Service Layer

Pagination, transactions, batch writes, and HikariCP config

Criteria

Without this skill

With this skill

readOnly transactions

100%

Write transactions

100%

PageRequest with Sort

100%

Cursor-based pagination

Composite index

30%

Projection interface

saveAll for bulk insert

100%

Batch size configuration

100%

HikariCP pool size

100%

HikariCP timeouts

50%

100%

90%

30%

Product Catalog JPA Entity Layer

Entity design, auditing, indexing, and relationships

Criteria

Without this skill

With this skill

IDENTITY key generation

100%

STRING enum mapping

100%

AuditingEntityListener

100%

Audit timestamp fields

50%

100%

EnableJpaAuditing config

100%

Table-level index declaration

100%

OneToMany cascade and orphan

100%

No EAGER on collection

100%

JOIN FETCH query

100%

Projection interface

Flyway or Liquibase migration

100%

Repository: affaan-m/ECC
Path: docs/zh-CN/skills/jpa-patterns/SKILL.md
Commit: e04ea0b

Evaluated: 6 months ago
Agent: Claude Code
Model: Claude Sonnet 4.6

Table of Contents

Product Catalog JPA Entity Layer Order Management Service — Repository and Service Layer Healthcare Records Service — Testing and Configuration Setup

Is this your skill?

If you maintain this skill, you can claim it as your own. Once claimed, you can manage eval scenarios, bundle related skills, attach documentation or rules, and ensure cross-agent compatibility.