annotate geo-backend/ChangeLog @ 556:48121fa4dc95

Summarized Changes and NEWS for Release 0.4 geo-backend/trunk@639 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Hans Plum <hans.plum@intevation.de>
date Wed, 27 Jan 2010 14:50:07 +0000
parents 825781a39c70
children 23a0f2c5e3b8
rev   line source
556
48121fa4dc95 Summarized Changes and NEWS for Release 0.4
Hans Plum <hans.plum@intevation.de>
parents: 555
diff changeset
1 2010-01-27 Hans Plum <hans@intevation.de>
48121fa4dc95 Summarized Changes and NEWS for Release 0.4
Hans Plum <hans.plum@intevation.de>
parents: 555
diff changeset
2
48121fa4dc95 Summarized Changes and NEWS for Release 0.4
Hans Plum <hans.plum@intevation.de>
parents: 555
diff changeset
3 RELEASE 0.4
48121fa4dc95 Summarized Changes and NEWS for Release 0.4
Hans Plum <hans.plum@intevation.de>
parents: 555
diff changeset
4
48121fa4dc95 Summarized Changes and NEWS for Release 0.4
Hans Plum <hans.plum@intevation.de>
parents: 555
diff changeset
5 * Changes, NEWS, ChangeLog: Summarized changes.
48121fa4dc95 Summarized Changes and NEWS for Release 0.4
Hans Plum <hans.plum@intevation.de>
parents: 555
diff changeset
6
555
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
7 2009-01-25 Sascha L. Teichmann <sascha.teichmann@intevation.de>
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
8
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
9 Fix for gnv/issue107
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
10
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
11 * src/main/java/de/intevation/gnv/geobackend/util/RedundancyRemover.java:
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
12 New. Used to reduce the redundancy of data in SQL result sets. Column
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
13 values are very distinct so the degree or redundancy is very high. E.g
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
14 the SDE produces for each date value a java.util.GregorianCalendar object
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
15 which are very heavy weighted. We only use them r/o so we can hash each date
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
16 value to one unique representative. Same logic applys to integer values
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
17 and so on.
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
18
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
19 With this technique we are able to reduce the memory consumption by
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
20 over 90%. Because it is not very feasible to store the whole history
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
21 of column we only have a limited number of cached values per column.
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
22 This is controlled via the system property
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
23 "de.intevation.gnv.geobackend.util.RedundancyRemover.lookback" which
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
24 defaults to 1029.
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
25
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
26 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java:
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
27 Use RedundancyRemovers to filter the incoming traffic from SDE.
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
28
554
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents: 553
diff changeset
29 2010-01-26 Tim Englich <tim.englich@intevation.de>
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents: 553
diff changeset
30
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents: 553
diff changeset
31 * src/test/java/de/intevation/gnv/geobackend/base/query/ToCharSample.java :
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents: 553
diff changeset
32 Added Sample for bug in ArcSDE 9.3 using to_char-Function with SpatialQuery
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents: 553
diff changeset
33 * src/test/java/de/intevation/gnv/geobackend/base/query/GroupBySample.java :
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents: 553
diff changeset
34 Added Sample for Bug in ArcSDE using group by with SpatialQuery
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents: 553
diff changeset
35
553
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
36 2009-01-25 Sascha L. Teichmann <sascha.teichmann@intevation.de>
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
37
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
38 Another attempt to fix gnv/issue34
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
39
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
40 * src/main/java/de/intevation/gnv/geobackend/base/DefaultResultDescriptor.java:
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
41 Add a toString() method.
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
42
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
43 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEConnection.java:
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
44 Added an idle time detection mechanism. You can call touch() on
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
45 a connection to refresh the internal timestamp and ask with isActive()
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
46 if a constructor given time interval in milliseconds is exceeded.
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
47
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
48 * src/main/java/de/intevation/gnv/geobackend/sde/connectionpool/ArcSDEPoolableObjectFactory.java:
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
49 Added a check of inactivity to validateObject() before relying on SDE logic.
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
50 This is the last line of defence if the testServer() call is going not to respond.
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
51 This duplicates the eviction policy of Apache Commons pool a bit but I found
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
52 this way to be more trustworthy.
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
53
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
54 The idle time is configure with the property 'serverInactiveInterval'.
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
55 units: seconds. Defaults to 5 minutes.
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
56
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
57 The unit of 'serverRoundtripInterval' (parameter of testServer()) is now
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
58 in seconds, too. Default: 5 seconds. This is the value used in GeoTools.
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
59
552
7615ee5d1345 Cleanup imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 551
diff changeset
60 2009-01-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
7615ee5d1345 Cleanup imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 551
diff changeset
61
7615ee5d1345 Cleanup imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 551
diff changeset
62 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/SDEQuery.java,
7615ee5d1345 Cleanup imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 551
diff changeset
63 src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java,
7615ee5d1345 Cleanup imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 551
diff changeset
64 src/main/java/de/intevation/gnv/geobackend/sde/datasources/RasterObject.java:
7615ee5d1345 Cleanup imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 551
diff changeset
65 Cleanup imports.
7615ee5d1345 Cleanup imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 551
diff changeset
66
551
1f6e2b256247 Improved the Objectvalidation of the ArcSDE-Databaseconnections
Tim Englich <tim.englich@intevation.de>
parents: 550
diff changeset
67 2010-01-15 Tim Englich <tim.englich@intevation.de>
1f6e2b256247 Improved the Objectvalidation of the ArcSDE-Databaseconnections
Tim Englich <tim.englich@intevation.de>
parents: 550
diff changeset
68
1f6e2b256247 Improved the Objectvalidation of the ArcSDE-Databaseconnections
Tim Englich <tim.englich@intevation.de>
parents: 550
diff changeset
69 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEConnection.java (isValid):
1f6e2b256247 Improved the Objectvalidation of the ArcSDE-Databaseconnections
Tim Englich <tim.englich@intevation.de>
parents: 550
diff changeset
70 Implemented the isValid-method of the ArcSDEConnection for
1f6e2b256247 Improved the Objectvalidation of the ArcSDE-Databaseconnections
Tim Englich <tim.englich@intevation.de>
parents: 550
diff changeset
71 getting a propper Validation of the used SEConnection.
1f6e2b256247 Improved the Objectvalidation of the ArcSDE-Databaseconnections
Tim Englich <tim.englich@intevation.de>
parents: 550
diff changeset
72 For the Validation the Method testServer of the SEConnection is used.
1f6e2b256247 Improved the Objectvalidation of the ArcSDE-Databaseconnections
Tim Englich <tim.englich@intevation.de>
parents: 550
diff changeset
73
1f6e2b256247 Improved the Objectvalidation of the ArcSDE-Databaseconnections
Tim Englich <tim.englich@intevation.de>
parents: 550
diff changeset
74 * src/main/java/de/intevation/gnv/geobackend/sde/connectionpool/ArcSDEPoolableObjectFactory.java (ArcSDEPoolableObjectFactory):
1f6e2b256247 Improved the Objectvalidation of the ArcSDE-Databaseconnections
Tim Englich <tim.englich@intevation.de>
parents: 550
diff changeset
75 Added Member serverRoundtripInterval to represent the Time in
1f6e2b256247 Improved the Objectvalidation of the ArcSDE-Databaseconnections
Tim Englich <tim.englich@intevation.de>
parents: 550
diff changeset
76 Milliseconds which is allowed to reused a returned Connection.
1f6e2b256247 Improved the Objectvalidation of the ArcSDE-Databaseconnections
Tim Englich <tim.englich@intevation.de>
parents: 550
diff changeset
77 Also used Connection.isValid Method instead of Connection.isClosed
1f6e2b256247 Improved the Objectvalidation of the ArcSDE-Databaseconnections
Tim Englich <tim.englich@intevation.de>
parents: 550
diff changeset
78 to validate the Connection befor it could be borrowed from the Pool.
1f6e2b256247 Improved the Objectvalidation of the ArcSDE-Databaseconnections
Tim Englich <tim.englich@intevation.de>
parents: 550
diff changeset
79
550
84ba7cbff791 Added bicubic spline interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 549
diff changeset
80 2009-01-12 Sascha L. Teichmann <sascha.teichmann@intevation.de>
84ba7cbff791 Added bicubic spline interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 549
diff changeset
81
84ba7cbff791 Added bicubic spline interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 549
diff changeset
82 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/RasterObject.java:
84ba7cbff791 Added bicubic spline interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 549
diff changeset
83 Added bicubic spline interpolation on raster tiles. This
84ba7cbff791 Added bicubic spline interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 549
diff changeset
84 should increase the 'virtual' resolution more than the
84ba7cbff791 Added bicubic spline interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 549
diff changeset
85 bilinear interpolation. To enable it write 'bicubic' into
84ba7cbff791 Added bicubic spline interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 549
diff changeset
86 the configuration file.
84ba7cbff791 Added bicubic spline interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 549
diff changeset
87
84ba7cbff791 Added bicubic spline interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 549
diff changeset
88 * pom.xml: Added dependency to Apache Common Math 2.0 for
84ba7cbff791 Added bicubic spline interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 549
diff changeset
89 the cubic spline interpolation.
84ba7cbff791 Added bicubic spline interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 549
diff changeset
90
549
0dcf068fb552 Added method to figure out interpolation method for a given string in raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 548
diff changeset
91 2009-01-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
0dcf068fb552 Added method to figure out interpolation method for a given string in raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 548
diff changeset
92
0dcf068fb552 Added method to figure out interpolation method for a given string in raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 548
diff changeset
93 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/RasterObject.java:
0dcf068fb552 Added method to figure out interpolation method for a given string in raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 548
diff changeset
94 Added static method to fetch matching interpolation type for
0dcf068fb552 Added method to figure out interpolation method for a given string in raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 548
diff changeset
95 given string. Defaults to nearest neighbor if no string is matching.
0dcf068fb552 Added method to figure out interpolation method for a given string in raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 548
diff changeset
96
548
ccd976fc0f7b Implemented bilinear interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 547
diff changeset
97 2009-01-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
ccd976fc0f7b Implemented bilinear interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 547
diff changeset
98
ccd976fc0f7b Implemented bilinear interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 547
diff changeset
99 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/RasterObject.java:
ccd976fc0f7b Implemented bilinear interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 547
diff changeset
100 Implemented bilinear interpolation.
ccd976fc0f7b Implemented bilinear interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 547
diff changeset
101
547
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
102 2009-01-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
103
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
104 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java:
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
105 Fixed transformations to figure out the right tile in the SDE.
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
106 Taking the tile origin into account now and does not do wrong rounding
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
107 of column and row indices. Simplified the code a lot.
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
108
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
109 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/RasterObject.java:
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
110 Fixed access to right right pixel now. Removed the envelope code because
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
111 its not needed any longer. You can ask a RasterObject directly now if
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
112 a given coordinate is on the tile now. The tile space is now correctly
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
113 spanned between (0, 0) and (tile width - 1, tile height - 1) now which
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
114 allows other access patterns like bilinear interpolation. TODO: implement
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
115 bilinear interpolation.
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
116
546
210716612c30 Removed Encodingerrors from listed Files. All Files are now UTF-8 compliant.
Tim Englich <tim.englich@intevation.de>
parents: 545
diff changeset
117 2010-01-08 Tim Englich <tim.englich@intevation.de>
210716612c30 Removed Encodingerrors from listed Files. All Files are now UTF-8 compliant.
Tim Englich <tim.englich@intevation.de>
parents: 545
diff changeset
118
210716612c30 Removed Encodingerrors from listed Files. All Files are now UTF-8 compliant.
Tim Englich <tim.englich@intevation.de>
parents: 545
diff changeset
119 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/SDEQuery.java,
210716612c30 Removed Encodingerrors from listed Files. All Files are now UTF-8 compliant.
Tim Englich <tim.englich@intevation.de>
parents: 545
diff changeset
120 src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java,
210716612c30 Removed Encodingerrors from listed Files. All Files are now UTF-8 compliant.
Tim Englich <tim.englich@intevation.de>
parents: 545
diff changeset
121 src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java,
210716612c30 Removed Encodingerrors from listed Files. All Files are now UTF-8 compliant.
Tim Englich <tim.englich@intevation.de>
parents: 545
diff changeset
122 src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEConnection.java,
210716612c30 Removed Encodingerrors from listed Files. All Files are now UTF-8 compliant.
Tim Englich <tim.englich@intevation.de>
parents: 545
diff changeset
123 src/main/java/de/intevation/gnv/geobackend/base/connectionpool/ConnectionPoolFactory.java (initializeConnectionPool):
210716612c30 Removed Encodingerrors from listed Files. All Files are now UTF-8 compliant.
Tim Englich <tim.englich@intevation.de>
parents: 545
diff changeset
124 Removed Encodingerrors from listed Files. All Files are now UTF-8 compliant.
210716612c30 Removed Encodingerrors from listed Files. All Files are now UTF-8 compliant.
Tim Englich <tim.englich@intevation.de>
parents: 545
diff changeset
125
545
347c84467478 Made RasterObject serializable to be cachable beyond reboot.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 544
diff changeset
126 2010-01-05 Tim Englich <tim.englich@intevation.de>
347c84467478 Made RasterObject serializable to be cachable beyond reboot.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 544
diff changeset
127
347c84467478 Made RasterObject serializable to be cachable beyond reboot.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 544
diff changeset
128 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/RasterObject.java:
347c84467478 Made RasterObject serializable to be cachable beyond reboot.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 544
diff changeset
129 Made it serializable to be cachable beyond reboot.
347c84467478 Made RasterObject serializable to be cachable beyond reboot.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 544
diff changeset
130
544
33f93898cbbf Added RasterObject for caching the Rastertiles to get a better performance
Tim Englich <tim.englich@intevation.de>
parents: 543
diff changeset
131 2010-01-05 Tim Englich <tim.englich@intevation.de>
33f93898cbbf Added RasterObject for caching the Rastertiles to get a better performance
Tim Englich <tim.englich@intevation.de>
parents: 543
diff changeset
132
33f93898cbbf Added RasterObject for caching the Rastertiles to get a better performance
Tim Englich <tim.englich@intevation.de>
parents: 543
diff changeset
133 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java (handleResultSet):
33f93898cbbf Added RasterObject for caching the Rastertiles to get a better performance
Tim Englich <tim.englich@intevation.de>
parents: 543
diff changeset
134 Switched to return the RasterObject instead of the depth in an Rasterquery.
33f93898cbbf Added RasterObject for caching the Rastertiles to get a better performance
Tim Englich <tim.englich@intevation.de>
parents: 543
diff changeset
135 This should help to get a better performance.
33f93898cbbf Added RasterObject for caching the Rastertiles to get a better performance
Tim Englich <tim.englich@intevation.de>
parents: 543
diff changeset
136 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/RasterObject.java (RasterObject):
33f93898cbbf Added RasterObject for caching the Rastertiles to get a better performance
Tim Englich <tim.englich@intevation.de>
parents: 543
diff changeset
137 Added new Object for Caching Rastertiles and all Informations that are
33f93898cbbf Added RasterObject for caching the Rastertiles to get a better performance
Tim Englich <tim.englich@intevation.de>
parents: 543
diff changeset
138 required for calculating the Depth to a given Coordinate.
33f93898cbbf Added RasterObject for caching the Rastertiles to get a better performance
Tim Englich <tim.englich@intevation.de>
parents: 543
diff changeset
139
543
fac02bf1c685 Added Rasterdatasupport to the ARCSDE-Statement
Tim Englich <tim.englich@intevation.de>
parents: 542
diff changeset
140 2010-01-04 Tim Englich <tim.englich@intevation.de>
fac02bf1c685 Added Rasterdatasupport to the ARCSDE-Statement
Tim Englich <tim.englich@intevation.de>
parents: 542
diff changeset
141
fac02bf1c685 Added Rasterdatasupport to the ARCSDE-Statement
Tim Englich <tim.englich@intevation.de>
parents: 542
diff changeset
142 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java (handleResultSet):
fac02bf1c685 Added Rasterdatasupport to the ARCSDE-Statement
Tim Englich <tim.englich@intevation.de>
parents: 542
diff changeset
143 Added Rasterdatasupport to the ARCSDESTATEMENT.
fac02bf1c685 Added Rasterdatasupport to the ARCSDE-Statement
Tim Englich <tim.englich@intevation.de>
parents: 542
diff changeset
144 Now it is possible to Query the Value of an Pixel like that:
fac02bf1c685 Added Rasterdatasupport to the ARCSDE-Statement
Tim Englich <tim.englich@intevation.de>
parents: 542
diff changeset
145 SELECT ST_ASTEXT(RASTER) FROM MEDIAN.TOPO_BS_D_6X10SEC where INTERSECTS(RASTER, "POINT( 12.084721594184593 54.35583351483295)")
fac02bf1c685 Added Rasterdatasupport to the ARCSDE-Statement
Tim Englich <tim.englich@intevation.de>
parents: 542
diff changeset
146
542
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
147 2009-12-19 Sascha L. Teichmann <sascha.teichmann@intevation.de>
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
148
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
149 * contrib/sql-cache.xml: Configured disk storage to survive restarts.
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
150
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
151 * src/main/java/de/intevation/gnv/geobackend/base/query/QueryExecutorFactory.java:
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
152 Added explicit shutdown hook.
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
153
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
154 * src/main/java/de/intevation/gnv/geobackend/base/query/CachingQueryExecutorFactory.java:
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
155 Fixed spelling of cacheResults() which prevented results to be stored in cache.
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
156 Added some logging.
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
157
541
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
158 2009-12-18 Sascha L. Teichmann <sascha.teichmann@intevation.de>
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
159
542
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
160 Experimental caching of SQL results via Ehcache
541
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
161
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
162 * pom.xml: Added dependency to Ehcache
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
163
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
164 * src/main/java/de/intevation/gnv/geobackend/base/query/QueryExecutor.java:
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
165 Extended interface to support caching by SQL statements as Strings.
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
166
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
167 * src/main/java/de/intevation/gnv/geobackend/base/query/QueryExecutorBase.java:
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
168 Implements new interface with no caching
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
169
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
170 * src/main/java/de/intevation/gnv/geobackend/base/query/container/QueryContainerFactory.java:
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
171 synchronized access to singleton.
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
172
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
173 * src/main/java/de/intevation/gnv/geobackend/base/query/DefaultQueryExceutor.java:
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
174 calls caching methods of base class.
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
175
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
176 * src/main/java/de/intevation/gnv/geobackend/base/query/QueryExecutorFactory.java:
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
177 When system property 'query.executor.factory' is given the value is used as
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
178 a class name to be instantiated as a sub class of QueryExecutorFactory.
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
179 This happens if the singleton of QueryExecutorFactory is created. With the
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
180 mechanism it is possible to replace the standard behavior of creating QueryExecutors.
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
181
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
182 * src/main/java/de/intevation/gnv/geobackend/base/query/CachingQueryExecutorFactory.java:
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
183 New: This class extends QueryExecutorFactory and can be used as replacement for
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
184 the standard QueryExecutorFactory. Usage:
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
185
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
186 -Dquery.executor.factory=de.intevation.gnv.geobackend.base.query.CachingQueryExecutorFactory
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
187
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
188 If you pass in another system property 'caching.query.executor.config' you can
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
189 customize the caching. The value is used as a file name to an XML file with
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
190 Ehcache configuration.
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
191
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
192 * contrib/sql-cache.xml: Demo configuration for sql caching. Usage:
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
193
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
194 -Dquery.executor.factory=de.intevation.gnv.geobackend.base.query.CachingQueryExecutorFactory
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
195 -Dcaching.query.executor.config=contrib/sql-cache.xml
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
196
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
197 2009-12-17 Sascha L. Teichmann <sascha.teichmann@intevation.de>
385
27082b83c267 Release 0.3
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 384
diff changeset
198
27082b83c267 Release 0.3
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 384
diff changeset
199 RELEASE 0.3
27082b83c267 Release 0.3
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 384
diff changeset
200
27082b83c267 Release 0.3
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 384
diff changeset
201 * Changes, NEWS, ChangeLog: Summarized changes.
27082b83c267 Release 0.3
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 384
diff changeset
202
384
da2da7bb1aa1 Fixed a bug in DefaultResult when querying an index out of bounds.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 383
diff changeset
203 2009-12-17 Ingo Weinzierl <ingo.weinzierl@intevation.de>
da2da7bb1aa1 Fixed a bug in DefaultResult when querying an index out of bounds.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 383
diff changeset
204
da2da7bb1aa1 Fixed a bug in DefaultResult when querying an index out of bounds.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 383
diff changeset
205 * src/main/java/de/intevation/gnv/geobackend/base/DefaultResult.java:
da2da7bb1aa1 Fixed a bug in DefaultResult when querying an index out of bounds.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 383
diff changeset
206 Fixed bug in DefaultResult when querying an index out of bounds.
da2da7bb1aa1 Fixed a bug in DefaultResult when querying an index out of bounds.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 383
diff changeset
207
383
0b813ae17173 Added Point in Polygon Query Support to ArcSDE-Statement-Processing
Tim Englich <tim.englich@intevation.de>
parents: 382
diff changeset
208 2009-12-15 Tim Englich <tim.englich@intevation.de>
0b813ae17173 Added Point in Polygon Query Support to ArcSDE-Statement-Processing
Tim Englich <tim.englich@intevation.de>
parents: 382
diff changeset
209
0b813ae17173 Added Point in Polygon Query Support to ArcSDE-Statement-Processing
Tim Englich <tim.englich@intevation.de>
parents: 382
diff changeset
210 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java (executeQuery):
0b813ae17173 Added Point in Polygon Query Support to ArcSDE-Statement-Processing
Tim Englich <tim.englich@intevation.de>
parents: 382
diff changeset
211 We have to use a different SpatialFilter for Point in Polygon Queries as
0b813ae17173 Added Point in Polygon Query Support to ArcSDE-Statement-Processing
Tim Englich <tim.englich@intevation.de>
parents: 382
diff changeset
212 in AreaIntersection Statements.
0b813ae17173 Added Point in Polygon Query Support to ArcSDE-Statement-Processing
Tim Englich <tim.englich@intevation.de>
parents: 382
diff changeset
213 So we have to include a switch which will do that.
0b813ae17173 Added Point in Polygon Query Support to ArcSDE-Statement-Processing
Tim Englich <tim.englich@intevation.de>
parents: 382
diff changeset
214 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEUtils.java (createPoints):
0b813ae17173 Added Point in Polygon Query Support to ArcSDE-Statement-Processing
Tim Englich <tim.englich@intevation.de>
parents: 382
diff changeset
215 Added Support of Point-Objects for the possibility to execute a Point in Pologon
0b813ae17173 Added Point in Polygon Query Support to ArcSDE-Statement-Processing
Tim Englich <tim.englich@intevation.de>
parents: 382
diff changeset
216 Statement using the ArcSDE.
0b813ae17173 Added Point in Polygon Query Support to ArcSDE-Statement-Processing
Tim Englich <tim.englich@intevation.de>
parents: 382
diff changeset
217
382
4af6379ac20b Changed exception handling if a the value of a column, which is not contained in Result, is requested. Will not throw an exception but return null.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 381
diff changeset
218 2009-12-11 Ingo Weinzierl <ingo.weinzierl@intevation.de>
4af6379ac20b Changed exception handling if a the value of a column, which is not contained in Result, is requested. Will not throw an exception but return null.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 381
diff changeset
219
4af6379ac20b Changed exception handling if a the value of a column, which is not contained in Result, is requested. Will not throw an exception but return null.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 381
diff changeset
220 * src/main/java/de/intevation/gnv/geobackend/base/DefaultResult.java:
4af6379ac20b Changed exception handling if a the value of a column, which is not contained in Result, is requested. Will not throw an exception but return null.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 381
diff changeset
221 DefaultResult will return null if it doesn't contain the specified column
4af6379ac20b Changed exception handling if a the value of a column, which is not contained in Result, is requested. Will not throw an exception but return null.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 381
diff changeset
222 name in method getString(String columnName), instead of throwing an
4af6379ac20b Changed exception handling if a the value of a column, which is not contained in Result, is requested. Will not throw an exception but return null.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 381
diff changeset
223 exception.
4af6379ac20b Changed exception handling if a the value of a column, which is not contained in Result, is requested. Will not throw an exception but return null.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 381
diff changeset
224
381
4a874c664123 Removed needless imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 380
diff changeset
225 2009-12-11 Sascha L. Teichmann <sascha.teichmann@intevation.de>
4a874c664123 Removed needless imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 380
diff changeset
226
4a874c664123 Removed needless imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 380
diff changeset
227 * src/main/java/de/intevation/gnv/geobackend/base/DefaultResultDescriptor.java,
4a874c664123 Removed needless imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 380
diff changeset
228 src/main/java/de/intevation/gnv/geobackend/base/query/container/QueryContainer.java,
4a874c664123 Removed needless imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 380
diff changeset
229 src/main/java/de/intevation/gnv/geobackend/base/query/container/DefaultQueryContainer.java:
4a874c664123 Removed needless imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 380
diff changeset
230 Removed needless imports.
4a874c664123 Removed needless imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 380
diff changeset
231
380
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
232 2009-11-30 Tim Englich <tim.englich@intevation.de>
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
233
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
234 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/SDEResultSet.java,
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
235 src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java,
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
236 src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEResultSetMetaData.java,
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
237 src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEConnection.java:
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
238 Added missing Methodstubs for Java 1.6 compability.
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
239 ###################################################
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
240 ###### ATTENTION: ONLY USE JAVA 1.6 FOR THIS ######
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
241 ###### AND ALL USING MODULES. ######
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
242 ###################################################
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
243
378
9ed654c21f9b Changed Splitalgorithm of Statements so that it is Possible to add to_date Colums into a Statement
Tim Englich <tim.englich@intevation.de>
parents: 279
diff changeset
244 2009-11-27 Tim Englich <tim.englich@intevation.de>
9ed654c21f9b Changed Splitalgorithm of Statements so that it is Possible to add to_date Colums into a Statement
Tim Englich <tim.englich@intevation.de>
parents: 279
diff changeset
245
9ed654c21f9b Changed Splitalgorithm of Statements so that it is Possible to add to_date Colums into a Statement
Tim Englich <tim.englich@intevation.de>
parents: 279
diff changeset
246 * src/test/ressources/QueryExecutorTestCase.properties,
9ed654c21f9b Changed Splitalgorithm of Statements so that it is Possible to add to_date Colums into a Statement
Tim Englich <tim.englich@intevation.de>
parents: 279
diff changeset
247 src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java:
379
31595c0a1a33 Revert Changes of the commit of Revision 377 which was unintended
Tim Englich <tim.englich@intevation.de>
parents: 378
diff changeset
248 Revert Changes of the commit of Revision 377 which was unintended
378
9ed654c21f9b Changed Splitalgorithm of Statements so that it is Possible to add to_date Colums into a Statement
Tim Englich <tim.englich@intevation.de>
parents: 279
diff changeset
249 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java (executeQuery):
9ed654c21f9b Changed Splitalgorithm of Statements so that it is Possible to add to_date Colums into a Statement
Tim Englich <tim.englich@intevation.de>
parents: 279
diff changeset
250 Changed Splitalgorithm of Statements so that it is Possible to add to_date Colums into a Statement
9ed654c21f9b Changed Splitalgorithm of Statements so that it is Possible to add to_date Colums into a Statement
Tim Englich <tim.englich@intevation.de>
parents: 279
diff changeset
251 with Spatial-Columns or Spatial-Filters
9ed654c21f9b Changed Splitalgorithm of Statements so that it is Possible to add to_date Colums into a Statement
Tim Englich <tim.englich@intevation.de>
parents: 279
diff changeset
252
279
3c38ef20d622 RELEASE 0.2: Summarized contents
Hans Plum <hans.plum@intevation.de>
parents: 278
diff changeset
253 2009-11-13 Hans Plum <hans@intevation.de>
3c38ef20d622 RELEASE 0.2: Summarized contents
Hans Plum <hans.plum@intevation.de>
parents: 278
diff changeset
254
3c38ef20d622 RELEASE 0.2: Summarized contents
Hans Plum <hans.plum@intevation.de>
parents: 278
diff changeset
255 RELEASE 0.2
3c38ef20d622 RELEASE 0.2: Summarized contents
Hans Plum <hans.plum@intevation.de>
parents: 278
diff changeset
256
3c38ef20d622 RELEASE 0.2: Summarized contents
Hans Plum <hans.plum@intevation.de>
parents: 278
diff changeset
257 * Changes, NEWS: Summarized changes.
3c38ef20d622 RELEASE 0.2: Summarized contents
Hans Plum <hans.plum@intevation.de>
parents: 278
diff changeset
258
278
095486545edf Made some ChangeLog entries a bit clearer.
Hans Plum <hans.plum@intevation.de>
parents: 277
diff changeset
259 2009-11-13 Hans Plum <hans@intevation.de>
095486545edf Made some ChangeLog entries a bit clearer.
Hans Plum <hans.plum@intevation.de>
parents: 277
diff changeset
260
095486545edf Made some ChangeLog entries a bit clearer.
Hans Plum <hans.plum@intevation.de>
parents: 277
diff changeset
261 * Made some ChangeLog entries a bit clearer.
095486545edf Made some ChangeLog entries a bit clearer.
Hans Plum <hans.plum@intevation.de>
parents: 277
diff changeset
262
277
f304f2f12db4 Changed the splitting of the Statements for ARCSDE-Transformation.
Tim Englich <tim.englich@intevation.de>
parents: 276
diff changeset
263 2009-11-10 Tim Englich <tim.englich@intevation.de>
f304f2f12db4 Changed the splitting of the Statements for ARCSDE-Transformation.
Tim Englich <tim.englich@intevation.de>
parents: 276
diff changeset
264
f304f2f12db4 Changed the splitting of the Statements for ARCSDE-Transformation.
Tim Englich <tim.englich@intevation.de>
parents: 276
diff changeset
265 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java (executeQuery):
f304f2f12db4 Changed the splitting of the Statements for ARCSDE-Transformation.
Tim Englich <tim.englich@intevation.de>
parents: 276
diff changeset
266 Changed the splitting of the Statements for ARCSDE-Transformation.
f304f2f12db4 Changed the splitting of the Statements for ARCSDE-Transformation.
Tim Englich <tim.englich@intevation.de>
parents: 276
diff changeset
267 Now it is possible to use a Select-Statement as an Table.
f304f2f12db4 Changed the splitting of the Statements for ARCSDE-Transformation.
Tim Englich <tim.englich@intevation.de>
parents: 276
diff changeset
268
276
6503bc864017 Removed target from version control.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 275
diff changeset
269 2009-11-06 Ingo Weinzierl <ingo.weinzierl@intevation.de>
6503bc864017 Removed target from version control.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 275
diff changeset
270
6503bc864017 Removed target from version control.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 275
diff changeset
271 * target/**: Removed. Should not be in version control.
6503bc864017 Removed target from version control.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 275
diff changeset
272
275
9063c5fcebf7 Added the possibility to use Innerselects in SpatialQueries
Tim Englich <tim.englich@intevation.de>
parents: 274
diff changeset
273 2009-11-05 Tim Englich <tim.englich@intevation.de>
9063c5fcebf7 Added the possibility to use Innerselects in SpatialQueries
Tim Englich <tim.englich@intevation.de>
parents: 274
diff changeset
274
9063c5fcebf7 Added the possibility to use Innerselects in SpatialQueries
Tim Englich <tim.englich@intevation.de>
parents: 274
diff changeset
275 * src/test/ressources/QueryExecutorTestCase.properties,
9063c5fcebf7 Added the possibility to use Innerselects in SpatialQueries
Tim Englich <tim.englich@intevation.de>
parents: 274
diff changeset
276 src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java (testSpatialQueryWithInnerSelect):
9063c5fcebf7 Added the possibility to use Innerselects in SpatialQueries
Tim Englich <tim.englich@intevation.de>
parents: 274
diff changeset
277 Added an Tescase to test the InnerSelect Statments in Spatial-Queries.
9063c5fcebf7 Added the possibility to use Innerselects in SpatialQueries
Tim Englich <tim.englich@intevation.de>
parents: 274
diff changeset
278 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java (getPosValue):
9063c5fcebf7 Added the possibility to use Innerselects in SpatialQueries
Tim Englich <tim.englich@intevation.de>
parents: 274
diff changeset
279 Bugfix. An Point could not have an Z-Coordinate-Value
9063c5fcebf7 Added the possibility to use Innerselects in SpatialQueries
Tim Englich <tim.englich@intevation.de>
parents: 274
diff changeset
280 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java (executeQuery):
9063c5fcebf7 Added the possibility to use Innerselects in SpatialQueries
Tim Englich <tim.englich@intevation.de>
parents: 274
diff changeset
281 Added the possibility to execute Spatial-Queries using InnerStatements instead
9063c5fcebf7 Added the possibility to use Innerselects in SpatialQueries
Tim Englich <tim.englich@intevation.de>
parents: 274
diff changeset
282 of WKT in Intersects-where-clauses.
9063c5fcebf7 Added the possibility to use Innerselects in SpatialQueries
Tim Englich <tim.englich@intevation.de>
parents: 274
diff changeset
283
274
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
284 2009-11-02 Tim Englich <tim.englich@intevation.de>
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
285
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
286 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEConnection.java (createStatement):
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
287 Changed TODO to a question
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
288 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java (executeQuery):
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
289 CodeCleanup: Removed deprecated TODO
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
290 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/SDEResultSet.java (getColumnIndex):
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
291 Removed Typo.
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
292 * src/main/java/de/intevation/gnv/geobackend/sde/connectionpool/ArcSDEPoolableObjectFactory.java:
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
293 CodeCleanup: Removed deprecated TODOS and replace Tabs with whitespaces.
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
294 * src/main/java/de/intevation/gnv/geobackend/base/query/container/DefaultQueryContainer.java:,
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
295 src/main/java/de/intevation/gnv/geobackend/base/query/container/QueryContainer.java:
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
296 CodeCleanup: Removed unused Method getQueryIds
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
297 * src/main/java/de/intevation/gnv/geobackend/sde/connectionpool/ArcSDEConnectionPool.java (closeConnection):
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
298 CodeCleanup: Inspect TODO and ansewerd the Question that the Connection has not to
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
299 be closed at that position but perhaps insite the ConnectionPool.
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
300
273
69ddef25e822 Polygon and 3D Support was added to the WKT-Representation.
Tim Englich <tim.englich@intevation.de>
parents: 272
diff changeset
301 2009-10-30 Tim Englich <tim.englich@intevation.de>
69ddef25e822 Polygon and 3D Support was added to the WKT-Representation.
Tim Englich <tim.englich@intevation.de>
parents: 272
diff changeset
302
69ddef25e822 Polygon and 3D Support was added to the WKT-Representation.
Tim Englich <tim.englich@intevation.de>
parents: 272
diff changeset
303 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java (getPosValue):
69ddef25e822 Polygon and 3D Support was added to the WKT-Representation.
Tim Englich <tim.englich@intevation.de>
parents: 272
diff changeset
304 Added Support for Polygons without interior Rings. This is required for generating
69ddef25e822 Polygon and 3D Support was added to the WKT-Representation.
Tim Englich <tim.englich@intevation.de>
parents: 272
diff changeset
305 Horizontal Cross-Section Outputs.
69ddef25e822 Polygon and 3D Support was added to the WKT-Representation.
Tim Englich <tim.englich@intevation.de>
parents: 272
diff changeset
306 The Z-Value of an Point was also added to the WKT-Represantation.
69ddef25e822 Polygon and 3D Support was added to the WKT-Representation.
Tim Englich <tim.englich@intevation.de>
parents: 272
diff changeset
307
272
05912f0304ac Added Integer-Support for DoubleValues because the ArcSDE does
Tim Englich <tim.englich@intevation.de>
parents: 271
diff changeset
308 2009-10-29 Tim Englich <tim.englich@intevation.de>
05912f0304ac Added Integer-Support for DoubleValues because the ArcSDE does
Tim Englich <tim.englich@intevation.de>
parents: 271
diff changeset
309
278
095486545edf Made some ChangeLog entries a bit clearer.
Hans Plum <hans.plum@intevation.de>
parents: 277
diff changeset
310 Issue 45: Defintion of gaps in temporal and spatial data
095486545edf Made some ChangeLog entries a bit clearer.
Hans Plum <hans.plum@intevation.de>
parents: 277
diff changeset
311
272
05912f0304ac Added Integer-Support for DoubleValues because the ArcSDE does
Tim Englich <tim.englich@intevation.de>
parents: 271
diff changeset
312 * src/main/java/de/intevation/gnv/geobackend/base/DefaultResult.java (getInteger):
05912f0304ac Added Integer-Support for DoubleValues because the ArcSDE does
Tim Englich <tim.englich@intevation.de>
parents: 271
diff changeset
313 Added Integer-Support for DoubleValues because the ArcSDE does
05912f0304ac Added Integer-Support for DoubleValues because the ArcSDE does
Tim Englich <tim.englich@intevation.de>
parents: 271
diff changeset
314 not read values like -1 as Integer-values. issue45
05912f0304ac Added Integer-Support for DoubleValues because the ArcSDE does
Tim Englich <tim.englich@intevation.de>
parents: 271
diff changeset
315
271
8aad9d098b08 Integrated Patch of issue57 to get some Memoryusage-improvements
Tim Englich <tim.englich@intevation.de>
parents: 270
diff changeset
316 2009-10-20 Tim Englich <tim.englich@intevation.de>
8aad9d098b08 Integrated Patch of issue57 to get some Memoryusage-improvements
Tim Englich <tim.englich@intevation.de>
parents: 270
diff changeset
317
278
095486545edf Made some ChangeLog entries a bit clearer.
Hans Plum <hans.plum@intevation.de>
parents: 277
diff changeset
318 Issue 57: Improving memory usage of data objects
095486545edf Made some ChangeLog entries a bit clearer.
Hans Plum <hans.plum@intevation.de>
parents: 277
diff changeset
319
271
8aad9d098b08 Integrated Patch of issue57 to get some Memoryusage-improvements
Tim Englich <tim.englich@intevation.de>
parents: 270
diff changeset
320 * src/main/java/de/intevation/gnv/geobackend/base/query/QueryExecutorBase.java (QueryExecutorBase),
8aad9d098b08 Integrated Patch of issue57 to get some Memoryusage-improvements
Tim Englich <tim.englich@intevation.de>
parents: 270
diff changeset
321 src/main/java/de/intevation/gnv/geobackend/base/ResultDescriptor.java (getColumnClassName),
8aad9d098b08 Integrated Patch of issue57 to get some Memoryusage-improvements
Tim Englich <tim.englich@intevation.de>
parents: 270
diff changeset
322 src/main/java/de/intevation/gnv/geobackend/base/Result.java,
8aad9d098b08 Integrated Patch of issue57 to get some Memoryusage-improvements
Tim Englich <tim.englich@intevation.de>
parents: 270
diff changeset
323 src/main/java/de/intevation/gnv/geobackend/base/DefaultResultDescriptor.java (serialVersionUID),
8aad9d098b08 Integrated Patch of issue57 to get some Memoryusage-improvements
Tim Englich <tim.englich@intevation.de>
parents: 270
diff changeset
324 src/main/java/de/intevation/gnv/geobackend/base/DefaultResult.java (getDate):
8aad9d098b08 Integrated Patch of issue57 to get some Memoryusage-improvements
Tim Englich <tim.englich@intevation.de>
parents: 270
diff changeset
325 Integrated Patch of issue57 to get some Memoryusage-improvements
8aad9d098b08 Integrated Patch of issue57 to get some Memoryusage-improvements
Tim Englich <tim.englich@intevation.de>
parents: 270
diff changeset
326
270
1fe93e3c80c0 DefaultResult now directly inherits from HashMap.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 269
diff changeset
327 2009-10-19 Sascha L. Teichmann <sascha.teichmann@intevation.de>
1fe93e3c80c0 DefaultResult now directly inherits from HashMap.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 269
diff changeset
328
1fe93e3c80c0 DefaultResult now directly inherits from HashMap.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 269
diff changeset
329 * src/main/java/de/intevation/gnv/geobackend/base/DefaultResult.java:
1fe93e3c80c0 DefaultResult now directly inherits from HashMap.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 269
diff changeset
330 Extends from HashMap directly to avoid one level of indirection and
1fe93e3c80c0 DefaultResult now directly inherits from HashMap.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 269
diff changeset
331 do not create so much needless objects.
1fe93e3c80c0 DefaultResult now directly inherits from HashMap.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 269
diff changeset
332
1fe93e3c80c0 DefaultResult now directly inherits from HashMap.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 269
diff changeset
333 TODO: The representation in form of HashMaps is not very efficent!
1fe93e3c80c0 DefaultResult now directly inherits from HashMap.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 269
diff changeset
334 Use array with index instead.
1fe93e3c80c0 DefaultResult now directly inherits from HashMap.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 269
diff changeset
335
269
db8920c5346d Added further Queries for Testing Spatial-Query-Support
Tim Englich <tim.englich@intevation.de>
parents: 268
diff changeset
336 2009-10-14 Tim Englich <tim.englich@intevation.de>
db8920c5346d Added further Queries for Testing Spatial-Query-Support
Tim Englich <tim.englich@intevation.de>
parents: 268
diff changeset
337
db8920c5346d Added further Queries for Testing Spatial-Query-Support
Tim Englich <tim.englich@intevation.de>
parents: 268
diff changeset
338 * src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java (testSpatialQueryWithoutIntersects),
db8920c5346d Added further Queries for Testing Spatial-Query-Support
Tim Englich <tim.englich@intevation.de>
parents: 268
diff changeset
339 src/test/ressources/QueryExecutorTestCase.properties:
db8920c5346d Added further Queries for Testing Spatial-Query-Support
Tim Englich <tim.englich@intevation.de>
parents: 268
diff changeset
340 Added further Queries for Testing Spatial-Query-Support
db8920c5346d Added further Queries for Testing Spatial-Query-Support
Tim Englich <tim.englich@intevation.de>
parents: 268
diff changeset
341
267
000e00592ba5 Added InnerJoin, Order By and Group By Support to Spatial-Queries
Tim Englich <tim.englich@intevation.de>
parents: 266
diff changeset
342 2009-10-14 Tim Englich <tim.englich@intevation.de>
000e00592ba5 Added InnerJoin, Order By and Group By Support to Spatial-Queries
Tim Englich <tim.englich@intevation.de>
parents: 266
diff changeset
343
268
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue
Tim Englich <tim.englich@intevation.de>
parents: 267
diff changeset
344 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java (getPosValue):
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue
Tim Englich <tim.englich@intevation.de>
parents: 267
diff changeset
345 Add WKT-Syntaxt to Shape ReturnValue
267
000e00592ba5 Added InnerJoin, Order By and Group By Support to Spatial-Queries
Tim Englich <tim.englich@intevation.de>
parents: 266
diff changeset
346 * src/test/ressources/QueryExecutorTestCase.properties:
000e00592ba5 Added InnerJoin, Order By and Group By Support to Spatial-Queries
Tim Englich <tim.englich@intevation.de>
parents: 266
diff changeset
347 Changed Test-Query-Statement for Spatial-Queries with INNERJOINS and ORDER BY
000e00592ba5 Added InnerJoin, Order By and Group By Support to Spatial-Queries
Tim Englich <tim.englich@intevation.de>
parents: 266
diff changeset
348 * src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java (testSpatialQueryWithoutIntersects):
000e00592ba5 Added InnerJoin, Order By and Group By Support to Spatial-Queries
Tim Englich <tim.englich@intevation.de>
parents: 266
diff changeset
349 Changed expected Result-Size because of Changes in the QueryStatement which is used.
000e00592ba5 Added InnerJoin, Order By and Group By Support to Spatial-Queries
Tim Englich <tim.englich@intevation.de>
parents: 266
diff changeset
350 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java (executeQuery):
000e00592ba5 Added InnerJoin, Order By and Group By Support to Spatial-Queries
Tim Englich <tim.englich@intevation.de>
parents: 266
diff changeset
351 Added INNERJOIN, ORDER BY and GROUP BY support to Spatial Queries
000e00592ba5 Added InnerJoin, Order By and Group By Support to Spatial-Queries
Tim Englich <tim.englich@intevation.de>
parents: 266
diff changeset
352
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
353 2009-10-13 Tim Englich <tim.englich@intevation.de>
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
354
266
1530890b28c9 Added SFS-Support to ArcSDE-Query-Part without any Spatial restriction in the where clause
Tim Englich <tim.englich@intevation.de>
parents: 265
diff changeset
355 * src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java (testSpatialQueryWithoutIntersects):
1530890b28c9 Added SFS-Support to ArcSDE-Query-Part without any Spatial restriction in the where clause
Tim Englich <tim.englich@intevation.de>
parents: 265
diff changeset
356 Added an TaesCase for Querying spatial Data without an spatial restriction
1530890b28c9 Added SFS-Support to ArcSDE-Query-Part without any Spatial restriction in the where clause
Tim Englich <tim.englich@intevation.de>
parents: 265
diff changeset
357 * src/test/ressources/QueryExecutorTestCase.properties:
1530890b28c9 Added SFS-Support to ArcSDE-Query-Part without any Spatial restriction in the where clause
Tim Englich <tim.englich@intevation.de>
parents: 265
diff changeset
358 Added TestQuery with no spatial restriction
1530890b28c9 Added SFS-Support to ArcSDE-Query-Part without any Spatial restriction in the where clause
Tim Englich <tim.englich@intevation.de>
parents: 265
diff changeset
359 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java (executeQuery):
1530890b28c9 Added SFS-Support to ArcSDE-Query-Part without any Spatial restriction in the where clause
Tim Englich <tim.englich@intevation.de>
parents: 265
diff changeset
360 Now it is possible to send spatial Quieries without an spatial restriction in the where clause.
1530890b28c9 Added SFS-Support to ArcSDE-Query-Part without any Spatial restriction in the where clause
Tim Englich <tim.englich@intevation.de>
parents: 265
diff changeset
361
1530890b28c9 Added SFS-Support to ArcSDE-Query-Part without any Spatial restriction in the where clause
Tim Englich <tim.englich@intevation.de>
parents: 265
diff changeset
362 2009-10-13 Tim Englich <tim.englich@intevation.de>
278
095486545edf Made some ChangeLog entries a bit clearer.
Hans Plum <hans.plum@intevation.de>
parents: 277
diff changeset
363
095486545edf Made some ChangeLog entries a bit clearer.
Hans Plum <hans.plum@intevation.de>
parents: 277
diff changeset
364 Issue 34: SQL Exception in REST Server when accessing geo-backend
095486545edf Made some ChangeLog entries a bit clearer.
Hans Plum <hans.plum@intevation.de>
parents: 277
diff changeset
365
265
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
366 * src/main/java/de/intevation/gnv/geobackend/sde/connectionpool/ArcSDEPoolableObjectFactory.java (validateObject) Edited:
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
367 Added Tests if the Object is Closed. And add propper instance Tests
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
368 * src/main/java/de/intevation/gnv/geobackend/sde/connectionpool/ArcSDEConnectionPool.java (initialize):
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
369 Added further ConfigurationParameters that could be set in the *.properties-File.
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
370 maxWait, maxIdle, minIdle, testOnBorrow, testOnReturn, testWhileIdle, numTestsPerEvictionRun,
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
371 timeBetweenEvictionRunsMillis, testWhileIdle
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
372 * src/test/ressources/ArcSDEConnectionPoolTestCase.properties:
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
373 Added som Configurationproperties for testing.
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
374
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
375
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
376 2009-10-13 Tim Englich <tim.englich@intevation.de>
264
5bbdbc0bbddc Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 263
diff changeset
377 * src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java (QueryExecutorTestCase):
5bbdbc0bbddc Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 263
diff changeset
378 Changed expected Result of Spatial-Query-TestCase because of Changes to the used Query
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
379 * src/test/ressources/QueryExecutorTestCase.properties:
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
380 Added SFS-Conformal Query
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
381 * pom.xml:
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
382 Added dependency to JTS 1.9
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
383 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java (executeQuery):
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
384 Added Spatial-Query-Support for ArcSDE
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
385 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEUtils.java (createPoints):
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
386 Switched Method Signature to JTS-Geometry-Support
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
387 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java (getStringValue):
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
388 Added String-Support for GeometryObjects
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
389
144
fcfa9d2de572 RELEASE 0.1
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 143
diff changeset
390 2009-10-07 Sascha L. Teichmann <sascha.teichmann@intevation.de>
fcfa9d2de572 RELEASE 0.1
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 143
diff changeset
391
fcfa9d2de572 RELEASE 0.1
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 143
diff changeset
392 RELEASE 0.1
fcfa9d2de572 RELEASE 0.1
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 143
diff changeset
393
fcfa9d2de572 RELEASE 0.1
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 143
diff changeset
394 * Changes, NEWS: Summarized changes.
fcfa9d2de572 RELEASE 0.1
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 143
diff changeset
395
143
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
396 2009-10-06 Sascha L. Teichmann <sascha.teichmann@intevation.de>
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
397
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
398 * Changelog -> ChangeLog: Renamed to make eclipse happy. Unified changelog style.
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
399
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
400 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/SDEQuery.java,
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
401 src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java:
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
402 Removed needless imports.
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
403
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
404 * pom.xml: xmllint-ed
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
405
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
406 2009-09-29 Tim Englich <tim.englich@intevation.de>
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
407
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
408 * src/main/java/de/intevation/gnv/geobackend/util/DateUtils.java (DATE_PATTERN) Edited:
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
409 Make the Constants assessible for other Parts of the Project to reduce the TouchPoints for
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
410 Dateformats.
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
411
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
412 2009-09-24 Tim Englich <tim.englich@intevation.de>
143
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
413
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
414 * src/main/java/de/intevation/gnv/geobackend/base/ResultDescriptor.java Edited,
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
415 src/main/java/de/intevation/gnv/geobackend/base/Result.java Edited,
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
416 src/main/java/de/intevation/gnv/geobackend/base/DefaultResultDescriptor.java Edited,
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
417 src/main/java/de/intevation/gnv/geobackend/base/DefaultResult.java Edited:
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
418 Make Classes Serializable for Storing in ArtifactDatabase
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
419
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
420 2009-09-21 Tim Englich <tim.englich@intevation.de>
143
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
421
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
422 * src/main/java/de/intevation/gnv/geobackend/base/DefaultResult.java:
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
423 Added formatted Date Handling in getString Method
143
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
424 * src/test/ressources/QueryExecutorTestCase.properties Edited,
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
425 src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java Edited:
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
426 Some tests for Spatialqueries added
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
427 * src/main/java/de/intevation/gnv/geobackend/base/query/DefaultQueryExceutor.java Edited:
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
428 Put the final Querystring into a Logmessage
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
429
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
430 2009-09-09 Tim Englich <tim.englich@intevation.de>
143
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
431
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
432 * src/main/java/de/intevation/gnv/geobackend/base/DefaultResult.java (getDate):
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
433 . Intance Check for DateValues
143
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
434 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/SDEResultSet.java (next):
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
435 Logging removed because the performance slowdown fetching many ResultSets
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
436
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
437 2009-09-04 Tim Englich <tim.englich@intevation.de>
143
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
438
270
1fe93e3c80c0 DefaultResult now directly inherits from HashMap.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 269
diff changeset
439 * pom.xml:

http://dive4elements.wald.intevation.org