# HG changeset patch # User Tim Englich # Date 1262961608 0 # Node ID 210716612c3015b1308324c8f726c85576e2092a # Parent 347c8446747816eafa5c1daec6fe2dcf8a2c71c7 Removed Encodingerrors from listed Files. All Files are now UTF-8 compliant. geo-backend/trunk@517 c6561f87-3c4e-4783-a992-168aeb5c3f6f diff -r 347c84467478 -r 210716612c30 geo-backend/ChangeLog --- a/geo-backend/ChangeLog Tue Jan 05 15:08:01 2010 +0000 +++ b/geo-backend/ChangeLog Fri Jan 08 14:40:08 2010 +0000 @@ -1,3 +1,12 @@ +2010-01-08 Tim Englich + + * src/main/java/de/intevation/gnv/geobackend/sde/datasources/SDEQuery.java, + src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java, + src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java, + src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEConnection.java, + src/main/java/de/intevation/gnv/geobackend/base/connectionpool/ConnectionPoolFactory.java (initializeConnectionPool): + Removed Encodingerrors from listed Files. All Files are now UTF-8 compliant. + 2010-01-05 Tim Englich * src/main/java/de/intevation/gnv/geobackend/sde/datasources/RasterObject.java: diff -r 347c84467478 -r 210716612c30 geo-backend/src/main/java/de/intevation/gnv/geobackend/base/connectionpool/ConnectionPoolFactory.java --- a/geo-backend/src/main/java/de/intevation/gnv/geobackend/base/connectionpool/ConnectionPoolFactory.java Tue Jan 05 15:08:01 2010 +0000 +++ b/geo-backend/src/main/java/de/intevation/gnv/geobackend/base/connectionpool/ConnectionPoolFactory.java Fri Jan 08 14:40:08 2010 +0000 @@ -67,7 +67,7 @@ public void initializeConnectionPool(Properties properties){ log.debug("ConnectionPoolFactory.initializeConnectionPool"); if (this.connectionPool == null){ - //TODO: Hier könnte anhand eines Flags die Instanz des Connectionpools umgeschaltet werden. + //TODO: Here it might be possible to switch the ConnectionPoolInstance using a FLAG. this.connectionPool = new ArcSDEConnectionPool(); this.connectionPool.initialize(properties); }else{ diff -r 347c84467478 -r 210716612c30 geo-backend/src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEConnection.java --- a/geo-backend/src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEConnection.java Tue Jan 05 15:08:01 2010 +0000 +++ b/geo-backend/src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEConnection.java Fri Jan 08 14:40:08 2010 +0000 @@ -99,7 +99,6 @@ */ public Statement createStatement(int resultSetType, int resultSetConcurrency) throws SQLException { - // TODO: Übergabeparameter beachten ? return new ArcSDEStatement(this); } @@ -109,7 +108,6 @@ public Statement createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) throws SQLException { - // TODO: Übergabeparameter beachten? return new ArcSDEStatement(this); } diff -r 347c84467478 -r 210716612c30 geo-backend/src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java --- a/geo-backend/src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java Tue Jan 05 15:08:01 2010 +0000 +++ b/geo-backend/src/main/java/de/intevation/gnv/geobackend/sde/datasources/ArcSDEStatement.java Fri Jan 08 14:40:08 2010 +0000 @@ -169,20 +169,20 @@ int pos = where.indexOf("intersects"); if (pos >= 0 ){ String substr = where.substring(pos); - where = where.substring(0,where.lastIndexOf("intersects")); // TODO auch or unterstützen + where = where.substring(0,where.lastIndexOf("intersects")); int andPos = where.lastIndexOf("and"); if (andPos < 0){ andPos = 0; } - where = where.substring(0,andPos); // TODO auch or unterstützen - String intersectsStmt = substr.substring(0, substr.lastIndexOf(")")); // Annahme räumliches Stmt steht am Ende + where = where.substring(0,andPos); // TODO support or also + String intersectsStmt = substr.substring(0, substr.lastIndexOf(")")); // Spatial-Statment is the last one String wkt = null; if (intersectsStmt.contains("select")){ // Anstelle eines WKT ist ein InnerSelect zum Bestimmen der Comparatorgeometrie gegeben. String stmt = intersectsStmt.substring(intersectsStmt.indexOf("select"),intersectsStmt.lastIndexOf(")")); ResultSet resultSet = this.executeQuery(stmt); if (resultSet != null && resultSet.next()){ - // TODO Selektion von mehreren Geometrien unterstützen. + // TODO: Support the selection of more than one Geometry wkt = resultSet.getString("SHAPE"); } }else{ diff -r 347c84467478 -r 210716612c30 geo-backend/src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java --- a/geo-backend/src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java Tue Jan 05 15:08:01 2010 +0000 +++ b/geo-backend/src/main/java/de/intevation/gnv/geobackend/sde/datasources/Row.java Fri Jan 08 14:40:08 2010 +0000 @@ -285,7 +285,7 @@ } } returnValue.append(")"); - // TODO Wie werden innere Ringe unterstützt. + // TODO How are Rings supported // for (int i =1 ; i < aList.size(); i++){ // returnValue.append("("); // mPoint = (SDEPoint[])aList.get(i); diff -r 347c84467478 -r 210716612c30 geo-backend/src/main/java/de/intevation/gnv/geobackend/sde/datasources/SDEQuery.java --- a/geo-backend/src/main/java/de/intevation/gnv/geobackend/sde/datasources/SDEQuery.java Tue Jan 05 15:08:01 2010 +0000 +++ b/geo-backend/src/main/java/de/intevation/gnv/geobackend/sde/datasources/SDEQuery.java Fri Jan 08 14:40:08 2010 +0000 @@ -196,34 +196,7 @@ Connection con = null; try { con = getConnection(); -// // get the layer for querying -// SeLayer lLayer = new SeLayer(con, pLayername, pSpatialColumnName); -// SeCoordinateReference cref = lLayer.getCoordRef(); -// -// -// SeShape shape = new SeShape(); -// shape.setCoordRef(lLayer.getCoordRef()); -// SDEPoint[] lPoints = ArcSDEUtils.createPoints(pPoints); -// -// /* -// * int numPts, int numParts, int[] partOffsets,SDEPoint[] ptArray -// * */ -// shape.generatePolygon(lPoints.length, 1, null, lPoints); -// SeShapeFilter filter = new SeShapeFilter(pLayername, pSpatialColumnName, shape, SeFilter.METHOD_AI); -// SeShapeFilter[] filters = new SeShapeFilter[1]; -// filters[0] = filter; -// -// SeQuery spatialQuery = null; -// SeSqlConstruct sqlCons = new SeSqlConstruct(pLayername); -// spatialQuery = new SeQuery(con, pReturnFields, sqlCons); -// spatialQuery.prepareQuery(); -// /* -// * Set spatial constraints -// */ -// spatialQuery.setSpatialConstraints(SeQuery.SE_OPTIMIZE, false, filters); -// spatialQuery.execute(); - - return null;//handleResultSet(spatialQuery); + return null; } catch (TechnicalException e) { sLogger.error(e.getMessage(), e); @@ -253,34 +226,7 @@ Connection con = null; try { con = getConnection(); -// // get the layer for querying -// SeLayer lLayer = new SeLayer(con, pLayername, pSpatialColumnName); -// SeCoordinateReference cref = lLayer.getCoordRef(); -// -// -// SeShape shape = new SeShape(); -// shape.setCoordRef(lLayer.getCoordRef()); -// SDEPoint[] lPoints = ArcSDEUtils.createPoints(pPoints); -// -// /* -// * int numPts, int numParts, int[] partOffsets,SDEPoint[] ptArray -// * */ -// shape.generatePolygon(lPoints.length, 1, null, lPoints); -// SeShapeFilter filter = new SeShapeFilter(pLayername, pSpatialColumnName, shape, SeFilter.METHOD_AI); -// SeShapeFilter[] filters = new SeShapeFilter[1]; -// filters[0] = filter; -// -// SeQuery spatialQuery = null; -// SeSqlConstruct sqlCons = new SeSqlConstruct(pLayername,pWhere); -// spatialQuery = new SeQuery(con, pReturnFields, sqlCons); -// spatialQuery.prepareQuery(); -// /* -// * Set spatial constraints -// */ -// spatialQuery.setSpatialConstraints(SeQuery.SE_OPTIMIZE, false, filters); -// spatialQuery.execute(); - - return null;//handleResultSet(spatialQuery); + return null; } catch (TechnicalException e) { sLogger.error(e.getMessage(), e);