Bonjour, je suis nouveau avec hibernate. J'essaie de d'obtenir la liste de tous les individu de ma table et j'optient une erreur comme quoi: ERROR: column this_.cd_valr_lang_fk does not exist pourtant, elle existe bel et bien dans ma bd. J'ai presque tout essayé, j'ai mis des enregistrement dans la table, j'ai dropé ma table et mon entitée et recréé le tout et rien ne fonctionne. Si j'enlève cette colonne de mon entitée, alors ça fonctionne correctement, de même que si j'essaie avec une autre entitée.

Je vous ait fournis tout ce qu'il me semblait utile, si vous avez besoin d'autre chose, faite le moi savoir.

Merci

Voici mon code:
InIndiv individu = new InIndiv();
individu.setNom(nomUtilisateur);
List resultats = this.getListe( Example.create(individu)
.ignoreCase()
.enableLike());

Hibernate version:
3

Mapping documents:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!--
Mapping file autogenerated by MyEclipse - Hibernate Tools
-->
<hibernate-mapping>
<class name="com.dmr.dmns.modele.service.entiteesDonneesDmns.InIndiv" table="in_indiv" schema="public">
<id name="idIndiv" type="integer">
<column name="id_indiv" />
<generator class="assigned" />
</id>
<property name="cdValrLangFk" type="string">
<column name="cd_valr_lang_fk" length="11" not-null="true" />
</property>
<property name="nom" type="string">
<column name="nom" length="50" not-null="true" />
</property>
<property name="prenm" type="string">
<column name="prenm" length="50" not-null="true" />
</property>
<property name="cdUtils" type="string">
<column name="cd_utils" length="11" />
</property>
<property name="motPasse" type="string">
<column name="mot_passe" length="11" />
</property>
<property name="noSeqncVerou" type="integer">
<column name="no_seqnc_verou" not-null="true" />
</property>
</class>
</hibernate-mapping>


Full stack trace of any exception that occurs:
ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:72 - ERROR: column this_.cd_valr_lang_fk does not exist
2006-08-28 10:35:21,403 [http-8080-Processor25] ERROR com.dmr.dmns.framework.modele.intercepteur.LogiqueAffaireErreursControleurIntercepteur.appel:51 - RuntimeException Appel de la méthode initialiserSessionUtilisateur de la classe com.dmr.dmns.controleur.authentification.AuthentificationControleur
org.springframework.dao.DataAccessResourceFailureException: Erreur pour obtenir une liste d'entitées.; nested exception is org.hibernate.exception.SQLGrammarException: could not execute query
org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:65)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2148)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
at org.hibernate.loader.Loader.list(Loader.java:2024)
at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1552)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
at com.dmr.dmns.framework.modele.dao.hibernate.BaseDAOImpl.getListe(BaseDAOImpl.java:159)
at com.dmr.dmns.modele.service.facetteIndividu.dao.hibernate.InIndivDAOImpl.authentifierUtilisateur(InIndivDAOImpl.java:33)
at com.dmr.dmns.modele.service.facetteIndividu.service.local.IndividuServiceImpl.authentifier(IndividuServiceImpl.java:41)
at com.dmr.dmns.modele.traitement.authentification.service.local.AuthentificationServiceImpl.initialiserSessionUtilisateur(AuthentificationServiceImpl.java:36)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:335)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:181)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
at com.dmr.dmns.framework.modele.intercepteur.LogiqueAffaireErreursServiceIntercepteur.appel(LogiqueAffaireErreursServiceIntercepteur.java:34)
at com.dmr.dmns.framework.modele.intercepteur.BaseIntercepteur.invoke(BaseIntercepteur.java:61)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at com.dmr.dmns.framework.modele.intercepteur.BaseIntercepteur.invoke(BaseIntercepteur.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:176)
at $Proxy3.initialiserSessionUtilisateur(Unknown Source)
at com.dmr.dmns.controleur.authentification.AuthentificationControleur.initialiserSessionUtilisateur(AuthentificationControleur.java:22)
at com.dmr.dmns.controleur.authentification.AuthentificationControleur$$FastClassByCGLIB$$e8955878.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:698)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:148)
at com.dmr.dmns.framework.modele.intercepteur.BaseIntercepteur.invoke(BaseIntercepteur.java:64)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at com.dmr.dmns.framework.modele.intercepteur.LogiqueAffaireErreursControleurIntercepteur.appel(LogiqueAffaireErreursControleurIntercepteur.java:37)
at com.dmr.dmns.framework.modele.intercepteur.BaseIntercepteur.invoke(BaseIntercepteur.java:61)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:170)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:643)
at com.dmr.dmns.controleur.authentification.AuthentificationControleur$$EnhancerByCGLIB$$8ad45717.initialiserSessionUtilisateur(<generated>)
at com.dmr.dmns.presentation.bean.commun.AuthentificationBean.loginAction(AuthentificationBean.java:42)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.sun.el.parser.AstValue.invoke(AstValue.java:130)
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:274)
at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
at com.sun.facelets.el.LegacyMethodBinding.invoke(LegacyMethodBinding.java:69)
at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:63)
at javax.faces.component.UICommand.broadcast(UICommand.java:106)
at javax.faces.component.UIViewRoot._broadcastForPhase(UIViewRoot.java:90)
at javax.faces.component.UIViewRoot.processApplication(UIViewRoot.java:164)
at org.apache.myfaces.lifecycle.LifecycleImpl.invokeApplication(LifecycleImpl.java:316)
at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:86)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:106)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.dmr.dmns.presentation.filtres.AuthenticationFilter.doFilter(AuthenticationFilter.java:87)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.myfaces.component.html.util.ExtensionsFilter.doFilter(ExtensionsFilter.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at com.dmr.dmns.framework.presentation.filtre.compression.FiltreCompression.doFilter(FiltreCompression.java:158)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: org.postgresql.util.PSQLException: ERROR: column this_.cd_valr_lang_fk does not exist
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:188)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:354)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:258)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
at org.hibernate.loader.Loader.doList(Loader.java:2145)
... 79 more

Name and version of the database you are using:
Postgresql 8.1

The generated SQL (show_sql=true):
select this_.id_indiv as id1_1_0_, this_.cd_valr_lang_fk as cd2_1_0_, this_.nom as nom1_0_, this_.prenm as prenm1_0_, this_.cd_utils as cd5_1_0_, this_.mot_passe as mot6_1_0_, this_.no_seqnc_verou as no7_1_0_ from public.in_indiv this_ where (lower(this_.nom) like ?)

I found my mistake, wrong bd used.

Thx