| gvSIG desktop 1

<?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>

	<packaging>jar</packaging>

	<version>2.0-SNAPSHOT</version>

	<name>libFMap_daldb</name>

	<parent>

		<groupId>org.gvsig</groupId>

		<artifactId>gvsig-base-library-pom</artifactId>

		<version>2.0-SNAPSHOT</version>

	</parent>	

	<properties>

		<!-- jdbc -->

		<jdbc-jarIncludes>org/gvsig/fmap/dal/store/jdbc/**/**</jdbc-jarIncludes>

		<jdbc-jarExcludes>NONE</jdbc-jarExcludes>

		<!-- postgresql -->

		<postgresql-jarIncludes>org/gvsig/fmap/dal/store/postgresql/**/**</postgresql-jarIncludes>

		<postgresql-jarExcludes>NONE</postgresql-jarExcludes>

		<!-- mysql -->

		<mysql-jarIncludes>org/gvsig/fmap/dal/store/mysql/**/**</mysql-jarIncludes>

		<mysql-jarExcludes>NONE</mysql-jarExcludes>

		<!-- Common -->

		<common-jarIncludes>**/**</common-jarIncludes>

		<build-dir>${basedir}/../build</build-dir>

        <eclipse.project.name>libFMap_daldb</eclipse.project.name>

	</properties>

	<dependencies>

		<dependency>

			<groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

		</dependency>

		<dependency>

			<groupId>org.gvsig</groupId>

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

			<classifier>spi</classifier>

            <scope>compile</scope>

		</dependency>		

		<dependency>

			<groupId>org.gvsig</groupId>

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

			<classifier>operation</classifier>

            <scope>compile</scope>

		</dependency>

		<dependency>

			<groupId>postgresql</groupId>

			<artifactId>postgresql</artifactId>

            <scope>compile</scope>

		</dependency>

		<dependency>

			<groupId>commons-dbcp</groupId>

			<artifactId>commons-dbcp</artifactId>

            <scope>compile</scope>

		</dependency>

		<dependency>

			<groupId>commons-collections</groupId>

			<artifactId>commons-collections</artifactId>

            <scope>compile</scope>

		</dependency>

		<dependency>

			<groupId>mysql</groupId>

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

            <scope>compile</scope>

		</dependency>

		<!--TEST-->

		<dependency>

			<groupId>org.gvsig</groupId>

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

			<type>test-jar</type>

			<scope>test</scope>

		</dependency>

		<dependency>

			<groupId>org.gvsig</groupId>

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

			<classifier>tests</classifier>

			<scope>test</scope>

		</dependency>

		<dependency>

			<groupId>org.gvsig</groupId>

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

			<classifier>impl</classifier>

			<scope>test</scope>

		</dependency>

		<dependency>

			<groupId>org.gvsig</groupId>

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

			<classifier>jts</classifier>

			<scope>test</scope>

		</dependency>

		<dependency>

			<groupId>org.gvsig</groupId>

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

			<classifier>impl</classifier>

			<scope>test</scope>

		</dependency>

		<dependency>

			<groupId>org.gvsig</groupId>

			<artifactId>org.gvsig.projection</artifactId>

			<classifier>cresques-impl</classifier>

			<scope>test</scope>

		</dependency>

		<dependency>

			<groupId>org.gvsig</groupId>

			<artifactId>org.gvsig.utils</artifactId>

			<scope>test</scope>

		</dependency>		

        <dependency>

            <groupId>org.slf4j</groupId>

            <artifactId>slf4j-api</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.projection</artifactId>

            <scope>compile</scope>

        </dependency>

        <dependency>

            <groupId>org.gvsig</groupId>

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

            <scope>compile</scope>

        </dependency>        

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.metadata.lib.basic.api</artifactId>

            <scope>compile</scope>

        </dependency> 

        <dependency>

            <groupId>org.gvsig</groupId>

            <artifactId>org.gvsig.timesupport.lib.api</artifactId>

            <scope>compile</scope>

        </dependency>       

	</dependencies>

	<build>

		<sourceDirectory>src</sourceDirectory>

		<testSourceDirectory>src-test</testSourceDirectory>

		<plugins>

			<plugin>

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

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

				<configuration>

					<excludes>

						<exclude>org/gvsig/fmap/data/**</exclude>

					</excludes>

				</configuration>

			</plugin>

			<plugin>

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

				<artifactId>maven-javadoc-plugin</artifactId>

				<configuration>

					<excludePackageNames>org/gvsig/fmap/data</excludePackageNames>

				</configuration>

			</plugin>

			<plugin>

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

				<artifactId>maven-jar-plugin</artifactId>

				<configuration>

					<excludes>

						<exclude>${jdbc-jarIncludes}</exclude>

						<exclude>${postgresql-jarIncludes}</exclude>

						<exclude>${mysql-jarIncludes}</exclude>

					</excludes>

				</configuration>

				<executions>

					<!--

						Generates a jar file only with the DAL JDBC Store classes

					-->

					<execution>

						<id>jdbc</id>

						<phase>package</phase>

						<goals>

							<goal>jar</goal>

						</goals>

						<configuration>

							<classifier>store.jdbc</classifier>

							<includes>

								<include>${jdbc-jarIncludes}</include>

							</includes>

							<excludes>

								<exclude>${jdbc-jarExcludes}</exclude>

							</excludes>

						</configuration>

					</execution>

					<!--

						Generates a jar file only with the DAL PostgreSQL Store classes

					-->

					<execution>

						<id>postgresql</id>

						<phase>package</phase>

						<goals>

							<goal>jar</goal>

						</goals>

						<configuration>

							<classifier>store.postgresql</classifier>

							<includes>

								<include>${postgresql-jarIncludes}</include>

							</includes>

							<excludes>

								<exclude>${postgresql-jarExcludes}</exclude>

							</excludes>

						</configuration>

					</execution>

					<!--

						Generates a jar file only with the DAL MySQL Store classes

					-->

					<execution>

						<id>mysql</id>

						<phase>package</phase>

						<goals>

							<goal>jar</goal>

						</goals>

						<configuration>

							<classifier>store.mysql</classifier>

							<includes>

								<include>${mysql-jarIncludes}</include>

							</includes>

							<excludes>

								<exclude>${mysql-jarExcludes}</exclude>

							</excludes>

						</configuration>

					</execution>

				</executions>

			</plugin>

			<plugin>

				<artifactId>maven-antrun-plugin</artifactId>

				<executions>

					<execution>

						<id>services</id>

						<phase>package</phase>

						<goals>

							<goal>run</goal>

						</goals>

						<configuration>

							<tasks>

								<jar destfile="${project.build.directory}/${project.build.finalName}.jar"

									update="true">

									<fileset dir="${basedir}/resources/api" />

								</jar>

								<jar destfile="${project.build.directory}/${project.build.finalName}-store.jdbc.jar"

									update="true">

									<fileset dir="${basedir}/resources/jdbc" />

								</jar>

								<jar destfile="${project.build.directory}/${project.build.finalName}-store.mysql.jar"

									update="true">

									<fileset dir="${basedir}/resources/mysql" />

								</jar>

								<jar destfile="${project.build.directory}/${project.build.finalName}-store.postgresql.jar"

									update="true">

									<fileset dir="${basedir}/resources/postgresql" />

								</jar>

							</tasks>

						</configuration>

					</execution>

				</executions>

			</plugin>

			<!-- PostgreSQL and MySQL is needed to run the tests -->

			<plugin>

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

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

				<configuration>

					<additionalClasspathElements>

						<additionalClasspathElement>${basedir}/resources/api</additionalClasspathElement>

						<additionalClasspathElement>${basedir}/resources/jdbc</additionalClasspathElement>

						<additionalClasspathElement>${basedir}/resources/mysql</additionalClasspathElement>

						<additionalClasspathElement>${basedir}/resources/postgresql</additionalClasspathElement>

					</additionalClasspathElements>

					<skipTests>true</skipTests>

				</configuration>

			</plugin>

		</plugins>

	</build>

	<profiles>

		<profile>

			<id>eclipse-project</id>

			<build>

				<defaultGoal>antrun:run</defaultGoal>

				<plugins>

					<plugin>

						<artifactId>maven-antrun-plugin</artifactId>

						<configuration>

							<tasks>

								<ant antfile="${build-dir}/ant-tasks/eclipse-tasks.xml"

									target="eclipse.all"/>

							</tasks>

						</configuration>

					</plugin>

				</plugins>

			</build>				

		</profile>			

	</profiles>

	<reporting>

		<plugins>

			<plugin>

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

				<artifactId>maven-javadoc-plugin</artifactId>

				<configuration>

					<doctitle>${project.name} ${project.version}</doctitle>

					<groups>

						<group>

							<title>DAL DB common</title>

							<packages>org.gvsig.fmap.dal*</packages>

						</group>

						<group>

							<title>DB Store</title>

							<packages>org.gvsig.fmap.dal.store.db*</packages>

						</group>

						<group>

							<title>JDBC Store</title>

							<packages>org.gvsig.fmap.dal.store.jdbc*</packages>

						</group>

						<group>

							<title>PostgreSQL Store</title>

							<packages>org.gvsig.fmap.dal.store.postgresql*</packages>

						</group>

						<group>

							<title>MySQL Store</title>

							<packages>org.gvsig.fmap.dal.store.mysql*</packages>

						</group>

					</groups>

				</configuration>

				<reportSets>

					<reportSet>

						<id>api</id>

						<configuration>

							<excludePackageNames>*.spi:*.impl:*.store</excludePackageNames>

							<name>Javadoc: API</name>

							<destDir>apidoc</destDir>

							<windowtitle>API Documentation</windowtitle>

							<links>

							</links>

						</configuration>

						<reports>

							<report>javadoc</report>

						</reports>

					</reportSet>

					<reportSet>

						<id>spi</id>

						<configuration>

							<doctitle>${project.name} ${project.version} SPI</doctitle>

							<subpackages>org.gvsig.fmap.dal.serverexplorer.db.spi:org.gvsig.fmap.dal.store.db:org.gvsig.fmap.dal.store.jdbc</subpackages>

							<name>Javadoc: SPI</name>

							<destDir>spidoc</destDir>

							<windowtitle>SPI and base stores documentation</windowtitle>

							<links>

								<link>../apidoc/</link>

							</links>

						</configuration>

						<reports>

							<report>javadoc</report>

						</reports>

					</reportSet>

					<reportSet>

						<id>impl</id>

						<configuration>

							<doctitle>${project.name} ${project.version} Default implementation and

								stores</doctitle>

							<subpackages>org.gvsig.fmap.dal.store.mysql:org.gvsig.fmap.dal.store.postgresql</subpackages>

							<name>Javadoc: Impl and Stores</name>

							<destDir>impldoc</destDir>

							<windowtitle>Default implementation and Stores Documentation</windowtitle>

							<links>

								<link>../apidoc/</link>

								<link>../spidoc/</link>

							</links>

						</configuration>

						<reports>

							<report>javadoc</report>

						</reports>

					</reportSet>

				</reportSets>

			</plugin>

		</plugins>

	</reporting>

</project>

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

<?xml version="1.0"?>

<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"?>

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

      <fields>

      </fields>

    </class>

    <class name="JDBCNewStoreParameters">

      <description></description>

      <extends>

        <class>JDBCStoreParameters</class>

	    <class namespace="dal" name="NewProviderParameters"/>

      </extends>

      <fields>

      </fields>

    </class>

    <class name="JDBCServerExplorerParameters">

      <extends>

        <class>JDBCResourceParameters</class>

        <class>DBServerExplorerParameters</class>

      </extends>

      <fields>

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

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

          <description>Show information tables</description>

        </field>

      </fields>

    </class>

  </classes>

</definitions>  

<?xml version="1.0"?>

<definitions>

  <version>1.0.0</version>

  <classes>

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

      <extends>

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

      </extends>

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

      <fields>

      </fields>

    </class>

  </classes>

</definitions>  

<?xml version="1.0"?>

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="PostgreSQLResourceParameters">

      <extends>

        <class>JDBCResourceParameters</class>

      </extends>

      <fields>

        <field name="JDBCDriverClass" type="string" mandatory="true"

          defaultValue="org.postgresql.Driver" group="Advanced">

          <description>JDBC Driver class</description>

        </field>

		<field name="port" type="integer" mandatory="false"

          defaultValue="5432" group="Connection">

          <description></description>

        </field>

        <field name="UseSSL" type="boolean" mandatory="false"

          defaultValue="false" group="Basic">

          <description>Use SSL connetion</description>

        </field>

      </fields>

    </class>

    <class name="PostgreSQLStoreParameters">

      <extends>

        <class>JDBCStoreParameters</class>

        <class>PostgreSQLResourceParameters</class>

      </extends>

      <fields/>

    </class>

    <class name="PostgreSQLNewStoreParameters">

      <extends>

        <class>PostgreSQLStoreParameters</class>

	    <class namespace="dal" name="NewProviderParameters"/>

      </extends>

      <fields/>

    </class>

    <class name="PostgreSQLServerExplorerParameters">

      <extends>

        <class>PostgreSQLResourceParameters</class>

        <class>JDBCServerExplorerParameters</class>

      </extends>

      <fields/>

    </class>

  </classes>

</definitions>  

org.gvsig.fmap.dal.store.postgresql.PostgreSQLLibrary

<?xml version="1.0"?>

<definitions>

  <version>1.0.0</version>

  <classes>

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

      <extends>

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

      </extends>

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

      <fields>

      </fields>

    </class>

  </classes>

</definitions>  

<?xml version="1.0"?>

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="MySQLResourceParameters">

      <extends>

        <class>JDBCResourceParameters</class>

      </extends>

      <fields>

        <field name="JDBCDriverClass" type="string" mandatory="true"

          defaultValue="com.mysql.jdbc.Driver" group="Advanced">

          <description>JDBC Driver class</description>

        </field>

		<field name="port" type="integer" mandatory="false"

          defaultValue="3306" group="Basic">

          <description></description>

        </field>

        <field name="UseSSL" type="boolean" mandatory="false"

          defaultValue="false" group="Basic">

          <description>Use SSL connetion</description>

        </field>

      </fields>

    </class>

    <class name="MySQLStoreParameters">

      <extends>

        <class>JDBCStoreParameters</class>

        <class>MySQLResourceParameters</class>

      </extends>

      <fields/>

    </class>

    <class name="MySQLNewStoreParameters">

      <extends>

        <class>MySQLStoreParameters</class>

	    <class namespace="dal" name="NewProviderParameters"/>

      </extends>

      <fields/>

    </class>

    <class name="MySQLServerExplorerParameters">

      <extends>

        <class>MySQLResourceParameters</class>

        <class>JDBCServerExplorerParameters</class>

      </extends>

      <fields/>

    </class>

  </classes>

</definitions>  

org.gvsig.fmap.dal.store.mysql.MySQLLibrary

org.gvsig.fmap.dal.DALDbLibrary

org.gvsig.fmap.dal.resource.db.DBResourceLibrary

org.gvsig.fmap.dal.store.db.DBStoreLibrary

<?xml version= "1.0 "?>

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="DBResourceParameters">

      <extends>

      	<class namespace="dal" name="ProviderParameters"/>

      </extends>

      <description>Store the parameters need to open a table of a database</description>

      <fields>

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

          <description></description>

        </field>

        <field name="port" type="integer" mandatory="false" group="Connection">

          <description></description>

        </field>

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

          <description></description>

        </field>

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

          <description></description>

        </field>

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

          <description></description>

        </field>

      </fields>

    </class>

  </classes>

</definitions>  

<?xml version= "1.0 "?>

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="DBServerExplorerParameters">

      <description></description>

      <extends>

      	<class name="DBResourceParameters"/>

      </extends>

      <fields>

      </fields>

    </class>

  </classes>

</definitions>  

<?xml version="1.0"?>

<definitions>

  <version>1.0.0</version>

  <classes>

    <class name="DBStoreParameters">

      <description>Store the parameters need to open a table of a database</description>

      <extends>

      	<class name="DBResourceParameters"/>

      </extends>

      <fields>

		<!--  Basic data -->

        <field name="Table" type="string" mandatory="true" group="Basic">

          <description>Name of the table or view to access</description>

        </field>

        <field name="DefaultGeometryField" type="string" mandatory="false" 

            group="Basic">

          <description>Default geometry field</description>

        </field>

		<!-- Advanced  -->

        <field name="CRS" type="crs" mandatory="false">

          <description>CRS used to override the autodetection</description>

        </field>

        <field name="SQL" type="string" mandatory="false">

          <description>SQL to use instead the table name</description>

        </field>

        <field name="Fields" type="string" mandatory="false">

          <description>comma separated list of the field names that we want to use</description>

        </field>

        <field name="BaseFilter" type="string" mandatory="false">

          <description>This filter is passed to BD provider on each request as a base filter.</description>

        </field>

        <field name="BaseOrder" type="string" mandatory="false">

          <description>This order is used if no custom order is request in query.</description>

        </field>

        <field name="PKFields" type="string" mandatory="false">

          <description>Comma separated list of the field names that compound the primary key</description>

        </field>

        <field name="Workingarea" type="envelope" mandatory="false">

          <description>Envelop that define the filter by area used</description>

        </field>

      </fields>

    </class>

  </classes>

</definitions>  

/* gvSIG. Geographic Information System of the Valencian Government

*

* Copyright (C) 2007-2008 Infrastructures and Transports Department

* of the Valencian Government (CIT)

*

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

* MA  02110-1301, USA.

*

*/

/*

* AUTHORS (In addition to CIT):

* 2009 IVER T.I   {{Task}}

*/

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

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.EditableFeatureType;

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

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

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

import org.gvsig.fmap.dal.store.jdbc.JDBCStoreParameters;

public class MySQLTestWrite extends BaseTestEditableFeatureStore {

	private MySQLNewStoreParameters newParams;

	private MySQLServerExplorer myExplorer;

	@Override

	protected void doSetUp() throws Exception {

		super.doSetUp();

	}

	public DataStoreParameters getDefaultDataStoreParameters()

			throws DataException {

		MySQLStoreParameters parameters = null;

		parameters = (MySQLStoreParameters) dataManager

				.createStoreParameters(MySQLStoreProvider.NAME);

		parameters.setHost("localhost");

		parameters.setPort(3306);

		parameters.setUser("test");

		parameters.setPassword("test");

		parameters.setDBName("gis");

		// parameters.setTable("alfanum_autoid");

		parameters.setTable("comunic_lin_300k");

		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) {

			MySQLServerExplorerParameters seParameters = null;

			seParameters = (MySQLServerExplorerParameters) dataManager

					.createServerExplorerParameters(MySQLServerExplorer.NAME);

			seParameters.setHost("localhost");

			seParameters.setPort(3306);

			seParameters.setUser("test");

			seParameters.setPassword("test");

			seParameters.setDBName("gis");

			myExplorer = (MySQLServerExplorer) dataManager

					.createServerExplorer(seParameters);

		}

		if (this.newParams == null) {

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

			newParams = (MySQLNewStoreParameters) 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. Geographic Information System of the Valencian Government

*

* Copyright (C) 2007-2008 Infrastructures and Transports Department

* of the Valencian Government (CIT)

*

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

* MA  02110-1301, USA.

*

*/

/*

* AUTHORS (In addition to CIT):

* 2009 IVER T.I   {{Task}}

*/

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. Geographic Information System of the Valencian Government

*

* Copyright (C) 2007-2008 Infrastructures and Transports Department

* of the Valencian Government (CIT)

*

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

* MA  02110-1301, USA.

*

*/

/*

* AUTHORS (In addition to CIT):

* 2009 IVER T.I   {{Task}}

*/

/**

 *

 */

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;

	}

}

/* gvSIG. Geographic Information System of the Valencian Government

*

* Copyright (C) 2007-2008 Infrastructures and Transports Department

* of the Valencian Government (CIT)

*

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

* MA  02110-1301, USA.

*

*/

/*

* AUTHORS (In addition to CIT):

* 2009 IVER T.I   {{Task}}

*/

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

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.text.MessageFormat;

import org.gvsig.fmap.geom.Geometry;

import org.gvsig.fmap.geom.GeometryLocator;

import org.gvsig.fmap.geom.GeometryManager;

import org.gvsig.fmap.geom.operation.fromwkb.FromWKB;

import org.gvsig.fmap.geom.operation.fromwkb.FromWKBGeometryOperationContext;

import org.gvsig.fmap.geom.operation.towkb.ToWKB;

import org.gvsig.fmap.geom.operation.towkt.ToWKT;

import org.gvsig.fmap.geom.primitive.impl.Point2D;

import org.gvsig.tools.junit.AbstractLibraryAutoInitTestCase;

public class TestReadAndWriteGeom extends AbstractLibraryAutoInitTestCase {

	private static final int FEATURES_TO_INSERT = 12000;

	private static final String TABLE_NAME_INSERT = "testReadadnwritegeom_testcase";

	private static final String FIELD_NAME_INSERT = "geom";

	private Connection conn;

	private GeometryManager geoManager;

	private static String SQL_FOR_READ_TEST = "Select {0} from medio_ejes";

	@Override

	protected void doSetUp() throws Exception {

		geoManager = GeometryLocator.getGeometryManager();

		Class klass = Class.forName(PostgreSQLLibrary.DEFAULT_JDCB_DRIVER_NAME);

		if (klass == null) {

			throw new Exception("Driver not found: "

					+ PostgreSQLLibrary.DEFAULT_JDCB_DRIVER_NAME);

		}

		// inicializamos operaciones de geometrias de las que dependemos

		int code = FromWKB.CODE;

		code = ToWKB.CODE;

		code = ToWKT.CODE;

		conn = DriverManager.getConnection(PostgreSQLLibrary.getJdbcUrl(

				"localhost", 5432, "gis"), "postgres", "postgres");

	}

	public void testInsertWKB() throws Exception {

		PreparedStatement pst = null;

		try {

			crearTablaTest();

			Point2D geom = (Point2D) geoManager.createPoint(0, 0,

					Geometry.SUBTYPES.GEOM2D);

			pst = conn.prepareStatement(

					"Insert into "

					+ TABLE_NAME_INSERT.toLowerCase() +

					"  ("

					+ FIELD_NAME_INSERT + ") Values (GeomFromWKB(?))");

			int i;

			for (i = 1; i <= FEATURES_TO_INSERT; i++) {

				pst.clearParameters();

				geom.setX(i);

				geom.setY(i);

				pst.setBytes(1,

					(byte[]) geom.invokeOperation(

							ToWKB.CODE,

							null)

					);

				pst.executeUpdate();

			}

			System.out

					.println("TestReadAndWriteGeom.testInsertPostgis() Inserteds= i");

		} finally {

			if (pst != null) {

				try {pst.close();} catch (SQLException e) {e.printStackTrace();}

			}

		}