Обсуждение: is not mapped Поиск
Список
Период
Сортировка

is not mapped
От
shahab
Дата:
Hi:

I am trying to use access table in postgress database using hibernate.
(similar to tutirial at
http://cwiki.apache.org/S2WIKI/struts-2-spring-jpa-ajax.html). I am getting
the following error -

SEVERE: Could not execute action
java.lang.IllegalArgumentException:
org.hibernate.hql.ast.QuerySyntaxException: tmsuser is not mapped [select
t.id, t.us
erid, t.password from tmsuser t]
    at
org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:616)

My table is set up as follows -
CREATE TABLE TMSUSER (
        id BIGSERIAL NOT NULL,
        userid    VARCHAR(8) NOT NULL CHECK (userid <> ''),
        password   VARCHAR(8) NOT NULL CHECK (password <> ''),
        PRIMARY KEY (id)
);

My Model file is as follows -
@Entity
public class TMSUser {
    @Id
    @GeneratedValue
    private Integer id;
    private String userid;
    private String password;


The query in service file is as follows -
Query query = getEntityManager().createQuery("select t.id, t.userid,
t.password from tmsuser t");


I would greatly appreaciate yore help.

thanx
Shahab
--
View this message in context: http://www.nabble.com/%3Ctable-name%3E-is-not-mapped-tf3175392.html#a8809786
Sent from the PostgreSQL - jdbc mailing list archive at Nabble.com.

Re:

is not mapped
От
"Ido M. Tamir"
Дата:
shahab wrote:

>
> Hi:
>
> I am trying to use access table in postgress database using hibernate.
> (similar to tutirial at
> http://cwiki.apache.org/S2WIKI/struts-2-spring-jpa-ajax.html). I am
> getting the following error -
>
> SEVERE: Could not execute action
> java.lang.IllegalArgumentException:
> org.hibernate.hql.ast.QuerySyntaxException: tmsuser is not mapped [select
> t.id, t.us
> erid, t.password from tmsuser t]
>     at
>
>
> My Model file is as follows -
> @Entity
> public class TMSUser {
>     @Id
>     @GeneratedValue
>     private Integer id;
>     private String userid;
>     private String password;
>

You have to go to the hibernate forum at hibernate.org.
But I think your problem is that class names are case
sensitive in HQL:
select t.id, t.userid, t.password from TMSUser t

HTH
ido