| gvSIG desktop 1

package org.gvsig.data.datastores.vectorial.db.jdbc.h2;

import java.io.IOException;

import java.sql.Connection;

import java.sql.Date;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import java.sql.Statement;

import org.gvsig.data.datastores.vectorial.db.jdbc.h2.H2StoreParameters;

import org.gvsig.data.vectorial.IFeature;

import org.gvsig.data.vectorial.IFeatureAttributeDescriptor;

import org.gvsig.data.vectorial.IFeatureType;

import org.gvsig.data.vectorial.visitor.DefaultFeaturesVisitor;

import org.gvsig.exceptions.BaseException;

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

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

/* 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

 *   Conselleria d'Infraestructures i Transport

 *   Av. Blasco Ib??ez, 50

 *   46010 VALENCIA

 *   SPAIN

 *

 *      +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

 */

/* CVS MESSAGES:

 *

 * $Id$

 * $Log$

 *

 */

/**

 * This visitor is used only to print a feature by console.

 * @author Jorge Piera Llodr? (jorge.piera@iver.es)

 */

public class SHP2H2FeaturesVisitor extends DefaultFeaturesVisitor{

	private IFeatureType featureType;

	private H2StoreParameters h2Params;

	private String tableName;

	private Connection con;

	private static int idUnico=0;

	public SHP2H2FeaturesVisitor(IFeatureType featureType,H2StoreParameters h2Params) {

		super();

		this.featureType = featureType;

		this.h2Params=h2Params;

		this.tableName = h2Params.tableID();

		try {

			Class.forName("org.h2.Driver");

			this.con=DriverManager.getConnection(h2Params.getUrl(), h2Params.getUser(), h2Params.getPassw());

		} catch (ClassNotFoundException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

	public void setTableName(String name){

		this.tableName=name;

	}

	/* (non-Javadoc)

	 * @see org.gvsig.data.vectorial.visitor.DefaultFeaturesVisitor#visit(org.gvsig.data.vectorial.IFeature)

	 */

	public void visit(IFeature feature) throws BaseException {

		WKBParser2 wkbParser = new WKBParser2();

		StringBuffer sb=new StringBuffer();

		sb.append("INSERT INTO ");

		sb.append(this.tableName);

		sb.append(" VALUES (");

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

			sb.append("?, ");

		}

		sb.append("?)");

		PreparedStatement pst=null;

		try{

			pst=con.prepareStatement(sb.toString());

			pst.setInt(1, idUnico++);

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

				IFeatureAttributeDescriptor descriptor = (IFeatureAttributeDescriptor) featureType

				.get(i);

				String type = descriptor.getDataType();

				if (type.equals(IFeatureAttributeDescriptor.TYPE_BOOLEAN)) {

					pst.setBoolean(i+2, feature.getBoolean(i));

				} else if (type.equals(IFeatureAttributeDescriptor.TYPE_BYTE)) {

					pst.setByte(i+2, feature.getByte(i));

				} else if (type.equals(IFeatureAttributeDescriptor.TYPE_DATE)) {

					pst.setDate(i+2, new Date(feature.getDate(i).getTime()));

				} else if (type.equals(IFeatureAttributeDescriptor.TYPE_DOUBLE)) {

					pst.setDouble(i+2, feature.getDouble(i));

				} else if (type.equals(IFeatureAttributeDescriptor.TYPE_FLOAT)) {

					pst.setFloat(i+2, feature.getFloat(i));

				} else if (type.equals(IFeatureAttributeDescriptor.TYPE_INT)) {

					pst.setInt(i+2, feature.getInt(i));

				} else if (type.equals(IFeatureAttributeDescriptor.TYPE_LONG)) {

					pst.setLong(i+2, feature.getLong(i));

				} else if (type.equals(IFeatureAttributeDescriptor.TYPE_STRING)) {

					pst.setString(i+2, feature.getString(i));

				} else if (type.equals(IFeatureAttributeDescriptor.TYPE_GEOMETRY)) {

					pst.setBytes( i+2,  ((IGeometry)feature.getGeometry(i)).toWKB());

				} else {

					System.out.print(" ---- " + "TYPE UNKNOWN");

				}

			}

			pst.execute();

			System.out.println("* Inserted Feature: "+idUnico);

		}

		catch(SQLException except){

			throw new RuntimeException(except);

		}catch(IOException except){

				throw new RuntimeException(except);

		}

	}

	public void createStructure() {

		System.out.println("******* CreateStructure ********");

		StringBuffer sb=new StringBuffer();

		sb.append("CREATE TABLE ");

//		String s=String.valueOf(System.currentTimeMillis());

//		String tableName="TablaPrueba"+s.substring(s.length()-5);

		sb.append(h2Params.tableID());

		sb.append(" (");

		sb.append("id int, ");

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

			IFeatureAttributeDescriptor descriptor=(IFeatureAttributeDescriptor)featureType.get(i);

			String type = descriptor.getDataType();

			if (type.equals(IFeatureAttributeDescriptor.TYPE_BOOLEAN)){

				sb.append(descriptor.getName());

				sb.append(" bit, ");

			}else if (type.equals(IFeatureAttributeDescriptor.TYPE_BYTE)){

				sb.append(descriptor.getName());

				sb.append(" byte, ");

			}else if (type.equals(IFeatureAttributeDescriptor.TYPE_DATE)){

				sb.append(descriptor.getName());

				sb.append(" date, ");

			}else if (type.equals(IFeatureAttributeDescriptor.TYPE_DOUBLE)){

				sb.append(descriptor.getName());

				sb.append(" double, ");

			}else if (type.equals(IFeatureAttributeDescriptor.TYPE_FLOAT)){

				sb.append(descriptor.getName());

				sb.append(" float, ");

			}else if (type.equals(IFeatureAttributeDescriptor.TYPE_INT)){

				sb.append(descriptor.getName());

				sb.append(" int, ");

			}else if (type.equals(IFeatureAttributeDescriptor.TYPE_LONG)){

				sb.append(descriptor.getName());

				sb.append(" bigint, ");

			}else if (type.equals(IFeatureAttributeDescriptor.TYPE_STRING)){

				sb.append(descriptor.getName());

				sb.append(" varchar, ");

			}else if (type.equals(IFeatureAttributeDescriptor.TYPE_GEOMETRY)){

				sb.append(descriptor.getName());

				sb.append(" other, ");

			}else {

				System.out.print(" ---- " + "TYPE UNKNOWN");

			}

		}

		String createTable=sb.toString();

		createTable=createTable.substring(0, createTable.length()-2);

		createTable+=")";

		try{

			Statement st=this.con.createStatement();

			System.out.println("Exec sql:\n"+createTable+"\n\n");

			st.execute(createTable);

			st.close();

		}

		catch(SQLException except){

			throw new RuntimeException(except);

		}

		System.out.println("******* CreateStructure: OK ********");

	}

	public void close(){

		try {

			this.con.close();

		} catch (SQLException e) {

		}

	}

}

package org.gvsig.data.datastores.vectorial.db.jdbc.h2;

import java.io.File;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Iterator;

import junit.framework.TestCase;

import org.gvsig.data.DataSourceManager;

import org.gvsig.data.IDataStoreParameters;

import org.gvsig.data.datastores.vectorial.db.jdbc.JDBCTest;

import org.gvsig.data.datastores.vectorial.db.jdbc.h2.H2Store;

import org.gvsig.data.datastores.vectorial.db.jdbc.h2.H2StoreParameters;

import org.gvsig.data.datastores.vectorial.db.jdbc.h2.Register;

import org.gvsig.data.datastores.vectorial.file.shp.SHPStore;

import org.gvsig.data.datastores.vectorial.file.shp.SHPStoreParameters;

import org.gvsig.data.datastores.vectorial.file.shp.utils.SHP;

import org.gvsig.data.exception.CloseException;

import org.gvsig.data.exception.InitializeException;

import org.gvsig.data.exception.OpenException;

import org.gvsig.data.exception.ReadException;

import org.gvsig.data.exception.WriteException;

import org.gvsig.data.vectorial.Feature;

import org.gvsig.data.vectorial.IFeature;

import org.gvsig.data.vectorial.IFeatureAttributeDescriptor;

import org.gvsig.data.vectorial.IFeatureCollection;

import org.gvsig.data.vectorial.IFeatureStore;

import org.gvsig.data.vectorial.IFeatureType;

import org.gvsig.data.vectorial.visitor.PrintlnFeaturesVisitor;

import org.gvsig.exceptions.BaseException;

import org.h2.tools.Server;

public class H2Test extends JDBCTest {

	private Server h2Server = null;

	private String h2Server_argsTCP[]= {"-baseDir",	"."};

	private File shpfile = new File(H2Test.class.getResource("data/prueba.shp").getFile());

	public static void main(String[] args) {

		junit.textui.TestRunner.run(H2Test.class);

	}

	protected void setUp() throws Exception {

		super.setUp();

		this.startH2Server();

	}

	public void startH2Server(){

		if (h2Server != null)

			throw new RuntimeException("H2 server ya arrancado");

		Server myh2Server = null;

		try{

			myh2Server = Server.createTcpServer(h2Server_argsTCP);

			myh2Server.start();

		} catch (Exception e){

			throw new RuntimeException(e);

		}

		h2Server = myh2Server;

		System.out.println("\n************************");

		System.out.println("* H2 SERVER STARTED!!!! *");

		System.out.println("************************\n");

	}

	public void stopH2Server(){

		if (h2Server == null)

			return;

		h2Server.stop();

		h2Server.shutdown();

		h2Server = null;

		System.out.println("\n************************");

		System.out.println("* H2 SERVER STOPED!!!! *");

		System.out.println("************************\n");

	}

	private void deleteTable(H2StoreParameters h2Params) {

		try {

			Class.forName("org.h2.Driver");

			Connection con=DriverManager.getConnection(h2Params.getUrl(), h2Params.getUser(), h2Params.getPassw());

			Statement st = con.createStatement();

			st.execute("Delete "+ h2Params.tableID());

			st.close();

			con.close();

			System.out.println("* Table " + h2Params.tableID() + " DELETED!!");

		} catch (ClassNotFoundException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		} catch (SQLException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

	public void shp2H2(File shpfile,H2StoreParameters h2Param) {

		System.out.println("======= SHP2H2 ==============");

		org.gvsig.data.datastores.vectorial.file.shp.Register.selfRegister();

		org.gvsig.data.datastores.vectorial.file.dbf.Register.selfRegister();

		DataSourceManager dsm=DataSourceManager.getManager();

//		File shpfile= new File(DataStoreTest.class.getResource("data/prueba.dbf").getFile());

//		IDriverParameters dp=dsm.createDriverParameters("shp");

		IDataStoreParameters dsp=dsm.createDataStoreParameters(SHPStore.DATASTORE_NAME);

		((SHPStoreParameters)dsp).setSHPFile(shpfile);

		((SHPStoreParameters)dsp).setSHXFile(SHP.getShxFile(shpfile));

		((SHPStoreParameters)dsp).setDBFFile(SHP.getDbfFile(shpfile));

		IFeatureStore fs=null;

		try {

			fs = (IFeatureStore)dsm.createDataStore(dsp);

		} catch (InitializeException e) {

			e.printStackTrace();

			fail("Exception:" + e);

		}

		try {

			fs.open();

		} catch (OpenException e2) {

			e2.printStackTrace();

			fail();

		}

		IFeatureType ft= fs.getDefaultFeatureType();

		IFeatureCollection featureCollection=null;

		try {

			featureCollection = (IFeatureCollection)fs.getDataCollection();

		} catch (ReadException e2) {

			// TODO Auto-generated catch block

			e2.printStackTrace();

		}

		SHP2H2FeaturesVisitor visitor=new SHP2H2FeaturesVisitor(ft,h2Param);

		visitor.createStructure();

		try {

			featureCollection.accept(visitor);

		} catch (BaseException e1) {

			e1.printStackTrace();

			System.out.println(e1.getMessageStack());

			fail();

		}

		try {

			visitor.close();

			fs.close();

		} catch (CloseException e) {

			e.printStackTrace();

			fail("Exception: "+e);

		}

		try {

			fs.dispose();

		} catch (CloseException e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

	public void testH2_sqlMode() {

		System.out.println("======= H2 (sql Mode)==============");

		Register.selfRegister();

		DataSourceManager dsm=DataSourceManager.getManager();

		H2StoreParameters dp=(H2StoreParameters)dsm.createDataStoreParameters(H2Store.DATASTORE_NAME);

		dp.setHost("localhost");

		dp.setUser("SA");

		dp.setPassw("");

		dp.setFields(new String[] {"*"});

		dp.setGeometryField("GEOMETRY");

		String s=String.valueOf(System.currentTimeMillis());

		String tableName="TablaPrueba"+s.substring(s.length()-8);

		dp.setTableName(tableName.toUpperCase());

		dp.setFieldId(new String[] {"ID"});

		try{

			this.shp2H2(shpfile, dp);

		} catch (Exception e) {

			if (e.getCause() instanceof BaseException){

				System.out.println(((BaseException)e).getLocalizedMessageStack());

			} else{

				e.printStackTrace();

			}

			fail();

		}

		H2StoreParameters dp2=(H2StoreParameters)dsm.createDataStoreParameters(H2Store.DATASTORE_NAME);

		dp2.setHost("localhost");

		dp2.setUser("SA");

		dp2.setPassw("");

		dp2.setGeometryField("GEOMETRY");

		dp2.setFieldId(new String[] {"ID"});

		dp2.setSqlSoure("Select * from " + dp.tableID() );

		storeTest((IDataStoreParameters)dp,null,null,false);

		Exception exc = null;

		IFeatureStore fs=null;

		try {

			fs = (IFeatureStore)dsm.createDataStore(dp2);

		} catch (InitializeException e) {

			e.printStackTrace();

			fail("Exception:" + e);

		}

		assertNotNull("Can't create Feature Store", fs);

		try {

			fs.open();

		} catch (OpenException e2) {

			e2.printStackTrace();

			fail();

		}

		Iterator it;

		IFeatureCollection fc =null;

		try {

			fc = (IFeatureCollection)fs.getDataCollection();

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(9, fc.size());

		assertFalse("Edition allowed in sqlSource mode", fs.isEditable());

		try {

			fs.startEditing();

		} catch (ReadException e1) {

			exc=e1;

		}

		assertNotNull("Edition allowed in sqlSource mode",exc);

		exc=null;

		try {

			fc = (IFeatureCollection)fs.getDataCollection(null,"NOMBRE like 'B%'",null);

		} catch (ReadException e1) {

			exc=e1;

		}

		assertNotNull("Filter allowed in sqlSource mode",exc);

		exc=null;

		try {

			fc = (IFeatureCollection)fs.getDataCollection(null,null,"NOMBRE");

		} catch (ReadException e1) {

			exc=e1;

		}

		assertNotNull("Order allowed in sqlSource mode",exc);

		try {

			fs.close();

		} catch (CloseException e) {

			e.printStackTrace();

			fail("Exception:" + e);

		}

		deleteTable(dp);

		System.out.println("======= /H2 (sql Mode) ==============");

	}

	public void testH2() {

		System.out.println("======= H2 ==============");

		Register.selfRegister();

		DataSourceManager dsm=DataSourceManager.getManager();

		H2StoreParameters dp=(H2StoreParameters)dsm.createDataStoreParameters(H2Store.DATASTORE_NAME);

		dp.setHost("localhost");

		dp.setUser("SA");

		dp.setPassw("");

		dp.setFields(new String[] {"*"});

		dp.setGeometryField("GEOMETRY");

		String s=String.valueOf(System.currentTimeMillis());

		String tableName="TablaPrueba"+s.substring(s.length()-8);

		dp.setTableName(tableName.toUpperCase());

		dp.setFieldId(new String[] {"ID"});

		try{

			this.shp2H2(shpfile, dp);

		} catch (Exception e) {

			if (e.getCause() instanceof BaseException){

				System.out.println(((BaseException)e).getLocalizedMessageStack());

			} else{

				e.printStackTrace();

			}

			fail();

		}

		storeTest((IDataStoreParameters)dp,null,null,true);

		IFeatureStore fs=null;

		try {

			fs = (IFeatureStore)dsm.createDataStore(dp);

		} catch (InitializeException e) {

			e.printStackTrace();

			fail("Exception:" + e);

		}

		assertNotNull("Can't create Feature Store", fs);

		try {

			fs.open();

		} catch (OpenException e2) {

			e2.printStackTrace();

			fail();

		}

		Iterator it;

		IFeatureCollection fc =null;

		Comparable v1,v2;

		IFeature feature,pfeature;

		long count;

		try {

			fc = (IFeatureCollection)fs.getDataCollection();

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(9, fc.size());

		try {

			fc = (IFeatureCollection)fs.getDataCollection(null,"lower(NOMBRE) like 'b%'",null);

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(2, fc.size());

		it = fc.iterator();

		count=0;

		while (it.hasNext()){

			feature = (IFeature)it.next();

			assertTrue("Filter error",feature.getString("NOMBRE").toLowerCase().startsWith("b"));

			count++;

		}

		assertEquals("Iteration error",2,count);

		try {

			fc = (IFeatureCollection)fs.getDataCollection(null,null,"NOMBRE ASC");

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(9, fc.size());

		it = fc.iterator();

		count=0;

		pfeature = (IFeature)it.next();

		count++;

		while (it.hasNext()){

			feature = (IFeature)it.next();

			v1 = (Comparable)pfeature.get("NOMBRE");

			v2 = (Comparable)feature.get("NOMBRE");

			pfeature=feature;

			assertTrue("Short error", (v1.compareTo(v1) <= 0));

			count++;

		}

		assertEquals("Iteration error",9,count);

		try {

			fc = (IFeatureCollection)fs.getDataCollection(null,null,"NOMBRE DESC");

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(9, fc.size());

		it = fc.iterator();

		count=0;

		pfeature = (IFeature)it.next();

		count++;

		while (it.hasNext()){

			feature = (IFeature)it.next();

			v1 = (Comparable)pfeature.get("NOMBRE");

			v2 = (Comparable)feature.get("NOMBRE");

			pfeature=feature;

			assertTrue("Short error", (v1.compareTo(v1) >= 0));

			count++;

		}

		assertEquals("Iteration error",9,count);

		try {

			fc = (IFeatureCollection)fs.getDataCollection(null,"lower(NOMBRE) like 'b%'","NOMBRE");

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(2, fc.size());

		it = fc.iterator();

		count=0;

		pfeature = (IFeature)it.next();

		assertTrue(pfeature.getString("NOMBRE").toLowerCase().startsWith("b"));

		count++;

		while (it.hasNext()){

			feature = (IFeature)it.next();

			assertTrue("Filter error",feature.getString("NOMBRE").toLowerCase().startsWith("b"));

			v1 = (Comparable)pfeature.get("NOMBRE");

			v2 = (Comparable)feature.get("NOMBRE");

			pfeature=feature;

			assertTrue("Short error", (v1.compareTo(v1) <= 0));

			count++;

		}

		assertEquals("Iteration error",2,count);

		try {

			fc = (IFeatureCollection)fs.getDataCollection(null,null,"Tipo,lower(NOMBRE) Desc");

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(9, fc.size());

		it = fc.iterator();

		count=0;

		pfeature = (IFeature)it.next();

		System.out.println(pfeature.getString("NOMBRE"));

		count++;

		while (it.hasNext()){

			feature = (IFeature)it.next();

			v1 = (Comparable)((String)pfeature.get("NOMBRE")).toLowerCase();

			v2 = (Comparable)((String)feature.get("NOMBRE")).toLowerCase();

			pfeature=feature;

			assertTrue("Short error", (v1.compareTo(v2) >= 0));

			System.out.println(pfeature.getString("NOMBRE"));

			count++;

		}

		assertEquals("Iteration error",9,count);

		/// CON  EDICION

		try {

			fs.startEditing();

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		IFeature newFeature = fs.createFeature(fs.getDefaultFeatureType());

		newFeature.set("NOMBRE","BuRjaSOT");

		newFeature.set("TIPO","MUNICIPIO");

		fs.insert(newFeature);

		try {

			fc = (IFeatureCollection)fs.getDataCollection();

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(10, fc.size());

		try {

			fc = (IFeatureCollection)fs.getDataCollection(null,"lower(NOMBRE) like 'b%'",null);

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(3, fc.size());

		it = fc.iterator();

		count=0;

		while (it.hasNext()){

			feature = (IFeature)it.next();

			assertTrue("Filter error",feature.getString("NOMBRE").toLowerCase().startsWith("b"));

			count++;

		}

		assertEquals("Iteration error",3,count);

		try {

			fc = (IFeatureCollection)fs.getDataCollection(null,null,"NOMBRE ASC");

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(10, fc.size());

		it = fc.iterator();

		count=0;

		pfeature = (IFeature)it.next();

		count++;

		while (it.hasNext()){

			feature = (IFeature)it.next();

			v1 = (Comparable)pfeature.get("NOMBRE");

			v2 = (Comparable)feature.get("NOMBRE");

			pfeature=feature;

			assertTrue("Short error", (v1.compareTo(v1) <= 0));

			count++;

		}

		assertEquals("Iteration error",10,count);

		try {

			fc = (IFeatureCollection)fs.getDataCollection(null,null,"NOMBRE DESC");

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(10, fc.size());

		it = fc.iterator();

		count=0;

		pfeature = (IFeature)it.next();

		count++;

		while (it.hasNext()){

			feature = (IFeature)it.next();

			v1 = (Comparable)pfeature.get("NOMBRE");

			v2 = (Comparable)feature.get("NOMBRE");

			pfeature=feature;

			assertTrue("Short error", (v1.compareTo(v1) >= 0));

			count++;

		}

		assertEquals("Iteration error",10,count);

		try {

			fc = (IFeatureCollection)fs.getDataCollection(null,"lower(NOMBRE) like 'b%'","NOMBRE");

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(3, fc.size());

		it = fc.iterator();

		count=0;

		pfeature = (IFeature)it.next();

		assertTrue(pfeature.getString("NOMBRE").toLowerCase().startsWith("b"));

		count++;

		while (it.hasNext()){

			feature = (IFeature)it.next();

			assertTrue("Filter error",feature.getString("NOMBRE").toLowerCase().startsWith("b"));

			v1 = (Comparable)pfeature.get("NOMBRE");

			v2 = (Comparable)feature.get("NOMBRE");

			pfeature=feature;

			assertTrue("Short error", (v1.compareTo(v1) <= 0));

			count++;

		}

		assertEquals("Iteration error",3,count);

		try {

			fc = (IFeatureCollection)fs.getDataCollection(null,null,"Tipo,lower(NOMBRE) Desc");

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(10, fc.size());

		it = fc.iterator();

		count=0;

		pfeature = (IFeature)it.next();

		System.out.println(pfeature.getString("NOMBRE"));

		count++;

		while (it.hasNext()){

			feature = (IFeature)it.next();

			v1 = (Comparable)((String)pfeature.get("NOMBRE")).toLowerCase();

			v2 = (Comparable)((String)feature.get("NOMBRE")).toLowerCase();

			pfeature=feature;

			assertTrue("Short error", (v1.compareTo(v2) >= 0));

			System.out.println(pfeature.getString("NOMBRE"));

			count++;

		}

		assertEquals("Iteration error",10,count);

		fs.cancelEditing();

		//Insertar un elemento

		try{

			fs.startEditing();

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		feature = fs.createDefaultFeature(true);

		feature.set("ID", 90000);

		feature.set("NOMBRE","BurJASOT");

		feature.set("TIPO", "OTRO");

		fs.insert(feature);

		try {

			fs.finishEditing();

		} catch (WriteException e) {

			e.printStackTrace();

			fail("Exception: "+e);

		} catch (ReadException e) {

			e.printStackTrace();

			fail("Exception: "+e);

		}

		try {

			fc = (IFeatureCollection)fs.getDataCollection(null,null,"lower(NOMBRE) Desc");

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(10, fc.size());

		it = fc.iterator();

		count=0;

		pfeature = (IFeature)it.next();

		System.out.println(pfeature.getString("NOMBRE"));

		count++;

		while (it.hasNext()){

			feature = (IFeature)it.next();

			v1 = (Comparable)((String)pfeature.get("NOMBRE")).toLowerCase();

			v2 = (Comparable)((String)feature.get("NOMBRE")).toLowerCase();

			pfeature=feature;

			assertTrue("Short error: "+ v1.toString() + " >= " +v2.toString(), (v1.compareTo(v2) >= 0));

			System.out.println(pfeature.getString("NOMBRE"));

			count++;

		}

		assertEquals("Iteration error",10,count);

		//Actualizacion

		try{

			fs.startEditing();

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		try {

			fc = (IFeatureCollection)fs.getDataCollection(null,"lower(NOMBRE) = 'burjasot'",null);

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(1, fc.size());

		Feature old =(Feature)fc.iterator().next();

		feature = fs.createDefaultFeature(false);

		it = fs.getDefaultFeatureType().iterator();

		IFeatureAttributeDescriptor attr;

		while(it.hasNext()){

			 attr = (IFeatureAttributeDescriptor)it.next();

//			 if (attr.getDataType() == IFeatureAttributeDescriptor.TYPE_GEOMETRY){

//				 feature.set(attr.getName(), old.get(attr.getName()));

//			 } else {

				 feature.set(attr.getName(), old.get(attr.getName()));

//			 }

		}

		feature.set("NOMBRE", feature.getString("NOMBRE")+"__KK__");

		fs.update(feature, old);

		try {

			fs.finishEditing();

		} catch (WriteException e) {

			e.printStackTrace();

			fail("Exception: "+e);

		} catch (ReadException e) {

			e.printStackTrace();

			fail("Exception: "+e);

		}

		try {

			fc = (IFeatureCollection)fs.getDataCollection(null,"NOMBRE like '%__KK__'",null);

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(1, fc.size());

		//Eliminacion

		try{

			fs.startEditing();

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		try {

			fc = (IFeatureCollection)fs.getDataCollection(null,"NOMBRE like '%__KK__'",null);

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(1, fc.size());

		fs.delete((IFeature)fc.iterator().next());

		try {

			fs.finishEditing();

		} catch (WriteException e) {

			e.printStackTrace();

			fail("Exception: "+e);

		} catch (ReadException e) {

			e.printStackTrace();

			fail("Exception: "+e);

		}

		try {

			fc = (IFeatureCollection)fs.getDataCollection();

		} catch (ReadException e1) {

			e1.printStackTrace();

			fail();

		}

		assertEquals(9, fc.size());

		try {

			fs.close();

		} catch (CloseException e) {

			e.printStackTrace();

			fail("Exception:" + e);

		}

		deleteTable(dp);

		System.out.println("======= /H2 ==============");

	}

	protected void tearDown() throws Exception {

		// TODO Auto-generated method stub

		super.tearDown();

		this.stopH2Server();

	}

}