svn commit: r561101 - /roller/trunk/apps/weblogger/src/java/org/apache/roller/weblogger/pojos/WeblogEntry.orm.xml

[snoopdave]

Author: snoopdave
Date: Mon Jul 30 12:51:08 2007
New Revision: 561101

URL: http://svn.apache.org/viewvc?view=rev&rev=561101
Log:
Fox for ROL-1502:
http://opensource.atlassian.com/projects/roller/browse/ROL-1502

Corrected query syntax. Also, the pubTime=pubTime,updateTime=updateTime 
updates, meant to prevent the database from resetting those two timestamp 
fields cause an error with OpenJPA.Turns out, they are unecessary here because 
OpenJPA takes care of preserving those value (tested that on MySQL and Derby).

Modified:
    
roller/trunk/apps/weblogger/src/java/org/apache/roller/weblogger/pojos/WeblogEntry.orm.xml

Modified: 
roller/trunk/apps/weblogger/src/java/org/apache/roller/weblogger/pojos/WeblogEntry.orm.xml
URL: 
http://svn.apache.org/viewvc/roller/trunk/apps/weblogger/src/java/org/apache/roller/weblogger/pojos/WeblogEntry.orm.xml?view=diff&rev=561101&r1=561100&r2=561101
==============================================================================
--- 
roller/trunk/apps/weblogger/src/java/org/apache/roller/weblogger/pojos/WeblogEntry.orm.xml
 (original)
+++ 
roller/trunk/apps/weblogger/src/java/org/apache/roller/weblogger/pojos/WeblogEntry.orm.xml
 Mon Jul 30 12:51:08 2007
@@ -78,9 +78,7 @@
             <query>SELECT COUNT(e) FROM WeblogEntry e WHERE e.status = ?1 AND 
e.website = ?2</query>
         </named-query>
         <named-query 
name="WeblogEntry.updateAllowComments&amp;CommentDaysByWebsite">
-            <query>UPDATE WeblogEntry SET allowComments = ?1, commentDays = 
?2, 
-                                              pubTime=pubTime, 
updateTime=updateTime
-                                          WHERE website = ?3</query>
+            <query>UPDATE WeblogEntry e SET e.allowComments = ?1, 
e.commentDays = ?2 WHERE e.website = ?3</query>
         </named-query>
         <attributes>
             <id name="id">