| gvSIG desktop 1

new_oracle_spatial_table=Nueva tabla Oracle Spatial

new_oracle_spatial_table=New Oracle Spatial table

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

			icon="images/oracle.png" />

		</extension>

		<extension class-name="es.prodevelop.cit.gvsig.jdbc_spatial.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>

            	DBLayerDefinition db_lyr_def = getLyrDef();

            	if (db_lyr_def == null) {

            		logger.warn("Found a null DB layer definition, method initialize of OracleWriter not called.");

            	} else {

            		writer.initialize(getLyrDef());

            	}

     * Tells whether the SRS is geodetic or not-

    public static boolean createEmptyTable(

    		DBLayerDefinition lyr_def,

    		IConnection the_conn,

    		Rectangle2D rect) {

            String srid_epsg = lyr_def.getSRID_EPSG();

            boolean with_srid = true;

            String _ora_srid = "NULL";

            try {

				_ora_srid = OracleSpatialDriver.epsgSridToOracleSrid(srid_epsg);

			} catch (Exception e1) {

				logger.error("Unknown EPSG code: " + srid_epsg);

				with_srid = false;

			}

            String _sql_rem_meta = OracleSpatialDriver.getRemoveMetadataSql(lyr_def);

            String _sql_drop = OracleSpatialDriver.getDropTableSql(lyr_def);

            String _sql_creation = OracleSpatialDriver.getTableCreationSql(lyr_def);

            String _sql_index = OracleSpatialDriver.getIndexCreationSql(lyr_def);

            String _sql_meta = OracleSpatialDriver.getMetadataUpdateSql(

            		lyr_def.getUser(),

            		lyr_def.getTableName(),

            		_ora_srid, rect, 2, with_srid);

            boolean removed = true;

            try {

                java.sql.PreparedStatement ps =

                	((ConnectionJDBC) the_conn).getConnection().prepareStatement(_sql_drop);

                ps.execute();

                ps.close();

            }

            catch (SQLException ex) {

                logger.info("Table did not exist: " + lyr_def.getTableName());

                removed = false;

            }

            if (removed) {

                logger.info("Table existed and was deleted: " + lyr_def.getTableName());

            }

            try {

                java.sql.PreparedStatement ps = ((ConnectionJDBC) the_conn).getConnection().prepareStatement(_sql_creation);

                ps.execute();

                ps.close();

            }

            catch (SQLException ex) {

                logger.error("Error while executing SQL for table creation: " +

                    ex.getMessage(), ex);

                return false;

            }

            try {

                java.sql.PreparedStatement ps = ((ConnectionJDBC)the_conn).getConnection().prepareStatement(_sql_rem_meta);

                ps.execute();

                ps.close();

            }

            catch (SQLException ex) {

                logger.error("Error while executing SQL for metadata removal: " +

                    ex.getMessage(), ex);

            }

            try {

                java.sql.PreparedStatement ps = ((ConnectionJDBC)the_conn).getConnection().prepareStatement(_sql_meta);

                ps.execute();

                ps.close();

            }

            catch (SQLException ex) {

                logger.error(

                    "Error while executing SQL for metadata insertion: " +

                    ex.getMessage(), ex);

                return false;

            }

            try {

                java.sql.PreparedStatement ps = ((ConnectionJDBC)the_conn).getConnection().prepareStatement(_sql_index);

                ps.execute();

                ps.close();

            }

            catch (SQLException ex) {

                logger.error("Error while executing SQL for index creation: " +

                    ex.getMessage(), ex);

                return false;

            }

            return true;

    }

package es.prodevelop.cit.gvsig.jdbc_spatial;

import javax.swing.ImageIcon;

import org.apache.log4j.Logger;

import com.hardcode.driverManager.Driver;

import com.hardcode.driverManager.DriverManager;

import com.iver.andami.PluginServices;

import com.iver.andami.plugins.Extension;

import com.iver.andami.ui.mdiManager.IWindow;

import com.iver.andami.ui.wizard.WizardAndami;

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

import com.iver.cit.gvsig.fmap.edition.IWriteable;

import com.iver.cit.gvsig.fmap.layers.LayerFactory;

import com.iver.cit.gvsig.project.documents.view.gui.View;

import es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver;

import es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard.NewOracleSpatialTableWizard;

import es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard.RepeatedChooseGeometryTypePanel;

import es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard.RepeatedFieldDefinitionPanel;

public class NewOracleSpatialTableExtension extends Extension {

    private static Logger logger = Logger.getLogger(NewOracleSpatialTableExtension.class.getName());

    public static boolean ORACLE_JAR_PRESENT = false;

	public void initialize() {

		ORACLE_JAR_PRESENT = isOracleJarPresent();

	}

	public void execute(String actionCommand) {

        if (actionCommand.compareToIgnoreCase("NEW_ORACLE_SPATIAL") == 0) {

       	 IWindow w = PluginServices.getMDIManager().getActiveWindow();

       	 if (w instanceof View) {

       		 try {

       			String _file = createResourceUrl("images/new_geodb_table.png").getFile();

       			ImageIcon iicon = new ImageIcon(_file);

       			 DriverManager writerManager = LayerFactory.getDM();

       			 WizardAndami wizard = new WizardAndami(iicon);

       			 RepeatedChooseGeometryTypePanel panelChoose =

       				 new RepeatedChooseGeometryTypePanel(wizard.getWizardComponents());

       			 RepeatedFieldDefinitionPanel panelFields =

       				 new RepeatedFieldDefinitionPanel(wizard.getWizardComponents());

       			 NewOracleSpatialTableWizard connPanel = 

       				 new NewOracleSpatialTableWizard(wizard.getWizardComponents());

       			 wizard.getWizardComponents().addWizardPanel(panelChoose);

       			 wizard.getWizardComponents().addWizardPanel(panelFields);

       			 wizard.getWizardComponents().addWizardPanel(connPanel);

       			 Driver driver = writerManager.getDriver(OracleSpatialDriver.NAME);

       			 panelFields.setWriter(((IWriteable) driver).getWriter());

       			 panelChoose.setDriver(driver);

       			 View theView = (View) w;

       			 MapContext mc = theView.getMapControl().getMapContext();

       			 NewOracleSpatialTableFinishAction action = 

       				 new NewOracleSpatialTableFinishAction(

       						 wizard.getWizardComponents(),

       						 wizard,

       						 connPanel,

       						 mc);

       			 wizard.getWizardComponents().setFinishAction(action);

           		 wizard.getWizardComponents().getFinishButton().setEnabled(false);

           		 wizard.getWindowInfo().setWidth(640);

           		 wizard.getWindowInfo().setHeight(350);

           		 wizard.getWindowInfo().setTitle(PluginServices.getText(this, "new_layer"));

           		 PluginServices.getMDIManager().addWindow(wizard);

       		 } catch (Exception ex) {

       			 logger.error("While showing new oracle spatial table wizard: " + ex.getMessage());

       		 }

       	 }

       }

	}

	public boolean isEnabled() {

		if (!ORACLE_JAR_PRESENT) return false;

		IWindow w = PluginServices.getMDIManager().getActiveWindow();

      	return (w instanceof View); 

	}

	public boolean isVisible() {

		return isEnabled();

	}

	/**

	 * Check presence of ojdbc14.jar.

	 * @return

	 */

    private boolean isOracleJarPresent() {

    	try {

    		Class rowid_class = Class.forName("oracle.sql.ROWID");

    	} catch (Exception ex) {

    		logger.error("Unable to instantiate ROWID (oracle jar missing?) : " + ex.getMessage());

    		return false;

    	}

		return true;

	}	

    private java.net.URL createResourceUrl(String path) {

        return getClass().getClassLoader().getResource(path);

    }    

}

import java.util.ArrayList;

import javax.swing.ImageIcon;

import com.hardcode.driverManager.Driver;

import com.hardcode.driverManager.DriverLoadException;

import com.hardcode.driverManager.DriverManager;

import com.iver.andami.messages.NotificationManager;

import com.iver.andami.ui.wizard.WizardAndami;

import com.iver.cit.gvsig.fmap.edition.IWriteable;

import com.iver.cit.gvsig.fmap.layers.LayerFactory;

import es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver;

import es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard.NewOracleSpatialTableWizard;

import es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard.RepeatedChooseGeometryTypePanel;

import es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard.RepeatedFieldDefinitionPanel;

    		logger.error("Unable to instantiate ROWID (oracle jar missing?) : " + ex.getMessage());

package es.prodevelop.cit.gvsig.jdbc_spatial;

import java.awt.geom.Rectangle2D;

import java.sql.Types;

import java.util.ArrayList;

import org.apache.log4j.Logger;

import com.hardcode.driverManager.Driver;

import com.iver.andami.PluginServices;

import com.iver.andami.ui.mdiManager.IWindow;

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

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

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

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

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

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

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

import com.iver.cit.gvsig.fmap.drivers.db.utils.ConnectionWithParams;

import com.iver.cit.gvsig.fmap.layers.FLyrVect;

import com.iver.cit.gvsig.fmap.layers.LayerFactory;

import es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver;

import es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialWriter;

import es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard.NewOracleSpatialTableWizard;

import es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard.RepeatedChooseGeometryTypePanel;

import es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard.RepeatedFieldDefinitionPanel;

import jwizardcomponent.FinishAction;

import jwizardcomponent.JWizardComponents;

public class NewOracleSpatialTableFinishAction extends FinishAction {

	private static Logger logger = Logger.getLogger(NewOracleSpatialTableFinishAction.class.getName());

	private NewOracleSpatialTableWizard connectionPanel;

	private RepeatedChooseGeometryTypePanel geoTypePanel;

	private RepeatedFieldDefinitionPanel fieldsPanel;

	private MapContext theMapContext;

	private IWindow closeThis;

	// ...

	public NewOracleSpatialTableFinishAction(

			JWizardComponents wc,

			IWindow closeit,

			NewOracleSpatialTableWizard connPanel,

			MapContext mc) {

		super(wc);

		theMapContext = mc;

		closeThis = closeit;

		connectionPanel = connPanel;

		geoTypePanel = (RepeatedChooseGeometryTypePanel) wc.getWizardPanel(0);

		fieldsPanel = (RepeatedFieldDefinitionPanel) wc.getWizardPanel(1);

	}

	public void performAction() {

		PluginServices.getMDIManager().closeWindow(closeThis);

		ViewPort vp = theMapContext.getViewPort();

		DBLayerDefinition lyr_def = new DBLayerDefinition();

		FieldDescription[] flds = fieldsPanel.getFieldsDescription();

		FieldDescription[] flds_new = getValidFields(flds);

		lyr_def.setFieldsDesc(flds_new);

		String table_name = geoTypePanel.getLayerName().toUpperCase();

		lyr_def.setTableName(table_name);

		String usr = connectionPanel.getConnectionWithParams().getUser();

		lyr_def.setUser(usr.toUpperCase());

		String epsg_code = vp.getProjection().getAbrev();

		lyr_def.setSRID_EPSG(epsg_code.substring(5));

		lyr_def.setFieldID(OracleSpatialDriver.ORACLE_ID_FIELD);

		lyr_def.setFieldGeometry(OracleSpatialDriver.DEFAULT_GEO_FIELD);

		lyr_def.setWhereClause("");

		Rectangle2D extent = vp.getAdjustedExtent();

		if (extent == null) {

			int h = vp.getImageHeight();

			int w = vp.getImageWidth();

			extent = new Rectangle2D.Double(0, 0, w, h);

		}

		IConnection iconn = connectionPanel.getConnectionWithParams().getConnection();

		// --------------------------------------------------------------------

		// -------------------------------------------------------------------

		// --------------------------------------------------------------------

		theMapContext.beginAtomicEvent();

		OracleSpatialWriter.createEmptyTable(lyr_def, iconn, extent);

		OracleSpatialDriver oracleDrv = new OracleSpatialDriver();

		oracleDrv.setData(iconn, lyr_def);

		FLyrVect lyr = (FLyrVect) LayerFactory.createDBLayer(

				oracleDrv,

				table_name,

				vp.getProjection());

		lyr.setVisible(true);

		theMapContext.getLayers().addLayer(lyr);

		theMapContext.endAtomicEvent();

		// --------------------------------------------------------------------

		// --------------------------------------------------------------------

		// --------------------------------------------------------------------

	}

	private boolean validFieldName(FieldDescription f_desc) {

		if ((f_desc.getFieldName().compareToIgnoreCase(OracleSpatialDriver.DEFAULT_ID_FIELD_CASE_SENSITIVE) == 0)

				|| (f_desc.getFieldName().compareToIgnoreCase(OracleSpatialDriver.ORACLE_ID_FIELD) == 0)) {

			return false;

		}

		return true;

	}

	private FieldDescription[] getValidFields(FieldDescription[] ff) {

		// remove GID, ROWID

		ArrayList aux = new ArrayList();

		// rowid

		FieldDescription row_fld = new FieldDescription();

		row_fld.setFieldName(OracleSpatialDriver.ORACLE_ID_FIELD);

		row_fld.setFieldType(Types.VARCHAR);

		aux.add(row_fld);

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

			if (validFieldName(ff[i])) {

				aux.add(ff[i]);

			}

		}

		// gid

		FieldDescription gid_fld = new FieldDescription();

		gid_fld.setFieldName(OracleSpatialDriver.DEFAULT_ID_FIELD_CASE_SENSITIVE);

		gid_fld.setFieldType(Types.INTEGER);

		aux.add(gid_fld);

		return (FieldDescription[]) aux.toArray(new FieldDescription[0]);

		// -------

	}

}

package es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard;

import java.awt.Component;

import java.awt.event.ActionEvent;

import java.awt.event.ActionListener;

import java.awt.event.ItemEvent;

import java.awt.event.ItemListener;

import java.beans.PropertyChangeEvent;

import java.beans.PropertyChangeListener;

import javax.swing.ImageIcon;

import javax.swing.JButton;

import javax.swing.JComboBox;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import org.apache.log4j.Logger;

import com.iver.andami.PluginServices;

import com.iver.cit.gvsig.SingleVectorialDBConnectionExtension;

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

import com.iver.cit.gvsig.fmap.drivers.db.utils.ConnectionWithParams;

import com.iver.cit.gvsig.fmap.drivers.db.utils.SingleVectorialDBConnectionManager;

import com.iver.utiles.swing.JPasswordDlg;

import com.prodevelop.cit.gvsig.vectorialdb.wizard.VectorialDBConnectionParamsDialog;

import jwizardcomponent.JWizardComponents;

import jwizardcomponent.JWizardPanel;

public class NewOracleSpatialTableWizard extends JWizardPanel implements ItemListener, PropertyChangeListener, ActionListener {

	private static Logger logger = Logger.getLogger(NewOracleSpatialTableWizard.class.getName());

	public NewOracleSpatialTableWizard(JWizardComponents wizardComponents) {

		super(wizardComponents);

		wizardComponents.addPropertyChangeListener(this);

		initialize();

	}

	private JLabel chooseConnLabel = null;

	private JComboBox datasourceComboBox;

	private ConnectionWithParams theConnWithParams = null;

	private JButton dbButton;

	/**

	 * This method initializes this

	 *

	 */

	private void initialize() {

		datasourceComboBox = getDatasourceComboBox();

		loadVectorialDBDatasourcesCombo();

		chooseConnLabel = new JLabel();

		chooseConnLabel.setText(PluginServices.getText(this, "choose_connection"));

		chooseConnLabel.setBounds(new java.awt.Rectangle(14,9,300,21));

		dbButton = getJdbcButton();

        this.setLayout(null);

        this.setSize(new java.awt.Dimension(358,263));

        this.add(chooseConnLabel, null);

        this.add(datasourceComboBox, null);

        this.add(dbButton, null);

        getWizardComponents().getFinishButton().setEnabled(false);

	}

	public ConnectionWithParams getConnectionWithParams() {

		return theConnWithParams;

	}

    private JComboBox getDatasourceComboBox() {

        if (datasourceComboBox == null) {

            datasourceComboBox = new JComboBox();

            datasourceComboBox.setBounds(new java.awt.Rectangle(14,32,300,22));

            datasourceComboBox.addItemListener(this);

        }

        return datasourceComboBox;

    }	

    private void loadVectorialDBDatasourcesCombo() {

        getDatasourceComboBox().removeAllItems();

        getDatasourceComboBox().addItem(new ConnectionWithParams());

        ConnectionWithParams[] conn =

        	SingleVectorialDBConnectionManager.instance().getAllConnections();

        if (conn == null) {

            return;

        }

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

            getDatasourceComboBox().addItem(conn[i]);

        }

    }

	public void itemStateChanged(ItemEvent e) {

		Object src = e.getSource();

		if (src == datasourceComboBox) {

            Object sel_obj = datasourceComboBox.getSelectedItem();

            if (sel_obj == null) {

            	getWizardComponents().getFinishButton().setEnabled(false);

            	theConnWithParams = null;

                return;

            }

            if (!(sel_obj instanceof ConnectionWithParams)) {

            	getWizardComponents().getFinishButton().setEnabled(false);

            	theConnWithParams = null;

                return;

            }

            ConnectionWithParams cwp = (ConnectionWithParams) sel_obj; 

            if (cwp.isNull()) {

            	getWizardComponents().getFinishButton().setEnabled(false);

            	theConnWithParams = null;

                return;

            }

            if (!cwp.isConnected()) {

                if (!tryToConnect(cwp)) {

                	getWizardComponents().getFinishButton().setEnabled(false);

                	theConnWithParams = null;

                	datasourceComboBox.setSelectedIndex(0);

                    return;

                }

            }

            theConnWithParams = cwp;

            getWizardComponents().getFinishButton().setEnabled(true);

            datasourceComboBox.repaint();

		}

	}    

    private boolean tryToConnect(ConnectionWithParams _cwp) {

        JPasswordDlg dlg = new JPasswordDlg();

        dlg.setLocationRelativeTo((Component)PluginServices.getMainFrame());

        String strMessage = PluginServices.getText(this, "conectar_jdbc");

        String strPassword = PluginServices.getText(this, "password");

        dlg.setMessage(strMessage + " [" + _cwp.getDrvName() + ", " +

            _cwp.getHost() + ", " + _cwp.getPort() + ", " + _cwp.getDb() +

            ", " + _cwp.getUser() + "]. " + strPassword + "?");

        dlg.setVisible(true);

        String clave = dlg.getPassword();

        if (clave == null) {

            return false;

        }

        try {

            _cwp.connect(clave);

        }

        catch (DBException e) {

            showConnectionErrorMessage(e.getMessage());

            return false;

        }

        return true;

    }	

    private void showConnectionErrorMessage(String _msg) {

        String msg = (_msg.length() > 300) ? "" : (": " + _msg);

        String title = PluginServices.getText(this, "connection_error");

        JOptionPane.showMessageDialog(this, title + msg, title,

            JOptionPane.ERROR_MESSAGE);

    }

	public void propertyChange(PropertyChangeEvent evt) {

		if (evt.getPropertyName().compareToIgnoreCase(JWizardComponents.CURRENT_PANEL_PROPERTY) == 0) {

			if (evt.getNewValue() == this) {

				boolean valid_conn = !(theConnWithParams == null);

				getWizardComponents().getFinishButton().setEnabled(valid_conn);

			}

		}

	}    

    private ConnectionWithParams addNewConnection() {

        ConnectionWithParams resp = null;

        VectorialDBConnectionParamsDialog newco = new VectorialDBConnectionParamsDialog();

        newco.showDialog();

        if (newco.isOkPressed()) {

            String _drvname = newco.getConnectionDriverName();

            String _host = newco.getConnectionServerUrl();

            String _port = newco.getConnectionPort();

            String _dbname = newco.getConnectionDBName();

            String _user = newco.getConnectionUser();

            String _pw = newco.getConnectionPassword();

            String _conn_usr_name = newco.getConnectionName();

            boolean hasToBeCon = newco.hasToBeConnected();

            try {

                resp = SingleVectorialDBConnectionManager.instance()

                                                  .getConnection(_drvname,

                        _user, _pw, _conn_usr_name, _host, _port, _dbname,

                        hasToBeCon);

            }

            catch (DBException e) {

                showConnectionErrorMessage(e.getMessage());

                return null;

            }

            SingleVectorialDBConnectionExtension.saveAllToPersistence();

            return resp;

        }

        else {

            return null;

        }

    }	

    /**

     * This method initializes jdbcButton

     *

     * @return javax.swing.JButton

     */

    private JButton getJdbcButton() {

        if (dbButton == null) {

            dbButton = new JButton();

            dbButton.addActionListener(this);

            dbButton.setToolTipText(PluginServices.getText(this,

                    "add_connection"));

            dbButton.setBounds(new java.awt.Rectangle(320, 32, 26, 21));

            String _file = createResourceUrl("images/jdbc.png").getFile();

            dbButton.setIcon(new ImageIcon(_file));

        }

        return dbButton;

    }

    private java.net.URL createResourceUrl(String path) {

        return getClass().getClassLoader().getResource(path);

    }

	public void actionPerformed(ActionEvent e) {

		Object src = e.getSource();

        if (src == dbButton) {

            ConnectionWithParams sel = addNewConnection();

            if (sel != null) {

                loadVectorialDBDatasourcesCombo();

                getDatasourceComboBox().setSelectedItem(sel);

            }

        }

	}    

}

package es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard;

import java.awt.BorderLayout;

import java.awt.Component;

import java.sql.Types;

import java.util.ArrayList;

import javax.swing.DefaultCellEditor;

import javax.swing.JButton;

import javax.swing.JComboBox;

import javax.swing.JLabel;

import javax.swing.JOptionPane;

import javax.swing.JPanel;

import javax.swing.JScrollPane;

import javax.swing.JTable;

import javax.swing.ListSelectionModel;

import javax.swing.event.ListSelectionEvent;

import javax.swing.event.ListSelectionListener;

import javax.swing.table.DefaultTableModel;

import javax.swing.table.TableColumn;

import jwizardcomponent.JWizardComponents;

import jwizardcomponent.JWizardPanel;

import com.iver.andami.PluginServices;

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

import com.iver.cit.gvsig.fmap.edition.IWriter;

/**

 * @author fjp

 *

 * Panel para que el usuario seleccione el driver que va a utilizar para

 * crear un tema desde cero

 *

 */

public class RepeatedFieldDefinitionPanel extends JWizardPanel {

	private JLabel jLabel = null;

	private JScrollPane jScrollPane = null;

	private JTable jTable = null;

	private JPanel jPanelEast = null;

	private JButton jButtonAddField = null;

	private JButton jButtonDeleteField = null;

	private int MAX_FIELD_LENGTH = 254;

	private IWriter writer = null;

	public RepeatedFieldDefinitionPanel(JWizardComponents wizardComponents) {

		super(wizardComponents, null);

		initialize();

		// TODO Auto-generated constructor stub

	}

	/* (non-Javadoc)

	 * @see jwizardcomponent.JWizardPanel#next()

	 */

	public void next() {

		DefaultTableModel tm=(DefaultTableModel) jTable.getModel();

		boolean valid=true;

		for (int i = 0;i<tm.getRowCount();i++) {

				String s=(String)tm.getValueAt(i,0);

				valid=validate(s);

				String size=(String) tm.getValueAt(i,2);

				valid=valid && validateInteger(size);

				if (!valid){

					return;

				}

				String type = (String) tm.getValueAt(i,1);

				int length = Integer.parseInt((String) tm.getValueAt(i,2));

				if (type.equals("String") && length > MAX_FIELD_LENGTH) {

					JOptionPane.showMessageDialog(this, PluginServices.getText(this, "max_length_is") + ": " + MAX_FIELD_LENGTH+

							"\n"+PluginServices.getText(this, "length_of_field")+ " '"+ s + "' " + PluginServices.getText(this, "will_be_truncated"));

					tm.setValueAt(String.valueOf(MAX_FIELD_LENGTH),i,2);

				}

		}

		// ensure no field name is used more than once

		ArrayList fieldNames = new ArrayList();

		for (int i = 0; i < jTable.getRowCount(); i++) {

			if (fieldNames.contains(tm.getValueAt(i,0))) {

				valid = false;

				JOptionPane.showMessageDialog(this, PluginServices.getText(this, "two_or_more_fields_with_the_same_name"));

				break;

			}

			fieldNames.add(tm.getValueAt(i, 0));

		}

		if (valid)

			super.next();

	}

	public void setWriter(IWriter writer) {

		this.writer = writer;

	}

	public IWriter getWriter() {

		return this.writer;

	}

	private boolean validateInteger(String size) {

		boolean valid=true;

		try{

		Integer.parseInt(size);

		}catch (NumberFormatException e) {

			valid=false;

			JOptionPane.showMessageDialog((Component)PluginServices.getMainFrame(),

					PluginServices.getText(this,"no_puede_continuar")+"\n"+

					PluginServices.getText(this,"size")+" : "+size+"\n"+

					PluginServices.getText(this,"incorrect_value"));

		}

		return valid;

	}

	private boolean validate(String s) {

		boolean valid=true;

		if (s.equals("")) {

			valid=false;

			JOptionPane.showMessageDialog((Component)PluginServices.getMainFrame(),

					PluginServices.getText(this,"no_puede_continuar")+"\n"+

					PluginServices.getText(this,"the_field_name_is_required"));

		}

		if (s.indexOf(" ")!=-1) {

			valid=false;

			JOptionPane.showMessageDialog((Component)PluginServices.getMainFrame(),

					PluginServices.getText(this,"no_puede_continuar")+"\n"+

					PluginServices.getText(this,"field")+" : "+s+"\n"+

					PluginServices.getText(this,"contiene_espacios_en_blanco"));

		}

		if (this.writer != null && this.writer.getCapability("FieldNameMaxLength") != null) {

			String value = writer.getCapability("FieldNameMaxLength");

			int intValue;

			try {

				intValue = Integer.parseInt(value);

			} catch (NumberFormatException e) {

				intValue = 0;

			}

			if (intValue > 0 && s.length() > intValue) {

				valid=false;

				JOptionPane.showMessageDialog((Component)PluginServices.getMainFrame(),

						PluginServices.getText(this,"no_puede_continuar")+"\n"+

						PluginServices.getText(this,"field")+" : "+s+"\n"+

						PluginServices.getText(this,"too_long_name")+"\n"+

						PluginServices.getText(this,"maximun_name_size")+" : "+intValue+"\n"

						);

			}

		}

		return valid;

	}

	/**

	 * This method initializes this

	 *

	 */

	private void initialize() {

        jLabel = new JLabel();

        jLabel.setText(PluginServices.getText(this,"define_fields"));

        this.setLayout(new BorderLayout(5,5));

        this.setSize(new java.awt.Dimension(499,232));

        this.add(jLabel, java.awt.BorderLayout.NORTH);

        this.add(getJScrollPane(), java.awt.BorderLayout.CENTER);

        this.add(getJPanelEast(), java.awt.BorderLayout.EAST);

	}

	/**

	 * This method initializes jScrollPane

	 *

	 * @return javax.swing.JScrollPane

	 */

	private JScrollPane getJScrollPane() {

		if (jScrollPane == null) {

			jScrollPane = new JScrollPane();

			jScrollPane.setViewportView(getJTable());

		}

		return jScrollPane;

	}

	/**

	 * This method initializes jTable

	 *

	 * @return javax.swing.JTable

	 */

	private JTable getJTable() {

		if (jTable == null) {

			jTable = new JTable();

			DefaultTableModel tm = (DefaultTableModel) jTable.getModel();

			tm.addColumn(PluginServices.getText(this,"field"));

			// TableColumn fieldTypeColumn = new TableColumn(1);

			// fieldTypeColumn.setHeaderValue("Type");

			// jTable.addColumn(fieldTypeColumn);

			tm.addColumn(PluginServices.getText(this,"type"));

			// MIRAR EL C?DIGO DEL BOT?N DE A?ADIR CAMPO PARA VER EL CellEditor con comboBox

			/* TableColumn fieldLengthColumn = new TableColumn(2);

			fieldLengthColumn.setHeaderValue("Length");

			// fieldLengthColumn.setCellRenderer(new DefaultTableCellRenderer());

			jTable.addColumn(fieldLengthColumn); */

			tm.addColumn(PluginServices.getText(this,"length"));

//			Ask to be notified of selection changes.

			ListSelectionModel rowSM = jTable.getSelectionModel();

			rowSM.addListSelectionListener(new ListSelectionListener() {

			    public void valueChanged(ListSelectionEvent e) {

			        //Ignore extra messages.

			        if (e.getValueIsAdjusting()) return;

			        ListSelectionModel lsm =

			            (ListSelectionModel)e.getSource();

			        if (lsm.isSelectionEmpty()) {

			            //no rows are selected

			        	jButtonDeleteField.setEnabled(false);

			        } else {

			            // int selectedRow = lsm.getMinSelectionIndex();

			            //selectedRow is selected

			        	jButtonDeleteField.setEnabled(true);

			        }

			    }

			});

			jTable.getColumn(PluginServices.getText(this,"field")).setWidth(180);

		}

		return jTable;

	}

	/**

	 * This method initializes jPanelWest

	 *

	 * @return javax.swing.JPanel

	 */

	private JPanel getJPanelEast() {

		if (jPanelEast == null) {

			jPanelEast = new JPanel();

			jPanelEast.setLayout(null);

			jPanelEast.setPreferredSize(new java.awt.Dimension(170,100));

			jPanelEast.add(getJButtonAddField(), null);

			jPanelEast.add(getJButtonDeleteField(), null);

		}

		return jPanelEast;

	}

	/**

	 * This method initializes jButtonAddField

	 *

	 * @return javax.swing.JButton

	 */

	private JButton getJButtonAddField() {

		if (jButtonAddField == null) {

			jButtonAddField = new JButton();

			jButtonAddField.setText(PluginServices.getText(this,"add_field"));

			jButtonAddField.setLocation(new java.awt.Point(7,5));

			jButtonAddField.setSize(new java.awt.Dimension(145,23));

			jButtonAddField.setPreferredSize(new java.awt.Dimension(100,26));

			jButtonAddField.addActionListener(new java.awt.event.ActionListener() {

				public void actionPerformed(java.awt.event.ActionEvent e) {

					DefaultTableModel tm = (DefaultTableModel) jTable.getModel();

					// Figure out a suitable field name

					ArrayList fieldNames = new ArrayList();

					for (int i = 0; i < jTable.getRowCount(); i++) {

						fieldNames.add(tm.getValueAt(i, 0));

					}

					String[] currentFieldNames = (String[]) fieldNames.toArray(new String[0]);

					String newField = PluginServices.getText(this, "field").replaceAll(" +", "_");

					int index=0;

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

						if (currentFieldNames[i].startsWith(newField)) {

							try {

								index = Integer.parseInt(currentFieldNames[i].replaceAll(newField,""));

							} catch (Exception ex) { /* we don't care */}

						}

					}

					String newFieldName = newField+(++index);

					// Add a new row

					Object[] newRow = new Object[tm.getColumnCount()];

					newRow[0] = newFieldName;

					newRow[1] = "String";

					newRow[2] = "20";

					tm.addRow(newRow);

					// Esto lo a?ado aqu? porque si no tiene registros, no hace caso. (Por eso no

					// lo pongo en getJTable()

					TableColumn typeColumn = jTable.getColumnModel().getColumn(1);

					JComboBox comboBox = new JComboBox();

					comboBox.addItem("Boolean");

					comboBox.addItem("Date");

					comboBox.addItem("Integer");

					comboBox.addItem("Double");

					comboBox.addItem("String");

					typeColumn.setCellEditor(new DefaultCellEditor(comboBox));

					TableColumn widthColumn = jTable.getColumnModel().getColumn(2);

					// tm.setValueAt("NewField", tm.getRowCount()-1, 0);

				}

			});

		}

		return jButtonAddField;

	}

	/**

	 * This method initializes jButton

	 *

	 * @return javax.swing.JButton

	 */

	private JButton getJButtonDeleteField() {

		if (jButtonDeleteField == null) {

			jButtonDeleteField = new JButton();

			jButtonDeleteField.setText(PluginServices.getText(this,"delete_field"));

			jButtonDeleteField.setLocation(new java.awt.Point(7,33));

			jButtonDeleteField.setSize(new java.awt.Dimension(145,23));

			jButtonDeleteField.setEnabled(false);

			jButtonDeleteField.addActionListener(new java.awt.event.ActionListener() {

				public void actionPerformed(java.awt.event.ActionEvent e) {

					int[] selecteds = jTable.getSelectedRows();

					DefaultTableModel tm = (DefaultTableModel) jTable.getModel();

					for (int i=selecteds.length-1; i >=0; i--)

						tm.removeRow(selecteds[i]);

				}

			});

		}

		return jButtonDeleteField;

	}

	/**

	 * Convierte lo que hay en la tabla en una definici?n de campos

	 * adecuada para crear un LayerDefinition

	 * @return

	 */

	public FieldDescription[] getFieldsDescription() {

		DefaultTableModel tm = (DefaultTableModel) jTable.getModel();

		FieldDescription[] fieldsDesc = new FieldDescription[tm.getRowCount()];

		for (int i=0; i < tm.getRowCount(); i++)

		{

			fieldsDesc[i] = new FieldDescription();

			fieldsDesc[i].setFieldName((String) tm.getValueAt(i,0));

			String strType = (String) tm.getValueAt(i,1);

			if (strType.equals("String"))

				fieldsDesc[i].setFieldType(Types.VARCHAR);

			if (strType.equals("Double"))

				fieldsDesc[i].setFieldType(Types.DOUBLE);

			if (strType.equals("Integer"))

				fieldsDesc[i].setFieldType(Types.INTEGER);

			if (strType.equals("Boolean"))

				fieldsDesc[i].setFieldType(Types.BOOLEAN);

			if (strType.equals("Date"))

				fieldsDesc[i].setFieldType(Types.DATE);

			int fieldLength = Integer.parseInt((String) tm.getValueAt(i,2));

			fieldsDesc[i].setFieldLength(fieldLength);

			// TODO: HACERLO BIEN

			if (strType.equals("Double"))

				fieldsDesc[i].setFieldDecimalCount(5);

		}

		return fieldsDesc;

	}

}  //  @jve:decl-index=0:visual-constraint="10,10"

import com.iver.andami.PluginServices;

import com.iver.andami.ui.mdiManager.IWindow;

import com.iver.andami.ui.mdiManager.WindowInfo;

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

import com.iver.cit.gvsig.fmap.drivers.db.utils.ConnectionWithParams;

import com.iver.cit.gvsig.fmap.drivers.db.utils.SingleVectorialDBConnectionManager;

import com.iver.utiles.swing.JPasswordDlg;

import com.prodevelop.cit.gvsig.vectorialdb.wizard.VectorialDBConnectionParamsDialog;

import es.prodevelop.cit.gvsig.fmap.drivers.jdbc.oracle.OracleSpatialDriver;

            String _file = createResourceUrl("images/jdbc.png").getFile();

package es.prodevelop.cit.gvsig.jdbc_spatial.gui.jdbcwizard;

import javax.swing.ButtonGroup;

import javax.swing.ImageIcon;

import javax.swing.JLabel;

import javax.swing.JPanel;

import javax.swing.JRadioButton;

import javax.swing.JTextField;

import javax.swing.event.CaretEvent;

import javax.swing.event.CaretListener;

import jwizardcomponent.JWizardComponents;

import jwizardcomponent.JWizardPanel;

import com.hardcode.driverManager.Driver;

import com.iver.andami.PluginServices;

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

import com.iver.cit.gvsig.fmap.edition.ISpatialWriter;

import com.iver.cit.gvsig.fmap.edition.IWriteable;

/**

 * @author fjp

 *

 * Panel para que el usuario seleccione el driver que va a utilizar para

 * crear un tema desde cero.

 *

 */

public class RepeatedChooseGeometryTypePanel extends JWizardPanel {

	private JLabel lblSelecGeometryType = null;

	private JPanel jPanelGeometryTypeOptions = null;

	private JRadioButton jRadioButtonPoint = null;

	private JRadioButton jRadioButtonLine = null;

	private JRadioButton jRadioButtonPolygon = null;

	private JRadioButton jRadioButtonMulti = null;

	private JRadioButton jRadioButtonMultiPoint = null;

	private JTextField jTextFieldLayerName = null;

	private JLabel jLabelLayerName = null;

	private String driverName;

	private class MyInputEventListener implements CaretListener

	{

		public void caretUpdate(CaretEvent arg0) {

			if (jTextFieldLayerName.getText().length() > 0)

				setNextButtonEnabled(true);

			else

				setNextButtonEnabled(false);

		}

	}

	public RepeatedChooseGeometryTypePanel(JWizardComponents wizardComponents) {

		super(wizardComponents);

		initialize();

		// TODO Auto-generated constructor stub

	}

	/**

	 * This method initializes this

	 *

	 */

	private void initialize() {

        jLabelLayerName = new JLabel();

        jLabelLayerName.setBounds(new java.awt.Rectangle(14,9,321,22));

        jLabelLayerName.setText(PluginServices.getText(this,"enter_layer_name"));

        lblSelecGeometryType = new JLabel();

        lblSelecGeometryType.setText(PluginServices.getText(this,"select_geometry_type"));

        lblSelecGeometryType.setBounds(new java.awt.Rectangle(13,63,329,15));

        this.setLayout(null);

        this.setSize(new java.awt.Dimension(358,263));

        this.add(lblSelecGeometryType, null);

        this.add(getJPanelGeometryTypeOptions(), null);

        this.add(getJTextFieldLayerName(), null);

        this.add(jLabelLayerName, null);

	}

	/**

	 * This method initializes jPanelGeometryTypeOptions

	 *

	 * @return javax.swing.JPanel

	 */

	private JPanel getJPanelGeometryTypeOptions() {

		if (jPanelGeometryTypeOptions == null) {

			jPanelGeometryTypeOptions = new JPanel();

			jPanelGeometryTypeOptions.setLayout(null);

			jPanelGeometryTypeOptions.setBorder(javax.swing.BorderFactory.createTitledBorder(null, PluginServices.getText(this,"Geometry_types"), javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, null, null));

			jPanelGeometryTypeOptions.setPreferredSize(new java.awt.Dimension(300,400));

			jPanelGeometryTypeOptions.setBounds(new java.awt.Rectangle(14,82,326,172));

			jPanelGeometryTypeOptions.add(getJRadioButtonPoint(), null);

			jPanelGeometryTypeOptions.add(getJRadioButtonLine(), null);

			jPanelGeometryTypeOptions.add(getJRadioButtonPolygon(), null);

			jPanelGeometryTypeOptions.add(getJRadioButtonMulti(), null);

			jPanelGeometryTypeOptions.add(getJRadioButtonMultiPoint(), null);

		    //Group the radio buttons.

		    ButtonGroup group = new ButtonGroup();

		    group.add(getJRadioButtonPoint());

		    group.add(getJRadioButtonLine());

		    group.add(getJRadioButtonPolygon());

		    group.add(getJRadioButtonMulti());

		    group.add(getJRadioButtonMultiPoint());

		}

		return jPanelGeometryTypeOptions;

	}

	/**

	 * This method initializes jRadioButtonPoint

	 *

	 * @return javax.swing.JRadioButton

	 */

	private JRadioButton getJRadioButtonPoint() {

		if (jRadioButtonPoint == null) {

			jRadioButtonPoint = new JRadioButton();

			jRadioButtonPoint.setText(PluginServices.getText(this,"point_type"));

			jRadioButtonPoint.setBounds(new java.awt.Rectangle(19,31,297,23));

		}

		return jRadioButtonPoint;

	}

	/**

	 * This method initializes jRadioButtonLine

	 *

	 * @return javax.swing.JRadioButton

	 */

	private JRadioButton getJRadioButtonLine() {

		if (jRadioButtonLine == null) {

			jRadioButtonLine = new JRadioButton();

			jRadioButtonLine.setText(PluginServices.getText(this,"line_type"));

			jRadioButtonLine.setSelected(true);

			jRadioButtonLine.setBounds(new java.awt.Rectangle(19,81,297,23));

		}

		return jRadioButtonLine;

	}

	/**

	 * This method initializes jRadioButtonPolygon

	 *

	 * @return javax.swing.JRadioButton

	 */

	private JRadioButton getJRadioButtonPolygon() {

		if (jRadioButtonPolygon == null) {

			jRadioButtonPolygon = new JRadioButton();

			jRadioButtonPolygon.setText(PluginServices.getText(this,"polygon_type"));

			jRadioButtonPolygon.setBounds(new java.awt.Rectangle(19,106,297,23));

		}

		return jRadioButtonPolygon;

	}

	/**

	 * This method initializes jRadioButtonMulti

	 *

	 * @return javax.swing.JRadioButton

	 */

	private JRadioButton getJRadioButtonMulti() {

		if (jRadioButtonMulti == null) {

			jRadioButtonMulti = new JRadioButton();

			jRadioButtonMulti.setText(PluginServices.getText(this,"multi_type"));

			jRadioButtonMulti.setBounds(new java.awt.Rectangle(19,131,297,23));

		}

		return jRadioButtonMulti;

	}

	/**

	 * This method initializes jRadioButton

	 *

	 * @return javax.swing.JRadioButton

	 */

	private JRadioButton getJRadioButtonMultiPoint() {

		if (jRadioButtonMultiPoint == null) {

			jRadioButtonMultiPoint = new JRadioButton();

			jRadioButtonMultiPoint.setText(PluginServices.getText(this,"multipoint_type"));

			jRadioButtonMultiPoint.setBounds(new java.awt.Rectangle(19,56,297,23));

		}

		return jRadioButtonMultiPoint;

	}

	/**

	 * En funci?n de qu? tipo de driver sea, habilitamos o deshabilitamos

	 * las opciones. Por ejemplo, si es de tipo shp, deshabilitamos

	 * multi_type

	 * @param writer

	 */

	public void setDriver(Driver driver) {

		// En funci?n de qu? tipo de driver sea, habilitamos o deshabilitamos

		// las opciones. Por ejemplo, si es de tipo shp, deshabilitamos

		// multi_type

		IWriteable aux = (IWriteable) driver;

		ISpatialWriter writer = (ISpatialWriter) aux.getWriter(); 

		driverName = driver.getName();

		getJRadioButtonPoint().setEnabled(writer.canWriteGeometry(FShape.POINT));

		getJRadioButtonMultiPoint().setEnabled(writer.canWriteGeometry(FShape.MULTIPOINT));

		getJRadioButtonLine().setEnabled(writer.canWriteGeometry(FShape.LINE));

		getJRadioButtonPolygon().setEnabled(writer.canWriteGeometry(FShape.POLYGON));

		getJRadioButtonMulti().setEnabled(writer.canWriteGeometry(FShape.MULTI));