Mercurial > dive4elements > gnv-client
view geo-backend/ChangeLog @ 275:9063c5fcebf7
Added the possibility to use Innerselects in SpatialQueries
geo-backend/trunk@286 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Tim Englich <tim.englich@intevation.de> |
---|---|
date | Thu, 05 Nov 2009 15:03:51 +0000 |
parents | ff1b7967e6b9 |
children | 6503bc864017 |
line wrap: on
line source
2009-11-05 Tim Englich <tim.englich@intevation.de> * src/test/ressources/QueryExecutorTestCase.properties, src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java (testSpatialQueryWithInnerSelect): Added an Tescase to test the InnerSelect Statments in Spatial-Queries. * src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java (getPosValue): Bugfix. An Point could not have an Z-Coordinate-Value * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java (executeQuery): Added the possibility to execute Spatial-Queries using InnerStatements instead of WKT in Intersects-where-clauses. 2009-11-02 Tim Englich <tim.englich@intevation.de> * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEConnection.java (createStatement): Changed TODO to a question * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java (executeQuery): CodeCleanup: Removed deprecated TODO * src/main/java/de/intevation/gnv/geobackend/sde/datasources/SDEResultSet.java (getColumnIndex): Removed Typo. * src/main/java/de/intevation/gnv/geobackend/sde/connectionpool/ArcSDEPoolableObjectFactory.java: CodeCleanup: Removed deprecated TODOS and replace Tabs with whitespaces. * src/main/java/de/intevation/gnv/geobackend/base/query/container/DefaultQueryContainer.java:, src/main/java/de/intevation/gnv/geobackend/base/query/container/QueryContainer.java: CodeCleanup: Removed unused Method getQueryIds * src/main/java/de/intevation/gnv/geobackend/sde/connectionpool/ArcSDEConnectionPool.java (closeConnection): CodeCleanup: Inspect TODO and ansewerd the Question that the Connection has not to be closed at that position but perhaps insite the ConnectionPool. 2009-10-30 Tim Englich <tim.englich@intevation.de> * src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java (getPosValue): Added Support for Polygons without interior Rings. This is required for generating Horizontal Cross-Section Outputs. The Z-Value of an Point was also added to the WKT-Represantation. 2009-10-29 Tim Englich <tim.englich@intevation.de> * src/main/java/de/intevation/gnv/geobackend/base/DefaultResult.java (getInteger): Added Integer-Support for DoubleValues because the ArcSDE does not read values like -1 as Integer-values. issue45 2009-10-20 Tim Englich <tim.englich@intevation.de> * src/main/java/de/intevation/gnv/geobackend/base/query/QueryExecutorBase.java (QueryExecutorBase), src/main/java/de/intevation/gnv/geobackend/base/ResultDescriptor.java (getColumnClassName), src/main/java/de/intevation/gnv/geobackend/base/Result.java, src/main/java/de/intevation/gnv/geobackend/base/DefaultResultDescriptor.java (serialVersionUID), src/main/java/de/intevation/gnv/geobackend/base/DefaultResult.java (getDate): Integrated Patch of issue57 to get some Memoryusage-improvements 2009-10-19 Sascha L. Teichmann <sascha.teichmann@intevation.de> * src/main/java/de/intevation/gnv/geobackend/base/DefaultResult.java: Extends from HashMap directly to avoid one level of indirection and do not create so much needless objects. TODO: The representation in form of HashMaps is not very efficent! Use array with index instead. 2009-10-14 Tim Englich <tim.englich@intevation.de> * src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java (testSpatialQueryWithoutIntersects), src/test/ressources/QueryExecutorTestCase.properties: Added further Queries for Testing Spatial-Query-Support 2009-10-14 Tim Englich <tim.englich@intevation.de> * src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java (getPosValue): Add WKT-Syntaxt to Shape ReturnValue * src/test/ressources/QueryExecutorTestCase.properties: Changed Test-Query-Statement for Spatial-Queries with INNERJOINS and ORDER BY * src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java (testSpatialQueryWithoutIntersects): Changed expected Result-Size because of Changes in the QueryStatement which is used. * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java (executeQuery): Added INNERJOIN, ORDER BY and GROUP BY support to Spatial Queries 2009-10-13 Tim Englich <tim.englich@intevation.de> * src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java (testSpatialQueryWithoutIntersects): Added an TaesCase for Querying spatial Data without an spatial restriction * src/test/ressources/QueryExecutorTestCase.properties: Added TestQuery with no spatial restriction * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java (executeQuery): Now it is possible to send spatial Quieries without an spatial restriction in the where clause. 2009-10-13 Tim Englich <tim.englich@intevation.de> * src/main/java/de/intevation/gnv/geobackend/sde/connectionpool/ArcSDEPoolableObjectFactory.java (validateObject) Edited: Added Tests if the Object is Closed. And add propper instance Tests * src/main/java/de/intevation/gnv/geobackend/sde/connectionpool/ArcSDEConnectionPool.java (initialize): Added further ConfigurationParameters that could be set in the *.properties-File. maxWait, maxIdle, minIdle, testOnBorrow, testOnReturn, testWhileIdle, numTestsPerEvictionRun, timeBetweenEvictionRunsMillis, testWhileIdle * src/test/ressources/ArcSDEConnectionPoolTestCase.properties: Added som Configurationproperties for testing. Issue-34 2009-10-13 Tim Englich <tim.englich@intevation.de> * src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java (QueryExecutorTestCase): Changed expected Result of Spatial-Query-TestCase because of Changes to the used Query * src/test/ressources/QueryExecutorTestCase.properties: Added SFS-Conformal Query * pom.xml: Added dependency to JTS 1.9 * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java (executeQuery): Added Spatial-Query-Support for ArcSDE * src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEUtils.java (createPoints): Switched Method Signature to JTS-Geometry-Support * src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java (getStringValue): Added String-Support for GeometryObjects 2009-10-07 Sascha L. Teichmann <sascha.teichmann@intevation.de> RELEASE 0.1 * Changes, NEWS: Summarized changes. 2009-10-06 Sascha L. Teichmann <sascha.teichmann@intevation.de> * Changelog -> ChangeLog: Renamed to make eclipse happy. Unified changelog style. * src/main/java/de/intevation/gnv/geobackend/sde/datasources/SDEQuery.java, src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java: Removed needless imports. * pom.xml: xmllint-ed 2009-09-29 Tim Englich <tim.englich@intevation.de> * src/main/java/de/intevation/gnv/geobackend/util/DateUtils.java (DATE_PATTERN) Edited: Make the Constants assessible for other Parts of the Project to reduce the TouchPoints for Dateformats. 2009-09-24 Tim Englich <tim.englich@intevation.de> * src/main/java/de/intevation/gnv/geobackend/base/ResultDescriptor.java Edited, src/main/java/de/intevation/gnv/geobackend/base/Result.java Edited, src/main/java/de/intevation/gnv/geobackend/base/DefaultResultDescriptor.java Edited, src/main/java/de/intevation/gnv/geobackend/base/DefaultResult.java Edited: Make Classes Serializable for Storing in ArtifactDatabase 2009-09-21 Tim Englich <tim.englich@intevation.de> * src/main/java/de/intevation/gnv/geobackend/base/DefaultResult.java: Added formatted Date Handling in getString Method * src/test/ressources/QueryExecutorTestCase.properties Edited, src/test/java/de/intevation/gnv/geobackend/base/query/QueryExecutorTestCase.java Edited: Some tests for Spatialqueries added * src/main/java/de/intevation/gnv/geobackend/base/query/DefaultQueryExceutor.java Edited: Put the final Querystring into a Logmessage 2009-09-09 Tim Englich <tim.englich@intevation.de> * src/main/java/de/intevation/gnv/geobackend/base/DefaultResult.java (getDate): . Intance Check for DateValues * src/main/java/de/intevation/gnv/geobackend/sde/datasources/SDEResultSet.java (next): Logging removed because the performance slowdown fetching many ResultSets 2009-09-04 Tim Englich <tim.englich@intevation.de> * pom.xml: