Eclipse Community Forums: EclipseLink » Is the use of @Column annotation as substitute of hibernate @Formula is possible?

Home » Eclipse Projects » EclipseLink » Is the use of @Column annotation as substitute of hibernate @Formula is possible?(hibernate formula)

Show: Today's Messages :: Show Polls :: Message Navigator

Is the use of @Column annotation as substitute of hibernate @Formula is possible? [message #933084]

Thu, 04 October 2012 14:14

Dariusz Skrudlik
Messages: 4
Registered: July 2009

Junior Member

I found that can use @Column annotation for execute subselect,
e.g

    private BigDecimal quantityOrders;

    @Column(name="(select 2 from dual) as quantityOrders",insertable = false, updatable = false)
    public BigDecimal getQuantityOrders() {
        return quantityOrders;
    }

I tested name with some select and all working. I can link to current table by name and all other in database. It is fantastic, but is it right ?

Where can I find any documentation for that ?

P.S.
In hibernate @Formula I can use 'this' for pointing current table, how do this here (it is important when define other alias e.g. when use CriteriaBuilder)

Report message to a moderator

Re: Is the use of @Column annotation as substitute of hibernate @Formula is possible? [message #939166 is a reply to message #933084]

Wed, 10 October 2012 09:39

James Sutherland
Messages: 1844
Registered: July 2009

Senior Member

EclipseLink does not currently have an equivalent to Hibernate's @Formula, please log a bug, and vote for it.

Setting the column name will work for simple queries, but not for complex queries.

The best solution is to create a view that adds the computed column to the table, and map the entity to the view.

You could also instead execute a named query for the value.

EclipseLink does have an @AttributeTransformer feature, that would allow you to execute a query for computed value.

James : Wiki : Book : Blog

Report message to a moderator

Re: Is the use of @Column annotation as substitute of hibernate @Formula is possible? [message #939388 is a reply to message #939166]

Wed, 10 October 2012 14:14

Dariusz Skrudlik
Messages: 4
Registered: July 2009

Junior Member

I checked and name work even for multi table subselect (only when you don't use aliases).

If I use a view in database, will I be able to update data ?

Can you give me a example of usage @AttributeTransformer for subselect ? (I found only some java doc for that annotation).

Report message to a moderator

Re: Is the use of @Column annotation as substitute of hibernate @Formula is possible? [message #946818 is a reply to message #939388]

Tue, 16 October 2012 10:35

James Sutherland
Messages: 1844
Registered: July 2009

Senior Member

Many databases allow updating simple views, for complex views you can use instead-of triggers to update them.

James : Wiki : Book : Blog

Report message to a moderator

Previous Topic:	@Id and @AttributeOverride
Next Topic:	using eclipselink in Eclipse' Tomcat

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 26 02:58:02 EDT 2013