Return-Path: Delivered-To: apmail-roller-commits-archive@www.apache.org Received: (qmail 6476 invoked from network); 3 Oct 2009 14:12:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 3 Oct 2009 14:12:14 -0000 Received: (qmail 67807 invoked by uid 500); 3 Oct 2009 14:12:14 -0000 Delivered-To: apmail-roller-commits-archive@roller.apache.org Received: (qmail 67780 invoked by uid 500); 3 Oct 2009 14:12:14 -0000 Mailing-List: contact commits-help@roller.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@roller.apache.org Delivered-To: mailing list commits@roller.apache.org Received: (qmail 67771 invoked by uid 99); 3 Oct 2009 14:12:14 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 03 Oct 2009 14:12:14 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 03 Oct 2009 14:12:11 +0000 Received: by eris.apache.org (Postfix, from userid 65534) id 67571238893B; Sat, 3 Oct 2009 14:11:50 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r821323 - in /roller/trunk: apps/weblogger/src/sql/400-to-500-migration.vm metadata/database/oracle.properties metadata/database/postgresql.properties Date: Sat, 03 Oct 2009 14:11:50 -0000 To: commits@roller.apache.org From: snoopdave@apache.org X-Mailer: svnmailer-1.0.8 Message-Id: <20091003141150.67571238893B@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Author: snoopdave Date: Sat Oct 3 14:11:49 2009 New Revision: 821323 URL: http://svn.apache.org/viewvc?rev=821323&view=rev Log: Fix for https://issues.apache.org/jira/browse/ROL-1760 "Scheduled tasks do not run on Oracle (or other DBs with high precision timestamps)" Fix suggested by Ceri Davis and confirmed by Ron Peterson Modified: roller/trunk/apps/weblogger/src/sql/400-to-500-migration.vm roller/trunk/metadata/database/oracle.properties roller/trunk/metadata/database/postgresql.properties Modified: roller/trunk/apps/weblogger/src/sql/400-to-500-migration.vm URL: http://svn.apache.org/viewvc/roller/trunk/apps/weblogger/src/sql/400-to-500-migration.vm?rev=821323&r1=821322&r2=821323&view=diff ============================================================================== --- roller/trunk/apps/weblogger/src/sql/400-to-500-migration.vm (original) +++ roller/trunk/apps/weblogger/src/sql/400-to-500-migration.vm Sat Oct 3 14:11:49 2009 @@ -148,3 +148,10 @@ alter table roller_mediafiledir add constraint mf_parentid_fk foreign key ( parentid ) references roller_mediafiledir( id ) $!db.ADDL_FK_PARAMS ; + +-- Fix for https://issues.apache.org/jira/browse/ROL-1760 + +#if ($db.DBTYPE == "POSTGRESQL" || $db.DBTYPE == "ORACLE") +alter table roller_tasklock alter timeacquired type timestamp(2) with time zone; +alter table roller_tasklock alter lastrun type timestamp(2) with time zone; +#end Modified: roller/trunk/metadata/database/oracle.properties URL: http://svn.apache.org/viewvc/roller/trunk/metadata/database/oracle.properties?rev=821323&r1=821322&r2=821323&view=diff ============================================================================== --- roller/trunk/metadata/database/oracle.properties (original) +++ roller/trunk/metadata/database/oracle.properties Sat Oct 3 14:11:49 2009 @@ -24,5 +24,5 @@ INDEXSIZE= INDEXSIZE_LARGE= ADDL_FK_PARAMS= -TIMESTAMP_SQL_TYPE_NULL=timestamp null -TIMESTAMP_SQL_TYPE=timestamp +TIMESTAMP_SQL_TYPE_NULL=timestamp(2) null +TIMESTAMP_SQL_TYPE=timestamp(2) Modified: roller/trunk/metadata/database/postgresql.properties URL: http://svn.apache.org/viewvc/roller/trunk/metadata/database/postgresql.properties?rev=821323&r1=821322&r2=821323&view=diff ============================================================================== --- roller/trunk/metadata/database/postgresql.properties (original) +++ roller/trunk/metadata/database/postgresql.properties Sat Oct 3 14:11:49 2009 @@ -24,5 +24,5 @@ INDEXSIZE= INDEXSIZE_LARGE= ADDL_FK_PARAMS= -TIMESTAMP_SQL_TYPE_NULL=timestamp with time zone null -TIMESTAMP_SQL_TYPE=timestamp with time zone +TIMESTAMP_SQL_TYPE_NULL=timestamp(2) with time zone null +TIMESTAMP_SQL_TYPE=timestamp(2) with time zone