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 2009/10/03 16:11:50 UTC
svn commit: r821323 - in /roller/trunk:
apps/weblogger/src/sql/400-to-500-migration.vm
metadata/database/oracle.properties metadata/database/postgresql.properties
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