You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@roller.apache.org by sn...@apache.org on 2007/07/30 21:51:09 UTC
svn commit: r561101 -
/roller/trunk/apps/weblogger/src/java/org/apache/roller/weblogger/pojos/WeblogEntry.orm.xml
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&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">