Search code examples
jpaspring-data-jpaquerydsl

When JPA QEntity is generated, it is generated with a certain word


I don't know why only the entity named "Member" is numbered.

Other entities don't.

Attached is a QEntity source.

so my question is

  • Why numbered "Member" Entity
  • I don't want it to be numbered. What should I do to solve this problem?
import static com.querydsl.core.types.PathMetadataFactory.*;

import com.querydsl.core.types.dsl.*;

import com.querydsl.core.types.PathMetadata;
import javax.annotation.Generated;
import com.querydsl.core.types.Path;


/**
 * QMember is a Querydsl query type for Member
 */
@Generated("com.querydsl.codegen.EntitySerializer")
public class QMember extends EntityPathBase<Member> {

    private static final long serialVersionUID = -1377787676L;

    public static final QMember member = new QMember("member1"); //why numbering...

    public final NumberPath<Integer> memberIdx = createNumber("memberIdx", Integer.class);

    public QMember(String variable) {
        super(Member.class, forVariable(variable));
    }

    public QMember(Path<? extends Member> path) {
        super(path.getType(), path.getMetadata());
    }

    public QMember(PathMetadata metadata) {
        super(Member.class, metadata);
    }

}

Solution

  • Because 'member' is a JPQL keyword.

    https://docs.oracle.com/html/E13946_04/ejb3_langref.html#ejb3_langref_collection_member

    The QueryDsl contains a list of these and escapes them by adding a numeric suffix:

    http://www.querydsl.com/static/querydsl/4.1.4/apidocs/index.html?com/querydsl/codegen/Keywords.html

    public static final Collection<String> JPA = ImmutableList.of(
            "ABS","ALL","AND","ANY","AS","ASC","AVG","BETWEEN",
            "BIT_LENGTH[51]","BOTH","BY","CASE","CHAR_LENGTH",
            "CHARACTER_LENGTH","CLASS",
            "COALESCE","CONCAT","COUNT","CURRENT_DATE","CURRENT_TIME",
            "CURRENT_TIMESTAMP",
            "DELETE","DESC","DISTINCT","ELSE","EMPTY","END","ENTRY",
            "ESCAPE","EXISTS","FALSE","FETCH",
            "FROM","GROUP","HAVING","IN","INDEX","INNER","IS","JOIN",
            "KEY","LEADING","LEFT","LENGTH","LIKE",
            "LOCATE","LOWER","MAX","MEMBER","MIN","MOD","NEW","NOT",
            "NULL","NULLIF","OBJECT","OF","OR",
            "ORDER","OUTER","POSITION","SELECT","SET","SIZE","SOME",
            "SQRT","SUBSTRING","SUM","THEN",
            "TRAILING","TRIM","TRUE","TYPE","UNKNOWN","UPDATE","UPPER",
            "VALUE","WHEN","WHERE");
    

    Why is it a problem given that you never need to refer to it in your code?