Revision 11867 branches/v10/extensions/extJDBC/src/com/iver/cit/gvsig/fmap/drivers/jdbc/postgis/PostGIS.java

View differences:

PostGIS.java
111 111
			resul = "CREATE TABLE " + dbLayerDef.getTableName() + " (";
112 112
		else */
113 113
		// FJP: NUEVO: NO TOLERAMOS CAMPOS QUE SE LLAMEN GID. Lo reservamos para uso nuestro.
114
		resul = "CREATE TABLE " + dbLayerDef.getTableName()
114
		resul = "CREATE TABLE " + dbLayerDef.getComposedTableName()
115 115
					+ " (gid serial PRIMARY KEY ";
116 116
		int j=0;
117 117
		for (int i = 0; i < dbLayerDef.getFieldNames().length; i++) {
......
151 151
		}
152 152

  
153 153
		String result = "SELECT AddGeometryColumn('"
154
				+ dbLayerDef.getCatalogName() + "', '"
154
				+ dbLayerDef.getSchema() + "', '"
155 155
				+ dbLayerDef.getTableName() + "', '"
156 156
				+ dbLayerDef.getFieldGeometry() + "', "
157 157
				+ dbLayerDef.getSRID_EPSG() + ", '" + strGeometryFieldType + "', "
......
215 215
	 * @return
216 216
	 */
217 217
	public String getSqlInsertFeature(DBLayerDefinition dbLayerDef,
218
			IFeature feat) {
218
			IFeature feat) {				
219 219
		StringBuffer sqlBuf = new StringBuffer("INSERT INTO "
220
				+ dbLayerDef.getTableName() + " (");
220
				+ dbLayerDef.getComposedTableName() + " (");
221 221
		String sql = null;
222 222
		int numAlphanumericFields = dbLayerDef.getFieldNames().length;
223 223

  
......
273 273
		 	WHERE date > '1994-11-28';
274 274
		 */
275 275
		StringBuffer sqlBuf = new StringBuffer("UPDATE "
276
				+ dbLayerDef.getTableName() + " SET");
276
				+ dbLayerDef.getComposedTableName() + " SET");
277 277
		String sql = null;
278 278
		int numAlphanumericFields = dbLayerDef.getFieldsDesc().length;
279 279

  
......
325 325
		// nos sirve dentro de un writer para modificar y/o borrar entidades
326 326
		// Por ahora, cojo el ID del campo que me indica el dbLayerDev
327 327
		StringBuffer sqlBuf = new StringBuffer("DELETE FROM "
328
				+ dbLayerDef.getTableName() + " WHERE ");
328
				+ dbLayerDef.getComposedTableName() + " WHERE ");
329 329
		String sql = null;
330 330
		int indexFieldId = dbLayerDef.getIdFieldID();
331 331
		sqlBuf.append(dbLayerDef.getFieldID() + " = " + row.getAttribute(indexFieldId));

Also available in: Unified diff