JPA /Hibernate mappiing error

[jeff mutonho]

I'm trying to persist a simple User object to an HSQLDB.The code performs a check to see if the User already exist and if not , then persists the User object.
The code is shown below :

List existing = JPAUtility.getEntityManager().createQuery("select u.username from USERS u where u.username=foo and u.password=bar").getResultList();
 if (existing.size() == 0) {
 UserBean user = new UserBean();
 user.setUserName("foo");
 user.setPassword("bar");
 em.persist(user);

} else {
System.out.println("User already  exists...");
}

The User class looks like :

import javax.persistence.*;
 
@Entity
@Table(name = "USERS")
public class User {
 
@Id
@Column(name = "ID")
private int id;
 
@Column(name = "USERNAME")
private String userName;
 
@Column(name = "PASSWORD")
private String password;
 
@Transient
private String verify;

public UserBean(){}
 
public String getPassword() {
return password;
}
 
public void setPassword(String password) {
this.password = password;
}
 
public String getUserName() {
return userName;
}
 
public void setUserName(String userName) {
this.userName = userName;
}
 
public String getVerify() {
return verify;
}
 
public void setVerify(String verify) {
this.verify = verify;
}

public int getId() {
return id;
}
 
public void setId(int id) {
this.id = id;
}
 
public User(String username, String password) {
this.userName = username;
this.password = password;
}
 
}

and my persistence.xml :

<?xml version="1.0" encoding="UTF-8"?>
<persistence xmlns="http://java.sun.com/xml/ns/persistence" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" version="1.0" xsi:schemaLocation="http://java.sun.com/xml/ns/persistence     <a href="http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd">" target="_blank" rel="nofollow">http://java.sun.com/xml/ns/persistence/persistence_1_0.xsd"></a>
    
<persistence-unit name="shoppingcart" transaction-type="RESOURCE_LOCAL">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
        <class>com.introspect.jpa.User</class>
  <properties>
       <property name="hibernate.dialect" value="org.hibernate.dialect.HSQLDialect"/>
<property name="hibernate.connection.driver_class" value="org.hsqldb.jdbcDriver"/>
<property name="hibernate.connection.url" value="jdbc:hsqldb:/devenv/data/shoppingcart"/>
<property name="hibernate.connection.username" value="sa"/>
  </properties>
</persistence-unit>
  
</persistence>

When I try to run the application , I'm getting the following exception:

Exception in thread "main" java.lang.IllegalArgumentException: org.hibernate.hql.ast.QuerySyntaxException: USERS is not mapped [select u.username from USERS u where u.username=foo and u.password=bar]
at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:616)
at org.hibernate.ejb.AbstractEntityManagerImpl.createQuery(AbstractEntityManagerImpl.java:95)
at com.introspect.jpa.JPAUtility.main(JPAUtility.java:163)
Caused by: org.hibernate.hql.ast.QuerySyntaxException: USERS is not mapped [select u.username from USERS u where u.username=foo and u.password=bar]
at org.hibernate.hql.ast.util.SessionFactoryHelper.requireClassPersister(SessionFactoryHelper.java:158)
at org.hibernate.hql.ast.tree.FromElementFactory.addFromElement(FromElementFactory.java:87)
at org.hibernate.hql.ast.tree.FromClause.addFromElement(FromClause.java:70)  

[Mark Spritzler]

Please do not duplicate post.

Thanks

Mark