-->
These old forums are deprecated now and set to read-only. We are waiting for you on our new forums!
More modern, Discourse-based and with GitHub/Google/Twitter authentication built-in.

All times are UTC - 5 hours [ DST ]



Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 8 posts ] 
Author Message
 Post subject: Select * = Select then update??
PostPosted: Tue Nov 09, 2004 8:30 pm 
Newbie

Joined: Tue Nov 09, 2004 5:56 pm
Posts: 4
Hibernate version:
Hiberate 2.16 - I own the Hiberate in Action book and have read it but I am still perplexed on what is going on. What we want this to do is in one query, go and query the 2 tables (which have a one to many relationship) and get the object backs. But what is happening is it is query (select)24-25 different times, then updating the records each time. See show-sql below. It should not be updating any records, only running a select query. I have changed a few of the package name to hide some of the internals due to corp standards. Any help please reply back. Thanks.

Mapping documents:
On our dao's we are using HibernateDaoSupport and also using HibernateInterceptor by spring to handle the session management.

Code:
   <class name="HourlyScheduleOffer" table="HOURLY_SCHEDULE_OFFER">
      <id name="id" column="ID" type="java.lang.Long">
         <generator class="native" />
      </id>
      <property name="creationTime" type="timestamp" />
    <property name="operatingDay" type="c[package name]" />
    <property name="hourEnding" type="[package name]" />
      <property name="unitName" type="string" length="20" />
      <property name="subStatus"
      type="[package name]"
         length="20" />
      <property name="market"
      type="[package name]"
         length="20" />
    <property name="ss" type="[package name]" />
    <property name="Status" type="[package name]" length="20" />
      <property name="offerPriceCurveSlope" type="boolean" />
    <property name="noLoadCost" type="[package name]" />
      <array name="offerCurve" table="S_OFFER_CURVE" cascade="none">
         <key column="OFFER_ID" />
         <index column="I" />
         <composite-element class="QuantityDollar">
        <property name="QuantityValue" type="[package name]" />
            <property name="dollarValue" type="[package name]" />
         </composite-element>
      </array>
   </class>


Code between sessionFactory.openSession() and session.close():
Code:
    public HourlyScheduleOffer find(String _nodeName, Market _forMarket, OperatingDay _operatingDay, HourEnding _hourEnding) {
        Session session = SessionFactoryUtils.getSession(getSessionFactory(), false);
       
        clock.start();
        try {
            HourlyScheduleOffer offer = (HourlyScheduleOffer)session.createCriteria(HourlyScheduleOffer.class)
           .setResultTransformer(new SingleObjectResultTransformer())
           .add(Expression.eq("unitName",     _nodeName))
           .add(Expression.eq("market",       _forMarket))
           .add(Expression.eq("hourEnding",   _hourEnding))
           .add(Expression.le("operatingDay", _operatingDay))
           .addOrder(Order.desc("creationTime"))
           .uniqueResult();
        return offer;
        } catch (HibernateException _he) {
            _he.printStackTrace();
            throw SessionFactoryUtils.convertHibernateAccessException(_he);
        }
        catch ( RuntimeException e )
        {
            e.printStackTrace();
            throw e;
        }
        finally {
            clock.stop();
            log.info("findOfferByNodeMarketAndDate: " + clock);
        }
    }

Full stack trace of any exception that occurs:

No Exceptions
Name and version of the database you are using:
oracle 8.1.7.4

The generated SQL (show_sql=true):
[code]
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue as dollarVa3___, offercurve0_.I as I__ from S_OFFER_CURVE offercurve0_ where offercurve0_.OFFER_ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: update HOURLY_SCHEDULE_OFFER set creationTime=?, operatingDay=?, hourEnding=?, unitName=?, subStatus=?, market=?, ss=?, Status=?, offerPriceCurveSlope=?, noLoadCost=? where ID=?
Hibernate: select this.ID as ID0_, this.creationTime as creation2_0_, this.operatingDay as operatin3_0_, this.hourEnding as hourEnding0_, this.unitName as unitName0_, this.subStatus as submitta6_0_, this.market as market0_, this.ss as selfSche8_0_, this.Status as commitSt9_0_, this.offerPriceCurveSlope as offerPr10_0_, this.noLoadCost as noLoadCost0_ from HOURLY_SCHEDULE_OFFER this where this.unitName=? and this.market=? and this.hourEnding=? and this.operatingDay<=? order by this.creationTime desc
Hibernate: select offercurve0_.OFFER_ID as OFFER_ID__, offercurve0_.megawattValue as megawatt2___, offercurve0_.dollarValue


Top
 Profile  
 
 Post subject: Pg 74 in hiberate manual
PostPosted: Tue Nov 16, 2004 4:12 pm 
Newbie

Joined: Tue Nov 09, 2004 5:56 pm
Posts: 4
I've also looked at pg 74 in the hiberate manual and I'm wondering if the topic discussed on that page is related to my problem. Thanks


Top
 Profile  
 
 Post subject:
PostPosted: Tue Nov 16, 2004 5:50 pm 
Hibernate Team
Hibernate Team

Joined: Thu Dec 18, 2003 9:55 am
Posts: 1977
Location: France
do you have something special on you getter setter ?

_________________
Anthony,
Get value thanks to your skills: http://www.redhat.com/certification


Top
 Profile  
 
 Post subject: getters/setters
PostPosted: Tue Nov 16, 2004 5:58 pm 
Newbie

Joined: Tue Nov 09, 2004 5:56 pm
Posts: 4
For seting of the offerCurve on the Hourly_ScheduleOffer class, you set it using an object array of type MegwattDollar and the getter returns an object array of the same type MegwattDollar. We are not using collection classes for this.

John


Top
 Profile  
 
 Post subject:
PostPosted: Wed Nov 17, 2004 12:21 pm 
Newbie

Joined: Tue Nov 09, 2004 5:56 pm
Posts: 4
Anthony,

We are not doing anything special on our getters and setters. As specified on the bottom of page 74 of the manual, we are using the same object structures on our getters and setters. We have a similar instance of this were we watched hibernate insert the values into the database, and then when we refreshed the app to get the newly persisted values, hibernate went back and erased the new values so there was nothing in the database. Why is hibernate synching inconsistently and erasing/updating our database when it shouldn't be?

John


Top
 Profile  
 
 Post subject:
PostPosted: Wed Nov 17, 2004 2:35 pm 
Hibernate Team
Hibernate Team

Joined: Thu Dec 18, 2003 9:55 am
Posts: 1977
Location: France
try to comment the properties in the mapping file, one by one to see which one causes the problem, their must be a mistake somewhere.

Hibernate is not going to update if the object has not changed

_________________
Anthony,
Get value thanks to your skills: http://www.redhat.com/certification


Top
 Profile  
 
 Post subject: Select & update
PostPosted: Thu Nov 18, 2004 4:23 pm 
Newbie

Joined: Thu Nov 18, 2004 4:03 pm
Posts: 7
Location: Pittsburgh,pa
Regarding the issue with an unwanted update when all that is being required is a select:

I ran into the same issue because I had one of my properties mapped to the wrong type. In my case I had a column mapped to a string when it was actually a Long. Check all your properties to make sure the type is correct.

Hope this helps


Top
 Profile  
 
 Post subject:
PostPosted: Fri Nov 19, 2004 10:00 am 
Newbie

Joined: Fri Aug 29, 2003 4:36 am
Posts: 16
Location: Belgium
Hi,

some collegues also had strange updates after a select, without doing anything "special" in the setters.
As it turned out, their setters trimmed the strings coming from the database and that caused the updates.

Bart.


Top
 Profile  
 
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 8 posts ] 

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

Search for:
© Copyright 2014, Red Hat Inc. All rights reserved. JBoss and Hibernate are registered trademarks and servicemarks of Red Hat, Inc.