| gvSIG desktop 1

import com.hardcode.gdbms.engine.data.DataSource;

import com.hardcode.gdbms.engine.data.NoSuchTableException;

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

import com.hardcode.gdbms.engine.instruction.TableNotFoundException;

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

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

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

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

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

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

import com.iver.utiles.StringUtilities;

//import org.hsqldb.lib.StringUtil;

import java.io.IOException;

import java.sql.Types;

	 */

	public static FLayer createWFSLayer(String layerName,WFSDriver driver, URL host,

		//throw new UnsupportedOperationException();

		FLyrVect layer=new FLyrVect();

		//layer.setName(name);

		VectorialAdapter adapter=new WFSAdapter();

		adapter.setDriver(driver);

		//WithDefaultLegend aux=(WithDefaultLegend)driver;

		layer.setName(layerName);

		layer.setSource(adapter);

		layer.setProjection(proj);

		try {

			layer.setLegend(LegendFactory.createSingleSymbolLegend(

					layer.getShapeType()));

		} catch (FieldNotFoundException e) {

			e.printStackTrace();

		} catch (DriverException e) {

			e.printStackTrace();

		}

		//layer.setHost(host);

		return layer;

    public static FLayer createArcSDELayer(String layerName,ArcSdeDriver driver, IProjection proj) {

            //throw new UnsupportedOperationException();

            FLyrVect layer=new FLyrVect();

            VectorialAdapter adapter=new VectorialDBAdapter();

            adapter.setDriver(driver);

            layer.setName(layerName);

            layer.setSource(adapter);

            layer.setProjection(proj);

            try {

                if (driver instanceof WithDefaultLegend) {

                    WithDefaultLegend aux = (WithDefaultLegend) driver;

                    adapter.start();

                    layer.setLegend((VectorialLegend) aux.getDefaultLegend());

                    adapter.stop();

                } else { 

                    layer.setLegend(LegendFactory.createSingleSymbolLegend(

                            layer.getShapeType()));

                }

            } catch (FieldNotFoundException e) {

                throw new UnsupportedOperationException(e.getMessage());

            } catch (DriverIOException e) {

                throw new UnsupportedOperationException(e.getMessage());

            } catch (DriverException e) {

                // TODO Auto-generated catch block

                e.printStackTrace();

            }

            try {

                layer.setLegend(LegendFactory.createSingleSymbolLegend(

                        layer.getShapeType()));

            } catch (FieldNotFoundException e) {

                e.printStackTrace();

            } catch (DriverException e) {

                e.printStackTrace();

            }

            return layer;

        }

	/**

	 * @param driver

	 * @param layerName

	 * @param object

	 * @return

	 * @throws SQLException

	 * @throws DriverIOException

	 * @throws IOException

	 * @throws DriverLoadException

	 * @throws com.hardcode.gdbms.engine.data.driver.DriverException

	 * @throws NoSuchTableException

	 * @throws ClassNotFoundException

	 * @throws 

	 */

	public static FLayer createDisconnectedDBLayer(VectorialJDBCDriver driver, String layerName, IProjection proj, ProgressListener listener) throws SQLException, IOException, DriverIOException, DriverLoadException, NoSuchTableException, com.hardcode.gdbms.engine.data.driver.DriverException, ClassNotFoundException {

	    VectorialDisconnectedDBAdapter dbAdapter = new VectorialDisconnectedDBAdapter();

	    dbAdapter.setDriver(driver);

	    DataSource ds = dbAdapter.getRecordset();

	    ds.start();

	    String database = dataSourceFactory.getTempFile();

	    String[] fieldNames = new String[ds.getFieldCount() + 1];

	    System.arraycopy(ds.getFieldNames(), 0, fieldNames, 1, ds.getFieldCount());

	    fieldNames[0] = "the_geom";

	    int[] types = new int[fieldNames.length];

	    types[0] = Types.BINARY;

	    for (int i = 1; i < types.length; i++) {

            types[i] = ds.getFieldType(i-1);

        }

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

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

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

	    local.start();

	    DataWare dw = local.getDataSourceFactory().createDataWare(local, DataSourceFactory.DATA_WARE_COHERENT_ROW_ORDER);

	    dw.start();

	    long t1 = System.currentTimeMillis();

	    dw.beginTrans();

	    if (listener == null){

	        listener = new ProgressListener() {

                /**

                 * @see com.iver.cit.gvsig.fmap.ProgressListener#progress(int)

                 */

                public void progress(int n) {

                    //do nothing

                }

            };

	    }

	    for (int i = 0; i < dbAdapter.getShapeCount(); i++) {

	        Value[] row = new Value[ds.getFieldCount() + 1];

	        byte[] bytes = dbAdapter.getShape(i).toWKB();

	        row[0] = ValueFactory.createValue(bytes);

	        for (int j = 0; j < ds.getFieldCount(); j++) {

	            row[j+1] = ds.getFieldValue(i, j);                

            }

	        dw.insertFilledRow(row);

	        listener.progress(100 * i / dbAdapter.getShapeCount());

        }

	    long t2 = System.currentTimeMillis();

	    dw.commitTrans();

	    long t3 = System.currentTimeMillis();

	    System.out.println((t2 - t1) + " - " + (t3 - t2));

	    dw.stop();

	    local.stop();

	    ds.stop();

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

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

	    cacheDriver.setData(java.sql.DriverManager.getConnection("jdbc:hsqldb:file:" + database, "sa", ""), dsName, StringUtilities.getComaSeparated(local.getFieldNames()), "", local.getPrimaryKeys()[0]+1);

	    cacheDriver.setWorkingArea(driver.getWorkingArea());

        return createDBLayer(cacheDriver, layerName, proj);

	}

				logger.error("", failures[i]);

			getDataSourceFactory().initialize();