Mercurial > dive4elements > gnv-client

annotate geo-backend/ChangeLog @ 267:000e00592ba5

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added InnerJoin, Order By and Group By Support to Spatial-Queries geo-backend/trunk@217 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Wed, 14 Oct 2009 09:28:18 +0000
parents 1530890b28c9
children 71b2f263f036
rev   line source
267
000e00592ba5 Added InnerJoin, Order By and Group By Support to Spatial-Queries
Tim Englich <tim.englich@intevation.de>
parents: 266
diff changeset
1 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
2
000e00592ba5 Added InnerJoin, Order By and Group By Support to Spatial-Queries
Tim Englich <tim.englich@intevation.de>
parents: 266
diff changeset
3 * 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
4 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
5 * 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
6 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
7 * 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
8 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
9
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
10 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
11
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
12 * 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
13 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
14 * 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
15 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
16 * 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
17 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
18
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
19 2009-10-13 Tim Englich <tim.englich@intevation.de>
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
20
265
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
21 * 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
22 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
23 * 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
24 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
25 maxWait, maxIdle, minIdle, testOnBorrow, testOnReturn, testWhileIdle, numTestsPerEvictionRun,
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
26 timeBetweenEvictionRunsMillis, testWhileIdle
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
27 * src/test/ressources/ArcSDEConnectionPoolTestCase.properties:
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
28 Added som Configurationproperties for testing.
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
29
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
30 Issue-34
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
31
e5379e129799 Fixed issue 34
Tim Englich <tim.englich@intevation.de>
parents: 264
diff changeset
32 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
33 * 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
34 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
35 * src/test/ressources/QueryExecutorTestCase.properties:
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
36 Added SFS-Conformal Query
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
37 * pom.xml:
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
38 Added dependency to JTS 1.9
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
39 * 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
40 Added Spatial-Query-Support for ArcSDE
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
41 * 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
42 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
43 * 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
44 Added String-Support for GeometryObjects
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
45
144
fcfa9d2de572 RELEASE 0.1
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 143
diff changeset
46 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
47
fcfa9d2de572 RELEASE 0.1
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 143
diff changeset
48 RELEASE 0.1
fcfa9d2de572 RELEASE 0.1
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 143
diff changeset
49
fcfa9d2de572 RELEASE 0.1
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 143
diff changeset
50 * Changes, NEWS: Summarized changes.
fcfa9d2de572 RELEASE 0.1
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents: 143
diff changeset
51
143
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
52 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
53
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
54 * 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
55
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
56 * 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
57 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
58 Removed needless imports.
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
59
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
60 * 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
61
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
62 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
63
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
64 * 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
65 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
66 Dateformats.
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
67
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
68 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
69
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
70 * 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
71 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
72 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
73 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
74 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
75
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
76 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
77
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
78 * 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
79 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
80 * 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
81 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
82 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
83 * 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
84 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
85
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
86 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
87
122fdc9da5f0 Unified changelog, removed some needless imports. xmllint-ed pom.xml
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
diff changeset
88 * 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
89 . 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
90 * 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
91 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
92
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
93 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
94
263
031ef9649cd1 Added SFS-Support to ArcSDE-Query-Part
Tim Englich <tim.englich@intevation.de>
parents: 144
diff changeset
95 * pom.xml:
http://dive4elements.wald.intevation.org