Mercurial > dive4elements > gnv-client

annotate geo-backend/ChangeLog @ 555:825781a39c70

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Fixed gnv/issue107 geo-backend/trunk@632 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Tue, 26 Jan 2010 16:33:36 +0000
parents 0ee3c0ed40e4
children 48121fa4dc95
rev   line source
555
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
1 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
2
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
3 Fix for gnv/issue107
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
4
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
5 * 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
6 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
7 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
8 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
9 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
10 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
11 and so on.
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
12
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
13 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
14 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
15 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
16 This is controlled via the system property
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
17 "de.intevation.gnv.geobackend.util.RedundancyRemover.lookback" which
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
18 defaults to 1029.
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
19
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
20 * 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
21 Use RedundancyRemovers to filter the incoming traffic from SDE.
825781a39c70 Fixed gnv/issue107
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 554
diff changeset
22
554
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents: 553
diff changeset
23 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
24
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents: 553
diff changeset
25 * 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
26 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
27 * 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
28 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
29
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
30 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
31
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
32 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
33
5b536542ef56 Another attempt to fix gnv/issue34. Implemented an internal idle time checking.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 552
diff changeset
34 * 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
35 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
36
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 * 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
38 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
39 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
40 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
41
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 * 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
43 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
44 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
45 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
46 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
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 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
49 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
50
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 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
52 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
53
552
7615ee5d1345 Cleanup imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 551
diff changeset
54 2009-01-09 Sascha L. Teichmann <sascha.teichmann@intevation.de>
7615ee5d1345 Cleanup imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 551
diff changeset
55
7615ee5d1345 Cleanup imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 551
diff changeset
56 * 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
57 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
58 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
59 Cleanup imports.
7615ee5d1345 Cleanup imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 551
diff changeset
60
551
1f6e2b256247 Improved the Objectvalidation of the ArcSDE-Databaseconnections
Tim Englich <tim.englich@intevation.de>
parents: 550
diff changeset
61 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
62
1f6e2b256247 Improved the Objectvalidation of the ArcSDE-Databaseconnections
Tim Englich <tim.englich@intevation.de>
parents: 550
diff changeset
63 * 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
64 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
65 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
66 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
67
1f6e2b256247 Improved the Objectvalidation of the ArcSDE-Databaseconnections
Tim Englich <tim.englich@intevation.de>
parents: 550
diff changeset
68 * 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
69 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
70 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
71 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
72 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
73
550
84ba7cbff791 Added bicubic spline interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 549
diff changeset
74 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
75
84ba7cbff791 Added bicubic spline interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 549
diff changeset
76 * 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
77 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
78 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
79 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
80 the configuration file.
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 * 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
83 the cubic spline interpolation.
84ba7cbff791 Added bicubic spline interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 549
diff changeset
84
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
85 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
86
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
87 * 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
88 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
89 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
90
548
ccd976fc0f7b Implemented bilinear interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 547
diff changeset
91 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
92
ccd976fc0f7b Implemented bilinear interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 547
diff changeset
93 * 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
94 Implemented bilinear interpolation.
ccd976fc0f7b Implemented bilinear interpolation on raster tiles.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 547
diff changeset
95
547
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
96 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
97
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
98 * 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
99 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
100 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
101 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
102
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
103 * 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
104 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
105 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
106 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
107 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
108 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
109 bilinear interpolation.
23d5cc37dd5b Fixed access to raster data.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 546
diff changeset
110
546
210716612c30 Removed Encodingerrors from listed Files. All Files are now UTF-8 compliant.
Tim Englich <tim.englich@intevation.de>
parents: 545
diff changeset
111 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
112
210716612c30 Removed Encodingerrors from listed Files. All Files are now UTF-8 compliant.
Tim Englich <tim.englich@intevation.de>
parents: 545
diff changeset
113 * 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
114 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
115 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
116 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
117 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
118 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
119
545
347c84467478 Made RasterObject serializable to be cachable beyond reboot.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 544
diff changeset
120 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
121
347c84467478 Made RasterObject serializable to be cachable beyond reboot.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 544
diff changeset
122 * 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
123 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
124
544
33f93898cbbf Added RasterObject for caching the Rastertiles to get a better performance
Tim Englich <tim.englich@intevation.de>
parents: 543
diff changeset
125 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
126
33f93898cbbf Added RasterObject for caching the Rastertiles to get a better performance
Tim Englich <tim.englich@intevation.de>
parents: 543
diff changeset
127 * 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
128 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
129 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
130 * 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
131 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
132 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
133
543
fac02bf1c685 Added Rasterdatasupport to the ARCSDE-Statement
Tim Englich <tim.englich@intevation.de>
parents: 542
diff changeset
134 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
135
fac02bf1c685 Added Rasterdatasupport to the ARCSDE-Statement
Tim Englich <tim.englich@intevation.de>
parents: 542
diff changeset
136 * 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
137 Added Rasterdatasupport to the ARCSDESTATEMENT.
fac02bf1c685 Added Rasterdatasupport to the ARCSDE-Statement
Tim Englich <tim.englich@intevation.de>
parents: 542
diff changeset
138 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
139 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
140
542
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
141 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
142
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
143 * 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
144
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
145 * 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
146 Added explicit shutdown hook.
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
147
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
148 * 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
149 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
150 Added some logging.
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
151
541
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
152 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
153
542
f0b6d0e2a0f6 Small fixes for Ehcache based SQL results caching.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 541
diff changeset
154 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
155
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
156 * 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
157
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
158 * 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
159 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
160
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
161 * 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
162 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
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/container/QueryContainerFactory.java:
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
165 synchronized access to singleton.
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/DefaultQueryExceutor.java:
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
168 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
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/QueryExecutorFactory.java:
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
171 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
172 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
173 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
174 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
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/CachingQueryExecutorFactory.java:
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
177 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
178 the standard QueryExecutorFactory. Usage:
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
179
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
180 -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
181
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
182 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
183 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
184 Ehcache configuration.
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 * 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
187
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
188 -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
189 -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
190
3cbf11c67fdc Experimental caching of SQL results via Ehache
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 385
diff changeset
191 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
192
27082b83c267 Release 0.3
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 384
diff changeset
193 RELEASE 0.3
27082b83c267 Release 0.3
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 384
diff changeset
194
27082b83c267 Release 0.3
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 384
diff changeset
195 * Changes, NEWS, ChangeLog: Summarized changes.
27082b83c267 Release 0.3
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 384
diff changeset
196
384
da2da7bb1aa1 Fixed a bug in DefaultResult when querying an index out of bounds.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 383
diff changeset
197 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
198
da2da7bb1aa1 Fixed a bug in DefaultResult when querying an index out of bounds.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 383
diff changeset
199 * 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
200 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
201
383
0b813ae17173 Added Point in Polygon Query Support to ArcSDE-Statement-Processing
Tim Englich <tim.englich@intevation.de>
parents: 382
diff changeset
202 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
203
0b813ae17173 Added Point in Polygon Query Support to ArcSDE-Statement-Processing
Tim Englich <tim.englich@intevation.de>
parents: 382
diff changeset
204 * 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
205 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
206 in AreaIntersection Statements.
0b813ae17173 Added Point in Polygon Query Support to ArcSDE-Statement-Processing
Tim Englich <tim.englich@intevation.de>
parents: 382
diff changeset
207 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
208 * 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
209 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
210 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
211
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
212 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
213
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
214 * 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
215 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
216 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
217 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
218
381
4a874c664123 Removed needless imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 380
diff changeset
219 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
220
4a874c664123 Removed needless imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 380
diff changeset
221 * 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
222 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
223 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
224 Removed needless imports.
4a874c664123 Removed needless imports
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 380
diff changeset
225
380
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
226 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
227
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
228 * 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
229 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
230 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
231 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
232 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
233 ###################################################
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
234 ###### 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
235 ###### AND ALL USING MODULES. ######
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
236 ###################################################
0100ebf6630f Added missing Methodstubs for Java 1.6 compability.
Tim Englich <tim.englich@intevation.de>
parents: 379
diff changeset
237
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
238 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
239
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
240 * 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
241 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
242 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
243 * 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
244 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
245 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
246
279
3c38ef20d622 RELEASE 0.2: Summarized contents
Hans Plum <hans.plum@intevation.de>
parents: 278
diff changeset
247 2009-11-13 Hans Plum <hans@intevation.de>
3c38ef20d622 RELEASE 0.2: Summarized contents
Hans Plum <hans.plum@intevation.de>
parents: 278
diff changeset
248
3c38ef20d622 RELEASE 0.2: Summarized contents
Hans Plum <hans.plum@intevation.de>
parents: 278
diff changeset
249 RELEASE 0.2
3c38ef20d622 RELEASE 0.2: Summarized contents
Hans Plum <hans.plum@intevation.de>
parents: 278
diff changeset
250
3c38ef20d622 RELEASE 0.2: Summarized contents
Hans Plum <hans.plum@intevation.de>
parents: 278
diff changeset
251 * Changes, NEWS: Summarized changes.
3c38ef20d622 RELEASE 0.2: Summarized contents
Hans Plum <hans.plum@intevation.de>
parents: 278
diff changeset
252
278
095486545edf Made some ChangeLog entries a bit clearer.
Hans Plum <hans.plum@intevation.de>
parents: 277
diff changeset
253 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
254
095486545edf Made some ChangeLog entries a bit clearer.
Hans Plum <hans.plum@intevation.de>
parents: 277
diff changeset
255 * 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
256
277
f304f2f12db4 Changed the splitting of the Statements for ARCSDE-Transformation.
Tim Englich <tim.englich@intevation.de>
parents: 276
diff changeset
257 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
258
f304f2f12db4 Changed the splitting of the Statements for ARCSDE-Transformation.
Tim Englich <tim.englich@intevation.de>
parents: 276
diff changeset
259 * 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
260 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
261 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
262
276
6503bc864017 Removed target from version control.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 275
diff changeset
263 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
264
6503bc864017 Removed target from version control.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 275
diff changeset
265 * target/**: Removed. Should not be in version control.
6503bc864017 Removed target from version control.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents: 275
diff changeset
266
275
9063c5fcebf7 Added the possibility to use Innerselects in SpatialQueries
Tim Englich <tim.englich@intevation.de>
parents: 274
diff changeset
267 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
268
9063c5fcebf7 Added the possibility to use Innerselects in SpatialQueries
Tim Englich <tim.englich@intevation.de>
parents: 274
diff changeset
269 * src/test/ressources/QueryExecutorTestCase.properties,
9063c5fcebf7 Added the possibility to use Innerselects in SpatialQueries
Tim Englich <tim.englich@intevation.de>
parents: 274
diff changeset
270 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
271 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
272 * 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
273 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
274 * 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
275 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
276 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
277
274
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
278 2009-11-02 Tim Englich <tim.englich@intevation.de>
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
279
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
280 * 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
281 Changed TODO to a question
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
282 * 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
283 CodeCleanup: Removed deprecated TODO
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
284 * 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
285 Removed Typo.
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
286 * src/main/java/de/intevation/gnv/geobackend/sde/connectionpool/ArcSDEPoolableObjectFactory.java:
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
287 CodeCleanup: Removed deprecated TODOS and replace Tabs with whitespaces.
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
288 * 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
289 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
290 CodeCleanup: Removed unused Method getQueryIds
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
291 * 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
292 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
293 be closed at that position but perhaps insite the ConnectionPool.
ff1b7967e6b9 General CodecCleanup:
Tim Englich <tim.englich@intevation.de>
parents: 273
diff changeset
294
273
69ddef25e822 Polygon and 3D Support was added to the WKT-Representation.
Tim Englich <tim.englich@intevation.de>
parents: 272
diff changeset
295 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
296
69ddef25e822 Polygon and 3D Support was added to the WKT-Representation.
Tim Englich <tim.englich@intevation.de>
parents: 272
diff changeset
297 * 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
298 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
299 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
300 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
301
272
05912f0304ac Added Integer-Support for DoubleValues because the ArcSDE does
Tim Englich <tim.englich@intevation.de>
parents: 271
diff changeset
302 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
303
278
095486545edf Made some ChangeLog entries a bit clearer.
Hans Plum <hans.plum@intevation.de>
parents: 277
diff changeset
304 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
305
272
05912f0304ac Added Integer-Support for DoubleValues because the ArcSDE does
Tim Englich <tim.englich@intevation.de>
parents: 271
diff changeset
306 * 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
307 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
308 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
309
271
8aad9d098b08 Integrated Patch of issue57 to get some Memoryusage-improvements
Tim Englich <tim.englich@intevation.de>
parents: 270
diff changeset
310 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
311
278
095486545edf Made some ChangeLog entries a bit clearer.
Hans Plum <hans.plum@intevation.de>
parents: 277
diff changeset
312 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
313
271
8aad9d098b08 Integrated Patch of issue57 to get some Memoryusage-improvements
Tim Englich <tim.englich@intevation.de>
parents: 270
diff changeset
314 * 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
315 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
316 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
317 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
318 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
319 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
320
270
1fe93e3c80c0 DefaultResult now directly inherits from HashMap.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 269
diff changeset
321 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
322
1fe93e3c80c0 DefaultResult now directly inherits from HashMap.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 269
diff changeset
323 * 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
324 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
325 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
326
1fe93e3c80c0 DefaultResult now directly inherits from HashMap.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 269
diff changeset
327 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
328 Use array with index instead.
1fe93e3c80c0 DefaultResult now directly inherits from HashMap.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 269
diff changeset
329
269
db8920c5346d Added further Queries for Testing Spatial-Query-Support
Tim Englich <tim.englich@intevation.de>
parents: 268
diff changeset
330 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
331
db8920c5346d Added further Queries for Testing Spatial-Query-Support
Tim Englich <tim.englich@intevation.de>
parents: 268
diff changeset
332 * 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
333 src/test/ressources/QueryExecutorTestCase.properties:
db8920c5346d Added further Queries for Testing Spatial-Query-Support
Tim Englich <tim.englich@intevation.de>
parents: 268
diff changeset
334 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
335
267
000e00592ba5 Added InnerJoin, Order By and Group By Support to Spatial-Queries
Tim Englich <tim.englich@intevation.de>
parents: 266
diff changeset
336 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
337
268
71b2f263f036 Add WKT-Syntaxt to Shape ReturnValue
Tim Englich <tim.englich@intevation.de>
parents: 267
diff changeset
338 * 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
339 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
340 * 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
341 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
342 * 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
343 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
344 * 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
345 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
346
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
347 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
348
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
349 * 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
350 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
351 * 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
352 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
353 * 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
354 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
355
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 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
357
095486545edf Made some ChangeLog entries a bit clearer.
Hans Plum <hans.plum@intevation.de>
parents: 277
diff changeset
358 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
359
265
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
360 * 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
361 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
362 * 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
363 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
364 maxWait, maxIdle, minIdle, testOnBorrow, testOnReturn, testWhileIdle, numTestsPerEvictionRun,
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
365 timeBetweenEvictionRunsMillis, testWhileIdle
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
366 * src/test/ressources/ArcSDEConnectionPoolTestCase.properties:
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
367 Added som Configurationproperties for testing.
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
368
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
369
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
370 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
371 * 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
372 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
373 * src/test/ressources/QueryExecutorTestCase.properties:
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
374 Added SFS-Conformal Query
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
375 * pom.xml:
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
376 Added dependency to JTS 1.9
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
377 * 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
378 Added Spatial-Query-Support for ArcSDE
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
379 * 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
380 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
381 * 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
382 Added String-Support for GeometryObjects
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
383
144
fcfa9d2de572 RELEASE 0.1
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 143
diff changeset
384 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
385
fcfa9d2de572 RELEASE 0.1
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 143
diff changeset
386 RELEASE 0.1
fcfa9d2de572 RELEASE 0.1
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 143
diff changeset
387
fcfa9d2de572 RELEASE 0.1
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 143
diff changeset
388 * Changes, NEWS: Summarized changes.
fcfa9d2de572 RELEASE 0.1
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 143
diff changeset
389
143
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
390 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
391
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
392 * 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
393
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
394 * 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
395 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
396 Removed needless imports.
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 * 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
399
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
400 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
401
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
402 * 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
403 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
404 Dateformats.
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
405
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
406 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
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/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
409 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
410 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
411 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
412 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
413
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
414 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
415
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/DefaultResult.java:
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
417 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
418 * 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
419 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
420 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
421 * 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
422 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
423
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
424 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
425
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
426 * 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
427 . 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
428 * 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
429 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
430
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
431 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
432
270
1fe93e3c80c0 DefaultResult now directly inherits from HashMap.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 269
diff changeset
433 * pom.xml:
http://dive4elements.wald.intevation.org