hi,

i havve a problem while execute query
i have two beans:

user
client that extends user

when i make the query asking for client, all work ok
but when i ask for user i have a Error: 1054, SQLState: 42S22

this is beacuse hibernate is trying to make a select to client table with the fields of user

Hibernate: select usuario0_.idUsuario as idUsuario11_, usuario0_.passUsuario as passUsua2_11_, usuario0_.eMail as eMail11_, usuario0_.idPerfil as idPerfil11_ from usuario usuario0_ where idUsuario='user1' and passUsuario='password'
Hibernate: select cliente0_.rutCliente as rutCliente0_, cliente0_.nomCliente as nomCliente0_, cliente0_.apePaterno as apePaterno0_, cliente0_.apeMaterno as apeMaterno0_, cliente0_.dirCliente as dirCliente0_, cliente0_.eMailCliente as eMailCli6_0_, cliente0_.idComuna as idComuna0_, cliente0_.fono1Cliente as fono8_0_, cliente0_.fono2Cliente as fono9_0_ from cliente cliente0_ where idUsuario='user1' and passUsuario='password'

if a remove the inheritance from client the query work ok

the user mapping is:

<class name="Usuario" table="usuario" lazy="false">
<id name="user" type="string" column="idUsuario"/>
<property name="password" column="passUsuario" type="string"/>
<property name="email" column="eMail" type="string"/>
<property name="perfil" column="idPerfil" type="int"/>
</class>

and the client mapping is:

<class name="Cliente" table="cliente">
<id name="rut" column="rutCliente" type="string">
<generator class="assigned"/>
</id>
<property name="nombre" type="string" column="nomCliente"/>
<property name="apPaterno" type="string" column="apePaterno"/>
<property name="apMaterno" type="string" column="apeMaterno"/>
<property name="direccion" type="string" column="dirCliente"/>
<property name="email" type="string" column="eMailCliente"/>
<property name="comuna" type="int" column="idComuna"/>
<property name="telefono1" type="string" column="fono1Cliente"/>
<property name="telefono2" type="string" column="fono2Cliente"/>
<set name="marcas" lazy="false">
<key column="rutCliente"/>
<one-to-many class="Marca"/>
</set>
</class>

can anyone say me what im doing wrong??
thanks

Hmmm.... I just don't get which type of inheritance strategy you are modeling here... Since your Client class is a subclass of User it is typical to map this with a <joined-subclass> or <subclass><join>.... But then you'll need a join column in the client table that references the user table...

Well, I think you should read the chapter about inheritance in the Hibernate documentation: http://docs.jboss.org/hibernate/stable/ ... tance.html

actually im not mapping any inheritace strategy
both classes can be accesed independently and is working with the exception that when i acces the user hibernate is looking for it in two tables, the log says

Hibernate: select usuario0_.idUsuario as idUsuario11_, usuario0_.passUsuario as passUsua2_11_, usuario0_.eMail as eMail11_, usuario0_.idPerfil as idPerfil11_ from usuario usuario0_ where idUsuario='user1' and passUsuario='password'
Hibernate: select cliente0_.rutCliente as rutCliente0_, cliente0_.nomCliente as nomCliente0_, cliente0_.apePaterno as apePaterno0_, cliente0_.apeMaterno as apeMaterno0_, cliente0_.dirCliente as dirCliente0_, cliente0_.eMailCliente as eMailCli6_0_, cliente0_.idComuna as idComuna0_, cliente0_.fono1Cliente as fono8_0_, cliente0_.fono2Cliente as fono9_0_ from cliente cliente0_ where idUsuario='user1' and passUsuario='password'

the first select its ok, but the second is wrong beacuse the fields idusuario and passusuario dont exist in cliente table
if is a mapping error, can you say me how i should do it??

thanks

Then, why is Client a subclass of User? That sure looks like inheritance to me.