Author: tchemit Date: 2013-12-16 23:34:04 +0100 (Mon, 16 Dec 2013) New Revision: 917 Url: http://forge.codelutin.com/projects/echobase/repository/revisions/917 Log: fix on sql migration Modified: trunk/echobase-services/src/main/resources/postgis-structure.sql Modified: trunk/echobase-services/src/main/resources/postgis-structure.sql =================================================================== --- trunk/echobase-services/src/main/resources/postgis-structure.sql 2013-12-16 22:25:41 UTC (rev 916) +++ trunk/echobase-services/src/main/resources/postgis-structure.sql 2013-12-16 22:34:04 UTC (rev 917) @@ -1216,5 +1216,6 @@ -- Compute all data SELECT echobase_compute_all_cell_spatial_data(); SELECT echobase_compute_all_operation_spatial_data(); -SELECT count(*) from echobase_cell_spatial; -SELECT count(*) from echobase_operation_spatial; + +-- Add an update query as the migration service will execute this script and can't finish with a query instruction (see PreparedStatement#executeUpdate) +UPDATE echobase_operation_spatial SET lastUpdateDate = now() WHERE operationid IS NULL; \ No newline at end of file