enum to string in JPQL select query

Question

I am facing problem in converting java enum to string conversion. Please if you have any idea.

String mainQuerySt = "select o.ttType from Tt o";

Query mainQuery = em.createQuery(mainQuerySt);
List result = mainQuery.setFirstResult(offset).setMaxResults(numofRecords).getResultList();

I want the string representation of ttType enum. How to do it?

My Tt Definition:

@Enumerated(EnumType.ORDINAL)
@Column(name = "tt_type", nullable = false)
private TTType ttType;

My enum TTType definition:

public enum TTType
{
    FC,
    PD
    ;

    @Override
    public String toString()
    {
        switch (this)
        {
            case FC:
                return "FC";
            case PD:
                return "PD";
            default:
                throw new AssertionError();
        }
    }
}

I can't use EnumType.STRING in @Enumerated now since the system is live.

Please reply.

So you dont want to change value at Database level thats why avoiding EnumType.STRING ? — rev_dihazum
– rev_dihazum, Commented Sep 24, 2016 at 12:01
@rev_dihazum: yes, since it will require data migration and I want to avoid it. Thanks — sarwar026
– sarwar026, Commented Sep 24, 2016 at 12:01
your String toString() method is also failed to serve purpose? I guess it should work. — rev_dihazum
– rev_dihazum, Commented Sep 24, 2016 at 12:03
No, it didn't work. Result contains TtType instead of string representation which I want. — sarwar026
– sarwar026, Commented Sep 25, 2016 at 0:19

rev_dihazum · Accepted Answer · 2016-09-24 12:11:32Z

1

One option may be to use enum constructor as bellow:

public enum TTType {
    FC("FC"),
    PD("PD");

    private String value; // the value

    // Constructor 
    TTType(String value) {
        this.value = value;
    }

    public String getValue() {
        return this.value;
    }

    public String toString() {
        return this.value;
    }
}

answered Sep 24, 2016 at 12:11

rev_dihazum

8181 gold badge9 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

enum to string in JPQL select query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related