Hibernate QuerySyntaxException Table is not mapped

Question

When I try to create any query to database with Hibernate, i get the same error: Error code

DaoMethod:

@Override
public List findAll() {
    openCurrentSessionWithTransaction();
    List books = currentSession.createQuery("from AuthorEntity").list();
    closeCurrentSessionWithTransaction();
    return books;
}

AuthorEntity(Setters and hashcode&equals are present but hidden):

import javax.persistence.*;
import java.util.Objects;
@Entity
@Table(name = "author")
public class AuthorEntity {
    private long authorId;
    private String name;

    @Id
    @Column(name = "author_id")
    public long getAuthorId() {
        return authorId;
    }

    @Basic
    @Column(name = "name")
    public String getName() {
        return name;
    }
}

Why does this error occur? I do this on IntellijIdea 2018, Java 1.8. hibernate.cfg.xml

Please post your Hibernate configuration files (hibernate.cfg.xml etc.) — , Nov 13 '18 at 13:46
Please add the configuration to the question body, not as a comment. — , Nov 13 '18 at 13:55
Can you update the whole AuthorEntity class. Just want to see your imports. — Killer, Nov 13 '18 at 14:05
I think you have used "org.hibernate.annotations.Entity" annotation. — Killer, Nov 13 '18 at 14:07
The actual package of AuthorEntity matches the package in hibernate.cfg.xml? — tom, Nov 13 '18 at 15:19
check this link: https://stackoverflow.com/questions/33531210/hibernate-exception-table-is-not-mapped — Killer, Nov 13 '18 at 15:29

score 0 · Accepted Answer · answered Nov 13 '18 at 20:12

Can you try this code for your sessionFactory. It helped me

final StandardServiceRegistry registry = new StandardServiceRegistryBuilder()
            .configure().build();
sessionFactory = new MetadataSources(registry).buildMetadata().buildSessionFactory();

Hibernate QuerySyntaxException Table is not mapped

1 Answers1