Mercurial > dive4elements > gnv-client

annotate geo-backend/src/test/java/de/intevation/gnv/geobackend/base/query/ToCharSample.java @ 554:0ee3c0ed40e4

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Added two Sample-Application demonstrating Bugs in the ArcSDE geo-backend/trunk@630 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Tue, 26 Jan 2010 13:55:55 +0000
parents
children 1c3efbd2fc5a
rev   line source
554
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
1 package de.intevation.gnv.geobackend.base.query;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
2
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
3 import com.esri.sde.sdk.client.SDEPoint;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
4 import com.esri.sde.sdk.client.SeColumnDefinition;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
5 import com.esri.sde.sdk.client.SeConnection;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
6 import com.esri.sde.sdk.client.SeException;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
7 import com.esri.sde.sdk.client.SeFilter;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
8 import com.esri.sde.sdk.client.SeLayer;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
9 import com.esri.sde.sdk.client.SeQuery;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
10 import com.esri.sde.sdk.client.SeQueryInfo;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
11 import com.esri.sde.sdk.client.SeRow;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
12 import com.esri.sde.sdk.client.SeShape;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
13 import com.esri.sde.sdk.client.SeShapeFilter;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
14 import com.esri.sde.sdk.client.SeSqlConstruct;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
15
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
16 public class ToCharSample {
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
17
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
18
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
19 public boolean executeQuery(SeConnection con, String[] pLayername,
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
20 String pSpatialColumnName, String pWhere,
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
21 SDEPoint[] g, String[] pReturnFields, String byClause) {
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
22
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
23 try {
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
24 // get the layer for querying
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
25
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
26 SeShapeFilter[] filters = null;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
27 if (g != null){
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
28 SeLayer lLayer = new SeLayer(con, pLayername[0], pSpatialColumnName);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
29 SeShape shape = new SeShape();
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
30 shape.setCoordRef(lLayer.getCoordRef());
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
31
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
32
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
33
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
34 shape.generatePolygon(g.length, 1, null, g);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
35 SeShapeFilter filter = new SeShapeFilter(pLayername[0],
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
36 pSpatialColumnName, shape, SeFilter.METHOD_AI);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
37 filters = new SeShapeFilter[1];
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
38 filters[0] = filter;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
39 }
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
40
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
41 SeQuery spatialQuery = null;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
42 SeSqlConstruct sqlCons = new SeSqlConstruct(pLayername, pWhere);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
43 spatialQuery = new SeQuery(con);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
44
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
45 SeQueryInfo queryInfo = new SeQueryInfo();
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
46 queryInfo.setColumns(pReturnFields);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
47
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
48 if (byClause != null){
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
49 queryInfo.setByClause(byClause);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
50 }
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
51
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
52 queryInfo.setConstruct(sqlCons);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
53 spatialQuery.prepareQueryInfo(queryInfo);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
54
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
55 /*
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
56 * Set spatial constraints
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
57 */
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
58 if (filters != null){
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
59 spatialQuery.setSpatialConstraints(SeQuery.SE_OPTIMIZE, false,
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
60 filters);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
61 }
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
62 spatialQuery.execute();
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
63
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
64 SeRow row;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
65 int lCount;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
66 for (lCount = 0; (row =spatialQuery.fetch()) != null; lCount++) {
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
67 // one time execution
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
68 if (lCount == 0) {
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
69 // analyze cols of result set
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
70 SeColumnDefinition[] lCols = row.getColumns();
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
71
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
72 }
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
73 short lNumCols = row.getNumColumns();
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
74
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
75 for (int i = 0; i < lNumCols; i++) {
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
76 System.out.println(row.getObject(i));
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
77 }
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
78
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
79 }
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
80 spatialQuery.close();
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
81 return true;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
82 } catch (Exception e){
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
83 e.printStackTrace();
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
84 return false;
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
85 }
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
86
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
87 }
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
88
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
89
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
90 /**
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
91 * @param args
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
92 */
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
93 public static void main(String[] args) {
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
94
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
95 try {
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
96
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
97 String[] layerNames = new String[] { "MEDIAN.TRACK" };
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
98 String spatialColumnName = "SHAPE";
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
99 String where = "MEDIAN.TRACK.CRUISEID = 47";
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
100 String[] returnFields = new String[] { "MEDIAN.TRACK.TRACKID KEY",
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
101 "to_char(STARTDATE,'DD.MM.YYYY HH24:MI') || ' - '|| to_char(ENDDATE,'DD.MM.YYYY HH24:MI') || ' - '|| NAME VALUE",
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
102 "NAME" };
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
103 String byClause = "ORDER BY STARTDATE, ENDDATE, NAME";
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
104 SDEPoint[] g = new SDEPoint[5];
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
105 g[0] = new SDEPoint(52, 8);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
106 g[1] = new SDEPoint(52, 9);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
107 g[2] = new SDEPoint(53, 9);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
108 g[3] = new SDEPoint(53, 8);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
109 g[4] = new SDEPoint(52, 8);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
110
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
111 String server = "";
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
112 String port = "";
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
113 String database = "";
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
114 String username = "";
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
115 String credentials = "";
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
116
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
117 SeConnection con = new SeConnection(server, port,
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
118 database, username,
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
119 credentials);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
120 boolean success = new ToCharSample().executeQuery(con, layerNames, spatialColumnName,
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
121 where, g, returnFields, byClause);
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
122
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
123 if (success){
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
124 System.out.println("Terminated successful.");
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
125 }else{
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
126 System.out.println("Terminated with an Exception.");
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
127 }
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
128 } catch (SeException e) {
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
129 e.printStackTrace();
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
130 }
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
131 }
0ee3c0ed40e4 Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
132 }
http://dive4elements.wald.intevation.org