| gvSIG desktop 1

package com.iver.cit.gvsig.sde;

import java.sql.ResultSet;

import junit.framework.TestCase;

import com.hardcode.gdbms.engine.data.driver.DriverException;

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

import com.iver.cit.gvsig.fmap.drivers.sde.ArcSdeDriver;

import com.iver.cit.gvsig.fmap.drivers.sde.ArcSDELayerDefinition;

public class SDETest extends TestCase {

        ArcSdeDriver driver = new ArcSdeDriver();

        ResultSet rsGood = null;

        protected void setUp() throws Exception {

                super.setUp();

                try {

                        ArcSDELayerDefinition lyrDef = new ArcSDELayerDefinition();

                        lyrDef.setUser("sde");

                        lyrDef.setPassword("iver");

                        lyrDef.setHost("192.168.0.114");

                        lyrDef.setPort("5151");

                        lyrDef.setName("EJES");

                        lyrDef.setTableName("EJES");

                        lyrDef.setSchema("ProvinciasPruebas");

                        lyrDef.setFieldGeometry("SHAPE");

                        lyrDef.setFieldID("OBJECTID");

                        lyrDef.setWhereClause("");

                        lyrDef.setFieldNames(new String[] {"OBJECTID","ID","REFERINE","CALLE_ID","DESDEPAR","HASTAPAR","DESDEIMPAR","HASTAIMPAR"});

                        lyrDef.setSRID_EPSG("23030");

                lyrDef.setConnectionName("NOMBRE CONEXI?N");

                        driver.setData(null, lyrDef);

                }

                catch (Exception e){

                        e.printStackTrace();

                }

        }

        protected void tearDown() throws Exception {

                super.tearDown();

                driver.close();

        }

        public void testGetFieldValue() {

                try {

                        for (int i=0; i < 15; i++){

                                //String aux = driver.getFieldValue(i, 0).toString();

                                int id = ((NumericValue) driver.getFieldValue(i, 0)).intValue();

                                System.out.println(id);

                                assertEquals(id,i+1);

                        }

                } catch (DriverException e) {

                        e.printStackTrace();

                }

        }

}