Application: gvSIG desktop

import org.cresques.ProjectionLibrary;

import org.cresques.impl.CresquesCtsLibrary;

import org.gvsig.fmap.dal.DALDbLibrary;

import org.gvsig.fmap.dal.index.spatial.jts.JTSIndexLibrary;

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

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

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

import org.gvsig.fmap.geom.impl.DefaultGeometryLibrary;

import org.gvsig.fmap.mapcontext.MapContext;

import org.gvsig.fmap.mapcontext.MapContextLibrary;

import org.gvsig.fmap.mapcontext.MapContextLocator;

import org.gvsig.fmap.mapcontext.MapContextManager;

import org.gvsig.fmap.mapcontext.layers.vectorial.FLyrVect;

import org.gvsig.fmap.mapcontrol.MapControl;

import org.gvsig.fmap.mapcontrol.MapControlsLibrary;

import org.gvsig.oraclespatial.extension.ExportToOracle;

import org.gvsig.tools.ToolsLocator;

import org.gvsig.tools.persistence.xmlentity.XMLEntityManager;

import junit.framework.TestCase;

public class TextExportToOracle extends TestCase {

	public TextExportToOracle(){

		ToolsLocator.registerDefaultPersistenceManager(XMLEntityManager.class);

		DefaultGeometryLibrary defGeomLib = new DefaultGeometryLibrary();

		defGeomLib.initialize();

		ProjectionLibrary projLib = new ProjectionLibrary();

		projLib.initialize();

		CresquesCtsLibrary cresquesLib = new CresquesCtsLibrary();

		cresquesLib.initialize();

		DALDbLibrary libDb = new DALDbLibrary();

		libDb.initialize();

		DBStoreLibrary libDbStore = new DBStoreLibrary();

		libDbStore.initialize();

		JDBCLibrary libJDBC = new JDBCLibrary();

		libJDBC.initialize();		

		JTSIndexLibrary jtsIndex = new JTSIndexLibrary();

		jtsIndex.initialize();

		MapContextLibrary mapContext = new MapContextLibrary();

		mapContext.initialize();

		MapControlsLibrary mapControl = new MapControlsLibrary();

		mapContext.initialize();

		projLib.postInitialize();

		cresquesLib.postInitialize();

		defGeomLib.postInitialize();

		libDb.postInitialize();

		libDbStore.postInitialize();

		libJDBC.postInitialize();

		jtsIndex.postInitialize();

		mapContext.postInitialize();

		mapControl.postInitialize();

	}

	public void testExportLayer(){

		MapControl control = new MapControl();

		MapContext context = control.getMapContext();

		FLyrVect layer = getLayer();

		ExportToOracle exp = new ExportToOracle();

		exp.toOracle(context, layer);

	}

	private FLyrVect getLayer(){

		return null;

	}

}

/* gvSIG. Sistema de Informaci?n Geogr?fica de la Generalitat Valenciana

 *

 * Copyright (C) 2006 Prodevelop 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

 *

 *   Prodevelop Integraci?n de Tecnolog?as SL

 *   Conde Salvatierra de ?lava , 34-10

 *   46004 Valencia

 *   Spain

 *

 *   +34 963 510 612

 *   +34 963 510 968

 *   gis@prodevelop.es

 *   http://www.prodevelop.es

 */

package org.gvsig.oraclespatial;

import java.awt.geom.PathIterator;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.ResultSetMetaData;

import java.sql.SQLException;

import java.sql.Statement;

import oracle.jdbc.driver.OracleDriver;

import oracle.jdbc.driver.OracleResultSet;

import oracle.sql.ARRAY;

import oracle.sql.Datum;

import oracle.sql.NUMBER;

import oracle.sql.STRUCT;

import org.cresques.cts.IProjection;

import org.gvsig.oraclespatial.driver.OracleSpatialDriver;

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

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

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

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

import com.iver.cit.gvsig.fmap.crs.CRSFactory;

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

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

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

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

import com.vividsolutions.jts.geom.MultiLineString;

import com.vividsolutions.jts.io.oracle.OraReader;

/**

 * @author FJP

 *

 * TODO To change the template for this generated type comment go to Window -

 * Preferences - Java - Code Generation - Code and Comments

 */

public class testOracle {

    private static boolean addOrdsToGPX(GeneralPathX gpx, int zero_based_start,

        int zero_based_include_end, Datum[] ords, int d, int ltype,

        boolean do_the_move, boolean must_do_first) {

        int length = ords.length;

        boolean return_following_must_do_first = true;

        double x = ((NUMBER) ords[zero_based_start]).doubleValue();

        double y = ((NUMBER) ords[zero_based_start + 1]).doubleValue();

        if (must_do_first) {

            if (do_the_move) {

                gpx.moveTo(x, y);

            }

            else {

                gpx.lineTo(x, y);

            }

        }

        int ind = 1;

        int size = ((zero_based_include_end - zero_based_start) / d) + 1;

        int indx;

        int indx2;

        if (ltype == PathIterator.SEG_QUADTO) { // (interpretation = 2)

            double x2;

            double y2;

            while (ind < size) {

                indx = zero_based_start + (ind * d);

                x = ((NUMBER) ords[indx]).doubleValue();

                y = ((NUMBER) ords[indx + 1]).doubleValue();

                indx2 = zero_based_start + ((ind + 1) * d);

                if (indx >= length) {

                    indx2 = zero_based_start;

                }

                x2 = ((NUMBER) ords[indx2]).doubleValue();

                y2 = ((NUMBER) ords[indx2 + 1]).doubleValue();

                gpx.quadTo(x, y, x2, y2);

                ind++;

                ind++;

            }

            return_following_must_do_first = false;

        }

        else { // PathIterator.SEG_LINETO (interpretation = 1)

            while (ind < size) {

                indx = zero_based_start + (ind * d);

                x = ((NUMBER) ords[indx]).doubleValue();

                y = ((NUMBER) ords[indx + 1]).doubleValue();

                gpx.lineTo(x, y);

                ind++;

            }

        }

        return return_following_must_do_first;

    }

    private static int getLineToType(Datum[] infos, int i) {

        int resp = PathIterator.SEG_LINETO;

        try {

            if (((NUMBER) infos[(3 * i) + 2]).intValue() == 2) {

                resp = PathIterator.SEG_QUADTO;

            }

        }

        catch (SQLException e) {

            e.printStackTrace();

        }

        return resp;

    }

    // CREATE TYPE sdo_geometry AS OBJECT (

    // SDO_GTYPE NUMBER,

    // SDO_SRID NUMBER,

    // SDO_POINT SDO_POINT_TYPE,

    // SDO_ELEM_INFO SDO_ELEM_INFO_ARRAY,

    // SDO_ORDINATES SDO_ORDINATE_ARRAY);

    private static GeneralPathX parseOracleStruct(STRUCT s)

        throws SQLException {

        GeneralPathX resp = new GeneralPathX();

        ARRAY infoARRAY = null;

        ARRAY ordsARRAY = null;

        Datum[] info_array = null;

        Datum[] ords_array = null;

        int info_array_size = 0;

        int[] start_ind;

        int[] end_ind;

        int dims = 0;

        boolean next_must_do_first = true;

        Datum[] aux = s.getOracleAttributes();

        infoARRAY = (ARRAY) aux[3];

        ordsARRAY = (ARRAY) aux[4];

        dims = ((NUMBER) aux[0]).intValue() / 1000;

        if (dims == 0) {

            dims = 2;

        }

        info_array = (Datum[]) infoARRAY.getOracleArray();

        ords_array = (Datum[]) ordsARRAY.getOracleArray();

        info_array_size = info_array.length / 3;

        int last_index = ords_array.length - dims + 1;

        // set indices:

        start_ind = new int[info_array_size];

        end_ind = new int[info_array_size];

        for (int i = 0; i < info_array_size; i++)

            start_ind[i] = ((NUMBER) info_array[3 * i]).intValue();

        for (int i = 0; i < (info_array_size - 1); i++)

            end_ind[i] = start_ind[i + 1] - 1;

        end_ind[info_array_size - 1] = last_index;

        int lineType = PathIterator.SEG_LINETO;

        if (end_ind[0] == 0) { // collection of paths

            for (int i = 1; i < info_array_size; i++) {

                lineType = getLineToType(info_array, i);

                next_must_do_first = addOrdsToGPX(resp, start_ind[i] - 1,

                        end_ind[i] - 1, ords_array, dims, lineType, (i == 1),

                        next_must_do_first);

            }

        }

        else {

            // standard case, do the moveto always

            for (int i = 0; i < info_array_size; i++) {

                lineType = getLineToType(info_array, i);

                addOrdsToGPX(resp, start_ind[i] - 1, end_ind[i] - 1,

                    ords_array, dims, lineType, true, true);

            }

        }

        return resp;

    }

    public static void main(String[] args) {

        /*

         * System.err.println("dburl has the following format:");

         * System.err.println("jdbc:postgresql://HOST:PORT/DATABASENAME");

         * System.err.println("tablename is 'jdbc_test' by default.");

         * System.exit(1);

         */

        String dburl = "jdbc:oracle:thin:@//localhost:1521/xe";

        String dbuser = "system";

        String dbpass = "aquilina";

        String dbtable = "VIAS";

        Connection conn = null;

        System.out.println("Creating JDBC connection...");

        try {

            DriverManager.registerDriver(new OracleDriver());

            conn = DriverManager.getConnection(dburl, dbuser, dbpass);

            conn.setAutoCommit(false);

            long t1 = System.currentTimeMillis();

            test1(conn, dburl, dbuser, dbpass, dbtable);

            // testHashID(conn, dburl, dbuser, dbpass, dbtable);

            long t2 = System.currentTimeMillis();

            System.out.println("Tiempo de consulta1:" + (t2 - t1) +

                " milisegundos");

            //			t1 = System.currentTimeMillis();

            //			OracleSpatialDriver driver = initDriverOracle(conn, dburl, dbuser, dbpass, dbtable);

            //			while (driver.getRowCount() == 0)

            //			{

            //				// do Nothing

            //			}

            //			t2 = System.currentTimeMillis();

            //			System.out.println("Tiempo de inicializar capa:" + (t2 - t1)

            //					+ " milisegundos");

            //

            //			t1 = System.currentTimeMillis();

            //			test4(driver);

            //			t2 = System.currentTimeMillis();

            //			System.out.println("Tiempo de recorrer capa:" + (t2 - t1)

            //					+ " milisegundos");

            conn.close();

        }

        catch (SQLException e) {

            // TODO Auto-generated catch block

            e.printStackTrace();

        }

    }

    /**

     * @param conn

     * @param dburl

     * @param dbuser

     * @param dbpass

     * @param dbtable

     */

    private static void test1(Connection conn, String dburl, String dbuser,

        String dbpass, String dbtable) {

        try {

            String strSQL = "select c.geometry, ROWID from " + dbtable + " c";

            //			String strSQL = "select c.GEOMETRY, ROWID  from VIAS c where (sdo_filter(GEOMETRY, mdsys.sdo_geometry(2003, 82337, null, mdsys.sdo_elem_info_array(1, 1003, 1), mdsys.sdo_ordinate_array(-167305.445478584,3826564.14408529, 1026816.46891846,3826564.14408529, 1026816.46891846,4919672.72433395, -167305.445478584,4919672.72433395, -167305.445478584,3826564.14408529)), 'mask=anyinteract querytype=window') = 'TRUE')";

            Statement s = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,

                    ResultSet.CONCUR_READ_ONLY);

            int fetchSize = 20000;

            s.setFetchSize(fetchSize);

            s.setFetchDirection(ResultSet.FETCH_FORWARD);

            //            s.execute("declare wkb_cursor binary cursor for " + strSQL);

            long t1 = System.currentTimeMillis();

            //            ResultSet r =   s.executeQuery("fetch forward " + fetchSize + " in wkb_cursor");

            OracleResultSet r = (OracleResultSet) s.executeQuery(strSQL);

            long t2 = System.currentTimeMillis();

            System.out.println("Tiempo de consulta:" + (t2 - t1) + " msecs.");

            ResultSetMetaData metadata = r.getMetaData();

            System.out.println(metadata.getColumnClassName(1));

            // Estar?a bien tener una clase OraParser separada,

            // igual que tenemos WKBParser y WKTParser.

            WKBParser2 parser = new WKBParser2();

            int numReg = 0;

            while (r.next()) {

                /*

                 * ?Hay otros m?todos de leer el campo SDO_GEOMETRY?

                 * STRUCT parece muy lento, sobre todo al tener que procesarlo

                 * despu?s.

                 */

                //				JGeometry geom = (JGeometry) r.getObject(1, mymap);

                //				byte[] aux2 = r.getBytes(1);

                //				InputStream aux = r.getBinaryStream(1);

                STRUCT _st = (oracle.sql.STRUCT) r.getObject(1);

                GeneralPathX gpx = parseOracleStruct(_st);

                //

                //				// Prueba con la parte de Prodevelop

                ////				GeneralPathX gpx = OracleSpatialUtils.structToGPX(_st

                ////						.getOracleAttributes());

                //				IGeometry geom = ShapeFactory.createGeometry(new FPolyline2D(gpx));

                /* PRUEBA CON LA CARGA STANDARD DE ORACLE */

                //				 JGeometry jg = JGeometry.load(_st);

                // GeneralPathX gpx = OracleSpatialUtils.structToGPX(_st);

                numReg++;

            }

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

            s.close();

        }

        catch (Exception e) {

            e.printStackTrace();

        }

    }

    private static void testHashID(Connection conn, String dburl,

        String dbuser, String dbpass, String dbtable) {

        try {

            /*

             * Create a statement and execute a select query.

             */

            // String strSQL = "select rowid, c.geometry.SDO_ELEM_INFO from " +

            // dbtable + "

            // c";

            String strSQL = "select rowid from " + dbtable;

            PreparedStatement s = conn.prepareStatement(strSQL);

            // Statement s =

            // conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,

            // ResultSet.CONCUR_READ_ONLY);

            int fetchSize = 5000;

            s.setFetchSize(fetchSize);

            ResultSet r = s.executeQuery(strSQL);

            int id = 0;

            while (r.next()) {

                String strAux = r.getString(1);

                id++;

                // System.out.println("Row " + id + ":" + strAux);

            }

            s.close();

        }

        catch (Exception e) {

            e.printStackTrace();

        }

    }

    /**

     * Prueba con JTS_IO. (OraReader)

     * @param conn

     * @param dburl

     * @param dbuser

     * @param dbpass

     * @param dbtable

     * @throws SQLException

     */

    private static void test3(Connection conn, String dburl, String dbuser,

        String dbpass, String dbtable) throws SQLException {

        // Usando el OraReader de JTSIO.

        OraReader or = new OraReader();

        String strSQL = "select c.GEOMETRY, ROWID  from VIAS c where (sdo_filter(GEOMETRY, mdsys.sdo_geometry(2003, 82337, null, mdsys.sdo_elem_info_array(1, 1003, 1), mdsys.sdo_ordinate_array(-167305.445478584,3826564.14408529, 1026816.46891846,3826564.14408529, 1026816.46891846,4919672.72433395, -167305.445478584,4919672.72433395, -167305.445478584,3826564.14408529)), 'mask=anyinteract querytype=window') = 'TRUE')";

        Statement s = conn.createStatement(ResultSet.TYPE_FORWARD_ONLY,

                ResultSet.CONCUR_READ_ONLY);

        int fetchSize = 20000;

        s.setFetchSize(fetchSize);

        s.setFetchDirection(ResultSet.FETCH_FORWARD);

        long t1 = System.currentTimeMillis();

        ResultSet r = s.executeQuery(strSQL);

        long t2 = System.currentTimeMillis();

        System.out.println("Tiempo de consulta:" + (t2 - t1) + " msecs.");

        ResultSetMetaData metadata = r.getMetaData();

        System.out.println(metadata.getColumnClassName(1));

        WKBParser2 parser = new WKBParser2();

        int numReg = 0;

        while (r.next()) {

            STRUCT st = (oracle.sql.STRUCT) r.getObject(1);

            MultiLineString pt2 = (MultiLineString) or.read(st);

            numReg++;

        }

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

        s.close();

    }

    private static void test4(OracleSpatialDriver driver) {

        try {

            IFeatureIterator geomIt = driver.getFeatureIterator(

                    "SELECT ROWID, GEOMETRY FROM VIAS");

            while (geomIt.hasNext()) {

                IFeature feat = geomIt.next();

                IGeometry geom = feat.getGeometry();

            }

        }

        catch (Exception e) {

            e.printStackTrace();

        }

    }

    private static OracleSpatialDriver initDriverOracle(IConnection conn,

        String dburl, String dbuser, String dbpass, String dbtable) {

        try {

            String fidField = "rowid"; // BE CAREFUL => MAY BE NOT!!!

            String geomField = "geometry"; // BE CAREFUL => MAY BE NOT!!! =>

            String[] fields = new String[1];

            fields[0] = "rowid";

            String whereClause = "";

            OracleSpatialDriver driver = new OracleSpatialDriver();

            // Here you can set the workingArea

            // driver.setWorkingArea(dbLayerDefinition.getWorkingArea());

            String strEPSG = "23030";

            DBLayerDefinition lyrDef = new DBLayerDefinition();

            lyrDef.setName(dbtable);

            lyrDef.setTableName(dbtable);

            lyrDef.setWhereClause(whereClause);

            lyrDef.setFieldNames(fields);

            lyrDef.setFieldGeometry(geomField);

            lyrDef.setFieldID(fidField);

            // if (dbLayerDefinition.getWorkingArea() != null)

            // lyrDef.setWorkingArea(dbLayerDefinition.getWorkingArea());

            lyrDef.setSRID_EPSG(strEPSG);

            if (driver instanceof ICanReproject) {

                ((ICanReproject) driver).setDestProjection(strEPSG);

            }

            driver.setData(conn, lyrDef);

            IProjection proj = null;

            if (driver instanceof ICanReproject) {

                proj = CRSFactory.getCRS("EPSG:" +

                        ((ICanReproject) driver).getSourceProjection(conn, lyrDef));

            }

            return driver;

        }

        catch (Exception e) {

            e.printStackTrace();

        }

        return null;

    }

}

package org.gvsig.oraclespatial;

import java.sql.SQLException;

import java.util.ArrayList;

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

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

import oracle.sql.NUMBER;

import oracle.sql.STRUCT;

import oracle.sql.StructDescriptor;

public class TestStCreator {

	private static int index = 0;

	private STRUCT[] st = new STRUCT[2];

	private static IConnection conn;

	public static STRUCT getStruct() {

		STRUCT resp = getStruct(index);

		index++;

		return resp;

	}

	private static STRUCT getStruct(int ind) {

		STRUCT resp = null;

        StructDescriptor dsc = null;

        Object[] obj = new Object[5];

        obj[0] = new NUMBER(2007);

        obj[1] = null;

        obj[2] = null;

		NUMBER[] indices = null;

		NUMBER[] ords = null;

        try {

			dsc = StructDescriptor.createDescriptor(

					"MDSYS.SDO_GEOMETRY",

					((ConnectionJDBC) conn).getConnection());

		} catch (SQLException e) {

			System.err.println(e.getMessage());

		}

		if (ind == 0) {

			System.err.println("CREANDO STRUCT 0...");

			indices = new NUMBER[36];

			indices[0] = new NUMBER(1);

			indices[1] = new NUMBER(1005);

			indices[2] = new NUMBER(4);

			indices[3] = new NUMBER(1);

			indices[4] = new NUMBER(2);

			indices[5] = new NUMBER(2);

			indices[6] = new NUMBER(5);

			indices[7] = new NUMBER(2);

			indices[8] = new NUMBER(2);

			indices[9] = new NUMBER(9);

			indices[10] = new NUMBER(2);

			indices[11] = new NUMBER(2);

			indices[12] = new NUMBER(13);

			indices[13] = new NUMBER(2);

			indices[14] = new NUMBER(1);

			indices[15] = new NUMBER(181);

			indices[16] = new NUMBER(1003);

			indices[17] = new NUMBER(1);

			indices[18] = new NUMBER(315);

			indices[19] = new NUMBER(1003);

			indices[20] = new NUMBER(1);

			indices[21] = new NUMBER(409);

			indices[22] = new NUMBER(1005);

			indices[23] = new NUMBER(4);

			indices[24] = new NUMBER(409);

			indices[25] = new NUMBER(2);

			indices[26] = new NUMBER(2);

			indices[27] = new NUMBER(413);

			indices[28] = new NUMBER(2);

			indices[29] = new NUMBER(1);

			indices[30] = new NUMBER(621);

			indices[31] = new NUMBER(2);

			indices[32] = new NUMBER(1);

			indices[33] = new NUMBER(685);

			indices[34] = new NUMBER(2);

			indices[35] = new NUMBER(1);

			ords = new NUMBER[688];

			// =================================

			for (int i=0; i<89; i++) {

				ords[2 * i] = new NUMBER(5000 + i);

				ords[2 * i + 1] = new NUMBER(i*i);

			}

			ords[178] = new NUMBER(5000);

			ords[179] = new NUMBER(0);

			// =================================

			for (int i=90; i<156; i++) {

				ords[2 * i] = new NUMBER(6000 + i);

				ords[2 * i + 1] = new NUMBER(i*i);

			}

			ords[312] = new NUMBER(6000 + 90);

			ords[313] = new NUMBER(90*90);

			// =================================

			for (int i=157; i<202; i++) {

				ords[2 * i] = new NUMBER(7000 + i);

				ords[2 * i + 1] = new NUMBER(10 * (i % 2));

			}

			ords[404] = new NUMBER(7070);

			ords[405] = new NUMBER(500);

			ords[406] = new NUMBER(7157);

			ords[407] = new NUMBER(10 * (157 % 2));

			// =================================

			for (int i=204; i<342; i++) {

				ords[2 * i] = new NUMBER(8000 + i);

				ords[2 * i + 1] = new NUMBER(10 * (i % 2));

			}

			ords[684] = new NUMBER(8300);

			ords[685] = new NUMBER(500);

			ords[686] = new NUMBER(8204);

			ords[687] = new NUMBER(10 * (204 % 2));

			// =================================

		} else {

			System.err.println("CREANDO STRUCT 1...");

			indices = new NUMBER[30];

			indices[0] = new NUMBER(1);

			indices[1] = new NUMBER(1003);

			indices[2] = new NUMBER(1);

			indices[3] = new NUMBER(39);

			indices[4] = new NUMBER(1003);

			indices[5] = new NUMBER(1);

			indices[6] = new NUMBER(327);

			indices[7] = new NUMBER(1005);

			indices[8] = new NUMBER(6);

			indices[9] = new NUMBER(327);

			indices[10] = new NUMBER(2);

			indices[11] = new NUMBER(2);

			indices[12] = new NUMBER(331);

			indices[13] = new NUMBER(2);

			indices[14] = new NUMBER(1);

			indices[15] = new NUMBER(1011);

			indices[16] = new NUMBER(2);

			indices[17] = new NUMBER(2);

			indices[18] = new NUMBER(1015);

			indices[19] = new NUMBER(2);

			indices[20] = new NUMBER(2);

			indices[21] = new NUMBER(1019);

			indices[22] = new NUMBER(2);

			indices[23] = new NUMBER(2);

			indices[24] = new NUMBER(1023);

			indices[25] = new NUMBER(2);

			indices[26] = new NUMBER(1);

			indices[27] = new NUMBER(2033);

			indices[28] = new NUMBER(2003);

			indices[29] = new NUMBER(1);

			ords = new NUMBER[2040];

			// =================================

			for (int i=0; i<18; i++) {

				ords[2 * i] = new NUMBER(1000 + i);

				ords[2 * i + 1] = new NUMBER(i*i);

			}

			ords[36] = new NUMBER(1000);

			ords[37] = new NUMBER(0);

			// =================================

			for (int i=19; i<162; i++) {

				ords[2 * i] = new NUMBER(2000 + i);

				ords[2 * i + 1] = new NUMBER(i*i);

			}

			ords[324] = new NUMBER(2000 + 19);

			ords[325] = new NUMBER(19 * 19);

			// =================================

			for (int i=163; i<1014; i++) {

				ords[2 * i] = new NUMBER(3000 + i);

				ords[2 * i + 1] = new NUMBER(10 * (i % 2));

			}

			ords[2028] = new NUMBER(4000);

			ords[2029] = new NUMBER(100);

			ords[2030] = new NUMBER(3163);

			ords[2031] = new NUMBER(10 * (163 % 2));

			// =================================

			ords[2032] = new NUMBER(3500);

			ords[2033] = new NUMBER(-100);

			ords[2034] = new NUMBER(3600);

			ords[2035] = new NUMBER(-100);

			ords[2036] = new NUMBER(3500);

			ords[2037] = new NUMBER(-200);

			ords[2038] = new NUMBER(3500);

			ords[2039] = new NUMBER(-100);

			// =================================

		}

        obj[3] = indices;

        obj[4] = ords;

        try {

			resp = new STRUCT(dsc, ((ConnectionJDBC) conn).getConnection(), obj);

		} catch (SQLException e) {

			System.err.println(e.getMessage());

		}

		return resp;

	}

	public static void init(IConnection _conn) {

		conn = _conn;

	}

}

add_connection=Afegir connexi?

almacenar_sc_de_vista=Salvar sistema de refer?ncia de la vista

cancel=Cancel.lar

choose_connection=Seleccione connexi?

conectar_jdbc=Intentant connectar

connection_error=Error de connexi?

error=Error

exportando_features=Exportant registres

exporting_=Exportant

geometries=geometr?es

insertar_capa=Afegir capa

insertar_en_la_vista_la_capa_creada=Afegir capa a la vista actual

intro_tablename=Introduisca nom de la taula

nombre_demasiado_largo=Nom massa llarg

nombre_no_valido=Nom no ?s v?lid

oracle_spatial=Oracle Spatial

password=Contrasenya

#Translations for language [pt]

#Thu Sep 28 13:19:48 CEST 2006

area_trabajo=\u00c1rea de trabalho

aviso_sin_extent_de_referencia=Para usar esta op\u00e7\u00e3o necessita ter como m\u00ednimo uma capa j\u00e1 adicionada que sirva de referencia.

back=Anterior

bd=bd

capa_importada=Capa importada. Deseja criar o \u00edndice espacial?

connection_name=Nome da conex\u00e3o

database_connection=

DBManager=

driver=Driver

error_conexion=Erro ao conectar \u00e0 base de dados.

host=M\u00e1quina

importar_extent=Importar a extens\u00e3o actual da vista

intro_tablename=Introduza o nome da tabela a criar. AVISO\: Se existe a tabela, vai ser apagada.

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=Seguinte

nombre_capa=Nome da capa

password=Senha

puerto=Porta

seleccion_de_campos=Selec\u00e7\u00e3o de campos

seleccione_tabla=Selecciona a tabela

select_all=Seleccionar todos

select_geom_field=Selecciona o campo que leva a geometria

select_none=Remover todos

select_unique_field=Seleccione o campo \u00fanico

usuario=Usu\u00e1rio

<?xml version="1.0" encoding="ISO-8859-1"?>

<plugin-config>

	<libraries library-dir="lib"/>

	<depends plugin-name="com.iver.cit.gvsig" />

	<depends plugin-name="org.gvsig.geodb" />

	<resourceBundle name="text"/>

	<extensions>

		<extension class-name="org.gvsig.oraclespatial.extension.ExportOracleExtension"

			description="Support to access Oracle Spatial databases" active="true">

			<menu text="Capa/export_to/oracle_spatial"

			action-command="EXPORT_TO_ORACLE_SPATIAL"

			icon="images/oracle.png"

			position="400" />

		</extension> 

		<extension class-name="org.gvsig.oraclespatial.extension.NewOracleSpatialTableExtension"

			description="Support to create new  Oracle Spatial tables" active="true">

			<menu text="Vista/new_layer/new_oracle_spatial_table" action-command="NEW_ORACLE_SPATIAL"

			icon="images/oracle.png" />

		</extension>

	</extensions>

</plugin-config>

#Translations for language [cs]

#Thu Sep 28 13:19:48 CEST 2006

area_trabajo=Pracovn\u00ed oblast

aviso_sin_extent_de_referencia=Aby jste mohli pou\u017e\u00edt tuto volbu, pot\u0159ebujete m\u00edt alespo\u0148 jednu vrstvu jako referen\u010dn\u00ed

back=P\u0159edchoz\u00ed

bd=db

capa_importada=Vrstva importov\u00e1na. Chcete vytvo\u0159it prostorov\u00fd index?

connection_name=N\u00e1zev spojen\u00ed

database_connection=

DBManager=

driver=Ovlada\u010d

error_conexion=Chyba p\u0159i spojen\u00ed s datab\u00e1z\u00ed

host=

importar_extent=Import aktu\u00e1ln\u00ed viditeln\u00e9 oblasti

intro_tablename=Zadejte n\u00e1zev tabulky k vytvo\u0159en\u00ed. VAROV\u00c1N\u00cd\: Pokud tabulka existuje bude vymaz\u00e1na.

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=Dal\u0161\u00ed

nombre_capa=N\u00e1zev vrstvy

password=K\u00f3d

puerto=

seleccion_de_campos=V\u00fdb\u011br pole

seleccione_tabla=V\u00fdb\u011br tabulky

select_all=Vyber v\u0161e

select_geom_field=Vyber polo\u017eku s geometri\u00ed

select_none=Odstra\u0148 v\u0161e

select_unique_field=Vyber jedine\u010dnou polo\u017eku

usuario=U\u017eivatel

#Translations for language [fr]

#Thu Sep 28 13:19:48 CEST 2006

area_trabajo=Espace de travail

aviso_sin_extent_de_referencia=Pour utiliser cette option, vous devez disposer d'une couche de r\u00e9f\u00e9rence.

back=Pr\u00e9c\u00e9dent

bd=bd

capa_importada=Couche g\u00e9ographique import\u00e9e. Voulez-vous cr\u00e9er un index spatial?

connection_name=Nom de la connexion

database_connection=

DBManager=

driver=Driver

error_conexion=Erreur de connexion \u00e0 la base de donn\u00e9es.

host=Machine

importar_extent=Importer l'extension de la vue

intro_tablename=D\u00e9finir le nom de la couche \u00e0 importer. ATTENTION\: Si la table existe d\u00e9j\u00e0, elle sera supprim\u00e9e.

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=Suivant

nombre_capa=Nom de la couche

password=Mot de passe

puerto=Port

seleccion_de_campos=S\u00e9lection des champs

seleccione_tabla=S\u00e9lectionnez la table

select_all=Tout s\u00e9lectionner

select_geom_field=S\u00e9lection la colonne g\u00e9ometrie

select_none=Tout supprimmer

select_unique_field=S\u00e9lectionner le champs unique

usuario=Utilisateur

#Translations for language [de]

#Thu Sep 28 13:19:48 CEST 2006

area_trabajo=Arbeitsbereich

aviso_sin_extent_de_referencia=F\u00fcr diese Option wird mindestens ein bereits hinzugef\u00fcgter Layer als Referenz ben\u00f6tigt.

back=Zur\u00fcck

bd=db

capa_importada=Importierter Layer. Wollen sie den r\u00e4umlichen Index einrichten?

connection_name=Name der verbindung

database_connection=

DBManager=

driver=Treiber

error_conexion=Fehler bei der Verbindung zur Datenbank

host=

importar_extent=Aktuellen Ansichtsbereich importieren.

intro_tablename=Bitte den Namen der neuen Tabelle eingeben. ACHTUNG\: Wenn es bereits eine Tabelle dieses Namens gibt, wird sie gel\u00f6scht\!

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=Weiter

nombre_capa=Name des Layers

password=Passwort

puerto=

seleccion_de_campos=Auswahl der felder

seleccione_tabla=W\u00e4hlen sie die tabelle aus.

select_all=Alle ausw\u00e4hlen

select_geom_field=W\u00e4hlen Sie das Feld mit der Geometrie aus.

select_none=Alle aus der Auswahl entfernen

select_unique_field=W\u00e4hlen Sie das einmalige Feld aus.

usuario=Benutzer

#Translations for language [eu]

#Thu Sep 28 13:19:48 CEST 2006

area_trabajo=Lan eremua

aviso_sin_extent_de_referencia=Aukera hau erabiltzeko aurretik erreferentzia gisa erabiliko den beste geruza bat erantsita izan behar duzu.

back=Aurrekoa

bd=bd

capa_importada=Inportatutako geruza. Espazio-indizea sortu nahi duzu?

connection_name=Konexioaren izena

database_connection=

DBManager=

driver=Driver

error_conexion=Errorea datu-basera konektatzean.

host=

importar_extent=Inportatu oraingo bistaren extent-a

intro_tablename=Sortuko duzun taularen izena sartu. OHARRA\: Taula aurretik badago, ezabatu egingo da.

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=Hurrengoa

nombre_capa=Geruzaren izena

password=Gakoa

puerto=Ataka

seleccion_de_campos=Eremuak hautatzea

seleccione_tabla=Hautatu taula

select_all=Hautatu dena

select_geom_field=Hautatu geometria duen eremua

select_none=Kendu denak

select_unique_field=Hautatu eremu bakarra

usuario=Erabiltzailea

#Translations for language [nl]

#Tue Dec 12 10:59:28 GMT+01:00 2006

area_trabajo=Werkplaats

aviso_sin_extent_de_referencia=

back=Terug

bd=db

connection_name=

database_connection=

DBManager=

driver=driver

error_conexion=

host=computer

importar_extent=Huidig kaartbeeld extentie importen

maxx=

maxy=

minx=

miny=

next=Volgende

nombre_capa=Naam van de laag

password=

puerto=Haven

seleccion_de_campos=

seleccione_tabla=Selecteer tabel

select_all=Selecteer alles

select_geom_field=Selecteer veld met geometrie

select_none=Verwijder alles

select_unique_field=Selecteer een uniek veld

usuario=Gebruiker

where_clause=

#Translations for language [it]

#Thu Oct 05 17:04:17 CEST 2006

area_trabajo=Area di lavoro

aviso_sin_extent_de_referencia=Per usare questa opzione \u00e9 necessario avere come minimo un layer gi\u00e0 aperto che serva da riferimento

back=Precedente

bd=Database

capa_importada=Layer importato, vuoi creare l'indice spaziale?

connection_name=Nome della connessione

database_connection=Connessione al database

DBManager=

driver=Driver

error_conexion=Errore nel connettersi al database

host=HOST

importar_extent=Importare l'estensione attuale della vista

intro_tablename=Inserisci il nome della tabella da creare. AVVISO\: Se la tabella esiste, si canceller\u00e0.

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=Successivo

nombre_capa=Nome del layer

password=Password

puerto=Porta

seleccion_de_campos=Selezione dei campi

seleccione_tabla=Seleziona la tabella

select_all=Seleziona tutto

select_geom_field=Seleziona il campo geometrico

select_none=Togli tutto

select_unique_field=Seleziona campo unico

usuario=Utente

#Translations for language [po]

#Tue Dec 12 10:59:28 GMT+01:00 2006

area_trabajo=

aviso_sin_extent_de_referencia=

back=

bd=

connection_name=

database_connection=

DBManager=

driver=

error_conexion=

host=

importar_extent=

maxx=

maxy=

minx=

miny=

next=

nombre_capa=

password=

puerto=

seleccion_de_campos=

seleccione_tabla=

select_all=

select_geom_field=

select_none=

select_unique_field=

usuario=

where_clause=

add_connection=A?adir conexi?n

almacenar_sc_de_vista=Almacenar sistema se referencia de la vista

cancel=Cancelar

choose_connection=Elija conexi?n

list_connection=Lista de conexiones

conectar_jdbc=Intentando conectar

connection_error=Error de conexi?n

error=Error

exportando_features=Exportando registros

exporting_=Exportando

geometries=geometr?as

insertar_capa=Insertar capa

insertar_en_la_vista_la_capa_creada=Insertar capa en vista actual

intro_tablename=Introduzca nombre de tabla

nombre_demasiado_largo=Nombre demasiado largo

nombre_no_valido=Nombre no v?lido

new_oracle_spatial_table=Nueva tabla Oracle Spatial

oracle_spatial=Oracle Spatial

password=Contrase?a

#Translations for language [zh]

#Tue Dec 12 10:59:28 GMT+01:00 2006

area_trabajo=\u5de5\u4f5c\u8303\u56f4

aviso_sin_extent_de_referencia=\u5fc5\u987b\u5df2\u6709\u56fe\u5c42\u4f5c\u4e3a\u53c2\u8003\uff0c\u624d\u53ef\u4ee5\u4f7f\u7528\u8fd9\u4e2a\u9009\u9879\u3002

back=\u540e\u9000

bd=\u6570\u636e\u5e93

capa_importada=\u56fe\u5c42\u5df2\u8f93\u5165\u3002\u60a8\u8981\u521b\u5efa\u7a7a\u95f4\u7d22\u5f15\u5417\uff1f

connection_name=\u8fde\u63a5

database_connection=\u6570\u636e\u5e93\u8fde\u63a5

DBManager=\u6570\u636e\u5e93\u7ba1\u7406\u5668

driver=\u9a71\u52a8\u7a0b\u5e8f

error_conexion=\u4e0e\u6570\u636e\u5e93\u8fde\u63a5\u65f6\u51fa\u9519

host=\u4e3b\u673a

importar_extent=\u8f93\u5165\u5f53\u524d\u89c6\u56fe\u6269\u5c55

intro_tablename=\u8f93\u5165\u65b0\u5efa\u8868\u683c\u540d\u79f0\u3002 \u6ce8\u610f\: \u5982\u679c\u8868\u683c\u5df2\u5b58\u5728, \u5b83\u5c06\u4f1a\u88ab\u5220\u9664\u3002

maxx=X\u8f74\u6700\u5927\u503c

maxy=Y\u8f74\u6700\u5927\u503c

minx=X\u8f74\u6700\u5c0f\u503c

miny=Y\u8f74\u6700\u5c0f\u503c

next=\u7ee7\u7eed

nombre_capa=\u56fe\u5c42\u540d\u79f0

password=\u5bc6\u7801

puerto=\u94fe\u63a5\u53e3

seleccion_de_campos=\u9009\u62e9\u5b57\u6bb5

seleccione_tabla=\u9009\u62e9\u8868\u683c

select_all=\u9009\u62e9\u5168\u90e8

select_geom_field=\u9009\u62e9\u5305\u542b\u51e0\u4f55\u7684\u5b57\u6bb5

select_none=\u5168\u90e8\u6e05\u9664

select_unique_field=\u9009\u62e9\u552f\u4e00\u5b57\u6bb5

usuario=\u7528\u6237

where_clause=Where \u5b50\u53e5

add_connection=Add connection

almacenar_sc_de_vista=Save current view's coordinate system in table

cancel=Cancel

choose_connection=Choose connection

list_connection=Connection list

conectar_jdbc=Trying to connect

connection_error=Connection error

error=Error

exportando_features=Exporting features

exporting_=Exporting

geometries=geometr?es

insertar_capa=Add layer

insertar_en_la_vista_la_capa_creada=Add layer to currant view

intro_tablename=Enter table name

nombre_demasiado_largo=Name is too long

nombre_no_valido=Invalid name

new_oracle_spatial_table=New Oracle Spatial table

oracle_spatial=Oracle Spatial

password=Password

#Translations for language [gl]

#Thu Sep 28 13:19:48 CEST 2006

area_trabajo=\u00c1rea de traballo

aviso_sin_extent_de_referencia=Para usar esta opci\u00f3n precisa ter como m\u00ednimo unha capa xa engadida que serva de referencia

back=Anterior

bd=bd

capa_importada=Capa mportada. Desexa crear o \u00edndice espacial?

connection_name=Nome da conexi\u00f3n

database_connection=

DBManager=

driver=Driver

error_conexion=Erro ao conectar \u00e1 base de datos

host=M\u00e1quina

importar_extent=Importar o extent actual da vista

intro_tablename=Introduza o nome da t\u00e1boa a crear. AVISO\: Se a t\u00e1boa xa existe, ser\u00e1 borrada

maxx=max.x

maxy=max.y

minx=min.x

miny=min.y

next=Seguinte

nombre_capa=Nome da capa

password=Chave

puerto=Porto

seleccion_de_campos=Selecci\u00f3n de campos

seleccione_tabla=Seleccione a t\u00e1boa

select_all=Seleccionar todo

select_geom_field=Selecciona o campo que leva a xeometr\u00eda

select_none=Quitar todos

select_unique_field=Seleccione o campo \u00fanico

usuario=Usuario

#!/bin/sh

java -jar oracle_spatial_driver.jar

java -jar oracle_spatial_driver.jar

<installation version="1.0">

	<info>

		<appname>gvSIG_1.0.2</appname>

		<appversion>1.0.2</appversion>

		<authors>

			<author name="Generalitat Valenciana. Conselleria d'Infraestructures i Transport" email="" />

			<author name="Prodevelop S.L." email="" />

		</authors>

		<url>http://www.prodevelop.es</url>

		<javaversion>1.4</javaversion>

		<uninstaller name="oracle_spatial_driver_uninstaller.jar" write="yes" />		

	</info>

	<guiprefs height="600" resizable="yes" width="800">

		<laf name="liquid">

			<os family="unix" />

		</laf>

		<laf name="liquid">

			<os family="windows" />

		</laf>

	</guiprefs>

	<locale>

		<langpack iso3="spa"/>

		<langpack iso3="val"/>

		<langpack iso3="eng"/>

		<langpack iso3="cat"/>

		<langpack iso3="chn"/>

		<langpack iso3="cze"/>

		<langpack iso3="dan"/>

		<langpack iso3="deu"/>

		<langpack iso3="fin"/>

		<langpack iso3="fra"/>

		<langpack iso3="glg"/>

		<langpack iso3="hun"/>

		<langpack iso3="ita"/>

		<langpack iso3="jpn"/>

		<langpack iso3="mys"/>

		<langpack iso3="ned"/>

		<langpack iso3="nor"/>

		<langpack iso3="pol"/>

		<langpack iso3="por"/>

		<langpack iso3="rom"/>

		<langpack iso3="rus"/>

		<langpack iso3="scg"/>

		<langpack iso3="svk"/>

		<langpack iso3="swe"/>

		<langpack iso3="ukr"/>

	</locale>

	<resources>

		<res src="resources/gpl.txt" id="LicencePanel.licence"/>

		<res src="resources/LEEME.html" id="HTMLInfoPanel.info"/>

		<res src="resources/images/Logo_gvsig_gva.jpg" id="Installer.image"/>

                <res src="resources/userInputSpec.xml" id="userInputSpec.xml"/>

                <parsable os="linux" targetfile="resources/userInputSpec.xml"/>

                <res src="resources/userInputLang.xml_val" id="userInputLang.xml_val" />

                <res src="resources/userInputLang.xml_spa" id="userInputLang.xml_spa" />

	</resources>

	<panels>

		<panel classname="HTMLInfoPanel"/>

		<panel classname="LicencePanel"/>

		<panel classname="PacksPanel"/>

		<panel classname="UserInputPanel"/>

		<panel classname="InstallPanel"/>

		<panel classname="SimpleFinishPanel"/>

	</panels>

	<packs>

		<pack name="Oracle Spatial driver" required="yes">

			<description>Adds the Oracle Spatial driver to read/write Oracle tables with columns of SDO_GEOMETRY type</description>

			<fileset targetdir="$INSTALL_PATH/bin" dir="./bin" override="true"

			excludes="**/*.svn"

			/>

		</pack>

	</packs>

</installation>