From: <pn...@hy...> - 2008-12-11 01:21:19
|
Author: pnguyen Date: 2008-12-10 17:21:14 -0800 (Wed, 10 Dec 2008) New Revision: 12019 URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=12019 Modified: branches/HQ_4_0/sql/galerts/GalertLog.hbm.xml Log: HQ-1534: Remove ordering by TIMESTAMP since it causes a problem with mysql. ordering by just the ID should be sufficient since it is essentially sequential anyways Modified: branches/HQ_4_0/sql/galerts/GalertLog.hbm.xml =================================================================== --- branches/HQ_4_0/sql/galerts/GalertLog.hbm.xml 2008-12-11 01:19:01 UTC (rev 12018) +++ branches/HQ_4_0/sql/galerts/GalertLog.hbm.xml 2008-12-11 01:21:14 UTC (rev 12019) @@ -45,14 +45,14 @@ <bag name="actionLogBag" table="EAM_ALERT_ACTION_LOG" cascade="all-delete-orphan" inverse="true" - order-by="TIMESTAMP, ID"> + order-by="ID"> <cache usage="read-write" /> <key on-delete="cascade" column="GALERT_ID" not-null="true"/> <one-to-many class="GalertActionLog" /> </bag> <bag name="auxLogBag" table="EAM_GALERT_AUX_LOGS" - cascade="all-delete-orphan" inverse="true" order-by="TIMESTAMP, ID"> + cascade="all-delete-orphan" inverse="true" order-by="ID"> <cache usage="read-write" /> <key on-delete="cascade" column="GALERT_ID" not-null="true"/> <one-to-many class="GalertAuxLog" /> |