--- a/geo-backend/src/test/java/de/intevation/gnv/geobackend/base/query/ToCharSample.java	Fri Mar 26 15:23:03 2010 +0000
+++ b/geo-backend/src/test/java/de/intevation/gnv/geobackend/base/query/ToCharSample.java	Mon Mar 29 07:49:16 2010 +0000
@@ -15,22 +15,22 @@
 
 public class ToCharSample {
 
-    
+
     public boolean executeQuery(SeConnection con, String[] pLayername,
                                    String pSpatialColumnName, String pWhere,
                                    SDEPoint[] g, String[] pReturnFields, String byClause) {
-       
+
         try {
             // get the layer for querying
-           
+
             SeShapeFilter[] filters  = null;
             if (g != null){
                 SeLayer lLayer = new SeLayer(con, pLayername[0], pSpatialColumnName);
                 SeShape shape = new SeShape();
                 shape.setCoordRef(lLayer.getCoordRef());
-                
-                
-    
+
+
+
                 shape.generatePolygon(g.length, 1, null, g);
                 SeShapeFilter filter = new SeShapeFilter(pLayername[0],
                         pSpatialColumnName, shape, SeFilter.METHOD_AI);
@@ -41,14 +41,14 @@
             SeQuery spatialQuery = null;
             SeSqlConstruct sqlCons = new SeSqlConstruct(pLayername, pWhere);
             spatialQuery = new SeQuery(con);
-            
+
             SeQueryInfo queryInfo = new SeQueryInfo();
             queryInfo.setColumns(pReturnFields);
-            
+
             if (byClause != null){
                 queryInfo.setByClause(byClause);
             }
-            
+
             queryInfo.setConstruct(sqlCons);
             spatialQuery.prepareQueryInfo(queryInfo);
 
@@ -68,36 +68,36 @@
                 if (lCount == 0) {
                     // analyze cols of result set
                     SeColumnDefinition[] lCols = row.getColumns();
-                    
+
                 }
                 short lNumCols = row.getNumColumns();
-                
+
                 for (int i = 0; i < lNumCols; i++) {
                     System.out.println(row.getObject(i));
                 }
-                
+
             }
             spatialQuery.close();
             return true;
-        } catch (Exception e){ 
+        } catch (Exception e){
                 e.printStackTrace();
                 return false;
         }
-        
+
     }
-    
-    
+
+
     /**
      * @param args
      */
     public static void main(String[] args) {
-        
+
         try {
 
             String[] layerNames = new String[] { "MEDIAN.TRACK" };
             String spatialColumnName = "SHAPE";
             String where = "MEDIAN.TRACK.CRUISEID = 47";
-            String[] returnFields = new String[] { "MEDIAN.TRACK.TRACKID KEY", 
+            String[] returnFields = new String[] { "MEDIAN.TRACK.TRACKID KEY",
                                                    "to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| NAME VALUE",
                                                    "NAME" };
             String byClause = "ORDER BY STARTDATE, ENDDATE, NAME";
@@ -113,13 +113,13 @@
             String database = "";
             String username = "";
             String credentials = "";
-            
-            SeConnection con = new SeConnection(server, port, 
+
+            SeConnection con = new SeConnection(server, port,
                                                 database, username,
                                                 credentials);
             boolean success = new ToCharSample().executeQuery(con, layerNames, spatialColumnName,
                                              where, g, returnFields, byClause);
-            
+
             if (success){
                 System.out.println("Terminated successful.");
             }else{