Mercurial > dive4elements > gnv-client
annotate geo-backend/src/test/java/de/intevation/gnv/geobackend/base/query/GroupBySample.java @ 1127:ebeb56428409
Added license headers and license file.
geo-backend/trunk@1261 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author | Ingo Weinzierl <ingo.weinzierl@intevation.de> |
---|---|
date | Tue, 02 Nov 2010 17:52:22 +0000 |
parents | 1c3efbd2fc5a |
children |
rev | line source |
---|---|
1127
ebeb56428409
Added license headers and license file.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
885
diff
changeset
|
1 /* |
ebeb56428409
Added license headers and license file.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
885
diff
changeset
|
2 * Copyright (c) 2010 by Intevation GmbH |
ebeb56428409
Added license headers and license file.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
885
diff
changeset
|
3 * |
ebeb56428409
Added license headers and license file.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
885
diff
changeset
|
4 * This program is free software under the LGPL (>=v2.1) |
ebeb56428409
Added license headers and license file.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
885
diff
changeset
|
5 * Read the file LGPL.txt coming with the software for details |
ebeb56428409
Added license headers and license file.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
885
diff
changeset
|
6 * or visit http://www.gnu.org/licenses/ if it does not exist. |
ebeb56428409
Added license headers and license file.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
885
diff
changeset
|
7 */ |
ebeb56428409
Added license headers and license file.
Ingo Weinzierl <ingo.weinzierl@intevation.de>
parents:
885
diff
changeset
|
8 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
9 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
|
10 |
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.SDEPoint; |
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.SeColumnDefinition; |
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.SeConnection; |
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.SeException; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
15 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
|
16 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
|
17 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
|
18 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
|
19 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
|
20 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
|
21 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
|
22 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
|
23 |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
24 public class GroupBySample { |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
25 |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
26 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
27 public void executeQuery(SeConnection con, String[] pLayername, |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
28 String pSpatialColumnName, String pWhere, |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
29 SDEPoint[] g, String[] pReturnFields, String byClause) { |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
30 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
31 try { |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
32 // get the layer for querying |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
33 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
34 SeShapeFilter[] filters = null; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
35 if (g != null){ |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
36 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
|
37 SeShape shape = new SeShape(); |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
38 shape.setCoordRef(lLayer.getCoordRef()); |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
39 |
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
40 |
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
41 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
42 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
|
43 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
|
44 pSpatialColumnName, shape, SeFilter.METHOD_AI); |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
45 filters = new SeShapeFilter[1]; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
46 filters[0] = filter; |
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 |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
49 SeQuery spatialQuery = null; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
50 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
|
51 spatialQuery = new SeQuery(con); |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
52 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
53 SeQueryInfo queryInfo = new SeQueryInfo(); |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
54 queryInfo.setColumns(pReturnFields); |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
55 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
56 if (byClause != null){ |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
57 queryInfo.setByClause(byClause); |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
58 } |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
59 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
60 queryInfo.setConstruct(sqlCons); |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
61 spatialQuery.prepareQueryInfo(queryInfo); |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
62 |
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 * Set spatial constraints |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
65 */ |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
66 if (filters != null){ |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
67 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
|
68 filters); |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
69 } |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
70 spatialQuery.execute(); |
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 SeRow row; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
73 int lCount; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
74 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
|
75 // one time execution |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
76 if (lCount == 0) { |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
77 // analyze cols of result set |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
78 SeColumnDefinition[] lCols = row.getColumns(); |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
79 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
80 } |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
81 short lNumCols = row.getNumColumns(); |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
82 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
83 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
|
84 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
|
85 } |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
86 |
554
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 spatialQuery.close(); |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
89 |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
90 } catch (Exception e){ |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
91 e.printStackTrace(); |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
92 } |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
93 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
94 } |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
95 |
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
96 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
97 /** |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
98 * @param args |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
99 */ |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
100 public static void main(String[] args) { |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
101 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
102 try { |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
103 String[] layerNames = new String[] { "median.meshpoint", "median.mesh" }; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
104 String spatialColumnName = "SHAPE"; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
105 String where = "median.meshpoint.meshid = median.mesh.meshid"; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
106 String[] returnFields = new String[] { "sourceid" }; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
107 String byClause = "group by sourceid"; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
108 SDEPoint[] g = new SDEPoint[5]; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
109 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
|
110 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
|
111 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
|
112 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
|
113 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
|
114 |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
115 String server = ""; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
116 String port = ""; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
117 String database = ""; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
118 String username = ""; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
119 String credentials = ""; |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
120 SeConnection con = new SeConnection(server, port, |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
121 database, username, |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
122 credentials); |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
123 new GroupBySample().executeQuery(con, layerNames, spatialColumnName, |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
124 where, g, returnFields, byClause); |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
125 |
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
126 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
127 } catch (SeException e) { |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
128 e.printStackTrace(); |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
129 } |
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 } |