Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[eclipselink-users] Use Transformer attribute fields in JPQL query

Please can you help me.

I have "Param" object with read+write transformer. And I want to map "Columns" to "attributes" because I want to sort/select "Items" according to Column "FREQ", "TYPE", ...

JPQL query: "select o from Items as o order by o.param.freq"

...
class Items {
...
    @ReadTransformer(transformerClass = Param.class)
    @WriteTransformers({
            @WriteTransformer(transformerClass = ParamType.class, column = @Column(name = "TYPE")),
            @WriteTransformer(transformerClass = ParamDouble.class, column = @Column(name = "FREQ", precision = 8, scale = 0)),
            @WriteTransformer(transformerClass = ParamDouble.class, column = @Column(name = "FREQ_LO_LIMIT", precision = 8, scale = 0)),
            @WriteTransformer(transformerClass = ParamDouble.class, column = @Column(name = "FREQ_HI_LIMIT", precision = 8, scale = 0))
    })
    private Param param;

...
}

  Thank you very much.
      Martin


Back to the top