Hibernate Community • View topic - Requete par criteres: mauvaise requete construite

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users (Français)

All times are UTC - 5 hours [ DST ]

Requete par criteres: mauvaise requete construite

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

XOrangoutan

Post subject: Requete par criteres: mauvaise requete construite

Posted: Thu Feb 09, 2006 9:33 am

Beginner

Joined: Fri May 13, 2005 9:39 am
Posts: 21

Bonjour,
J'ai un petit soucis avec une requete par critères. En effet, lorsque j'invoque monCriteria.list(), la requete SQL générée n'intègre pas toutes les tables qu'il faudrait et me renvoie donc une erreur SQL "Table ou vue inexistante"

En définitive, je veux récupérer l'ensemble de mes coûts pour une année donnée, une période (budget, actu, up-to-date), éventuellement d'autre filtres sur les investissements et soit dont le statut prend une valeur dans une liste, soit est différent des statuts Closed et Cancelled.

Hibernate version:3

Mapping documents: 3 classe sont concernées:

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
                            "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
                            "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

<!-- DO NOT EDIT: This is a generated file that is synchronized -->
<!-- by MyEclipse Hibernate tool integration.                   -->
<!-- Created Wed Apr 27 09:32:23 CEST 2005                         -->
<hibernate-mapping package="com.isover.capex.model">

    <class name="Investment" table="INVESTMENT">
        <id name="idInvestment" column="ID_INVESTMENT" type="java.lang.Long">
            <generator class="increment"/>
        </id>
 
        <property name="checkValue" column="CHECK_VALUE" type="java.lang.String" />
        <property name="idIsolineDoc" column="ID_ISOLINE_DOC" type="java.lang.String" />
        <property name="description" column="DESCRIPTION" type="java.lang.String" />
        <property name="approvalCost" column="APPROVAL_COST" type="java.util.Date" />
        <property name="creditDate" column="CREDIT_DATE" type="java.util.Date" />
        <property name="dateModif" column="DATE_MODIF" type="java.util.Date" />
        <property name="dateCreation" column="DATE_CREATION" type="java.util.Date" />
         <property name="approvalExp" column="APPROVAL_EXP" type="java.lang.Float" />
         <property name="MailModif" column="MAIL_MODIF" type="java.lang.String" />
 
        <many-to-one name="area" column="ID_AREA" class="Area" />
 
        <many-to-one name="capexGroups" column="ID_GROUP" class="CapexGroups" />
 
        <many-to-one name="codeInv" column="CODE_INV" class="CodeInv" />
 
        <many-to-one name="division" column="DIVISION_CODE" class="Division"  not-null="true" />
 
        <many-to-one name="equipment" column="ID_EQUIPMENT" class="Equipment" />
 
        <many-to-one name="site" column="ID_SITE" class="Site"  not-null="true" />
 
        <many-to-one name="subject" column="ID_SUBJECT" class="Subject" />
 
        <many-to-one name="users" column="MODIF_LOGIN" class="Users" />
 
        <many-to-one name="users1" column="CREATION_LOGIN" class="Users" />

      <set name="statusSet" table="HAS_STATUS" order-by="YEAR_STATUS" >
         <key column="ID_INVESTMENT"/>
         <one-to-many class="HasStatus" />
      </set>
    </class>
    
</hibernate-mapping>

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
                            "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
                            "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

<!-- DO NOT EDIT: This is a generated file that is synchronized -->
<!-- by MyEclipse Hibernate tool integration.                   -->
<!-- Created Thu Apr 21 10:23:50 CEST 2005                         -->
<hibernate-mapping package="com.isover.capex.model">

    <class name="InvCost" table="INV_COST">
        <composite-id name="id" class="InvCostKey">
            <key-many-to-one name="period" column="CODE_PERIOD" class="Period"/>
            <key-property name="enterYear" column="ENTER_YEAR" type="java.lang.String"/>
            <key-many-to-one name="investment" column="ID_INVESTMENT" class="Investment"/>
            <key-property name="yearCost" column="YEAR_COST" type="java.lang.String"/>
        </composite-id>
 
        <property name="beforeCost" column="BEFORE_COST" type="java.lang.Float" />
        <property name="actuCost" column="ACTU__COST" type="java.lang.Float" />
        <property name="beforeJvCost" column="BEFORE_JV_COST" type="java.lang.Float" />
        <property name="actuJvCost" column="ACTU_JV_COST" type="java.lang.Float" />
        <property name="afterJvCost" column="AFTER_JV_COST" type="java.lang.Float" />
        <property name="euroBeforeCost" column="EURO_BEFORE_COST" type="java.lang.Float" />
        <property name="euroActuCost" column="EURO_ACTU_COST" type="java.lang.Float" />
        <property name="euroAfterCost" column="EURO_AFTER_COST" type="java.lang.Float" />
        <property name="euroJvBeforeCost" column="EURO_JV_BEFORE_COST" type="java.lang.Float" />
        <property name="euroJvActuCost" column="EURO_JV_ACTU_COST" type="java.lang.Float" />
        <property name="euroJvAfterCost" column="EURO_JV_AFTER_COST" type="java.lang.Float" />
        <property name="afterCost" column="AFTER_COST" type="java.lang.Float" />
        <property name="statement" column="STATEMENT" type="java.lang.String" />
        <property name="dateEnter" column="DATE_ENTER" type="timestamp" />
        <property name="ipTotalCostInLocal" formula="GET_IP_TOTAL_COST(Id_Investment, Enter_Year, Code_Period, 'LOC')" />
        <property name="ipTotalCostInEuro" formula="GET_IP_TOTAL_COST(Id_Investment, Enter_Year, Code_Period, 'EUR')" />
        
    </class>
    
</hibernate-mapping>

Code:

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
                            "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
                            "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

<!-- DO NOT EDIT: This is a generated file that is synchronized -->
<!-- by MyEclipse Hibernate tool integration.                   -->
<!-- Created Tue May 03 15:08:52 CEST 2005                         -->
<hibernate-mapping package="com.isover.capex.model">

    <class name="HasStatus" table="HAS_STATUS">
        <composite-id name="id" class="HasStatusKey">
            <key-many-to-one name="investment" column="ID_INVESTMENT" class="Investment"/>
            <key-property name="yearStatus" column="YEAR_STATUS" type="java.lang.String"/>
        </composite-id>

         <many-to-one name="status" column="STATUS_CODE" class="Status" />
         <property name="forced" column="FORCED" type="java.lang.String" />
 
    </class>
    
</hibernate-mapping>

Code between sessionFactory.openSession() and session.close():
[code]
session = HibernateSessionFactory.currentSession();
Criteria criteria = session.createCriteria(InvCost.class);
criteria.add(Expression.in("id.period.codePeriod", periodArray));
criteria.add(Expression.eq("id.enterYear", year));
Criteria statusCriteria = criteria.createAlias("id.investment.statusSet", "has_Status");
criteria.add(Expression.eqProperty("id.investment.idInvestment", "has_status.id.investment.idInvestment"));
criteria.add(Expression.eqProperty("id.enterYear", "has_Status.id.yearStatus"));
if (idStatus != null && idStatus.length != 0)
{
Long[] statuses = new Long[idStatus.length];
for(int i = 0; i<idSite.length; i++)
{
statuses[i] = new Long(idStatus[i]);
}
statusCriteria.add(Expression.in("status.statusCode", statuses));
}
else
{
Long[] statuses = new Long[2];
statuses[0] = new Long(5);
statuses[1] = new Long(6);
statusCriteria.add(Expression.not(Expression.in("status.statusCode", statuses)));
}
if(limit>0)
{
criteria.add(Expression.ge("ipTotalCostInEuro", new Float(limit)));
criteria.add(Expression.not(Expression.eq("id.investment.area.idArea", new Integer(9))));
criteria.add(Expression.not(Expression.eq("id.investment.equipment.idEquipment", new Integer(41))));
criteria.add(Expression.not(Expression.eq("id.investment.subject.idSubject", new Integer(9))));
criteria.add(Expression.not(Expression.eq("id.investment.codeInv.codeInv", new Integer(9))));
}
criteria.addOrder(Order.desc("ipTotalCostInEuro"));
criteria.addOrder(Order.asc("id.investment.idInvestment"));
criteria.addOrder(Order.asc("id.yearCost"));
invCollectionComplete = criteria.list();
[code]

Full stack trace of any exception that occurs:
[code]
org.hibernate.QueryException: could not resolve property: has_status of: com.isover.capex.model.InvCost
at org.hibernate.persister.entity.AbstractPropertyMapping.throwPropertyException(AbstractPropertyMapping.java:43)
at org.hibernate.persister.entity.AbstractPropertyMapping.toType(AbstractPropertyMapping.java:37)
at org.hibernate.persister.entity.BasicEntityPersister.getSubclassPropertyTableNumber(BasicEntityPersister.java:1111)
at org.hibernate.persister.entity.BasicEntityPropertyMapping.toColumns(BasicEntityPropertyMapping.java:31)
at org.hibernate.persister.entity.BasicEntityPersister.toColumns(BasicEntityPersister.java:1086)
at org.hibernate.loader.criteria.CriteriaQueryTranslator.getColumns(CriteriaQueryTranslator.java:403)
at org.hibernate.loader.criteria.CriteriaQueryTranslator.getColumnsUsingProjection(CriteriaQueryTranslator.java:369)
at org.hibernate.criterion.PropertyExpression.toSqlString(PropertyExpression.java:31)
at org.hibernate.loader.criteria.CriteriaQueryTranslator.getWhereCondition(CriteriaQueryTranslator.java:314)
at org.hibernate.loader.criteria.CriteriaLoader.<init>(CriteriaLoader.java:92)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1303)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:300)
at com.isover.capex.manager.InvCostsManager.GetAllDataBInvestCostRequest(InvCostsManager.java:2116)
at com.isover.capex.struts.action.Filtered_invAction.execute(Filtered_invAction.java:873)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:237)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at com.isover.capex.util.HibernateFilter.doFilter(HibernateFilter.java:46)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:186)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:157)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:214)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:198)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:152)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:137)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:118)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:102)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:104)
at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:520)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:799)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:705)
at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:577)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:683)
at java.lang.Thread.run(Thread.java:534)[/code]

Name and version of the database you are using: Oracle 9i database

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » Hibernate Users (Français)

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum