Application: gvSIG desktop

    private static Hashtable poolPassw = new Hashtable();

    protected Connection conn;

    protected ResultSet rs;

    protected boolean bCursorActivo = false;

    protected Statement st;

    protected int numReg=-1;

    protected Hashtable hashRelate;

    protected ResultSetMetaData metaData = null;

    protected Rectangle2D workingArea;

	/**

	 * @return devuelve la Conexi?n a la base de datos, para que 

	}

	public String[] getFields()

	{

        String[] arrayFields = new String[tokenizer.countTokens()];

        int i=0;

        while (tokenizer.hasMoreTokens())

            arrayFields[i] = tokenizer.nextToken();

            i++;

        }

	}

	public String getWhereClause()

	{

	}

	public String getTableName()

	{

	}

	    	    try

	            {

	    	        Statement s = conn.createStatement();	            

		            r.next();

		            numReg = r.getInt(1);

		            System.err.println("numReg = " + numReg);

            while (rs.next())

            {

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

                index++;

            }

    public int getRowIndexByFID(IFeature FID)

    {

        int resul;

        // System.err.println("Mirando si existe " + obj.toString());

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

        resul = rowIndex.intValue();

    {

        String className = xml.getStringProperty("className");

        String dbUrl = xml.getStringProperty("dbURL");

        String userName =xml.getStringProperty("username");

        String driverClass =xml.getStringProperty("driverclass");     

        String tableName = xml.getStringProperty("tablename");

        int idFIDfield = xml.getIntProperty("FID");

        String whereClause = xml.getStringProperty("whereclause");

        try {            

            Class.forName(driverClass);

            newConn = DriverManager.getConnection(dbUrl, userName, clave);

            newConn.setAutoCommit(false);

        } catch (ClassNotFoundException e) {

            logger.debug(e);

            throw new XMLException(e); 

        try {

            DatabaseMetaData metadata = getConnection().getMetaData();

            xml.putProperty("dbURL", metadata.getURL());

            // TODO: NO DEBEMOS GUARDAR EL NOMBRE DE USUARIO Y CONTRASE?A

            // AQUI. Hay que utilizar un pool de conexiones

            // y pedir al usuario que conecte a la base de datos

            xml.putProperty("driverclass", drv.getClass().getName());

            xml.putProperty("tablename", getTableName());

            xml.putProperty("whereclause", getWhereClause());

        } catch (SQLException e) {

            // TODO Auto-generated catch block

        // TODO Auto-generated method stub

    }

}

public interface VectorialJDBCDriver extends  VectorialDatabaseDriver {

    /**

     * @param conn

     * @param id_FID_field El identificador del campo que contiene una clave ?nica. 1=> primer campo, 2 => segundo campo, etc

     * 

     */

    public Connection getConnection();

    public IFeatureIterator getFeatureIterator(String sql) throws DriverException;

	public String getConnectionStringBeginning();

    private String whereClause;

    private Rectangle2D workingArea;

    private String SRID_EPSG;

    // private int idFieldGeometry = -1;

    private int idFieldID = -1;

    public void setTableName(String tableName) {

        this.tableName = tableName;

    }

    public String getWhereClause() {

        return whereClause;

    }

    public void setSRID_EPSG(String srid_epsg) {

        SRID_EPSG = srid_epsg;

    }

}

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

import com.iver.cit.gvsig.fmap.layers.FBitSet;

import com.iver.cit.gvsig.fmap.layers.FLayer;

import com.iver.cit.gvsig.fmap.layers.VectorialDBAdapter;

import com.iver.cit.gvsig.fmap.layers.layerOperations.ClassifiableVectorial;

import com.iver.cit.gvsig.fmap.layers.layerOperations.Selectable;

    public void draw(BufferedImage image, Graphics2D g, ViewPort viewPort, Cancellable cancel) throws DriverException {

        // Nos aprovechamos del SQL para lanzar la consulta

        // teniendo en cuenta el boundingbox que toca.

        VectorialDBAdapter dbAdapter = (VectorialDBAdapter) ((SingleLayer) capa).getSource();

        VectorialDatabaseDriver dbDriver = (VectorialDatabaseDriver) dbAdapter.getDriver();

        dbAdapter.start();

		FBitSet bitSet = selection.getSelection();

        String strEPSG = viewPort.getProjection().getAbrev().substring(5);

        // con todos los campos de Vias: 11 segundos.

        // => MODIFICAR EL getFeatureIterator para que admita los nombres

        // de los campos adem?s del rect?ngulo que pides.

        Rectangle2D rectAux = viewPort.getAdjustedExtent();

        if (ct != null) {

            ICoordTrans invertedCT = ct.getInverted();

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

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

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

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

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

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

import com.iver.cit.gvsig.fmap.operations.arcview.ArcJoin;

import com.iver.cit.gvsig.fmap.rendering.LegendFactory;

import com.iver.cit.gvsig.fmap.rendering.VectorialLegend;

/**

        }

	    String dsName = dataSourceFactory.createTable(database, ds.getPKNames(), fieldNames, types);

	    dataSourceFactory.addDBDataSourceByTable(dsName, null, 0, "sa", "", database, dsName, "GDBMS HSQLDB Transactional driver");

	    DataSource local = dataSourceFactory.createRandomDataSource(dsName, DataSourceFactory.MANUAL_OPENING);

	    local.start();

	    VectorialJDBCDriver cacheDriver = (VectorialJDBCDriver) LayerFactory.getDM().getDriver("HSQLDB Driver");

        Class.forName("org.hsqldb.jdbcDriver");

	    cacheDriver.setWorkingArea(driver.getWorkingArea());

        return createDBLayer(cacheDriver, layerName, proj);

	}