diff flys-backend/ChangeLog @ 3961:f5912365619c

Adapted the spatial schema for DEMs and the DgmSqlConverter. flys-backend/trunk@5632 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Ingo Weinzierl <ingo.weinzierl@intevation.de>
date Fri, 28 Sep 2012 08:37:08 +0000
parents 9e4468d50329
children a4930c43b806
line wrap: on
line diff
--- a/flys-backend/ChangeLog	Thu Sep 27 17:45:49 2012 +0000
+++ b/flys-backend/ChangeLog	Fri Sep 28 08:37:08 2012 +0000
@@ -1,3 +1,16 @@
+2012-09-28  Ingo Weinzierl <ingo@intevation.de>
+
+	* doc/schema/postgresql-spatial.sql,
+	  doc/schema/oracle-spatial.sql: Changed the type of date columns to
+	  VARCHAR. This is a quick fix to solve the concatination problem in
+	  Oracle and PostgreSQL. Both aren't able to concatinate null values.
+	  So, null values are not valid for those columns. Users can now decide
+	  to fill these columns with correct values or an empty string.
+
+	* src/main/java/de/intevation/flys/utils/DgmSqlConverter.java: Set
+	  year_from and year_to values to an empty string if no correct value is
+	  specified.
+
 2012-09-27  Felix Wolfsteller <felix.wolfsteller@intevation.de>
 
 	For issue862/1, fix parsing of year field of bed height csvs,

http://dive4elements.wald.intevation.org