Mercurial > dive4elements > gnv-client
annotate geo-backend/src/test/java/de/intevation/gnv/geobackend/base/query/ToCharSample.java @ 1145:dfe1ac687c7f tip
added tags
author | Thomas Arendsen Hein <thomas@intevation.de> |
---|---|
date | Fri, 28 Sep 2012 12:16:15 +0200 |
parents | ebeb56428409 |
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 ToCharSample { |
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 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
|
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 return true; |
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 return false; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
93 } |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
94 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
95 } |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
96 |
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
97 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
98 /** |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
99 * @param args |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
100 */ |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
101 public static void main(String[] args) { |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
102 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
103 try { |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
104 |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
105 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
|
106 String spatialColumnName = "SHAPE"; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
107 String where = "MEDIAN.TRACK.CRUISEID = 47"; |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
108 String[] returnFields = new String[] { "MEDIAN.TRACK.TRACKID KEY", |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
109 "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
|
110 "NAME" }; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
111 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
|
112 SDEPoint[] g = new SDEPoint[5]; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
113 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
|
114 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
|
115 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
|
116 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
|
117 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
|
118 |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
119 String server = ""; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
120 String port = ""; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
121 String database = ""; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
122 String username = ""; |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
123 String credentials = ""; |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
124 |
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
125 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
|
126 database, username, |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
127 credentials); |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
128 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
|
129 where, g, returnFields, byClause); |
885
1c3efbd2fc5a
Removes trailing whitespace.
Sascha L. Teichmann <sascha.teichmann@intevation.de>
parents:
554
diff
changeset
|
130 |
554
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
131 if (success){ |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
132 System.out.println("Terminated successful."); |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
133 }else{ |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
134 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
|
135 } |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
136 } catch (SeException e) { |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
137 e.printStackTrace(); |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
138 } |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
139 } |
0ee3c0ed40e4
Added two Sample-Application demonstrating Bugs in the ArcSDE
Tim Englich <tim.englich@intevation.de>
parents:
diff
changeset
|
140 } |