I am trying to create an entity from a mysql view. Is it possible? JBoss writes that table 'Prueba' not exists because Prueba is not a table. Prueba is a View of two tables. I want to display a list of data from two tables join by id. Thanks and sorry for my English.

Hi,

I think you should just be able to create a normal entity and use the @Table annotation, like so:



I have not tested this but it should work (hopefully)

Cheers,

Andy

p.s. Your English is pretty good ;-)

Thanks for the answer. I had tried this but jboss writes that table **** not exists. I look for @View annotation but i don't find nothing similar.

your view is probably in the wrong schema, or the wrong database :)

thanks for the reply. The view is in the correct schema. i am using seam-gen that generates all the entities for all the tables and views in my schema. The views' entities don't work (compilation error 'table not found'). i don't understand it.

Can you post a sample entity and the view's DDL, this should hopefully shed some more light on the problem.

Tables and View are in consultas schema.
Table secciones.
seccion INTEGER (PK)
logo VARCHAR(45)
linea INTEGER
bienvenida TEXT
...

Table codigos.
seccion INTEGER (PK)
codIni INTEGER
codFin INTEGER
codActual INTEGER
name VARCHAR (45)

View Prueba.
VIEW `prueba` AS select `s`.`seccion` AS `seccion`,`codigos`.`name` AS `name`,`s`.`linea` AS `linea`,`codigos`.`codIni` AS `codIni`,`codigos`.`codFin` AS `codFin`,`codigos`.`codActual` AS `codActual` from (`secciones` `s` join `codigos` on((`s`.`seccion` = `codigos`.`seccion`)))

@Entity
@Table(name = "prueba", catalog = "consultas")
public class Codigos implements Serializable {

private int seccion;
private int codIni;
private int codFin;
private int codActual;
private int linea;
private String name;

/get and set methods are defined.

When JBoss is starting writes 'Table Prueba is not defined'.

Thanks for help me.

Hi! I'm currently faceing the same problem with a View in Oracle - the tables and views are in the same schema but when i try to map a view with @Entity(name ="XYZ") I get the message "table not found".

Has anyone found a solution for mapping views?

Thanks,

altes-kind

.
Emmanuel should know it better. If you let run the Hibernate validate tool at server startup (which is a good thing!), it complains about not finding the table (which in fact doesn't exist) because it doesn't look for database views . The only possible thing is to NOT run the validation - which is a bad thing.

I read in the release notes for V3.2.6 that this a Jira documented bug and it is fixed with this release. I didn't test it until now.

I also think that there should be a @View annotation - even it works with @Table it should be made explicit that we are dealing with a view and not with a table.

Carlo

In smart DBs, there is not much fo a difference between a view and a table. No need to separate the concepts.

Maybe, and maybe that "@View" is not needed. The problem that I noticed is: Hibernate's validation task that's running on server startup on (which is a good thing!) says that a table cannot be found if I map an entity to a view! So I had to disable this validation (which is a bad thing!).

I think there exists a Jira entry on this error.

Carlo

Vote on the JIRA entry, Max will look at it.