QueryDSL切换JPASQLQuery后无法自动映射JPA实体的技术求助

Great question! I've run into this exact issue before when switching from JPAQuery to JPASQLQuery in QueryDSL 4.x. The core problem here is that JPASQLQuery operates on raw SQL, so it doesn't automatically map results to JPA entities the way JPAQuery (which uses JPQL) does. Instead, it returns raw column arrays by default.

Luckily, there are a couple of ways to get it to return your PriceModel entities without manual mapping:

1. Use JPA's @SqlResultSetMapping (cleanest approach for entity mapping) #

This leverages JPA's built-in result set mapping to let the persistence provider handle the entity conversion automatically.

First, add the mapping to your PriceModel entity class. If your database column names match your entity property names exactly, you can keep it simple:

@Entity
@SqlResultSetMapping(
    name = "PriceModelMapping",
    entities = @EntityResult(entityClass = PriceModel.class)
)
public class PriceModel {
    // Your entity fields, getters, setters, etc.
}

If your column names don't match your property names, you can explicitly map them with @FieldResult:

@Entity
@SqlResultSetMapping(
    name = "PriceModelMapping",
    entities = @EntityResult(
        entityClass = PriceModel.class,
        fields = {
            @FieldResult(name = "id", column = "PRICE_ID"),
            @FieldResult(name = "price", column = "PRICE_AMOUNT"),
            // Map other properties to their respective columns here
        }
    )
)
public class PriceModel {
    // ...
}

Then, reference this mapping in your JPASQLQuery:

QPriceModel pm = QPriceModel.priceModel;
List<PriceModel> priceModels = new JPASQLQuery<>(entityManager, new OracleTemplates())
    .select(pm)
    .from(pm)
    .setResultSetMapping("PriceModelMapping")
    .fetch();

2. Use QueryDSL's Transformers.aliasToBean #

If you don't want to add annotations to your entity, you can use QueryDSL's projection transformer to map results to your bean. This works as long as the alias names in your query match the property names in PriceModel:

QPriceModel pm = QPriceModel.priceModel;
List<PriceModel> priceModels = new JPASQLQuery<>(entityManager, new OracleTemplates())
    // Select all columns (use pm.all() if you want every field, or list specific ones)
    .select(pm.id, pm.price, pm.productId) // Ensure these aliases match your entity property names
    .from(pm)
    .transform(Transformers.aliasToBean(PriceModel.class));

Note: If your query uses custom column aliases, make sure they exactly match the property names in PriceModel (case sensitivity might depend on your JPA provider).

Why this happens #

Just to clarify: JPAQuery uses JPQL, which is tightly integrated with JPA entities—so the persistence provider knows exactly how to map results back to your entity. JPASQLQuery executes raw SQL, which is agnostic to your entity structure, so you have to explicitly tell it how to convert the raw column data into your entity type.

内容的提问来源于stack exchange，提问作者Ben