Getting an error while using "Generics" in Hibernate Query

Question

I'm using Hibernate in my project and using "Query" Like below.

Query query = em.createQuery("delete from User where name=:name");
query.setParameter("name", "Zigi");
int deleted = query.executeUpdate();

I'm getting the result. When i'm using generics Like below

Query<?> query = em.createQuery("delete from User where name=:name");
query.setParameter("name", "Zigi");
int deleted = query.executeUpdate();

getting the result because "?" is something as wildcard (or) it will accept any datatype

when i'm using the code as below getting some error( java.lang.IllegalArgumentException: Update/delete queries cannot be typed ). i'm using Integer datatype because createQuery return number when it's executed

Query<Integer> query = em.createQuery("delete from User where name=:name", Integer.class);
query.setParameter("name", "Zigi");
int deleted = query.executeUpdate();

Any suggestions. I have to use Generics with specific datatype in it like above code.

thanks in advance

java.lang.IllegalArgumentException: Update/delete queries cannot be typed — vikram kumar
– vikram kumar, Commented Nov 14, 2018 at 4:28

Eamon Scullion · Accepted Answer · 2018-11-14 10:12:44Z

0

Unfortunately executeUpdate does not allow you to use a typed query.

Instead you can use uniqueResult, and cast to the type that you want:

Query query = em.createQuery("delete from User where name=:name");
query.setParameter("name", "Zigi");
int deleted = (Integer) query.uniqueResult();

Referencing this answer

answered Nov 14, 2018 at 10:12

Eamon Scullion

1,4048 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Getting an error while using "Generics" in Hibernate Query

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related