Revision 11197 branches/v10/extensions/extSDE/src/com/iver/cit/gvsig/fmap/drivers/sde/ArcSdeWriter.java
ArcSdeWriter.java | ||
---|---|---|
1 | 1 |
package com.iver.cit.gvsig.fmap.drivers.sde; |
2 | 2 |
|
3 | 3 |
import java.io.IOException; |
4 |
import java.sql.SQLException; |
|
5 | 4 |
import java.sql.Types; |
6 | 5 |
import java.util.Calendar; |
7 | 6 |
import java.util.Date; |
... | ... | |
17 | 16 |
import com.esri.sde.sdk.client.SeRow; |
18 | 17 |
import com.esri.sde.sdk.client.SeShape; |
19 | 18 |
import com.esri.sde.sdk.client.SeUpdate; |
20 |
import com.hardcode.gdbms.engine.data.driver.DriverException; |
|
21 | 19 |
import com.iver.cit.gvsig.fmap.core.FShape; |
22 | 20 |
import com.iver.cit.gvsig.fmap.core.IFeature; |
23 | 21 |
import com.iver.cit.gvsig.fmap.core.IGeometry; |
24 | 22 |
import com.iver.cit.gvsig.fmap.drivers.FieldDescription; |
25 | 23 |
import com.iver.cit.gvsig.fmap.drivers.ITableDefinition; |
26 |
import com.iver.cit.gvsig.fmap.drivers.sde.utils.SDELayerDefinition; |
|
27 | 24 |
import com.iver.cit.gvsig.fmap.edition.EditionException; |
28 | 25 |
import com.iver.cit.gvsig.fmap.edition.IFieldManager; |
29 | 26 |
import com.iver.cit.gvsig.fmap.edition.IRowEdited; |
30 | 27 |
import com.iver.cit.gvsig.fmap.edition.ISpatialWriter; |
31 | 28 |
import com.iver.cit.gvsig.fmap.edition.writers.AbstractWriter; |
32 | 29 |
|
33 |
public class ArcSdeWriter extends AbstractWriter implements ISpatialWriter, IFieldManager { |
|
34 | 30 |
|
35 |
private int numRows; |
|
31 |
/** |
|
32 |
* DOCUMENT ME! |
|
33 |
* |
|
34 |
* @author Vicente Caballero Navarro |
|
35 |
*/ |
|
36 |
public class ArcSdeWriter extends AbstractWriter implements ISpatialWriter, |
|
37 |
IFieldManager { |
|
38 |
private int numRows; |
|
39 |
private ArcSDELayerDefinition lyrDef; |
|
40 |
private SeConnection conex; |
|
36 | 41 |
|
37 |
private SDELayerDefinition lyrDef; |
|
42 |
//private Statement st; |
|
43 |
private boolean bCreateTable; |
|
44 |
private ArcSdeDriver driver; |
|
45 |
private SeLayer selayer; |
|
38 | 46 |
|
39 |
private SeConnection conex; |
|
47 |
//private ArcSde postGisSQL = new ArcSde(); |
|
48 |
// private double flatness; |
|
49 |
//private JdbcFieldManager fieldManager; |
|
40 | 50 |
|
41 |
//private Statement st; |
|
51 |
/** |
|
52 |
* Useful to create a layer from scratch Call setFile before using this |
|
53 |
* function |
|
54 |
* |
|
55 |
* @param lyrD |
|
56 |
* |
|
57 |
* @throws EditionException |
|
58 |
*/ |
|
59 |
public void initialize(ITableDefinition lyrD) throws EditionException { |
|
60 |
super.initialize(lyrD); |
|
61 |
this.lyrDef = (ArcSDELayerDefinition) lyrD; |
|
62 |
conex = (SeConnection) lyrDef.getConnection(); |
|
42 | 63 |
|
43 |
private boolean bCreateTable; |
|
64 |
// |
|
65 |
// try { |
|
66 |
// //st = conex.createStatement(); |
|
67 |
// |
|
68 |
// if (bCreateTable) { |
|
69 |
// try { |
|
70 |
// st.execute("DROP TABLE " + lyrDef.getTableName() + ";"); |
|
71 |
// } catch (SQLException e1) { |
|
72 |
// // Si no existe la tabla, no hay que borrarla. |
|
73 |
// } |
|
74 |
// |
|
75 |
// String sqlCreate = postGisSQL.getSqlCreateSpatialTable(lyrDef, |
|
76 |
// lyrDef.getFieldsDesc(), true); |
|
77 |
// System.out.println("sqlCreate =" + sqlCreate); |
|
78 |
// st.execute(sqlCreate); |
|
79 |
// |
|
80 |
// String sqlAlter = postGisSQL.getSqlAlterTable(lyrDef); |
|
81 |
// System.out.println("sqlAlter =" + sqlAlter); |
|
82 |
// st.execute(sqlAlter); |
|
83 |
// // CREATE TABLE PARKS ( PARK_ID int4, PARK_NAME varchar(128), |
|
84 |
// // PARK_DATE date, PARK_TYPE varchar(2) ); |
|
85 |
// // SELECT AddGeometryColumn('parks_db', 'parks', 'park_geom', |
|
86 |
// // 128, |
|
87 |
// // 'MULTIPOLYGON', 2 ); |
|
88 |
// |
|
89 |
// /* |
|
90 |
// * BEGIN; INSERT INTO ROADS_GEOM (ID,GEOM,NAME ) VALUES |
|
91 |
// * (1,GeometryFromText('LINESTRING(191232 243118,191108 |
|
92 |
// * 243242)',-1),'Jeff Rd'); INSERT INTO ROADS_GEOM (ID,GEOM,NAME ) |
|
93 |
// * VALUES (2,GeometryFromText('LINESTRING(189141 244158,189265 |
|
94 |
// * 244817)',-1),'Geordie Rd'); COMMIT; |
|
95 |
// */ |
|
96 |
// conex.commit(); |
|
97 |
// } |
|
98 |
// conex.setAutoCommit(false); |
|
99 |
// fieldManager = new JdbcFieldManager(conex, lyrDef.getTableName()); |
|
100 |
// |
|
101 |
// } catch (SQLException e) { |
|
102 |
// e.printStackTrace(); |
|
103 |
// throw new EditionException(e); |
|
104 |
// } |
|
105 |
} |
|
44 | 106 |
|
45 |
private ArcSdeDriver driver; |
|
107 |
/** |
|
108 |
* DOCUMENT ME! |
|
109 |
* |
|
110 |
* @throws EditionException DOCUMENT ME! |
|
111 |
*/ |
|
112 |
public void preProcess() throws EditionException { |
|
113 |
numRows = 0; |
|
46 | 114 |
|
47 |
private SeLayer selayer; |
|
48 |
|
|
49 |
//private ArcSde postGisSQL = new ArcSde(); |
|
50 |
// private double flatness; |
|
51 |
|
|
52 |
//private JdbcFieldManager fieldManager; |
|
53 |
|
|
54 |
/** |
|
55 |
* Useful to create a layer from scratch Call setFile before using this |
|
56 |
* function |
|
57 |
* |
|
58 |
* @param lyrDef |
|
59 |
* @throws IOException |
|
60 |
* @throws DriverException |
|
61 |
*/ |
|
62 |
public void initialize(ITableDefinition lyrD) throws EditionException { |
|
63 |
super.initialize(lyrD); |
|
64 |
this.lyrDef = (SDELayerDefinition) lyrD; |
|
65 |
conex = (SeConnection)lyrDef.getConnection(); |
|
66 |
// |
|
67 |
// try { |
|
68 |
// //st = conex.createStatement(); |
|
69 |
// |
|
70 |
// if (bCreateTable) { |
|
71 |
// try { |
|
72 |
// st.execute("DROP TABLE " + lyrDef.getTableName() + ";"); |
|
73 |
// } catch (SQLException e1) { |
|
74 |
// // Si no existe la tabla, no hay que borrarla. |
|
75 |
// } |
|
76 |
// |
|
77 |
// String sqlCreate = postGisSQL.getSqlCreateSpatialTable(lyrDef, |
|
78 |
// lyrDef.getFieldsDesc(), true); |
|
79 |
// System.out.println("sqlCreate =" + sqlCreate); |
|
80 |
// st.execute(sqlCreate); |
|
81 |
// |
|
82 |
// String sqlAlter = postGisSQL.getSqlAlterTable(lyrDef); |
|
83 |
// System.out.println("sqlAlter =" + sqlAlter); |
|
84 |
// st.execute(sqlAlter); |
|
85 |
// // CREATE TABLE PARKS ( PARK_ID int4, PARK_NAME varchar(128), |
|
86 |
// // PARK_DATE date, PARK_TYPE varchar(2) ); |
|
87 |
// // SELECT AddGeometryColumn('parks_db', 'parks', 'park_geom', |
|
88 |
// // 128, |
|
89 |
// // 'MULTIPOLYGON', 2 ); |
|
90 |
// |
|
91 |
// /* |
|
92 |
// * BEGIN; INSERT INTO ROADS_GEOM (ID,GEOM,NAME ) VALUES |
|
93 |
// * (1,GeometryFromText('LINESTRING(191232 243118,191108 |
|
94 |
// * 243242)',-1),'Jeff Rd'); INSERT INTO ROADS_GEOM (ID,GEOM,NAME ) |
|
95 |
// * VALUES (2,GeometryFromText('LINESTRING(189141 244158,189265 |
|
96 |
// * 244817)',-1),'Geordie Rd'); COMMIT; |
|
97 |
// */ |
|
98 |
// conex.commit(); |
|
99 |
// } |
|
100 |
// conex.setAutoCommit(false); |
|
101 |
// fieldManager = new JdbcFieldManager(conex, lyrDef.getTableName()); |
|
102 |
// |
|
103 |
// } catch (SQLException e) { |
|
104 |
// e.printStackTrace(); |
|
105 |
// throw new EditionException(e); |
|
106 |
// } |
|
107 |
|
|
108 |
} |
|
109 |
|
|
110 |
public void preProcess() throws EditionException { |
|
111 |
numRows = 0; |
|
112 | 115 |
// ATENTION: We will transform (in PostGIS class; doubleQuote()) |
113 | 116 |
// to UTF-8 strings. Then, we tell the PostgreSQL server |
114 | 117 |
// that we will use UTF-8, and it can translate |
115 | 118 |
// to its charset |
116 | 119 |
// Note: we have to translate to UTF-8 because |
117 | 120 |
// the server cannot manage UTF-16 |
118 |
|
|
119 | 121 |
//ResultSet rsAux; |
120 |
try {
|
|
121 |
//conex.rollbackTransaction();
|
|
122 |
conex.startTransaction();
|
|
123 |
alterTable();
|
|
122 |
try {
|
|
123 |
//conex.rollbackTransaction();
|
|
124 |
conex.startTransaction();
|
|
125 |
alterTable();
|
|
124 | 126 |
|
125 |
//rsAux = conex.getRelease().st.executeQuery("SHOW server_encoding;"); |
|
126 |
//rsAux.next(); |
|
127 |
//String serverEncoding = rsAux.getString(1); |
|
128 |
//System.out.println("Server encoding = " + serverEncoding); |
|
129 |
// st.execute("SET CLIENT_ENCODING TO 'UNICODE';"); |
|
130 |
// Intentamos convertir nuestras cadenas a ese encode. |
|
131 |
// postGisSQL.setEncoding(serverEncoding); |
|
132 |
} catch (SeException e) { |
|
133 |
// TODO Auto-generated catch block |
|
134 |
e.printStackTrace(); |
|
135 |
} |
|
127 |
//rsAux = conex.getRelease().st.executeQuery("SHOW server_encoding;"); |
|
128 |
//rsAux.next(); |
|
129 |
//String serverEncoding = rsAux.getString(1); |
|
130 |
//System.out.println("Server encoding = " + serverEncoding); |
|
131 |
// st.execute("SET CLIENT_ENCODING TO 'UNICODE';"); |
|
132 |
// Intentamos convertir nuestras cadenas a ese encode. |
|
133 |
// postGisSQL.setEncoding(serverEncoding); |
|
134 |
} catch (SeException e) { |
|
135 |
// TODO Auto-generated catch block |
|
136 |
e.printStackTrace(); |
|
137 |
} |
|
138 |
} |
|
136 | 139 |
|
137 |
} |
|
140 |
/** |
|
141 |
* DOCUMENT ME! |
|
142 |
* |
|
143 |
* @param _row DOCUMENT ME! |
|
144 |
* |
|
145 |
* @throws EditionException DOCUMENT ME! |
|
146 |
*/ |
|
147 |
public void process(IRowEdited _row) throws EditionException { |
|
148 |
int status = _row.getStatus(); |
|
138 | 149 |
|
139 |
public void process(IRowEdited _row) throws EditionException { |
|
140 |
int status = _row.getStatus(); |
|
141 |
try { |
|
142 |
switch (status) { |
|
143 |
case IRowEdited.STATUS_ADDED: |
|
144 |
addRow(_row); |
|
150 |
try { |
|
151 |
switch (status) { |
|
152 |
case IRowEdited.STATUS_ADDED: |
|
153 |
addRow(_row); |
|
145 | 154 |
|
146 |
/*
|
|
147 |
// TODO when addRowInCreation() is implemented:
|
|
148 |
if (tableCreation) {
|
|
149 |
addRowInCreation(_row);
|
|
150 |
} else {
|
|
151 |
addRow(_row);
|
|
152 |
}
|
|
153 |
*/
|
|
154 |
break;
|
|
155 |
/*
|
|
156 |
// TODO when addRowInCreation() is implemented:
|
|
157 |
if (tableCreation) {
|
|
158 |
addRowInCreation(_row);
|
|
159 |
} else {
|
|
160 |
addRow(_row);
|
|
161 |
}
|
|
162 |
*/
|
|
163 |
break;
|
|
155 | 164 |
|
156 |
case IRowEdited.STATUS_DELETED: |
|
165 |
case IRowEdited.STATUS_DELETED: |
|
166 |
deleteRow(_row); |
|
157 | 167 |
|
158 |
deleteRow(_row);
|
|
168 |
break;
|
|
159 | 169 |
|
170 |
case IRowEdited.STATUS_MODIFIED: |
|
171 |
updateRow(_row); |
|
160 | 172 |
|
161 |
break;
|
|
173 |
break;
|
|
162 | 174 |
|
163 |
case IRowEdited.STATUS_MODIFIED:
|
|
164 |
updateRow(_row);
|
|
175 |
case IRowEdited.STATUS_ORIGINAL:
|
|
176 |
originalRow(_row);
|
|
165 | 177 |
|
166 |
break; |
|
178 |
break; |
|
179 |
} |
|
180 |
} catch (SeException e) { |
|
181 |
e.printStackTrace(); |
|
182 |
throw new EditionException(); |
|
183 |
} catch (IOException e) { |
|
184 |
e.printStackTrace(); |
|
185 |
throw new EditionException(); |
|
186 |
} |
|
187 |
} |
|
167 | 188 |
|
168 |
case IRowEdited.STATUS_ORIGINAL: |
|
169 |
originalRow(_row); |
|
189 |
/** |
|
190 |
* DOCUMENT ME! |
|
191 |
* |
|
192 |
* @param _row DOCUMENT ME! |
|
193 |
*/ |
|
194 |
private void originalRow(IRowEdited _row) { |
|
195 |
// TODO Auto-generated method stub |
|
196 |
} |
|
170 | 197 |
|
171 |
break;
|
|
172 |
}
|
|
173 |
} catch (SeException e) {
|
|
174 |
e.printStackTrace();
|
|
175 |
throw new EditionException();
|
|
176 |
} catch (IOException e) {
|
|
177 |
e.printStackTrace();
|
|
178 |
throw new EditionException();
|
|
179 |
}
|
|
180 |
}
|
|
181 |
private void originalRow(IRowEdited _row) {
|
|
182 |
// TODO Auto-generated method stub
|
|
198 |
/**
|
|
199 |
* DOCUMENT ME!
|
|
200 |
*
|
|
201 |
* @param irow DOCUMENT ME!
|
|
202 |
*
|
|
203 |
* @throws SeException DOCUMENT ME!
|
|
204 |
* @throws IOException DOCUMENT ME!
|
|
205 |
*/
|
|
206 |
private void updateRow(IRowEdited irow) throws SeException, IOException {
|
|
207 |
// the values associated with the given record.
|
|
208 |
SeUpdate update = new SeUpdate(conex);
|
|
209 |
String[] cols = lyrDef.getFieldNames();
|
|
183 | 210 |
|
184 |
} |
|
211 |
// String featureId = feature.getID().substring( |
|
212 |
// feature.getID().lastIndexOf('.') + 1, |
|
213 |
// feature.getID().length()); |
|
214 |
update.toTable(selayer.getQualifiedName(), cols, |
|
215 |
"SHAPE" + " = " + irow.getID()); |
|
216 |
update.setWriteMode(true); |
|
185 | 217 |
|
186 |
private void updateRow(IRowEdited irow) throws SeException, IOException { |
|
187 |
// the values associated with the given record. |
|
188 |
SeUpdate update = new SeUpdate(conex); |
|
189 |
String[] cols = lyrDef.getFieldNames(); |
|
190 |
// String featureId = feature.getID().substring( |
|
191 |
// feature.getID().lastIndexOf('.') + 1, |
|
192 |
// feature.getID().length()); |
|
193 |
update.toTable(selayer.getQualifiedName(), cols, |
|
194 |
"SHAPE" + " = " + irow.getID()); |
|
195 |
update.setWriteMode(true); |
|
218 |
SeRow row = update.getRowToSet(); |
|
196 | 219 |
|
197 |
SeRow row = update.getRowToSet(); |
|
220 |
// Set values on rows here..... |
|
221 |
for (int i = 0; i < cols.length; i++) { |
|
222 |
if (cols[i].equals("SHAPE")) { |
|
223 |
setRowValue(row, i, |
|
224 |
((IFeature) irow.getLinkedRow()).getGeometry()); |
|
225 |
} else { |
|
226 |
setRowValue(row, i, irow.getAttribute(i)); |
|
227 |
} |
|
228 |
} |
|
198 | 229 |
|
199 |
// Set values on rows here..... |
|
200 |
for (int i = 0; i < cols.length; i++) { |
|
201 |
if (cols[i].equals("SHAPE")){ |
|
202 |
setRowValue(row,i,((IFeature)irow.getLinkedRow()).getGeometry()); |
|
203 |
}else{ |
|
204 |
setRowValue(row, i, irow.getAttribute(i)); |
|
205 |
} |
|
206 |
} |
|
230 |
update.execute(); |
|
231 |
update.close(); |
|
232 |
} |
|
207 | 233 |
|
208 |
update.execute(); |
|
209 |
update.close(); |
|
234 |
/** |
|
235 |
* DOCUMENT ME! |
|
236 |
* |
|
237 |
* @param _row DOCUMENT ME! |
|
238 |
* |
|
239 |
* @throws SeException DOCUMENT ME! |
|
240 |
*/ |
|
241 |
private void deleteRow(IRowEdited _row) throws SeException { |
|
242 |
// if ((this.features == null) |
|
243 |
// || (this.currentIndex >= this.features.size())) { |
|
244 |
// throw new IOException("No current feature available."); |
|
245 |
// } |
|
246 |
// if (this.notInserted) { |
|
247 |
// this.features.remove(this.currentIndex--); |
|
248 |
// this.notInserted = false; |
|
249 |
// } else { |
|
250 |
// Feature feature = (Feature) this.features.get(this.currentIndex); |
|
251 |
// PooledConnection connection = null; |
|
252 |
// connection = getConnection(); |
|
253 |
SeDelete seDelete = new SeDelete(conex); |
|
210 | 254 |
|
211 |
} |
|
255 |
long featureId = Long.parseLong(_row.getID()); |
|
256 |
SeObjectId objectID = new SeObjectId(featureId); |
|
257 |
seDelete.byId(selayer.getQualifiedName(), objectID); |
|
212 | 258 |
|
213 |
private void deleteRow(IRowEdited _row) throws SeException {
|
|
214 |
// if ((this.features == null)
|
|
215 |
// || (this.currentIndex >= this.features.size())) {
|
|
216 |
// throw new IOException("No current feature available.");
|
|
217 |
// }
|
|
259 |
//this.dataStore.fireRemoved(feature);
|
|
260 |
// } catch (Exception e) {
|
|
261 |
// throw new SOException(e.getMessage());
|
|
262 |
// } finally {
|
|
263 |
conex.close();
|
|
218 | 264 |
|
219 |
// if (this.notInserted) { |
|
220 |
// this.features.remove(this.currentIndex--); |
|
221 |
// this.notInserted = false; |
|
222 |
// } else { |
|
223 |
// Feature feature = (Feature) this.features.get(this.currentIndex); |
|
224 |
// PooledConnection connection = null; |
|
265 |
// } |
|
266 |
// } |
|
267 |
} |
|
225 | 268 |
|
226 |
// connection = getConnection(); |
|
269 |
/** |
|
270 |
* DOCUMENT ME! |
|
271 |
* |
|
272 |
* @param irow DOCUMENT ME! |
|
273 |
* |
|
274 |
* @throws EditionException DOCUMENT ME! |
|
275 |
*/ |
|
276 |
private void addRow(IRowEdited irow) throws EditionException { |
|
277 |
try { |
|
278 |
//Feature feature = (Feature) this.features.get(this.currentIndex); |
|
279 |
//FeatureType featureType = feature.getFeatureType(); |
|
280 |
//AttributeType[] attributeTypes = featureType.getAttributeTypes(); |
|
281 |
//connection = getConnection(); |
|
282 |
//if (this.notInserted) { |
|
283 |
// We must insert the record into ArcSDE |
|
284 |
SeInsert insert = new SeInsert(conex); |
|
285 |
String[] cols = lyrDef.getFieldNames(); |
|
286 |
insert.intoTable(selayer.getQualifiedName(), cols); |
|
287 |
insert.setWriteMode(true); |
|
227 | 288 |
|
228 |
SeDelete seDelete = new SeDelete(conex);
|
|
289 |
SeRow row = insert.getRowToSet();
|
|
229 | 290 |
|
230 |
long featureId = Long.parseLong(_row.getID()); |
|
231 |
SeObjectId objectID = new SeObjectId(featureId); |
|
232 |
seDelete.byId(selayer.getQualifiedName(), objectID); |
|
233 |
//this.dataStore.fireRemoved(feature); |
|
234 |
// } catch (Exception e) { |
|
235 |
// throw new SOException(e.getMessage()); |
|
236 |
// } finally { |
|
237 |
conex.close(); |
|
238 |
// } |
|
239 |
// } |
|
240 |
} |
|
291 |
// Now set the values for the new row here... |
|
292 |
for (int i = 0; i < cols.length; i++) { |
|
293 |
if (cols[i].equals("SHAPE")) { |
|
294 |
setRowValue(row, i, |
|
295 |
((IFeature) irow.getLinkedRow()).getGeometry()); |
|
296 |
} else { |
|
297 |
setRowValue(row, i, irow.getAttribute(i)); |
|
298 |
} |
|
299 |
} |
|
241 | 300 |
|
242 |
private void addRow(IRowEdited irow) throws EditionException { |
|
243 |
try { |
|
244 |
//Feature feature = (Feature) this.features.get(this.currentIndex); |
|
245 |
//FeatureType featureType = feature.getFeatureType(); |
|
246 |
//AttributeType[] attributeTypes = featureType.getAttributeTypes(); |
|
247 |
//connection = getConnection(); |
|
301 |
// Now "commit" the changes. |
|
302 |
insert.execute(); |
|
303 |
insert.close(); |
|
248 | 304 |
|
249 |
//if (this.notInserted) { |
|
250 |
// We must insert the record into ArcSDE |
|
251 |
SeInsert insert = new SeInsert(conex); |
|
252 |
String[] cols = lyrDef.getFieldNames(); |
|
253 |
insert.intoTable(selayer.getQualifiedName(), cols); |
|
254 |
insert.setWriteMode(true); |
|
305 |
//this.dataStore.fireAdded(feature); |
|
306 |
//} |
|
307 |
// else { |
|
308 |
// // The record is already inserted, so we will be updating |
|
309 |
// // the values associated with the given record. |
|
310 |
// SeUpdate update = new SeUpdate(connection); |
|
311 |
// String[] cols = getColumns(attributeTypes, connection); |
|
312 |
// String featureId = feature.getID().substring( |
|
313 |
// feature.getID().lastIndexOf('.') + 1, |
|
314 |
// feature.getID().length()); |
|
315 |
// update.toTable(this.layer.getQualifiedName(), cols, |
|
316 |
// this.spatialColumnName + " = " + featureId); |
|
317 |
// update.setWriteMode(true); |
|
318 |
// |
|
319 |
// SeRow row = update.getRowToSet(); |
|
320 |
// |
|
321 |
// // Set values on rows here..... |
|
322 |
// for (int i = 0; i < cols.length; i++) { |
|
323 |
// Object value = feature |
|
324 |
// .getAttribute(this.mutableAttributeIndexes[i] |
|
325 |
// .intValue()); |
|
326 |
// setRowValue(row, i, value); |
|
327 |
// } |
|
328 |
// |
|
329 |
// update.execute(); |
|
330 |
// update.close(); |
|
331 |
// |
|
332 |
// } |
|
333 |
} catch (Exception e) { |
|
334 |
// LOGGER.log(Level.WARNING, e.getMessage(), e); |
|
335 |
// if (LOGGER.isLoggable(Level.FINE)) { |
|
336 |
// e.printStackTrace(); |
|
337 |
// } |
|
338 |
// throw new DataSourceException(e.getMessage(), e); |
|
339 |
} finally { |
|
340 |
try { |
|
341 |
conex.close(); |
|
342 |
} catch (SeException e) { |
|
343 |
// TODO Auto-generated catch block |
|
344 |
e.printStackTrace(); |
|
345 |
} |
|
346 |
} |
|
347 |
} |
|
255 | 348 |
|
256 |
SeRow row = insert.getRowToSet(); |
|
349 |
/** |
|
350 |
* Used to set a value on an SeRow object. The values is converted to the |
|
351 |
* appropriate type based on an inspection of the SeColumnDefintion |
|
352 |
* object. |
|
353 |
* |
|
354 |
* @param row |
|
355 |
* @param index |
|
356 |
* @param value |
|
357 |
* |
|
358 |
* @throws SeException DOCUMENT ME! |
|
359 |
* @throws IOException DOCUMENT ME! |
|
360 |
*/ |
|
361 |
private void setRowValue(SeRow row, int index, Object value) |
|
362 |
throws SeException, IOException { |
|
363 |
SeColumnDefinition seColumnDefinition = null; |
|
364 |
seColumnDefinition = row.getColumnDef(index); |
|
257 | 365 |
|
258 |
// Now set the values for the new row here... |
|
259 |
for (int i = 0; i < cols.length; i++) { |
|
260 |
if (cols[i].equals("SHAPE")){ |
|
261 |
setRowValue(row,i,((IFeature)irow.getLinkedRow()).getGeometry()); |
|
262 |
}else{ |
|
263 |
setRowValue(row, i, irow.getAttribute(i)); |
|
264 |
} |
|
265 |
} |
|
366 |
switch (seColumnDefinition.getType()) { |
|
367 |
case SeColumnDefinition.TYPE_INTEGER: { |
|
368 |
if (value != null) { |
|
369 |
row.setInteger(index, new Integer(value.toString())); |
|
370 |
} else { |
|
371 |
row.setInteger(index, null); |
|
372 |
} |
|
266 | 373 |
|
267 |
// Now "commit" the changes. |
|
268 |
insert.execute(); |
|
269 |
insert.close(); |
|
270 |
//this.dataStore.fireAdded(feature); |
|
271 |
//} |
|
374 |
break; |
|
375 |
} |
|
272 | 376 |
|
273 |
// else { |
|
274 |
// // The record is already inserted, so we will be updating |
|
275 |
// // the values associated with the given record. |
|
276 |
// SeUpdate update = new SeUpdate(connection); |
|
277 |
// String[] cols = getColumns(attributeTypes, connection); |
|
278 |
// String featureId = feature.getID().substring( |
|
279 |
// feature.getID().lastIndexOf('.') + 1, |
|
280 |
// feature.getID().length()); |
|
281 |
// update.toTable(this.layer.getQualifiedName(), cols, |
|
282 |
// this.spatialColumnName + " = " + featureId); |
|
283 |
// update.setWriteMode(true); |
|
284 |
// |
|
285 |
// SeRow row = update.getRowToSet(); |
|
286 |
// |
|
287 |
// // Set values on rows here..... |
|
288 |
// for (int i = 0; i < cols.length; i++) { |
|
289 |
// Object value = feature |
|
290 |
// .getAttribute(this.mutableAttributeIndexes[i] |
|
291 |
// .intValue()); |
|
292 |
// setRowValue(row, i, value); |
|
293 |
// } |
|
294 |
// |
|
295 |
// update.execute(); |
|
296 |
// update.close(); |
|
297 |
// |
|
298 |
// } |
|
299 |
} catch (Exception e) { |
|
377 |
case SeColumnDefinition.TYPE_SMALLINT: { |
|
378 |
if (value != null) { |
|
379 |
row.setShort(index, new Short(value.toString())); |
|
380 |
} else { |
|
381 |
row.setShort(index, null); |
|
382 |
} |
|
300 | 383 |
|
301 |
// LOGGER.log(Level.WARNING, e.getMessage(), e); |
|
302 |
// if (LOGGER.isLoggable(Level.FINE)) { |
|
303 |
// e.printStackTrace(); |
|
304 |
// } |
|
305 |
// throw new DataSourceException(e.getMessage(), e); |
|
306 |
} finally { |
|
307 |
try { |
|
308 |
conex.close(); |
|
309 |
} catch (SeException e) { |
|
310 |
// TODO Auto-generated catch block |
|
311 |
e.printStackTrace(); |
|
312 |
} |
|
313 |
} |
|
314 |
} |
|
384 |
break; |
|
385 |
} |
|
315 | 386 |
|
316 |
/** |
|
317 |
* Used to set a value on an SeRow object. The values is converted to the |
|
318 |
* appropriate type based on an inspection of the SeColumnDefintion object. |
|
319 |
* |
|
320 |
* @param row |
|
321 |
* @param index |
|
322 |
* @param value |
|
323 |
* |
|
324 |
* @throws SeException |
|
325 |
* DOCUMENT ME! |
|
326 |
* @throws IOException |
|
327 |
* DOCUMENT ME! |
|
328 |
*/ |
|
329 |
private void setRowValue(SeRow row, int index, Object value) |
|
330 |
throws SeException, IOException { |
|
331 |
SeColumnDefinition seColumnDefinition = null; |
|
332 |
seColumnDefinition = row.getColumnDef(index); |
|
387 |
case SeColumnDefinition.TYPE_FLOAT: { |
|
388 |
if (value != null) { |
|
389 |
row.setFloat(index, new Float(value.toString())); |
|
390 |
} else { |
|
391 |
row.setFloat(index, null); |
|
392 |
} |
|
333 | 393 |
|
334 |
switch (seColumnDefinition.getType()) { |
|
335 |
case SeColumnDefinition.TYPE_INTEGER: { |
|
336 |
if (value != null) { |
|
337 |
row.setInteger(index, new Integer(value.toString())); |
|
338 |
} else { |
|
339 |
row.setInteger(index, null); |
|
340 |
} |
|
394 |
break; |
|
395 |
} |
|
341 | 396 |
|
342 |
break; |
|
343 |
} |
|
397 |
case SeColumnDefinition.TYPE_DOUBLE: { |
|
398 |
if (value != null) { |
|
399 |
row.setDouble(index, new Double(value.toString())); |
|
400 |
} else { |
|
401 |
row.setDouble(index, null); |
|
402 |
} |
|
344 | 403 |
|
345 |
case SeColumnDefinition.TYPE_SMALLINT: { |
|
346 |
if (value != null) { |
|
347 |
row.setShort(index, new Short(value.toString())); |
|
348 |
} else { |
|
349 |
row.setShort(index, null); |
|
350 |
} |
|
404 |
break; |
|
405 |
} |
|
351 | 406 |
|
352 |
break; |
|
353 |
} |
|
407 |
case SeColumnDefinition.TYPE_STRING: { |
|
408 |
if (value != null) { |
|
409 |
row.setString(index, value.toString()); |
|
410 |
} else { |
|
411 |
row.setString(index, null); |
|
412 |
} |
|
354 | 413 |
|
355 |
case SeColumnDefinition.TYPE_FLOAT: { |
|
356 |
if (value != null) { |
|
357 |
row.setFloat(index, new Float(value.toString())); |
|
358 |
} else { |
|
359 |
row.setFloat(index, null); |
|
360 |
} |
|
414 |
break; |
|
415 |
} |
|
361 | 416 |
|
362 |
break; |
|
363 |
} |
|
417 |
case SeColumnDefinition.TYPE_DATE: { |
|
418 |
if (value != null) { |
|
419 |
Calendar calendar = Calendar.getInstance(); |
|
420 |
calendar.setTime((Date) value); |
|
421 |
row.setTime(index, calendar); |
|
422 |
} else { |
|
423 |
row.setTime(index, null); |
|
424 |
} |
|
364 | 425 |
|
365 |
case SeColumnDefinition.TYPE_DOUBLE: { |
|
366 |
if (value != null) { |
|
367 |
row.setDouble(index, new Double(value.toString())); |
|
368 |
} else { |
|
369 |
row.setDouble(index, null); |
|
370 |
} |
|
426 |
break; |
|
427 |
} |
|
371 | 428 |
|
372 |
break; |
|
373 |
} |
|
429 |
case SeColumnDefinition.TYPE_SHAPE: { |
|
430 |
if (value != null) { |
|
431 |
try { |
|
432 |
SeCoordinateReference coordRef = selayer.getCoordRef(); |
|
433 |
IGeometry geom = (IGeometry) value; |
|
434 |
SeShape shape = ArcSdeFeatureIterator.constructShape(geom, |
|
435 |
coordRef); |
|
436 |
row.setShape(index, shape); |
|
437 |
} catch (Exception e) { |
|
438 |
e.printStackTrace(); |
|
439 |
} |
|
440 |
} else { |
|
441 |
row.setShape(index, null); |
|
442 |
} |
|
374 | 443 |
|
375 |
case SeColumnDefinition.TYPE_STRING: { |
|
376 |
if (value != null) { |
|
377 |
row.setString(index, value.toString()); |
|
378 |
} else { |
|
379 |
row.setString(index, null); |
|
380 |
} |
|
444 |
break; |
|
445 |
} |
|
446 |
} |
|
447 |
} |
|
381 | 448 |
|
382 |
break; |
|
383 |
} |
|
449 |
/** |
|
450 |
* DOCUMENT ME! |
|
451 |
* |
|
452 |
* @throws EditionException DOCUMENT ME! |
|
453 |
*/ |
|
454 |
public void postProcess() throws EditionException { |
|
455 |
try { |
|
456 |
conex.commitTransaction(); |
|
457 |
} catch (SeException e) { |
|
458 |
e.printStackTrace(); |
|
459 |
throw new EditionException(e); |
|
460 |
} |
|
461 |
} |
|
384 | 462 |
|
385 |
case SeColumnDefinition.TYPE_DATE: {
|
|
386 |
if (value != null) {
|
|
387 |
Calendar calendar = Calendar.getInstance();
|
|
388 |
calendar.setTime((Date) value);
|
|
389 |
row.setTime(index, calendar);
|
|
390 |
} else {
|
|
391 |
row.setTime(index, null);
|
|
392 |
}
|
|
463 |
/**
|
|
464 |
* DOCUMENT ME!
|
|
465 |
*
|
|
466 |
* @return DOCUMENT ME!
|
|
467 |
*/
|
|
468 |
public String getName() {
|
|
469 |
return "gvSIG SDE Writer";
|
|
470 |
}
|
|
393 | 471 |
|
394 |
break; |
|
395 |
} |
|
472 |
/** |
|
473 |
* DOCUMENT ME! |
|
474 |
* |
|
475 |
* @param gvSIGgeometryType DOCUMENT ME! |
|
476 |
* |
|
477 |
* @return DOCUMENT ME! |
|
478 |
*/ |
|
479 |
public boolean canWriteGeometry(int gvSIGgeometryType) { |
|
480 |
switch (gvSIGgeometryType) { |
|
481 |
case FShape.POINT: |
|
482 |
return true; |
|
396 | 483 |
|
397 |
case SeColumnDefinition.TYPE_SHAPE: { |
|
398 |
if (value != null) { |
|
399 |
try { |
|
400 |
SeCoordinateReference coordRef = selayer.getCoordRef(); |
|
401 |
IGeometry geom = (IGeometry) value; |
|
402 |
SeShape shape = ArcSdeFeatureIterator.constructShape(geom, |
|
403 |
coordRef); |
|
404 |
row.setShape(index, shape); |
|
405 |
} catch (Exception e) { |
|
406 |
e.printStackTrace(); |
|
407 |
} |
|
408 |
} else { |
|
409 |
row.setShape(index, null); |
|
410 |
} |
|
484 |
case FShape.LINE: |
|
485 |
return true; |
|
411 | 486 |
|
412 |
break; |
|
413 |
} |
|
414 |
} |
|
415 |
} |
|
487 |
case FShape.POLYGON: |
|
488 |
return true; |
|
416 | 489 |
|
417 |
public void postProcess() throws EditionException { |
|
418 |
try { |
|
419 |
conex.commitTransaction(); |
|
420 |
} catch (SeException e) { |
|
421 |
e.printStackTrace(); |
|
422 |
throw new EditionException(e); |
|
423 |
} |
|
424 |
} |
|
490 |
case FShape.ARC: |
|
491 |
return false; |
|
425 | 492 |
|
426 |
public String getName() { |
|
427 |
return "gvSIG SDE Writer"; |
|
428 |
} |
|
493 |
case FShape.ELLIPSE: |
|
494 |
return false; |
|
429 | 495 |
|
430 |
public boolean canWriteGeometry(int gvSIGgeometryType) { |
|
431 |
switch (gvSIGgeometryType) { |
|
432 |
case FShape.POINT: |
|
433 |
return true; |
|
434 |
case FShape.LINE: |
|
435 |
return true; |
|
436 |
case FShape.POLYGON: |
|
437 |
return true; |
|
438 |
case FShape.ARC: |
|
439 |
return false; |
|
440 |
case FShape.ELLIPSE: |
|
441 |
return false; |
|
442 |
case FShape.MULTIPOINT: |
|
443 |
return true; |
|
444 |
case FShape.TEXT: |
|
445 |
return false; |
|
446 |
} |
|
447 |
return false; |
|
448 |
} |
|
496 |
case FShape.MULTIPOINT: |
|
497 |
return true; |
|
449 | 498 |
|
450 |
public boolean canWriteAttribute(int sqlType) { |
|
451 |
switch (sqlType) { |
|
452 |
case Types.DOUBLE: |
|
453 |
case Types.FLOAT: |
|
454 |
case Types.INTEGER: |
|
455 |
case Types.BIGINT: |
|
456 |
return true; |
|
457 |
case Types.DATE: |
|
458 |
return true; |
|
459 |
case Types.BIT: |
|
460 |
case Types.BOOLEAN: |
|
461 |
return true; |
|
462 |
case Types.VARCHAR: |
|
463 |
case Types.CHAR: |
|
464 |
case Types.LONGVARCHAR: |
|
465 |
return true; |
|
499 |
case FShape.TEXT: |
|
500 |
return false; |
|
501 |
} |
|
466 | 502 |
|
467 |
} |
|
503 |
return false; |
|
504 |
} |
|
468 | 505 |
|
469 |
return false; |
|
470 |
} |
|
506 |
/** |
|
507 |
* DOCUMENT ME! |
|
508 |
* |
|
509 |
* @param sqlType DOCUMENT ME! |
|
510 |
* |
|
511 |
* @return DOCUMENT ME! |
|
512 |
*/ |
|
513 |
public boolean canWriteAttribute(int sqlType) { |
|
514 |
switch (sqlType) { |
|
515 |
case Types.DOUBLE: |
|
516 |
case Types.FLOAT: |
|
517 |
case Types.INTEGER: |
|
518 |
case Types.BIGINT: |
|
519 |
return true; |
|
471 | 520 |
|
472 |
/** |
|
473 |
* @return Returns the bCreateTable. |
|
474 |
*/ |
|
475 |
public boolean isCreateTable() { |
|
476 |
return bCreateTable; |
|
477 |
} |
|
521 |
case Types.DATE: |
|
522 |
return true; |
|
478 | 523 |
|
479 |
/** |
|
480 |
* @param createTable |
|
481 |
* The bCreateTable to set. |
|
482 |
*/ |
|
483 |
public void setCreateTable(boolean createTable) { |
|
484 |
bCreateTable = createTable; |
|
485 |
} |
|
524 |
case Types.BIT: |
|
525 |
case Types.BOOLEAN: |
|
526 |
return true; |
|
486 | 527 |
|
487 |
public FieldDescription[] getOriginalFields() { |
|
488 |
return lyrDef.getFieldsDesc(); |
|
489 |
} |
|
528 |
case Types.VARCHAR: |
|
529 |
case Types.CHAR: |
|
530 |
case Types.LONGVARCHAR: |
|
531 |
return true; |
|
532 |
} |
|
490 | 533 |
|
491 |
public void addField(FieldDescription fieldDesc) {
|
|
492 |
// fieldManager.addField(fieldDesc);
|
|
534 |
return false;
|
|
535 |
}
|
|
493 | 536 |
|
494 |
} |
|
537 |
/** |
|
538 |
* DOCUMENT ME! |
|
539 |
* |
|
540 |
* @return Returns the bCreateTable. |
|
541 |
*/ |
|
542 |
public boolean isCreateTable() { |
|
543 |
return bCreateTable; |
|
544 |
} |
|
495 | 545 |
|
496 |
public FieldDescription removeField(String fieldName) { |
|
497 |
// return fieldManager.removeField(fieldName); |
|
498 |
return null; |
|
499 |
} |
|
546 |
/** |
|
547 |
* DOCUMENT ME! |
|
548 |
* |
|
549 |
* @param createTable The bCreateTable to set. |
|
550 |
*/ |
|
551 |
public void setCreateTable(boolean createTable) { |
|
552 |
bCreateTable = createTable; |
|
553 |
} |
|
500 | 554 |
|
501 |
public void renameField(String antName, String newName) { |
|
502 |
// fieldManager.renameField(antName, newName); |
|
555 |
/** |
|
556 |
* DOCUMENT ME! |
|
557 |
* |
|
558 |
* @return DOCUMENT ME! |
|
559 |
*/ |
|
560 |
public FieldDescription[] getOriginalFields() { |
|
561 |
return lyrDef.getFieldsDesc(); |
|
562 |
} |
|
503 | 563 |
|
504 |
} |
|
564 |
/** |
|
565 |
* DOCUMENT ME! |
|
566 |
* |
|
567 |
* @param fieldDesc DOCUMENT ME! |
|
568 |
*/ |
|
569 |
public void addField(FieldDescription fieldDesc) { |
|
570 |
// fieldManager.addField(fieldDesc); |
|
571 |
} |
|
505 | 572 |
|
506 |
public boolean alterTable() throws EditionException { |
|
507 |
// return fieldManager.alterTable(); |
|
508 |
return false; |
|
509 |
} |
|
573 |
/** |
|
574 |
* DOCUMENT ME! |
|
575 |
* |
|
576 |
* @param fieldName DOCUMENT ME! |
|
577 |
* |
|
578 |
* @return DOCUMENT ME! |
|
579 |
*/ |
|
580 |
public FieldDescription removeField(String fieldName) { |
|
581 |
// return fieldManager.removeField(fieldName); |
|
582 |
return null; |
|
583 |
} |
|
510 | 584 |
|
511 |
public FieldDescription[] getFields() { |
|
512 |
// return fieldManager.getFields(); |
|
513 |
return lyrDef.getFieldsDesc(); |
|
514 |
} |
|
585 |
/** |
|
586 |
* DOCUMENT ME! |
|
587 |
* |
|
588 |
* @param antName DOCUMENT ME! |
|
589 |
* @param newName DOCUMENT ME! |
|
590 |
*/ |
|
591 |
public void renameField(String antName, String newName) { |
|
592 |
// fieldManager.renameField(antName, newName); |
|
593 |
} |
|
515 | 594 |
|
516 |
public boolean canAlterTable() { |
|
517 |
return true; |
|
518 |
} |
|
595 |
/** |
|
596 |
* DOCUMENT ME! |
|
597 |
* |
|
598 |
* @return DOCUMENT ME! |
|
599 |
* |
|
600 |
* @throws EditionException DOCUMENT ME! |
|
601 |
*/ |
|
602 |
public boolean alterTable() throws EditionException { |
|
603 |
// return fieldManager.alterTable(); |
|
604 |
return false; |
|
605 |
} |
|
519 | 606 |
|
520 |
public boolean canSaveEdits() { |
|
521 |
// try { |
|
522 |
// return !conex.isReadOnly(); |
|
523 |
// } catch (SQLException e) { |
|
524 |
// // TODO Auto-generated catch block |
|
525 |
// e.printStackTrace(); |
|
526 |
// return false; |
|
527 |
// } |
|
528 |
return false; |
|
529 |
} |
|
607 |
/** |
|
608 |
* DOCUMENT ME! |
|
609 |
* |
|
610 |
* @return DOCUMENT ME! |
|
611 |
*/ |
|
612 |
public FieldDescription[] getFields() { |
|
613 |
// return fieldManager.getFields(); |
|
614 |
return lyrDef.getFieldsDesc(); |
|
615 |
} |
|
530 | 616 |
|
531 |
public void setDriver(ArcSdeDriver driver) { |
|
532 |
this.driver=driver; |
|
617 |
/** |
|
618 |
* DOCUMENT ME! |
|
619 |
* |
|
620 |
* @return DOCUMENT ME! |
|
621 |
*/ |
|
622 |
public boolean canAlterTable() { |
|
623 |
return true; |
|
624 |
} |
|
533 | 625 |
|
534 |
} |
|
626 |
/** |
|
627 |
* DOCUMENT ME! |
|
628 |
* |
|
629 |
* @return DOCUMENT ME! |
|
630 |
*/ |
|
631 |
public boolean canSaveEdits() { |
|
632 |
// try { |
|
633 |
// return !conex.isReadOnly(); |
|
634 |
// } catch (SQLException e) { |
|
635 |
// // TODO Auto-generated catch block |
|
636 |
// e.printStackTrace(); |
|
637 |
// return false; |
|
638 |
// } |
|
639 |
return false; |
|
640 |
} |
|
535 | 641 |
|
536 |
public void setSeLayer(SeLayer layer) { |
|
537 |
this.selayer=layer; |
|
538 |
} |
|
642 |
/** |
|
643 |
* DOCUMENT ME! |
|
644 |
* |
|
645 |
* @param driver DOCUMENT ME! |
|
646 |
*/ |
|
647 |
public void setDriver(ArcSdeDriver driver) { |
|
648 |
this.driver = driver; |
|
649 |
} |
|
539 | 650 |
|
651 |
/** |
|
652 |
* DOCUMENT ME! |
|
653 |
* |
|
654 |
* @param layer DOCUMENT ME! |
|
655 |
*/ |
|
656 |
public void setSeLayer(SeLayer layer) { |
|
657 |
this.selayer = layer; |
|
658 |
} |
|
540 | 659 |
} |
Also available in: Unified diff