Named Native Query, execute update statement

Question

Can we create update statement using @NamedNativeQuery,

@Entity
@Table(schema = "public", name = "conversion_checker")
@NamedNativeQueries({
    @NamedNativeQuery(name="updateExpireStatus", query="UPDATE conversion_checker SET status='Expired' FROM conversion_checker ")
})
public class ConversionChecker extends BaseEntity {...}

And here I am Executing native Query

/**
 * {@inheritDoc}}
 */
@Override
public int executeNativeUpdate(String namedNativeQuery, Map<String, Object> params) {
    Query query = getSession().getNamedQuery(namedNativeQuery);
    if(params!=null && params.size()>0){
        for(Map.Entry<String, Object> param: params.entrySet()){
            query.setParameter(param.getKey(), param.getValue());
        }
    }
    return query.executeUpdate();
}

it throws,

Caused by: org.hibernate.cfg.NotYetImplementedException: Pure native scalar queries are not yet supported,

How to execute update statement using @NamedNativeQuery or this is not possible?

Did you look at this to [return a value with Hibernate NamedNativeQueries]( stackoverflow.com/questions/13278544/…) — Vijay Kukkala
– Vijay Kukkala, Commented Aug 5, 2013 at 13:52
@vinit-prajapati And also please correct your update query. It should be like UPDATE table_name SET properties WHERE clause — Ram Patra
– Ram Patra, Commented Jan 26, 2017 at 12:22

Luca Basso Ricci · Accepted Answer · 2014-06-17 14:39:41Z

2

Try adding @NamedNativeQuery( resultClass = ConversionChecker.class ).

edited Jun 17, 2014 at 14:39

user1271598

answered Aug 5, 2013 at 13:53

Luca Basso Ricci

18.5k2 gold badges51 silver badges75 bronze badges

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

1 Comment

Charnjeet Singh Over a year ago

Can you provide more detail about this?

Collectives™ on Stack Overflow

Named Native Query, execute update statement

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related