Hibernate MappingNotFoundException when using annotations to map an Entity class

Question

I'm new to Hibernate. I'm trying to run a simple query to see if the given login information for a user is correct:

public boolean checkLogin(String user, String pw)
{    
    pw = Util.encrypt(pw);

    String sql = "select count(*) from User where email = :email and pw = :pw";
    Query q = HibernateUtil.getSession().createQuery(sql);

    q.setParameter("email", user);
    q.setParameter("pw", pw);

    int count  = ( (Integer)  q.iterate().next() ).intValue();

    return count > 0;
}

When I call this method, I get an exception which says User class is not mapped.

To fixed this, I created this user class:

import javax.persistence.*;

@Entity @Table(name = "user")
public class User
{
    @Id @GeneratedValue
    @Column(name = "id")
    private Long id;

    public Long getId()
    {
        return id;
    }

    public void setId(Long id)
    {
        this.id = id;
    }
}

And in my HibernateUtils.createSession I added the following line:

configuration.addClass(User.class);

However this gives me the exception:

Caused by: org.hibernate.MappingNotFoundException: resource: 
net/myProject/server/model/User.hbm.xml not found
    at org.hibernate.cfg.Configuration.addResource(Configuration.java:741)
    at org.hibernate.cfg.Configuration.addClass(Configuration.java:786)
    at net.myProject.server.util.HibernateUtil.<clinit>(HibernateUtil.java:28)

What am I doing wrong?

It looks like your hibernate isn't processing @Entity annotation... Can you show your persistence.xml file? — MGorgon
– MGorgon, Commented Feb 8, 2014 at 17:10
@MGorgon I don't have a persistence.xml file. Do I need to create one? I don't see any mention of it in the examples I've looked at. — Ali
– Ali, Commented Feb 8, 2014 at 17:12
Read docs.jboss.org/hibernate/orm/4.2/javadocs/org/hibernate/cfg/…, as well as the javadoc of the method just below. Also: createQuery() expects an HQL query, not an SQL query. count(*) is not valid HQL. And your variable should be named hql, not sql. — JB Nizet
– JB Nizet, Commented Feb 8, 2014 at 17:12

Ori Dar · Accepted Answer · 2014-02-08 17:20:21Z

16

Use addAnnotatedClass instead of addClass

Configuration.addClass() indeed expects a companion hbm.xml

edited Feb 8, 2014 at 17:20

answered Feb 8, 2014 at 17:14

Ori Dar

19.1k5 gold badges61 silver badges76 bronze badges

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

7 Comments

Ali Over a year ago

Isn't that deprecated? mkyong.com/hibernate/…

Ori Dar Over a year ago

Indeed, fixed my response

Ali Over a year ago

Thanks.. one more question. My id field is simply an auto_increment int column in a mysql table. What annotation do I need to use with it in order to get it to work in the same way as auto_increment?

Ori Dar Over a year ago

@GeneratedValue(strategy = GenerationType.AUTO)

JB Nizet Over a year ago

AUTO is the default, as the javadoc indicates: docs.oracle.com/javaee/6/api/javax/persistence/…. You can learn much by reading the javadoc, isn't it?

|

helderdarocha · Accepted Answer · 2014-02-08 17:17:57Z

2

It seems that Hibernate is looking for your XML mapping (XML files), but you are using annotation mapping (Classes).

If you are using Hibernate with Java Persistence API you have to configure a persistence.xml file where you can inform where the mapped classes are.

(You don't need to have a User.hbm.xml file if you use JPA. But if you don't, you can declare your mappings for User in that XML file. You will also need to use a hibernate.cfg.xml to say where your mappings are.)

Here is an example of a persistence.xml file:

<persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/persistence http://xmlns.jcp.org/xml/ns/persistence/persistence_2_1.xsd">
  <persistence-unit name="PersistenceUnitName" transaction-type="RESOURCE_LOCAL">
    <provider>org.eclipse.persistence.jpa.PersistenceProvider</provider>
    <class>package.name.YourEntityClass</class>
    <properties>
      <property name="javax.persistence.jdbc.url" value="jdbc:derby://localhost:1527/database"/>
      <property name="javax.persistence.jdbc.user" value="user"/>
      <property name="javax.persistence.jdbc.driver" value="org.apache.derby.jdbc.ClientDriver"/>
      <property name="javax.persistence.jdbc.password" value="pass"/>
    </properties>
  </persistence-unit>
</persistence>

edited Feb 8, 2014 at 17:17

answered Feb 8, 2014 at 17:10

helderdarocha

23.7k4 gold badges52 silver badges66 bronze badges

5 Comments

Ali Over a year ago

Could you show me a sample of the persistence.xml file that I need to use for annotations?

Ali Over a year ago

And will the persistence.xml work with tomcat as well as jboss?

helderdarocha Over a year ago

Yes. It's part of the JPA spec. If you have JPA support in your app you can use it. In case you are using an application server, you probably won't use transaction-type="RESOURCE_LOCAL" but "JTA" and will use a JNDI name instead of the 4 lines I used above to configure the database.

Ali Over a year ago

It seems that using config.addAnnotatedClass fixed it without needing this file.

helderdarocha Over a year ago

Yes. You can also use the API programmatically.

Collectives™ on Stack Overflow

Hibernate MappingNotFoundException when using annotations to map an Entity class

2 Answers 2

7 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related