Revision 35336 trunk/extensions/extJDBC/src/com/iver/cit/gvsig/fmap/drivers/jdbc/postgis/PostGISWriter.java
| PostGISWriter.java | ||
|---|---|---|
| 318 | 318 |
try {
|
| 319 | 319 |
// return !((ConnectionJDBC) conex).getConnection().isReadOnly(); |
| 320 | 320 |
boolean can_edit = false; |
| 321 |
|
|
| 322 |
|
|
| 321 | 323 |
st = ((ConnectionJDBC) conex).getConnection().createStatement(); |
| 324 |
String sql2; |
|
| 325 |
sql2 = "select * from GEOMETRY_COLUMNS WHERE F_TABLE_SCHEMA = '" |
|
| 326 |
+ lyrDef.getSchema() + "' AND F_TABLE_NAME = '" + lyrDef.getTableName() |
|
| 327 |
+ "'"; |
|
| 328 |
|
|
| 329 |
ResultSet rs2 = st.executeQuery(sql2); |
|
| 330 |
int dim =0; |
|
| 331 |
while (rs2.next()) {
|
|
| 332 |
dim = rs2.getInt("coord_dimension");
|
|
| 333 |
} |
|
| 334 |
rs2.close(); |
|
| 335 |
|
|
| 322 | 336 |
String sql = "SELECT has_table_privilege('"
|
| 323 | 337 |
+ lyrDef.getComposedTableName() + "', 'insert') " |
| 324 | 338 |
+ "AND has_table_privilege('"
|
| ... | ... | |
| 330 | 344 |
if (rs.next()) {
|
| 331 | 345 |
can_edit = rs.getBoolean("can_edit");
|
| 332 | 346 |
} |
| 347 |
rs.close(); |
|
| 348 |
st.close(); |
|
| 349 |
if (dim > 2) |
|
| 350 |
return false; |
|
| 351 |
|
|
| 352 |
|
|
| 333 | 353 |
return can_edit |
| 334 | 354 |
&& !((ConnectionJDBC) conex).getConnection().isReadOnly(); |
| 335 | 355 |
|
Also available in: Unified diff