| gvSIG desktop 1

			description="Support to access SDE"

			active="true"

			priority="1">

	</extensions>

</plugin-config>

 * Created on 11-mar-2005

 *

 * gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 * Copyright (C) 2004 IVER T.I. and Generalitat Valenciana.

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *    or

 *   IVER T.I. S.A

 *   Salamanca 50

 *   46005 Valencia

 *   Spain

 *   +34 963163400

 *   dac@iver.es

 */

import com.esri.sde.sdk.client.SeShape;

import com.hardcode.gdbms.engine.values.Value;

import com.hardcode.gdbms.engine.values.ValueFactory;

import com.iver.cit.gvsig.fmap.core.DefaultFeature;

import com.iver.cit.gvsig.fmap.core.FNullGeometry;

import com.iver.cit.gvsig.fmap.core.FPoint2D;

import com.iver.cit.gvsig.fmap.drivers.IFeatureIterator;

/**

 */

public class ArcSdeFeatureIterator implements IFeatureIterator {

    IGeometry geom;

    private boolean bFirst;

    Value[] regAtt;

    SeRow row;

    static GeneralPathX convertSeShapeToGeneralPathX(SeShape spVal) throws SeException

    {

        double[][][] points = spVal.getAllCoords(SeShape.TURN_RIGHT);

        // Display the X and Y values

        boolean bStartPart;

        for( int partNo = 0 ; partNo < points.length ; partNo++)

            for( int subPartNo = 0 ; subPartNo < points[partNo].length ; subPartNo++)

            {

                bStartPart = true;

                }

            }

        return gpx;

    }

    public static IGeometry getGeometry( SeShape shape ) {

        try {

            /*

             *   Retrieve the shape type.

             */

            int type = -1;

            type = shape.getType();

            // Display the X and Y values

                        System.out.println("X: " + points[partNo][subPartNo][pointNo] + "\tY: "

            switch( type )

            {

                case SeShape.TYPE_POINT:

                    double[][][] points = shape.getAllCoords();

                    FPoint2D p =  new FPoint2D(points[0][0][0],points[0][0][1]);

                    return ShapeFactory.createPoint2D(p);

                case SeShape.TYPE_LINE:

                case SeShape.TYPE_MULTI_LINE:

                case SeShape.TYPE_MULTI_SIMPLE_LINE:

                case SeShape.TYPE_SIMPLE_LINE:

                    GeneralPathX gpx = new GeneralPathX(shape.toGeneralPath());

                    return ShapeFactory.createPolyline2D(gpx);

                    break;

                case SeShape.TYPE_NIL:

                    return new FNullGeometry();

                case SeShape.TYPE_POLYGON:

                    // GeneralPathX gpx2 = new GeneralPathX(shape.toGeneralPath());

                    GeneralPathX gpx2 = convertSeShapeToGeneralPathX(shape);

                    /* SeExtent r = shape.getExtent();

            e.printStackTrace();

        }

        return new FNullGeometry();

    /**

     * @throws SQLException

     */

    public ArcSdeFeatureIterator(SeQuery query) {

        // Debe ser forward only

            e.printStackTrace();

        }

    }

    /* (non-Javadoc)

     * @see com.iver.cit.gvsig.fmap.drivers.jdbc.GeometryIterator#hasNext()

     */

        try {

            if (bFirst)

                bFirst = false;

                query.close();

                return false;

            }

            return true;

        }

            // throw new SQLException(e.getMessage());

        }

        return false;

    /* (non-Javadoc)

     * @see com.iver.cit.gvsig.fmap.drivers.jdbc.GeometryIterator#next()

     */

        SeShape spVal = null;

        IFeature feat = null;

        try

                for (int colNum = 0; colNum < colDefs.length; colNum++)

                    SeColumnDefinition colDef = colDefs[colNum];

                    int dataType = colDef.getType();

                    if ( row.getIndicator((short)colNum) != SeRow.SE_IS_NULL_VALUE)

                    {

                        switch( dataType )

                        {

                                regAtt[colNum-1] =  ValueFactory.createValue(row.getShort(colNum).intValue());

                            case SeColumnDefinition.TYPE_DATE:

                                break;

                                regAtt[colNum-1] =  ValueFactory.createValue(row.getInteger(colNum).intValue());

                                break;

                                regAtt[colNum-1] =  ValueFactory.createValue(row.getFloat(colNum).floatValue());

                                break;

                                regAtt[colNum-1] =  ValueFactory.createValue(row.getDouble(colNum).doubleValue());

                                break;

                            case SeColumnDefinition.TYPE_STRING:

                                regAtt[colNum-1] =  ValueFactory.createValue(row.getString(colNum));

                                break;

                            case SeColumnDefinition.TYPE_SHAPE:

                                geom = getGeometry(spVal);

                                break;

                        } // End switch

                    } // End if

                } // for

                // System.out.println("Dentro de next(): " + spVal.getFeatureId().toString() + " " + regAtt[0]);

                feat = new DefaultFeature(geom, regAtt, "" + spVal.getFeatureId().longValue());

            } // if

        } catch (SeException e)

        {

            e.printStackTrace();

        }

        return feat;

    }

}

 * Created on 13-may-2005

 *

 * gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 * Copyright (C) 2004 IVER T.I. and Generalitat Valenciana.

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *    or

 *   IVER T.I. S.A

 *   Salamanca 50

 *   46005 Valencia

 *   Spain

 *   +34 963163400

 *   dac@iver.es

 */

import com.iver.cit.gvsig.fmap.core.GeneralPathX;

public class testSDE {

        // Conexi?n:

        SeConnection conn = null;

        int instance      = 5151;

        String user       = "sde";

        try {

        }catch (SeException e) {

            e.printStackTrace();

            return;

        // Fetching data

        SeObjectId layerID = null;

        String strSpatialColumn = "";

        try {

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

            {

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

                    layerID = layer.getID();

                    strSpatialColumn = layer.getSpatialColumn();

                }

            }

            if (layerID == null)

                System.err.println("Capa no encontrada");

                return;

            }

            SeLayer layer = new SeLayer( conn, layerName, strSpatialColumn );

            SeSqlConstruct sqlConstruct = new SeSqlConstruct( layerName);

            long t1 = System.currentTimeMillis();

    //      Create a query stream between the client and server

            String[] cols = new String[2];

            SeQuery query = new SeQuery( conn, cols, sqlConstruct );

            query.prepareQuery();

            query.execute();

            long t2 = System.currentTimeMillis();

            System.out.println("Tiempo de consulta:" + (t2 - t1) + " milisegundos");

            t1 = System.currentTimeMillis();

            int cont = 0;

            SeRow row = query.fetch();

            if( row == null ) {

                System.out.println(" No rows fetched");

                return;

            }

            // String rowID = "2";

            // Get the definitions of all the columns retrieved

            SeColumnDefinition[] colDefs = row.getColumns();

            while (row != null)

                cont++;

            }

            // Close the query.

            query.close();

            t2 = System.currentTimeMillis();

            System.out.println("Tiempo de recorrido:"  + (t2 - t1) + " milisegundos. " + cont + " registros.");

            queryInfo.setConstruct(sqlConstruct);

            // queryInfo.setQueryType(SeQueryInfo.SE_QUERYTYPE_JFA);

            // query.prepareQueryInfo(queryInfo);

            SeExtent seExtent = extentQuery.calculateLayerExtent(queryInfo);

            extentQuery.close();

            System.out.println(seExtent.toString());

            SeQuery queryAux;

            t1 = System.currentTimeMillis();

            for (int i=0; i < 250; i++)

            {

                queryAux = new SeQuery( conn, cols, sqlConstruct );

                SeObjectId rowID = new SeObjectId(i+1);

                row = queryAux.fetchRow("provin", rowID, cols);

                evaluateRow(row, colDefs);

                queryAux.close();

            }

            // queryAux.close();

            t2 = System.currentTimeMillis();

            System.out.println("Tiempo de recorrido:"  + (t2 - t1) + " milisegundos. "); */

            /* queryAux = new SeQuery( conn, cols, sqlConstruct );

            SeObjectId rowID = new SeObjectId(1);

            evaluateRow(row, colDefs);

            evaluateRow(row, colDefs);

            queryAux.close(); */

        } catch( SeException e ) {

            System.out.println(e.getSeError().getErrDesc());

        }

    }

    static GeneralPathX convertSeShapeToGeneralPathX(SeShape spVal) throws SeException

        for( int partNo = 0 ; partNo < points.length ; partNo++)

        {

            bStartPart = true;

                for( int pointNo = 0 ; pointNo < points[partNo][subPartNo].length ; pointNo+=2)

                {

                    if (bStartPart)

                                points[partNo][subPartNo][(pointNo+1)]);

                }

        return gpx;

    }

    static void evaluateRow(SeRow row, SeColumnDefinition[] colDefs)

        try

        {

            for (int colNum = 0; colNum < colDefs.length; colNum++)

                SeColumnDefinition colDef = colDefs[colNum];

                int dataType = colDef.getType();

                if ( row.getIndicator((short)colNum) != SeRow.SE_IS_NULL_VALUE)

                    {

                        case SeColumnDefinition.TYPE_SMALLINT:

                            break;

                        case SeColumnDefinition.TYPE_DATE:

                            break;

                        case SeColumnDefinition.TYPE_INTEGER:

                            break;

                        case SeColumnDefinition.TYPE_FLOAT:

                            break;

                        case SeColumnDefinition.TYPE_DOUBLE:

                            break;

                        case SeColumnDefinition.TYPE_STRING:

                            // System.out.println(row.getString(colNum));

                            break;

                        case SeColumnDefinition.TYPE_SHAPE:

                            SeShape spVal = row.getShape(colNum);

                            convertSeShapeToGeneralPathX(spVal);

 * Created on 13-may-2005

 *

 * gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 * Copyright (C) 2004 IVER T.I. and Generalitat Valenciana.

 * This program is free software; you can redistribute it and/or

 * modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2

 * of the License, or (at your option) any later version.

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU General Public License for more details.

 * You should have received a copy of the GNU General Public License

 * along with this program; if not, write to the Free Software

 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.

 * For more information, contact:

 *

 *  Generalitat Valenciana

 *      +34 963862235

 *   gvsig@gva.es

 *      www.gvsig.gva.es

 *    or

 *   IVER T.I. S.A

 *   Salamanca 50

 *   46005 Valencia

 *   Spain

 *   +34 963163400

 *   dac@iver.es

 */

import java.awt.geom.Rectangle2D;

import java.io.IOException;

import java.sql.Types;

import java.util.Hashtable;

import java.util.Vector;

import com.esri.sde.sdk.client.SeShapeFilter;

import com.esri.sde.sdk.client.SeSqlConstruct;

import com.esri.sde.sdk.client.SeTable;

import com.hardcode.gdbms.engine.data.edition.DataWare;

import com.hardcode.gdbms.engine.values.Value;

import com.hardcode.gdbms.engine.values.ValueFactory;

import com.iver.cit.gvsig.fmap.DriverException;

import com.iver.cit.gvsig.fmap.core.FShape;

import com.iver.cit.gvsig.fmap.core.IFeature;

import com.iver.cit.gvsig.fmap.core.IGeometry;

import com.iver.cit.gvsig.fmap.drivers.DriverAttributes;

import com.iver.cit.gvsig.fmap.drivers.IFeatureIterator;

    private SeLayer layer;

    private SeQuery query;

    private SeQuery queryAux;

    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 SeConnection conn = null;

    /**

     */

        hashRelate = new Hashtable();

        try {

                System.out.println(" No rows fetched");

                return;

            }

            int index = 0;

                SeShape shpVal = row.getShape(idSpatialColumn);

                SeObjectId objID = shpVal.getFeatureId();

                String theKey = "" + objID.longValue();

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

                row = query.fetch();

                index++;

            numReg = index;

            e.printStackTrace();

        }

    }

    public Rectangle2D getFullExtent() {

    public IGeometry getShape(int index) {

        SeRow row;

        try {

            row = obtainRow(index);

            SeShape spVal = row.getShape(idSpatialColumn);

            IGeometry geom = ArcSdeFeatureIterator.getGeometry(spVal);

            return geom;

        } catch (SeException e) {

            e.printStackTrace();

        }

    }

    public IFeatureIterator getFeatureIterator(String sql)

        return null;

    }

    public IFeatureIterator getFeatureIterator(Rectangle2D r, String strEPSG)

        /*

         *   Generate a rectangular shape that will be used as a filter

         */

        try {

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

            shape.generateRectangle(extent);

            SeShape[] shapes = new SeShape[1];

            shapes[0] = shape;

            /*

             *   Retrieve all the shapes that are contained within the

             *   rectangles envelope.

             */

            SeShapeFilter filter = null;

            filters[0] = filter;

            SeQuery spatialQuery = null;

            spatialQuery = new SeQuery(conn, fields, sqlCons);

            /*

             *   Set spatial constraints

             */

            spatialQuery.prepareQuery();

            spatialQuery.execute();

            return new ArcSdeFeatureIterator(spatialQuery);

        } catch (SeException e) {

            e.printStackTrace();

            return null;

        }

    }

    public void close() {

    }

    public void open() throws DriverException {

    }

    public int getRowIndexByFID(IFeature FID) {

        int resul;

        String strID = FID.getID();

        Integer rowIndex = (Integer) hashRelate.get(strID);

        }

        resul = rowIndex.intValue();

        return resul;

    }

    public DriverAttributes getDriverAttributes() {

        return null;

    }

        return "ArcSDE driver";

    }

    public String[] getFields() {

    public String getTableName() {

        return layer.getName();

    }

            }

        }

    }

        SeRow row;

        Value val = null;

        try {

            int idFieldArcSDE = fieldId + 1; // SIEMPRE CONTANDO CON

            row = obtainRow(rowIndex);

            int dataType = colDefs[idFieldArcSDE].getType();

                String strAux = row.getString(idFieldArcSDE);

            }

            return val;

        } catch (SeException e) {

            e.printStackTrace();

        }

        return ValueFactory.createNullValue();

    }

    }

    }

        return numReg;

    }

        return fieldTypes[i];

    }

    /**

     * @see com.hardcode.gdbms.engine.data.driver.ObjectDriver#getPrimaryKeys()

     */

        throw new UnsupportedOperationException();

    }

    /**

     * @see com.hardcode.gdbms.engine.data.driver.ObjectDriver#write(com.hardcode.gdbms.engine.data.edition.DataWare)

     */