Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- org.hibernate.hql.internal.ast.QuerySyntaxException: users is not mapped [from users]
- org.hibernate.hql.internal.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:180)
- org.hibernate.hql.internal.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:110)
- org.hibernate.hql.internal.ast.tree.FromClause.addFromElement(FromClause.java:93)
- public List<User> getUsers() {
- Session session = HibernateUtil.getSessionFactory().getCurrentSession();
- session.beginTransaction();
- List<User> result = (List<User>) session.createQuery("from users").list();
- session.getTransaction().commit();
- return result;
- }
- public void addUser(User user) {
- Session session = HibernateUtil.getSessionFactory().getCurrentSession();
- session.beginTransaction();
- session.save(user);
- session.getTransaction().commit();
- }
- public void addUser(List<User> users) {
- Session session = HibernateUtil.getSessionFactory().getCurrentSession();
- session.beginTransaction();
- for (User user : users) {
- session.save(user);
- }
- session.getTransaction().commit();
- }
- <hibernate-configuration>
- <session-factory>
- <property name="connection.url">jdbc:mysql://localhost:3306/test</property>
- <property name="connection.username">root</property>
- <property name="connection.password">root</property>
- <property name="connection.driver_class">com.mysql.jdbc.Driver</property>
- <property name="hibernate.default_schema">test</property>
- <property name="dialect">org.hibernate.dialect.MySQL5Dialect</property>
- <property name="show_sql">true</property>
- <property name="format_sql">true</property>
- <property name="hbm2ddl.auto">create-drop</property>
- <!-- JDBC connection pool (use the built-in) -->
- <property name="connection.pool_size">1</property>
- <property name="current_session_context_class">thread</property>
- <!-- Mapping files will go here.... -->
- <mapping class="model.Company" />
- <mapping class="model.Conference" />
- <mapping class="model.ConferencesParticipants" />
- <mapping class="model.ConferenceParticipantStatus" />
- <mapping class="model.ConferencesUsers" />
- <mapping class="model.Location" />
- <mapping class="model.User" />
- </session-factory>
- @Entity
- @Table( name = "Users" )
- public class User implements Serializable{
- private long userID;
- private int pasportID;
- private Company company;
- private String name;
- private String email;
- private String phone1;
- private String phone2;
- private String password; //may be null/empty , will be kept hashed
- private boolean isAdmin;
- private Date lastLogin;
- User() {} //not public on purpose!
- public User(int countryID, Company company, String name, String email,
- String phone1, String phone2, String password, boolean isAdmin) {
- this.pasportID = countryID;
- this.company = company;
- this.name = name;
- this.email = email;
- this.phone1 = phone1;
- this.phone2 = phone2;
- this.password = password;
- this.isAdmin = isAdmin;
- }
- @Id
- @GeneratedValue(generator="increment")
- @GenericGenerator(name="increment", strategy = "increment")
- public long getUserID() {
- return userID;
- }
- public void setUserID(long userID) {
- this.userID = userID;
- }
- ...
- }
- List<User> result = (List<User>) session.createQuery("from User").list();
- Query query = entityManager. createQuery("Select UserName from **UserDetails** ");
- import org.hibernate.annotations.Entity;
- import javax.persistence.Entity;
- import javax.persistence.*;
- @Entity
- @Table(name = "VENDOR")
- public class Vendor {
- //~ --- [INSTANCE FIELDS] ------------------------------------------------------------------------------------------
- private int id;
- private String name;
- //~ --- [METHODS] --------------------------------------------------------------------------------------------------
- @Override
- public boolean equals(final Object o) {
- if (this == o) {
- return true;
- }
- if (o == null || getClass() != o.getClass()) {
- return false;
- }
- final Vendor vendor = (Vendor) o;
- if (id != vendor.id) {
- return false;
- }
- if (name != null ? !name.equals(vendor.name) : vendor.name != null) {
- return false;
- }
- return true;
- }
- //~ ----------------------------------------------------------------------------------------------------------------
- @Column(name = "ID")
- @GeneratedValue(strategy = GenerationType.AUTO)
- @Id
- public int getId() {
- return id;
- }
- @Basic
- @Column(name = "NAME")
- public String getName() {
- return name;
- }
- public void setId(final int id) {
- this.id = id;
- }
- public void setName(final String name) {
- this.name = name;
- }
- @Override
- public int hashCode() {
- int result = id;
- result = 31 * result + (name != null ? name.hashCode() : 0);
- return result;
- }
- }
- <property name="packagesToScan" value="yourpackage" />
- @Query(value = 'select ID, CLUMN2, CLUMN3 FROM VENDOR c where c.ID = :ID', nativeQuery = true)
- @javax.persistence.Entity
- @javax.persistence.Table(name = "Users")
- public class User {
- // this sets the name of the table and the name of the entity
- @javax.persistence.Entity(name = "Users")
- public class User implements Serializable{
- private static SessionFactory buildsSessionFactory() {
- try {
- if (sessionFactory == null) {
- StandardServiceRegistry standardRegistry = new StandardServiceRegistryBuilder()
- .configure("/hibernate.cfg.xml").build();
- Metadata metaData = new MetadataSources(standardRegistry)
- .getMetadataBuilder().build();
- sessionFactory = metaData.getSessionFactoryBuilder().build();
- }
- return sessionFactory;
- } catch (Throwable th) {
- System.err.println("Enitial SessionFactory creation failed" + th);
- throw new ExceptionInInitializerError(th);
- }
- }
Add Comment
Please, Sign In to add comment