roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From snoopd...@apache.org
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 GMT
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



Mime
View raw message