hibernate query not working in java spring

Question

I have this code and its working fine

Registration person = (Registration) session.get(Registration.class, 8);
      person.setConfirmed(true);
      session.save(person);

but this is not working , says mapping error

String query = "FROM registration WHERE user_id = 8";
 Query query2 = session.createQuery(query);
 Registration person = (Registration) query2.uniqueResult();
 person.setConfirmed(true);
 session.save(person);

This is my registration class

@Column(name = "user_id")
    public Integer getUserId() {
        return userId;
    }

dseibert · Accepted Answer · 2011-03-19 03:00:20Z

4

Because you are using a non-native query language, you probably need something like

String query = "FROM Registration WHERE userId = 8";

answered Mar 19, 2011 at 3:00

dseibert

1,3299 silver badges19 bronze badges

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

Comments

chris · Accepted Answer · 2011-03-19 08:33:56Z

2

@Pasha, the following code is a SQL query not a HQL query.

String query = "FROM registration WHERE user_id = 8";
Query query2 = session.createQuery(query);

If you must run a SQL query, use the following instead:

String query = "FROM registration WHERE user_id = 8";
Query query2 = session.createSQLQuery(query); 
query2.executeUpdate();

To convert the SQL query to a HQL query, assuming the Registration class has userId field:

String query = "FROM registration WHERE userId = 8";
Query query2 = session.createQuery(query); 
query2.executeUpdate();

For a complete example, see the following guide: http://krams915.blogspot.com/2011/03/spring-hibernate-one-to-many.html

answered Mar 19, 2011 at 8:33

chris

3,8687 gold badges38 silver badges36 bronze badges

Collectives™ on Stack Overflow

hibernate query not working in java spring

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related