| gvSIG desktop 1

/**

 * Driver of ArcSDE.

 */

public class ArcSdeDriver implements ICanReproject, IWriteable, VectorialSDEDriver, ObjectDriver{

    protected static Hashtable poolPassw = new Hashtable();

    private SeLayer layer;

    private SeSqlConstruct sqlConstruct;

    private SeColumnDefinition[] colDefs;

    private SeRow row = null;

    private int numReg = -1;

    private Rectangle2D fullExtent = null;

    private Hashtable hashRelate = null;

    private int idSpatialColumn = -1;

    private String[] fields;

    private int[] fieldTypes;

    private long lastRowServed = -1;

    private String strEPSG;

    private String originalEPSG = null;

    private String sqlTotal;

    private long posActual = -1;

    private SeRow cachedRow = null;

    protected VectorialSDELayerDefinition lyrDef = null;

    protected Rectangle2D workingArea;

    protected String driverClass;

    protected String className;

            }

            int index = 0;

            int fid=getLyrDef().getIdFieldID();

            while (value != null) {

                //SeShape shpVal = row.getShape(idSpatialColumn);

                //SeObjectId objID = shpVal.getFeatureId();

            	String theKey = value.toString();

                hashRelate.put(theKey, new Integer(index));

                value = getFieldValue(index,fid-1);

            }

            numReg = index;

    }

    /**

	 * @return

	 */

    public Rectangle2D getFullExtent() {

		return fullExtent;

        try {

            row = obtainRow(index);

            SeShape spVal = row.getShape(idSpatialColumn);

            IGeometry geom = ArcSdeFeatureIterator.getGeometry(spVal);

            return geom;

         */

        try {

            SeShape shape = new SeShape(layer.getCoordRef());

            shape.generateRectangle(extent);

            SeShape[] shapes = new SeShape[1];

            SeQuery spatialQuery = null;

            SeSqlConstruct sqlCons = new SeSqlConstruct(layer.getName());

            /*

             *   Set spatial constraints

             */

                filters);

            spatialQuery.prepareQuery();

        return layer.getName();

    }

            if (rowIndex == 0) {

                if (query != null) {

                    if (query.inProgress()) {

                        query.close();

                    }

                }

                lastRowServed = -1;

            }

                row = query.fetch();

                lastRowServed++;

            } else {

                }

                SeObjectId rowID = new SeObjectId(rowIndex + 1);

                row = queryAux.fetchRow(layer.getName(), rowID, fields);

            }

            posActual = rowIndex;

            cachedRow = row;

        }

        */

        try {

            SeShape shape = new SeShape(layer.getCoordRef());

            shape.generateRectangle(extent);

            SeShape[] shapes = new SeShape[1];

            SeQuery spatialQuery = null;

            SeSqlConstruct sqlCons = new SeSqlConstruct(layer.getName());

            /*

             *   Set spatial constraints

    public boolean isWritable() {

        return false;

    }

    public void setData(Connection connection, DBLayerDefinition lyrDef) {

        setLyrDef(lyrDef);

        // Conexi?n:

        String password = sdeDef.getPassword();

        String[] cols = sdeDef.getFieldNames();

        String tableName = sdeDef.getTableName();

        try {

        } catch (SeException e) {

            e.printStackTrace();

            return;

        }

        // Fetching data

        String layerName = tableName;

        SeObjectId layerID = null;

        String strSpatialColumn = "";

        try {

            for (int i = 0; i < theLayers.size(); i++) {

                SeLayer layer = (SeLayer) theLayers.elementAt(i);

            }

            // layerName = layer.getName();

            //TODO aqu? se puede saber la proyecci?n

            //layer.getCoordRef().getSrid();

            sqlConstruct = new SeSqlConstruct(layerName);

            //      Create a query stream between the client and server

            query.prepareQuery();

            query.execute();

            row = query.fetch();

                }

            }

            fields=cols;

            SeQueryInfo queryInfo = new SeQueryInfo();

            queryInfo.setConstruct(sqlConstruct);

        xml.putProperty("dbName", sdeDef.getSchema());

        xml.putProperty("connName", sdeDef.getConnectionName());

        if (getWorkingArea() != null) {

            xml.putProperty("minXworkArea", getWorkingArea().getMinX());

            xml.putProperty("minYworkArea", getWorkingArea().getMinY());

            lyrDef.setSchema(xml.getStringProperty("dbName"));

            lyrDef.setConnectionName(xml.getStringProperty("connName"));

        }

        if (xml.contains("minXworkArea")) {

            double x = xml.getDoubleProperty("minXworkArea");

            double y = xml.getDoubleProperty("minYworkArea");

    /**

	 * @return

	 */

    public DBLayerDefinition getLyrDef() {

    /**

     * Empty method called when the layer is going to be removed from the view.

    }

    public Object getConnection() {

    }

	public String getConnectionString(

    		String host,

    		String port,

		resp += "/" + dbname.toLowerCase();

		return resp;

    }

}

public class ArcSdeWriter extends AbstractWriter implements ISpatialWriter,

    IFieldManager {

    private int numRows;

    private SeConnection conex;

    //private Statement st;

    private boolean bCreateTable;

    private SeLayer selayer;

    //private ArcSde postGisSQL = new ArcSde();

     */

    public void initialize(ITableDefinition lyrD) throws EditionException {

        super.initialize(lyrD);

        conex = (SeConnection) lyrDef.getConnection();

        //