<table name> is not mapped - Mailing list pgsql-jdbc : Postgres Professional

is not mapped - Mailing list pgsql-jdbc

From

shahab

Subject

is not mapped

Date	February 5, 2007 15:44:09
Msg-id	8809786.post@talk.nabble.com Whole thread Raw
List	pgsql-jdbc

Tree view

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.

pgsql-jdbc by date:

From: "Do, Leon \(Leon\)"
Date: 05 February 2007, 14:59:25
Subject: Re: Max size for bytea type

From: "Ido M. Tamir"
Date: 06 February 2007, 08:03:33
Subject: Re: is not mapped

Previous

Next