Application: gvSIG desktop

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

  <modelVersion>4.0.0</modelVersion>

  <artifactId>org.gvsig.fmap.dal.db</artifactId>

  <name>${project.artifactId}</name>

  <packaging>pom</packaging>

  <parent>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.fmap.dal</artifactId>

      <version>2.0.127</version>

  </parent>  

  <modules>

    <module>org.gvsig.fmap.dal.db.lib</module>

    <module>org.gvsig.fmap.dal.db.jdbc</module>

    <module>org.gvsig.fmap.dal.db.h2</module>

  </modules>

  <description>This library has the implementation of the provider of te Data Access Library for accesing to database resources, like JDBC, PostgreSQL or H2.</description>

</project>

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

  <modelVersion>4.0.0</modelVersion>

  <artifactId>org.gvsig.fmap.dal.db.jdbc</artifactId>

  <name>${project.artifactId}</name>

  <parent>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.fmap.dal.db</artifactId>

      <version>2.0.127</version>

  </parent>  

  <dependencies>

    <dependency>

      <groupId>org.gvsig</groupId>

      <artifactId>org.gvsig.tools.lib</artifactId>

      <scope>compile</scope>

    </dependency>

    <dependency>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.fmap.dal.api</artifactId>

        <scope>compile</scope>

    </dependency>

    <dependency>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.fmap.dal.spi</artifactId>

        <scope>compile</scope>

    </dependency>

    <dependency>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.fmap.dal.db.lib</artifactId>

        <scope>compile</scope>

    </dependency>

    <dependency>

        <groupId>commons-dbcp</groupId>

        <artifactId>commons-dbcp</artifactId>

        <scope>compile</scope>

    </dependency>

    <!-- Tests -->

    <dependency>

        <groupId>org.gvsig</groupId>

        <artifactId>org.gvsig.fmap.dal.impl</artifactId>

        <type>test-jar</type>

        <scope>test</scope>

    </dependency>

    <dependency>

        <groupId>mysql</groupId>

        <artifactId>mysql-connector-java</artifactId>

        <scope>test</scope>

    </dependency>

  </dependencies>

  <build>

    <plugins>

      <plugin>

        <groupId>org.apache.maven.plugins</groupId>

        <artifactId>maven-surefire-plugin</artifactId>

        <configuration>

          <skipTests>true</skipTests>

        </configuration>

      </plugin>

      <plugin>

        <groupId>org.apache.maven.plugins</groupId>

        <artifactId>maven-compiler-plugin</artifactId>

        <executions>

          <execution>

            <id>default-testCompile</id>

            <phase>process-test-sources</phase>

            <goals>

              <goal>testCompile</goal>

            </goals>

            <configuration>

              <skip>true</skip>

            </configuration>

          </execution>

        </executions>

      </plugin>

    </plugins>

  </build>

</project>

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

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

 * 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., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.fmap.dal.store.jdbc;

import org.gvsig.fmap.dal.DataStoreParameters;

import org.gvsig.fmap.dal.exception.DataException;

import org.gvsig.fmap.dal.feature.BaseTestEditableFeatureStore;

import org.gvsig.fmap.dal.feature.EditableFeature;

import org.gvsig.fmap.dal.feature.EditableFeatureType;

import org.gvsig.fmap.dal.feature.FeatureStore;

import org.gvsig.fmap.dal.feature.FeatureType;

import org.gvsig.fmap.dal.feature.NewFeatureStoreParameters;

import com.mysql.jdbc.Driver;

public class JDBCTestWrite extends BaseTestEditableFeatureStore {

	private JDBCNewStoreParameters newParams;

	private JDBCServerExplorer myExplorer;

	private int newId = 50000;

	public void fillPrimaryKeyInserFeature(EditableFeature feature) {

		feature.set("id", newId);

		newId++;

	}

	@Override

	protected void doSetUp() throws Exception {

		// Nothing to do	

	}

	public DataStoreParameters getDefaultDataStoreParameters()

			throws DataException {

		JDBCStoreParameters parameters = null;

		parameters = (JDBCStoreParameters) dataManager

				.createStoreParameters(JDBCStoreProvider.NAME);

		parameters.setHost("localhost");

		parameters.setPort(3306);

		parameters.setUser("test");

		parameters.setPassword("test");

		parameters.setDBName("gis");

		parameters.setTable("alfanum");

		parameters.setUrl("jdbc:mysql://" + parameters.getHost() + ":"

				+ parameters.getPort() + "/" + parameters.getDBName());

		parameters.setJDBCDriverClassName(Driver.class.getName());

		return parameters;

	}

	/*

	 * (non-Javadoc)

	 *

	 * @see org.gvsig.fmap.dal.feature.BaseTestFeatureStore#hasExplorer()

	 */

	@Override

	public boolean hasExplorer() {

		// TODO Auto-generated method stub

		return true;

	}

	/*

	 * (non-Javadoc)

	 *

	 * @see org.gvsig.fmap.dal.feature.BaseTestFeatureStore#usesResources()

	 */

	@Override

	public boolean usesResources() {

		// TODO Auto-generated method stub

		return true;

	}

	/*

	public void testImportDB() throws Exception {

		JDBCNewStoreParameters newParasm = (JDBCNewStoreParameters) getDefaultNewDataStoreParameters();

		JDBCServerExplorerParameters seParams = (JDBCServerExplorerParameters) dataManager

				.createServerExplorerParameters(JDBCServerExplorer.NAME);

		assertTrue(myExplorer.add(newParasm, true));

		FeatureStore store = (FeatureStore) dataManager

				.createStore(getDefaultDataStoreParameters());

		FeatureStore newstore = (FeatureStore) dataManager

				.createStore(newParasm);

		newstore.edit(FeatureStore.MODE_APPEND);

		FeatureSet set = store.getFeatureSet();

		DisposableIterator iter = set.iterator();

		Feature org;

		EditableFeature trg;

		Iterator attrIter;

		FeatureAttributeDescriptor attr;

		while (iter.hasNext()) {

			org = (Feature) iter.next();

			trg = newstore.createNewFeature(false);

			attrIter = trg.getType().iterator();

			while (attrIter.hasNext()) {

				attr = (FeatureAttributeDescriptor) attrIter.next();

				trg.set(attr.getName(), org.get(attr.getName()));

			}

			newstore.insert(trg);

		}

		newstore.finishEditing();

		iter.dispose();

		set.dispose();

		store.dispose();

		newstore.dispose();

	}

	*/

	@Override

	public NewFeatureStoreParameters getDefaultNewDataStoreParameters()

			throws Exception {

		JDBCStoreParameters params = (JDBCStoreParameters) getDefaultDataStoreParameters();

		if (this.myExplorer == null) {

			JDBCServerExplorerParameters seParameters = null;

			seParameters = (JDBCServerExplorerParameters) dataManager

					.createServerExplorerParameters(JDBCServerExplorer.NAME);

			seParameters.setHost("localhost");

			seParameters.setPort(3306);

			seParameters.setUser("test");

			seParameters.setPassword("test");

			seParameters.setDBName("gis");

			seParameters.setUrl("jdbc:mysql://" + seParameters.getHost() + ":"

					+ seParameters.getPort() + "/" + seParameters.getDBName());

			seParameters.setJDBCDriverClassName(Driver.class.getName());

			myExplorer = (JDBCServerExplorer) dataManager

					.createServerExplorer(seParameters);

		}

		if (this.newParams == null) {

			FeatureStore store = (FeatureStore) dataManager.createStore(params);

			newParams = (JDBCNewStoreParameters) myExplorer

					.getAddParameters();

//			newParams.setTable(params.getTable() + "_test");

			FeatureType ftOrg = store.getDefaultFeatureType();

			EditableFeatureType ftTrg = ftOrg.getEditable();

//			EditableFeatureType ftTrg = (EditableFeatureType) newParams

//					.getDefaultFeatureType();

			newParams.setDefaultFeatureType(ftTrg);

//			FeatureAttributeDescriptor org;

//			EditableFeatureAttributeDescriptor trg;

//			Iterator iter = ftOrg.iterator();

//			while (iter.hasNext()) {

//				org = (FeatureAttributeDescriptor) iter.next();

//				trg = ftTrg.add(org.getName(), org.getDataType());

//				trg.setAllowNull(org.allowNull());

//				trg.setDefaultValue(org.getDefaultValue());

//				trg.setGeometrySubType(org.getGeometrySubType());

//				trg.setGeometryType(org.getGeometryType());

//				trg.setIsAutomatic(org.isAutomatic());

//				trg.setIsPrimaryKey(org.isPrimaryKey());

//				trg.setIsReadOnly(org.isReadOnly());

//				trg.setMaximumOccurrences(org.getMaximumOccurrences());

//				trg.setMinimumOccurrences(org.getMinimumOccurrences());

//				trg.setPrecision(org.getPrecision());

//				trg.setSize(org.getSize());

//				trg.setSRS(org.getSRS());

//				trg.setAdditionalInfo("SQLType", org

//						.getAdditionalInfo("SQLType"));

//				trg.setAdditionalInfo("SQLTypeName", org

//						.getAdditionalInfo("SQLTypeName"));

//

//			}

//			ftTrg.setDefaultGeometryAttributeName(ftOrg

//					.getDefaultGeometryAttributeName());

//			ftTrg.setHasOID(ftOrg.hasOID());

			store.dispose();

		}

		return this.newParams;

	}

	@Override

	public boolean resourcesNotifyChanges() {

		// TODO Auto-generated method stub

		return false;

	}

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

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

 * 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., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.fmap.dal.store.jdbc;

import org.gvsig.fmap.dal.DataStoreParameters;

import org.gvsig.fmap.dal.exception.DataException;

import org.gvsig.fmap.dal.feature.BaseTestFeatureStore;

import com.mysql.jdbc.Driver;

/**

 * @author jmvivo

 *

 */

public class JDBCTest extends BaseTestFeatureStore {

	@Override

	protected void doSetUp() throws Exception {

		// Nothing to do	

	}

	public DataStoreParameters getDefaultDataStoreParameters()

			throws DataException {

		JDBCStoreParameters parameters = null;

		parameters = (JDBCStoreParameters) dataManager

				.createStoreParameters(JDBCStoreProvider.NAME);

		parameters.setHost("localhost");

		parameters.setPort(3306);

		parameters.setUser("test");

		parameters.setPassword("test");

		parameters.setDBName("gis");

		parameters.setTable("alfanum");

		parameters.setUrl("jdbc:mysql://" + parameters.getHost() + ":"

				+ parameters.getPort() + "/" + parameters.getDBName());

		parameters.setJDBCDriverClassName(Driver.class.getName());

		return parameters;

	}

	/* (non-Javadoc)

	 * @see org.gvsig.fmap.dal.feature.BaseTestFeatureStore#hasExplorer()

	 */

	@Override

	public boolean hasExplorer() {

		// TODO Auto-generated method stub

		return true;

	}

	/* (non-Javadoc)

	 * @see org.gvsig.fmap.dal.feature.BaseTestFeatureStore#usesResources()

	 */

	@Override

	public boolean usesResources() {

		// TODO Auto-generated method stub

		return true;

	}

}

org.gvsig.fmap.dal.store.jdbc.JDBCLibrary

<?xml version="1.0"?>

<!--

    gvSIG. Desktop Geographic Information System.

    Copyright (C) 2007-2013 gvSIG Association.

    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 3

    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., 51 Franklin Street, Fifth Floor, Boston,

    MA  02110-1301, USA.

    For any additional information, do not hesitate to contact us

    at info AT gvsig.com, or visit our website www.gvsig.com.

-->

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="JDBC" namespace="Metadata">

      <extends>

      	<class name="SpatialProvider" namespace="Metadata"/>

      </extends>

      <description>Metadata of a JDBC store</description>

      <fields>

      </fields>

    </class>

  </classes>

</definitions>  

<?xml version="1.0"?>

<!--

    gvSIG. Desktop Geographic Information System.

    Copyright (C) 2007-2013 gvSIG Association.

    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 3

    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., 51 Franklin Street, Fifth Floor, Boston,

    MA  02110-1301, USA.

    For any additional information, do not hesitate to contact us

    at info AT gvsig.com, or visit our website www.gvsig.com.

-->

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="JDBCResourceParameters">

      <description></description>

      <extends>

        <class>DBResourceParameters</class>

      </extends>

      <fields>

        <field name="JDBCDriverClass" type="string" mandatory="true" group="Advanced">

          <description>JDBC Driver class</description>

        </field>

        <field name="URL" type="string" mandatory="true" group="Connection">

          <description>JDBC url connection</description>

        </field>

        <field name="Catalog" type="string" mandatory="false" group="Basic">

          <description>Database catalog</description>

        </field>

        <field name="Schema" type="string" mandatory="false" group="Basic">

          <description>Database schema</description>

        </field>

      </fields>

    </class>

    <class name="JDBCStoreParameters">

      <extends>

        <class>JDBCResourceParameters</class>

        <class>DBStoreParameters</class>

      </extends>

      <tags>

          <value name="defaultGroup" value="Basic"/>

      </tags>

      <fields>

      </fields>

    </class>

    <class name="JDBCNewStoreParameters">

      <description></description>

      <extends>

        <class>JDBCResourceParameters</class>

        <class>DBNewStoreParameters</class>

      </extends>

      <tags>

          <value name="defaultGroup" value="Basic"/>

      </tags>

      <fields>

        <field name="selectRole" label="Roles for select" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have select privilegies</description>

        </field>

        <field name="insertRole" label="Roles for insert" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have insert privilegies</description>

        </field>

        <field name="updateRole" label="Roles for update" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have update privilegies</description>

        </field>

        <field name="deleteRole" label="Roles for delete" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have delete privilegies</description>

        </field>

        <field name="truncateRole" label="Roles for truncate" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have truncate privilegies</description>

        </field>

        <field name="referenceRole" label="Roles for reference" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have reference privilegies</description>

        </field>

        <field name="triggerRole" label="Roles for trigger" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have trigger privilegies</description>

        </field>

        <field name="allRole" label="Roles for all" type="String" mandatory="false" defaultValue="" group="Permissions">

          <description>Roles asigned to have all privilegies</description>

        </field>

        <field name="postCreatingStatement" label="Post-creating statement" type="String" mandatory="false" defaultValue="" group="Advanced">

          <description>Roles asigned to have all privilegies</description>

        </field>

      </fields>

    </class>

    <class name="JDBCServerExplorerParameters">

      <extends>

        <class>JDBCResourceParameters</class>

        <class>DBServerExplorerParameters</class>

      </extends>

      <tags>

          <value name="defaultGroup" value="Basic"/>

      </tags>

      <fields>

        <field name="ShowInformationDBTables" type="boolean" 

            mandatory="false" defaultValue="false" group="Basic">

          <description>Show information tables</description>

        </field>

      </fields>

    </class>

  </classes>

</definitions>  

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

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

 * 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., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.fmap.dal.store.jdbc;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.Iterator;

import java.util.List;

import java.util.NoSuchElementException;

import org.gvsig.fmap.dal.DataTypes;

import org.gvsig.fmap.dal.exception.DataException;

import org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor;

import org.gvsig.fmap.dal.feature.FeatureQuery;

import org.gvsig.fmap.dal.feature.FeatureQueryOrder;

import org.gvsig.fmap.dal.feature.FeatureType;

import org.gvsig.fmap.dal.feature.FeatureQueryOrder.FeatureQueryOrderMember;

import org.gvsig.fmap.dal.feature.spi.AbstractFeatureSetProvider;

import org.gvsig.tools.evaluator.Evaluator;

import org.gvsig.tools.evaluator.EvaluatorFieldValue;

import org.gvsig.tools.evaluator.EvaluatorFieldsInfo;

import org.gvsig.tools.exception.BaseException;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

/**

 * @author jmvivo

 *

 */

public class JDBCSetProvider extends AbstractFeatureSetProvider {

	final static private Logger logger = LoggerFactory

			.getLogger(JDBCSetProvider.class);

	protected String filter;

	protected String order;

	protected Long size = null;

	protected Boolean isEmpty = null;

	protected List resultSetIDReferenced;

	private JDBCHelper helper = null;

	private int defaultFetchSize = 1000;

	private long limit = -1l;

    private boolean directSQLMode;

	public JDBCSetProvider(JDBCStoreProvider store, FeatureQuery query,

			FeatureType featureType) throws DataException {

		super(store, query, featureType);

		this.helper = store.getHelper();

		this.resultSetIDReferenced = new ArrayList();

		this.directSQLMode =  store.isDirectSQLMode();

		if (query.hasFilter() && this.canFilter()) {

			setFilter(query.getFilter());

		} else {

			setFilter(null);

		}

		if (query.hasOrder() && canOrder()) {

			setOrder(query.getOrder());

		} else {

			setOrder(null);

		}

		if (query != null) {

			limit = query.getLimit();

		}

	}

	/**

	 * @return the defaultFetchSize

	 */

	public int getDefaultFetchSize() {

		return defaultFetchSize;

	}

	/**

	 * @param defaultFetchSize

	 *            the defaultFetchSize to set

	 */

	public void setDefaultFetchSize(int defaultFetchSize) {

		this.defaultFetchSize = defaultFetchSize;

	}

	protected String getSqlForEvaluator(Evaluator filter) {

		if (filter == null) {

			return null;

		}

		EvaluatorFieldsInfo info = filter.getFieldsInfo();

		String filterString = filter.getSQL();

		if (info == null) {

			return filterString;

		}

		String[] filterNames = info.getFieldNames();

		String[] finalNames = new String[filterNames.length];

		EvaluatorFieldValue[] fValues;

		List values = new ArrayList();

		FeatureAttributeDescriptor attr;

		for (int i = 0; i < filterNames.length; i++) {

			attr = getFeatureType().getAttributeDescriptor(filterNames[i]);

			if (attr == null) {

				finalNames[i] = filterNames[i];

				continue;

			}

			finalNames[i] = getEscapedFieldName(attr.getName());

		}

		for (int i = 0; i < filterNames.length; i++) {

			if (!filterNames[i].equals(finalNames[i])) {

				filterString = filterString.replaceAll(

						"\\b" + filterNames[i] + "\\b",

						finalNames[i]);

			}

		}

		return filterString;

	}

	protected String getEscapedFieldName(String fieldName) {

		if (helper == null) {

			helper = getJDBCStoreProvider().getHelper();

		}

		return helper.escapeFieldName(fieldName);

	}

	protected void setOrder(FeatureQueryOrder order) {

		if (order == null || order.size() == 0) {

			this.order = null;

			return;

		}

		StringBuilder buffer = new StringBuilder();

		Iterator iter = order.iterator();

		FeatureQueryOrderMember menber;

		while (true) {

			menber = (FeatureQueryOrderMember) iter.next();

			if (menber.hasEvaluator()) {

				buffer.append(getSqlForEvaluator(menber.getEvaluator()));

			} else {

				buffer.append(getEscapedFieldName(menber.getAttributeName()));

			}

			if (menber.getAscending()) {

				buffer.append(" ASC");

			} else {

				buffer.append(" DESC");

			}

			if (iter.hasNext()) {

				buffer.append(", ");

			} else {

				buffer.append(' ');

				break;

			}

		}

		this.order = buffer.toString();

	}

	protected void setFilter(Evaluator filter) {

		this.filter = getSqlForEvaluator(filter);

	}

	/* (non-Javadoc)

	 * @see org.gvsig.fmap.dal.feature.spi.FeatureSetProvider#canFilter()

	 */

	public boolean canFilter() {

		Evaluator filter = getQuery().getFilter();

		if (directSQLMode){

		    return false;

		}

		if (filter != null) {

			if (filter.getSQL() == null || filter.getSQL().length() == 0) {

				return false;

			} else {

				// TODO Check Geom fields if

				EvaluatorFieldsInfo fInfo = filter.getFieldsInfo();

				if (fInfo == null || fInfo.getFieldNames() == null) {

					return true;

				}

				Iterator names = Arrays.asList(fInfo.getFieldNames())

						.iterator();

				String name;

				int type;

				while (names.hasNext()) {

					name = (String) names.next();

					type =

							this.getFeatureType()

									.getAttributeDescriptor(name)

							.getType();

					if (type == DataTypes.GEOMETRY

							&& !this.helper.supportsGeometry()) {

						return false;

					}

				}

				return true;

			}

		} else{

			return false;

		}

	}

	/* (non-Javadoc)

	 * @see org.gvsig.fmap.dal.feature.spi.FeatureSetProvider#canIterateFromIndex()

	 */

	public boolean canIterateFromIndex() {

		return helper.supportOffset();

	}

	/* (non-Javadoc)

	 * @see org.gvsig.fmap.dal.feature.spi.FeatureSetProvider#canOrder()

	 */

	public boolean canOrder() {

	    if (directSQLMode){

	        return false;

	    }

		// TODO Check Geom fields if postgis not are available

		FeatureQuery query = getQuery();

		if (query.hasOrder()) {

			Iterator iter = query.getOrder().iterator();

			FeatureQueryOrderMember menber;

			String sql;

			while (iter.hasNext()){

				menber = (FeatureQueryOrderMember) iter.next();

				if (menber.hasEvaluator()){

					sql = menber.getEvaluator().getSQL();

					if (sql == null || sql.length() == 0) {

						return false;

					}

				}

			}

		}

		return true;

	}

	private JDBCStoreProvider getJDBCStoreProvider() {

		return (JDBCStoreProvider) getStore();

	}

	@Override

	protected void doDispose() throws BaseException {

		if (resultSetIDReferenced != null) {

			Iterator iter = resultSetIDReferenced.iterator();

			Integer resID;

			while (iter.hasNext()) {

				resID = (Integer) iter.next();

				if (resID != null) {

					logger.warn(

						"ResultSet (ID {}) not closed on dispose, will close",

						resID);

					try {

						getJDBCStoreProvider().closeResulset(resID.intValue());

					} catch (DataException e) {

						logger.error("Close resulset Exception", e);

					}

				}

				iter.remove();

			}

		}

		resultSetIDReferenced = null;

		filter = null;

		order = null;

		size = null;

		isEmpty = null;

	}

	protected String getSQL(long fromIndex) throws DataException {

		return getJDBCStoreProvider().compoundSelect(getFeatureType(), filter,

				order, limit, fromIndex);

	}

	/* (non-Javadoc)

	 * @see org.gvsig.fmap.dal.feature.spi.FeatureSetProvider#getSize()

	 */

	public long getSize() throws DataException {

		if (size == null) {

			size = new Long(getJDBCStoreProvider().getCount(filter));

		}

		return size.longValue();

	}

	/* (non-Javadoc)

	 * @see org.gvsig.fmap.dal.feature.spi.FeatureSetProvider#isEmpty()

	 */

	public boolean isEmpty() throws DataException {

		JDBCStoreProvider store = getJDBCStoreProvider();

		if (isEmpty == null) {

			if (size == null) {

				String sql =

						store.compoundSelect(getFeatureType(), filter, null, 1,

								0);

				int rsID = store.createResultSet(sql, getFetchSize());

				isEmpty = new Boolean(!store.resulsetNext(rsID));

				store.closeResulset(rsID);

			} else {

				isEmpty = new Boolean(size.longValue() < 1);

			}

		}

		return isEmpty.booleanValue();

	}

	protected int getFetchSize() {

		long pageSize = -1;

		if (getQuery() != null) {

			pageSize = getQuery().getPageSize();

			pageSize =

					pageSize > Integer.MAX_VALUE ? Integer.MAX_VALUE : pageSize;

		}

		return (pageSize > 0 ? (int) pageSize : defaultFetchSize);

	}

	protected JDBCIterator createFastIterator(long index) throws DataException {

		if (isEmpty != null && isEmpty.booleanValue()) {

			return new EmptyJDBCIterator(getJDBCStoreProvider());

		}

		int rsID =

				getJDBCStoreProvider().createResultSet(getSQL(index),

						getFetchSize());

		return createDefaultFastIterator(rsID);

	}

	protected JDBCIterator createDefaultFastIterator(int resultSetID)

			throws DataException {

		return new JDBCFastIterator(getJDBCStoreProvider(), this,

				getFeatureType(), resultSetID);

	}

	protected JDBCIterator createIterator(long index) throws DataException {

        if (isEmpty != null && isEmpty.booleanValue()) {

            return new EmptyJDBCIterator(getJDBCStoreProvider());

        }

        int rsID =

                getJDBCStoreProvider().createResultSet(getSQL(index),

                        getFetchSize());

        return createDefaultIterator(rsID);

	}

	protected JDBCIterator createDefaultIterator(int resultSetID)

			throws DataException {

		return new JDBCIterator(getJDBCStoreProvider(), this, getFeatureType(),

				resultSetID);

	}

	public void addResulsetReference(int resulsetID) {

		this.resultSetIDReferenced.add(new Integer(resulsetID));

	}

	public void removeResulsetReference(int resulsetID) {

		this.resultSetIDReferenced.remove(new Integer(resulsetID));

	}

	private class EmptyJDBCIterator extends JDBCIterator {

		protected EmptyJDBCIterator(JDBCStoreProvider store) throws DataException {

			super(store, null, null, -1);

		}

		@Override

		protected boolean internalHasNext() {

			return false;

		}

		@Override

		protected Object internalNext() {

			throw new NoSuchElementException();

		}

		@Override

		protected void doDispose() throws BaseException {

			// nothing to do

		}

	}

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

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

 * 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., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.fmap.dal.store.jdbc;

import org.gvsig.fmap.dal.exception.DataException;

import org.gvsig.fmap.dal.feature.FeatureType;

import org.gvsig.fmap.dal.feature.spi.FeatureProvider;

import org.gvsig.tools.exception.BaseException;

/**

 * @author jmvivo

 *

 */

public class JDBCFastIterator extends JDBCIterator {

	protected FeatureProvider featureProvider;

	protected JDBCFastIterator(JDBCStoreProvider store, JDBCSetProvider set,

			FeatureType featureType, int resultsetID) throws DataException {

		super(store, set, featureType, resultsetID);

		this.featureProvider = super.createFeatureProvider();

	}

	protected FeatureProvider createFeatureProvider() throws DataException {

		return this.featureProvider;

	}

	@Override

	protected void doDispose() throws BaseException {

		super.doDispose();

		featureProvider = null;

	}

}

/**

 * gvSIG. Desktop Geographic Information System.

 *

 * Copyright (C) 2007-2013 gvSIG Association.

 *

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

 * 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., 51 Franklin Street, Fifth Floor, Boston,

 * MA  02110-1301, USA.

 *

 * For any additional information, do not hesitate to contact us

 * at info AT gvsig.com, or visit our website www.gvsig.com.

 */

package org.gvsig.fmap.dal.store.jdbc;

import java.security.InvalidParameterException;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.Collections;

import java.util.Iterator;

import java.util.List;

import org.cresques.cts.IProjection;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.DataServerExplorer;

import org.gvsig.fmap.dal.DataStore;

import org.gvsig.fmap.dal.DataStoreNotification;

import org.gvsig.fmap.dal.DataTypes;

import org.gvsig.fmap.dal.exception.CloseException;

import org.gvsig.fmap.dal.exception.DataException;

import org.gvsig.fmap.dal.exception.InitializeException;

import org.gvsig.fmap.dal.exception.OpenException;

import org.gvsig.fmap.dal.exception.ReadException;

import org.gvsig.fmap.dal.exception.ValidateDataParametersException;

import org.gvsig.fmap.dal.feature.EditableFeatureType;

import org.gvsig.fmap.dal.feature.FeatureAttributeDescriptor;

import org.gvsig.fmap.dal.feature.FeatureQuery;

import org.gvsig.fmap.dal.feature.FeatureType;

import org.gvsig.fmap.dal.feature.spi.AbstractFeatureStoreProvider;

import org.gvsig.fmap.dal.feature.spi.FeatureProvider;

import org.gvsig.fmap.dal.feature.spi.FeatureReferenceProviderServices;

import org.gvsig.fmap.dal.feature.spi.FeatureSetProvider;

import org.gvsig.fmap.dal.resource.ResourceAction;

import org.gvsig.fmap.dal.resource.exception.ResourceExecuteException;

import org.gvsig.fmap.dal.resource.spi.ResourceProvider;

import org.gvsig.fmap.dal.spi.DataStoreProviderServices;

import org.gvsig.fmap.dal.store.db.DBHelper;

import org.gvsig.fmap.dal.store.db.FeatureTypeHelper;

import org.gvsig.fmap.dal.store.jdbc.exception.InvalidResultSetIdException;

import org.gvsig.fmap.dal.store.jdbc.exception.JDBCException;

import org.gvsig.fmap.dal.store.jdbc.exception.JDBCExecutePreparedSQLException;

import org.gvsig.fmap.dal.store.jdbc.exception.JDBCSQLException;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.fmap.geom.GeometryLocator;

import org.gvsig.fmap.geom.GeometryManager;

import org.gvsig.fmap.geom.primitive.Envelope;

import org.gvsig.tools.dynobject.DynObject;

import org.gvsig.tools.dynobject.exception.DynFieldNotFoundException;

import org.gvsig.tools.exception.BaseException;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

/**

 * @author jmvivo

 *

 */

public class JDBCStoreProvider extends AbstractFeatureStoreProvider

		implements JDBCHelperUser {

	final static private Logger logger = LoggerFactory

			.getLogger(JDBCStoreProvider.class);

	private List<ResultSetInfo> resulsetList;

	public static String NAME = "JDBC";

	public static String DESCRIPTION = "JDBC source";

	public static final String METADATA_DEFINITION_NAME = NAME;

	private long mlsecondsToZombie = 1000 * 60 * 10; // 10 Min

	protected JDBCHelper helper;

	protected boolean directSQLMode;

	private Long totalCount = null;

	private GeometryManager geomManager = null;

	public JDBCStoreProvider(JDBCStoreParameters params,

			DataStoreProviderServices storeServices) throws InitializeException {

		this(

				params, 

				storeServices,

				DBHelper.newMetadataContainer(METADATA_DEFINITION_NAME)

		);

	}

	protected JDBCStoreProvider(JDBCStoreParameters params,

			DataStoreProviderServices storeServices, DynObject metadata)

			throws InitializeException {

		super(params, storeServices, metadata);

		geomManager = GeometryLocator.getGeometryManager();

		resulsetList = new ArrayList<ResultSetInfo>(10);

		helper = createHelper();

		if (params.getSQL() != null && (params.getSQL()).trim().length() > 0) {

			directSQLMode = true;

		}

		this.initFeatureType();

	}

	public Object getDynValue(String name) throws DynFieldNotFoundException {

		try {

			if( DataStore.METADATA_ENVELOPE.equalsIgnoreCase(name) ) {

				Envelope env = this.getEnvelope();

				if( env != null ) {

					return env;

				}

			} else if( DataStore.METADATA_CRS.equalsIgnoreCase(name) ) {

				IProjection proj;

				proj = this.getFeatureStore().getDefaultFeatureType().getDefaultSRS();

				if( proj != null ) {

					return proj;

				}

			}

		} catch (DataException e) {

			throw new RuntimeException(e);

		}

		return super.getDynValue(name);

	}

	protected JDBCStoreParameters getJDBCParameters() {

		return (JDBCStoreParameters) this.getParameters();

	}

	/**

	 * Load data form a resulset.<br>

	 *

	 * <strong>Note:</strong><br>

	 * this method have to perform <code>resouceBegin</code> at the begining and

	 * <code>resourceEnd</code> at the end of execution.

	 *

	 *

	 * @param data

	 * @param resulsetID

	 *

	 * @return

	 * @throws DataException

	 */

	public void loadFeatureProvider(final FeatureProvider data, final int resultsetID)

			throws DataException {

		getResource().execute(new ResourceAction() {

			public Object run() throws Exception {

				ResultSet rs = getResultSet(resultsetID);

				FeatureAttributeDescriptor attr;

				Iterator<FeatureAttributeDescriptor> iter = FeatureTypeHelper.iterator(data.getType());

				while (iter.hasNext()) {

					attr = iter.next();

					loadFeatureProviderValue(data, rs, attr);

				}

				return null;

			}

                        public String toString() {

                            return "loadFeature";

                        }

		});

	}

	protected void loadFeatureProviderValue(FeatureProvider data, ResultSet rs,

			FeatureAttributeDescriptor attr) throws DataException {

		if (attr.getType() == DataTypes.GEOMETRY) {

			byte[] buffer;

			try {

				buffer = rs.getBytes(attr.getIndex() + 1);

				if (buffer == null) {

					data.set(attr.getIndex(), null);

				} else {

					data.set(attr.getIndex(), this.helper.getGeometry(buffer));

				}

			} catch (SQLException e) {

				throw new JDBCSQLException(e);

			} catch (BaseException e) {

				throw new ReadException(getProviderName(), e);

			}

		} else {

			try {

				data.set(attr.getIndex(), rs.getObject(attr.getIndex() + 1));

			} catch (SQLException e) {

				throw new JDBCSQLException(e);

			}

		}

	}

	public long getTimeToResulSetZombie() {

		return mlsecondsToZombie;

	}

	public void setTimeToResulSetZombie(long mlSeconds) {

		mlsecondsToZombie = mlSeconds;

	}

	private class ResultSetInfo{

		private ResultSet resultSet = null;

		private long lastUse = 0;

		public ResultSetInfo(ResultSet resulSet) {

			this.resultSet = resulSet;

			used();

		}

		private void used() {

			lastUse = System.currentTimeMillis();

		}

		public ResultSet get() {

			used();

			return resultSet;

		}

		public boolean isZombie() {

			return System.currentTimeMillis() - lastUse > mlsecondsToZombie;

		}

	}

	public final int createResultSet(String sql, int fetchSize)

			throws DataException {

        return createResultSet(sql, null, fetchSize);

	}

	public final int createResultSet(final String sql, final Object[] values,

			final int fetchSize)

			throws DataException {

		synchronized (this) {

			checksResulsets();

			return ((Integer) getResource().execute(new ResourceAction() {

				public Object run() throws Exception {

					ResultSetInfo newRs =

							new ResultSetInfo(createNewResultSet(sql, values,

									fetchSize));

					int newId = getNewId();

					if (newId < 0) {

						newId = resulsetList.size();

						resulsetList.add(newRs);

					} else {

						resulsetList.set(newId, newRs);

					}

					logger.debug("Created resultset id: {} (total open: {})",

							newId, getResultsetOpenCount());

					return Integer.valueOf(newId);

				}

			})).intValue();

		}

	}

	private int getNewId() {

		int newId;

		if (resulsetList.size() < 1) {

			return -1;

		}

		for (newId = 0; newId < resulsetList.size(); newId++) {

			if (resulsetList.get(newId) == null) {

				return newId;

			}

		}

		return -1;

	}

	protected final void forceCloseAllResultSet()

			throws ResourceExecuteException,

			JDBCException {

		synchronized (this) {

			// FIXME: Esto no deberia funcionar. 

			Iterator iter = resulsetList.iterator();

			Integer rsID = null;

			while (iter.hasNext()) {

				rsID = (Integer) iter.next();

				if (rsID != null) {

					try {

						forceCloseResultSet(rsID.intValue());

					} catch (InvalidResultSetIdException e) {

						continue;

					}

				}

				iter.remove();

			}

		}

	}

	protected final void forceCloseResultSet(int rsID)

			throws ResourceExecuteException, JDBCException,

			InvalidResultSetIdException {

		logger.warn("Close forced of resultSet ({})", rsID);

		closeResulset(rsID);

	}

	protected final ResultSet getResultSet(int resultsetID)

			throws InvalidResultSetIdException {

		if (resultsetID >= resulsetList.size()) {

			throw new InvalidResultSetIdException(resultsetID);

		}

		ResultSetInfo rsInfo = resulsetList.get(resultsetID);

		if (rsInfo == null) {

			throw new InvalidResultSetIdException(resultsetID);

		}

		return rsInfo.get();

	}

	private ResultSet dropResultSet(int resultsetID)

			throws InvalidResultSetIdException {

		if (resultsetID >= resulsetList.size()) {

			throw new InvalidResultSetIdException(resultsetID);

		}

		ResultSetInfo rsInfo = (ResultSetInfo) resulsetList.get(resultsetID);

		if (rsInfo == null) {

			throw new InvalidResultSetIdException(resultsetID);

		}

		if (resultsetID == resulsetList.size() - 1) {

			resulsetList.remove(resultsetID);

		} else {

			resulsetList.set(resultsetID, null);

		}

		return rsInfo.get();

	}

	public final boolean resulsetNext(final int resultsetID)

			throws JDBCException,

			InvalidResultSetIdException, ResourceExecuteException {

		return ((Boolean) getResource().execute(new ResourceAction() {

			public Object run() throws Exception {

			    boolean bool = getResultSet(resultsetID).next();

				return Boolean.valueOf(bool);

			}

		})).booleanValue();

	}