Application: gvSIG desktop

import java.awt.Color;

import org.gvsig.tools.exception.BaseException;

//            String s = Xml2dbSwingCommons.getHTMLColorTag(Color.RED.darker(), BaseException.getMessageStack(ex, 0));            

            String s = BaseException.getMessageStack(ex, 0);            

            this.taskStatus.message(s);

import org.gvsig.xml2db.swing.impl.Task;

import java.awt.Color;

import java.io.File;

import java.util.ArrayList;

import java.util.List;

import javax.swing.AbstractListModel;

import org.cresques.cts.IProjection;

import java.nio.charset.Charset;

import javax.swing.JOptionPane;

import javax.swing.SwingUtilities;

import javax.swing.event.ChangeEvent;

import org.apache.commons.io.FilenameUtils;

import org.apache.commons.lang3.StringUtils;

import org.gvsig.fmap.dal.DALLocator;

import org.gvsig.fmap.dal.DataManager;

import org.gvsig.fmap.dal.store.h2.H2SpatialUtils;

import org.gvsig.fmap.dal.swing.ProjectionPickerController;

import org.gvsig.tools.swing.api.pickercontroller.CharsetPickerController;

import org.gvsig.tools.swing.api.task.TaskStatusController;

import org.gvsig.tools.swing.api.windowmanager.WindowManager_v2;

import org.gvsig.tools.task.SimpleTaskStatus;

import org.gvsig.tools.util.LabeledValue;

import org.gvsig.tools.util.LabeledValueImpl;

import org.gvsig.xml2db.lib.api.Xml2dbLocator;

import org.gvsig.xml2db.lib.api.Xml2dbManager;

import org.gvsig.xml2db.lib.api.xmlinfo.XMLInfo;

import org.gvsig.xml2db.lib.api.xmlinfo.XMLTableInfo;

import org.gvsig.xml2db.swing.impl.Xml2dbSwingCommons;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

@SuppressWarnings("UseSpecificCatch")

    protected static final Logger LOGGER = LoggerFactory.getLogger(CopyXml2dbPanel.class);

    private static class XMLInfoListModel extends AbstractListModel<LabeledValue<XMLTableInfo>> {

        private final XMLInfo xmlinfo;

        private final List<LabeledValue<XMLTableInfo>> tables;

        public XMLInfoListModel() {

            this(null);

        }

        public XMLInfoListModel(XMLInfo xmlinfo) {

            this.xmlinfo = xmlinfo;

            if( xmlinfo != null ) {

                this.tables = new ArrayList<>(xmlinfo.size());

                for (XMLTableInfo tableInfo : xmlinfo) {

                    this.tables.add(new LabeledValueImpl<>(tableInfo.getName(),tableInfo));

                }

            } else {

                this.tables = null;

            }

        }

        @Override

        public LabeledValue<XMLTableInfo> getElementAt(int index) {

            if( this.tables == null ) {

                return null;

            }

            return tables.get(index);

        }

        @Override

        public int getSize() {

            if( this.tables == null ) {

                return 0;

            }

            return this.tables.size();

        }

    }

    private FilePickerController pickerDbfile;

    private ProjectionPickerController pickerProjection;

    private CharsetPickerController pickerCharset;

    private TaskStatusController taskStatusController;

    private Task lastTask;

    private XMLInfo xmlinfo;

        this.lastTask = Task.FAKE_TASK;

        this.xmlinfo = null;

        this.taskStatusController = ToolsSwingLocator.getTaskStatusSwingManager().createTaskStatusController(

                lblStatusCaption, 

                lblStatusMsg,

                pbStatus

        );

        this.taskStatusController.setVisible(false);

        this.pickerXMLFile.addChangeListener((ChangeEvent e) -> {

            doChangeXMLfile();

        });

        this.pickerCharset = toolsSwingManager.createCharsetPickerController(

                null,

                this.cboCharset

        this.pickerProjection = dataSwingManager.createProjectionPickerController(

                this.txtProjection, 

                this.btnProjection

        );

        this.pickerDbfile = toolsSwingManager.createFilePickerController(

                this.txtDatabaseFile, 

                this.btnDataBaseFile

        );

        this.pickerDbfile.addChangeListener((ChangeEvent e) -> {

            doChangeDBfile();

        });

        this.pickerCharset.set(Charset.defaultCharset());

        this.chkRegisterConnection.setSelected(true);

        this.chkConnectToRepository.setSelected(true);

        this.chkOverwriteDatabase.setSelected(false);

        this.chkOverwriteDatabase.addChangeListener((ChangeEvent e) -> {

            updateStateComponents();

        });

        this.cboCharset.setSelectedIndex(-1);

        SwingUtilities.invokeLater(() -> { updateStateComponents(); });

        ToolsSwingUtils.ensureRowsCols(this, 13, 80, 15, 100);

        ToolsSwingManager toolsSwingManager = ToolsSwingLocator.getToolsSwingManager();

        toolsSwingManager.translate(this.lblCharset);

        toolsSwingManager.translate(this.lblRepositoryName);

        toolsSwingManager.translate(this.lblFileXML);

        toolsSwingManager.translate(this.lblDatabaseFile);

        toolsSwingManager.translate(this.lblProjection);

        toolsSwingManager.translate(this.lblRegisterConnection);

        toolsSwingManager.translate(this.lblConnectToRepository);

        toolsSwingManager.translate(this.lblOverwriteDatabase);

    private boolean isProcessing() {

        return this.lastTask.isProcessing();

    }

    private void updateStateComponents() {

        if( !SwingUtilities.isEventDispatchThread() ) {

            SwingUtilities.invokeLater(this::updateStateComponents);

            return;

        }

        if( this.isProcessing() ) {

            this.pickerXMLFile.setEnabled(false);

            this.pickerCharset.setEnabled(false);

            this.pickerProjection.setEnabled(false);

            if( this.dialog!=null ) {

                this.dialog.setButtonEnabled(WindowManager_v2.BUTTON_OK, false);

            }

            return;

        }

        this.pickerXMLFile.setEnabled(true);

        this.pickerCharset.setEnabled(true);

        this.pickerProjection.setEnabled(true);

        File xmlfile = this.pickerXMLFile.get();

        if( xmlfile == null || !xmlfile.exists() ) {

            if( xmlfile==null ) {

                this.message("_XML_file_is_required", JOptionPane.WARNING_MESSAGE);

            } else {

                this.message("_XML_file_not_exists", JOptionPane.WARNING_MESSAGE);

            }

            if( this.dialog!=null ) {

                this.dialog.setButtonEnabled(WindowManager_v2.BUTTON_OK, false);

            }

            return;

        }

        File dbfile = this.pickerDbfile.get();

        if( dbfile == null ) {

            this.message("_Database_file_is_required", JOptionPane.WARNING_MESSAGE);

            if( this.dialog!=null ) {

                this.dialog.setButtonEnabled(WindowManager_v2.BUTTON_OK, false);

            }

            return;

        }

        if( H2SpatialUtils.existsH2db(dbfile) && !this.chkOverwriteDatabase.isSelected() ) {

            this.message("_Database_file_already_exists", JOptionPane.WARNING_MESSAGE);

            if( this.dialog!=null ) {

                this.dialog.setButtonEnabled(WindowManager_v2.BUTTON_OK, false);

            }

            return;

        }

        if( StringUtils.isBlank(this.txtRepositoryName.getText()) ) {

            this.message("_Repository_name_is_required", JOptionPane.WARNING_MESSAGE);

            if( this.dialog!=null ) {

                this.dialog.setButtonEnabled(WindowManager_v2.BUTTON_OK, false);

            }

            return;

        }

        if( this.dialog!=null ) {

            this.dialog.setButtonEnabled(WindowManager_v2.BUTTON_OK, true);        

        }

        if( this.lastTask.needToShowTheStatus()) {

            this.taskStatusController.setVisible(true);        

        } else {

            message(null);

            this.taskStatusController.setVisible(false);        

        }

        doCopy();

    }

    private void doCopy() {

        File xmlfile = this.pickerXMLFile.get();

        if( xmlfile == null || !xmlfile.exists() ) {

            return;

        }

        IProjection proj = this.pickerProjection.get();

        Charset charset = this.pickerCharset.get();

        File dbfile = this.pickerDbfile.get();

        if( dbfile==null || dbfile.exists()) {

            return;

        }

        String s = this.txtRepositoryName.getText();

        if( StringUtils.isBlank(s) ) {

            s = FilenameUtils.getBaseName(dbfile.getName());

        } 

        String repoName = s;

        boolean registerConnection = this.chkRegisterConnection.isSelected();

        boolean connectToRepository = this.chkConnectToRepository.isSelected();

        Xml2dbManager manager = Xml2dbLocator.getXml2dbManager();

        if( H2SpatialUtils.existsH2db(dbfile) ) {

            if( !this.chkOverwriteDatabase.isSelected() ) {

                message("Database already exists", JOptionPane.WARNING_MESSAGE);

                return;

            }

        }        

        this.lastTask = new Task(                

                "Xml2db_copy", 

                "Copy xml to database", 

                this::updateStateComponents, 

                taskStatusController

            ) {

            @Override

            protected void task(SimpleTaskStatus taskStatus) throws Throwable{

                try {

                    if( H2SpatialUtils.existsH2db(dbfile) ) {

                        taskStatus.message("Removing existing database...");

                        H2SpatialUtils.server_stop();

                        H2SpatialUtils.removeH2db(dbfile);

                        H2SpatialUtils.server_start();

                    }        

                    XMLInfo xmlinfo = manager.extractStructure(xmlfile, charset, proj, taskStatus);

                    if( xmlinfo==null ) {

                        throw new RuntimeException("Can't process xml file");

                    }

                    if( proj==null && xmlinfo.getSrid()!=null ) {

                        pickerProjection.set(xmlinfo.getSrid());

                    }

                    if( xmlinfo.getCharset()!=null && charset==null ) {

                        pickerCharset.set(xmlinfo.getCharset());

                    }

                    JDBCServerExplorerParameters params = manager.createDatabase(dbfile, xmlinfo, taskStatus);

                    if( params == null ) {

                        throw new RuntimeException("Can't copy xml to database");

                    }

                    if( registerConnection ) {

                        addToConnectionPool(params,repoName);   

                    }

                    manager.copyXml2Db(xmlfile, xmlinfo.getCharset(), params, taskStatus);

                    if( connectToRepository) {

                        DataSwingManager dataSwingManager = DALSwingLocator.getDataSwingManager();

                        dataSwingManager.connectToDatabaseWorkspace(params);                        

                    }

                } catch(Exception ex) {

                    LOGGER.warn("Can't copy xml to database",ex);

                    throw ex;

                }

            }

            @Override

            protected void postTask() {

//                message(null);

            }

        };

        this.lastTask.start();

    public void addToConnectionPool(JDBCServerExplorerParameters params, String id) {

        DataManager dataManager = DALLocator.getDataManager();

        dataManager.getDataServerExplorerPool().add(id, params);

    }

    private void doChangeXMLfile() {

        File xmlfile = this.pickerXMLFile.get();

        if( xmlfile != null ) {

            File dbfile = this.pickerDbfile.get();

            if( dbfile == null ) {

                dbfile = new File(FilenameUtils.removeExtension(xmlfile.getAbsolutePath()));

                this.pickerDbfile.set(dbfile);

                this.txtRepositoryName.setText(FilenameUtils.getBaseName(xmlfile.getName()));

            }

        }

        updateStateComponents();

    }

    private void doChangeDBfile() {

        File dbfile = this.pickerDbfile.get();

        if( dbfile != null ) {

            String repoName = this.txtRepositoryName.getText();

            if( StringUtils.isBlank(repoName) ) {

                this.txtRepositoryName.setText(FilenameUtils.getBaseName(dbfile.getName()));

            }

        }

        updateStateComponents();

    }

    private void message(String msg) {

        message(msg,JOptionPane.INFORMATION_MESSAGE);

    }

    private void message(final String msg, final int type) {

        if( !SwingUtilities.isEventDispatchThread() ) {

            SwingUtilities.invokeLater(() -> { this.message(msg, type);});

            return;

        }

        if( StringUtils.isBlank(msg) ) {

            this.lblStatusMsg.setText("");

            return;

        }

        String s = msg;

        if( type == JOptionPane.WARNING_MESSAGE ) {

            s = Xml2dbSwingCommons.getHTMLColorTag(Color.RED.darker(), msg);

        }        

        this.lblStatusMsg.setText(s);

        this.lblStatusMsg.setVisible(true);

    }

   <at name="path">datos/devel/org.gvsig.desktop/org.gvsig.desktop.plugin/org.gvsig.xml2db/org.gvsig.xml2db.swing/org.gvsig.xml2db.swing.impl/src/main/java/org/gvsig/xml2db/swing/impl/copyxml2db/CopyXml2dbPanelView.xml</at>

   <at name="rowspecs">CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE,CENTER:DEFAULT:NONE,CENTER:2DLU:NONE</at>

            <at name="width">138</at>

       <object classname="com.jeta.forms.store.memento.BeanMemento">

        <super classname="com.jeta.forms.store.memento.ComponentMemento">

         <at name="cellconstraints">

          <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

           <at name="column">2</at>

           <at name="row">8</at>

           <at name="colspan">1</at>

           <at name="rowspan">1</at>

           <at name="halign">default</at>

           <at name="valign">default</at>

           <at name="insets" object="insets">0,0,0,0</at>

          </object>

         </at>

         <at name="componentclass">com.jeta.forms.gui.form.StandardComponent</at>

        </super>

        <at name="jetabeanclass">com.jeta.forms.gui.beans.JETABean</at>

        <at name="beanclass">com.jeta.forms.components.label.JETALabel</at>

        <at name="beanproperties">

         <object classname="com.jeta.forms.store.memento.PropertiesMemento">

          <at name="classname">com.jeta.forms.components.label.JETALabel</at>

          <at name="properties">

           <object classname="com.jeta.forms.store.support.PropertyMap">

            <at name="border">

             <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

              <super classname="com.jeta.forms.store.properties.BorderProperty">

               <at name="name">border</at>

              </super>

              <at name="borders">

               <object classname="java.util.LinkedList">

                <item >

                 <at name="value">

                  <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                   <super classname="com.jeta.forms.store.properties.BorderProperty">

                    <at name="name">border</at>

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

            <at name="name">lblDatabaseFile</at>

            <at name="width">138</at>

            <at name="text">_File_for_the_database</at>

            <at name="fill">

             <object classname="com.jeta.forms.store.properties.effects.PaintProperty">

              <at name="name">fill</at>

             </object>

            </at>

            <at name="height">16</at>

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

       <object classname="com.jeta.forms.store.memento.BeanMemento">

        <super classname="com.jeta.forms.store.memento.ComponentMemento">

         <at name="cellconstraints">

          <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

           <at name="column">2</at>

           <at name="row">10</at>

           <at name="colspan">1</at>

           <at name="rowspan">1</at>

           <at name="halign">default</at>

           <at name="valign">default</at>

           <at name="insets" object="insets">0,0,0,0</at>

          </object>

         </at>

         <at name="componentclass">com.jeta.forms.gui.form.StandardComponent</at>

        </super>

        <at name="jetabeanclass">com.jeta.forms.gui.beans.JETABean</at>

        <at name="beanclass">com.jeta.forms.components.label.JETALabel</at>

        <at name="beanproperties">

         <object classname="com.jeta.forms.store.memento.PropertiesMemento">

          <at name="classname">com.jeta.forms.components.label.JETALabel</at>

          <at name="properties">

           <object classname="com.jeta.forms.store.support.PropertyMap">

            <at name="border">

             <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

              <super classname="com.jeta.forms.store.properties.BorderProperty">

               <at name="name">border</at>

              </super>

              <at name="borders">

               <object classname="java.util.LinkedList">

                <item >

                 <at name="value">

                  <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                   <super classname="com.jeta.forms.store.properties.BorderProperty">

                    <at name="name">border</at>

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

            <at name="name">lblRepositoryName</at>

            <at name="width">138</at>

            <at name="text">_Name_for_the_repository</at>

            <at name="fill">

             <object classname="com.jeta.forms.store.properties.effects.PaintProperty">

              <at name="name">fill</at>

             </object>

            </at>

            <at name="height">16</at>

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

       <object classname="com.jeta.forms.store.memento.BeanMemento">

        <super classname="com.jeta.forms.store.memento.ComponentMemento">

         <at name="cellconstraints">

          <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

           <at name="column">4</at>

           <at name="row">10</at>

           <at name="colspan">1</at>

           <at name="rowspan">1</at>

           <at name="halign">default</at>

           <at name="valign">default</at>

           <at name="insets" object="insets">0,0,0,0</at>

          </object>

         </at>

         <at name="componentclass">com.jeta.forms.gui.form.StandardComponent</at>

        </super>

        <at name="jetabeanclass">com.jeta.forms.gui.beans.JETABean</at>

        <at name="beanclass">javax.swing.JTextField</at>

        <at name="beanproperties">

         <object classname="com.jeta.forms.store.memento.PropertiesMemento">

          <at name="classname">javax.swing.JTextField</at>

          <at name="properties">

           <object classname="com.jeta.forms.store.support.PropertyMap">

            <at name="border">

             <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

              <super classname="com.jeta.forms.store.properties.BorderProperty">

               <at name="name">border</at>

              </super>

              <at name="borders">

               <object classname="java.util.LinkedList">

                <item >

                 <at name="value">

                  <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                   <super classname="com.jeta.forms.store.properties.BorderProperty">

                    <at name="name">border</at>

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

            <at name="name">txtRepositoryName</at>

            <at name="width">1443</at>

            <at name="height">22</at>

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

       <object classname="com.jeta.forms.store.memento.BeanMemento">

        <super classname="com.jeta.forms.store.memento.ComponentMemento">

         <at name="cellconstraints">

          <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

           <at name="column">2</at>

           <at name="row">6</at>

           <at name="colspan">1</at>

           <at name="rowspan">1</at>

           <at name="halign">default</at>

           <at name="valign">default</at>

           <at name="insets" object="insets">0,0,0,0</at>

          </object>

         </at>

         <at name="componentclass">com.jeta.forms.gui.form.StandardComponent</at>

        </super>

        <at name="jetabeanclass">com.jeta.forms.gui.beans.JETABean</at>

        <at name="beanclass">com.jeta.forms.components.label.JETALabel</at>

        <at name="beanproperties">

         <object classname="com.jeta.forms.store.memento.PropertiesMemento">

          <at name="classname">com.jeta.forms.components.label.JETALabel</at>

          <at name="properties">

           <object classname="com.jeta.forms.store.support.PropertyMap">

            <at name="border">

             <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

              <super classname="com.jeta.forms.store.properties.BorderProperty">

               <at name="name">border</at>

              </super>

              <at name="borders">

               <object classname="java.util.LinkedList">

                <item >

                 <at name="value">

                  <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                   <super classname="com.jeta.forms.store.properties.BorderProperty">

                    <at name="name">border</at>

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

            <at name="name">lblProjection</at>

            <at name="width">138</at>

            <at name="text">_Projection</at>

            <at name="fill">

             <object classname="com.jeta.forms.store.properties.effects.PaintProperty">

              <at name="name">fill</at>

             </object>

            </at>

            <at name="height">16</at>

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

       <object classname="com.jeta.forms.store.memento.BeanMemento">

        <super classname="com.jeta.forms.store.memento.ComponentMemento">

         <at name="cellconstraints">

          <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

           <at name="column">2</at>

           <at name="row">4</at>

           <at name="colspan">1</at>

           <at name="rowspan">1</at>

           <at name="halign">default</at>

           <at name="valign">default</at>

           <at name="insets" object="insets">0,0,0,0</at>

          </object>

         </at>

         <at name="componentclass">com.jeta.forms.gui.form.StandardComponent</at>

        </super>

        <at name="jetabeanclass">com.jeta.forms.gui.beans.JETABean</at>

        <at name="beanclass">com.jeta.forms.components.label.JETALabel</at>

        <at name="beanproperties">

         <object classname="com.jeta.forms.store.memento.PropertiesMemento">

          <at name="classname">com.jeta.forms.components.label.JETALabel</at>

          <at name="properties">

           <object classname="com.jeta.forms.store.support.PropertyMap">

            <at name="border">

             <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

              <super classname="com.jeta.forms.store.properties.BorderProperty">

               <at name="name">border</at>

              </super>

              <at name="borders">

               <object classname="java.util.LinkedList">

                <item >

                 <at name="value">

                  <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                   <super classname="com.jeta.forms.store.properties.BorderProperty">

                    <at name="name">border</at>

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

            <at name="name">lblCharset</at>

            <at name="width">138</at>

            <at name="text">_Charset</at>

            <at name="fill">

             <object classname="com.jeta.forms.store.properties.effects.PaintProperty">

              <at name="name">fill</at>

             </object>

            </at>

            <at name="height">16</at>

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

       <object classname="com.jeta.forms.store.memento.BeanMemento">

        <super classname="com.jeta.forms.store.memento.ComponentMemento">

         <at name="cellconstraints">

          <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

           <at name="column">4</at>

           <at name="row">4</at>

           <at name="colspan">1</at>

           <at name="rowspan">1</at>

           <at name="halign">default</at>

           <at name="valign">default</at>

           <at name="insets" object="insets">0,0,0,0</at>

          </object>

         </at>

         <at name="componentclass">com.jeta.forms.gui.form.StandardComponent</at>

        </super>

        <at name="jetabeanclass">com.jeta.forms.gui.beans.JETABean</at>

        <at name="beanclass">javax.swing.JComboBox</at>

        <at name="beanproperties">

         <object classname="com.jeta.forms.store.memento.PropertiesMemento">

          <at name="classname">javax.swing.JComboBox</at>

          <at name="properties">

           <object classname="com.jeta.forms.store.support.PropertyMap">

            <at name="border">

             <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

              <super classname="com.jeta.forms.store.properties.BorderProperty">

               <at name="name">border</at>

              </super>

              <at name="borders">

               <object classname="java.util.LinkedList">

                <item >

                 <at name="value">

                  <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                   <super classname="com.jeta.forms.store.properties.BorderProperty">

                    <at name="name">border</at>

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

            <at name="name">cboCharset</at>

            <at name="width">1443</at>

            <at name="items">

             <object classname="com.jeta.forms.store.properties.ItemsProperty">

              <at name="name">items</at>

             </object>

            </at>

            <at name="height">22</at>

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

       <object classname="com.jeta.forms.store.memento.BeanMemento">

        <super classname="com.jeta.forms.store.memento.ComponentMemento">

         <at name="cellconstraints">

          <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

           <at name="column">2</at>

           <at name="row">12</at>

           <at name="colspan">1</at>

           <at name="rowspan">1</at>

           <at name="halign">default</at>

           <at name="valign">default</at>

           <at name="insets" object="insets">0,0,0,0</at>

          </object>

         </at>

         <at name="componentclass">com.jeta.forms.gui.form.StandardComponent</at>

        </super>

        <at name="jetabeanclass">com.jeta.forms.gui.beans.JETABean</at>

        <at name="beanclass">com.jeta.forms.components.label.JETALabel</at>

        <at name="beanproperties">

         <object classname="com.jeta.forms.store.memento.PropertiesMemento">

          <at name="classname">com.jeta.forms.components.label.JETALabel</at>

          <at name="properties">

           <object classname="com.jeta.forms.store.support.PropertyMap">

            <at name="border">

             <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

              <super classname="com.jeta.forms.store.properties.BorderProperty">

               <at name="name">border</at>

              </super>

              <at name="borders">

               <object classname="java.util.LinkedList">

                <item >

                 <at name="value">

                  <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                   <super classname="com.jeta.forms.store.properties.BorderProperty">

                    <at name="name">border</at>

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

            <at name="name">lblRegisterConnection</at>

            <at name="width">138</at>

            <at name="text">_Register_connection</at>

            <at name="fill">

             <object classname="com.jeta.forms.store.properties.effects.PaintProperty">

              <at name="name">fill</at>

             </object>

            </at>

            <at name="height">16</at>

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

       <object classname="com.jeta.forms.store.memento.BeanMemento">

        <super classname="com.jeta.forms.store.memento.ComponentMemento">

         <at name="cellconstraints">

          <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

           <at name="column">4</at>

           <at name="row">12</at>

           <at name="colspan">1</at>

           <at name="rowspan">1</at>

           <at name="halign">default</at>

           <at name="valign">default</at>

           <at name="insets" object="insets">0,0,0,0</at>

          </object>

         </at>

         <at name="componentclass">com.jeta.forms.gui.form.StandardComponent</at>

        </super>

        <at name="jetabeanclass">com.jeta.forms.gui.beans.JETABean</at>

        <at name="beanclass">javax.swing.JCheckBox</at>

        <at name="beanproperties">

         <object classname="com.jeta.forms.store.memento.PropertiesMemento">

          <at name="classname">javax.swing.JCheckBox</at>

          <at name="properties">

           <object classname="com.jeta.forms.store.support.PropertyMap">

            <at name="border">

             <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

              <super classname="com.jeta.forms.store.properties.BorderProperty">

               <at name="name">border</at>

              </super>

              <at name="borders">

               <object classname="java.util.LinkedList">

                <item >

                 <at name="value">

                  <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                   <super classname="com.jeta.forms.store.properties.BorderProperty">

                    <at name="name">border</at>

                   </super>

                  </object>

                 </at>

                </item>

               </object>

              </at>

             </object>

            </at>

            <at name="name">chkRegisterConnection</at>

            <at name="width">1443</at>

            <at name="height">15</at>

           </object>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

        <at name="id">embedded.2125077403</at>

                 <at name="width">1415</at>

       <object classname="com.jeta.forms.store.memento.FormMemento">

           <at name="column">4</at>

           <at name="row">8</at>

         <at name="componentclass">com.jeta.forms.gui.form.FormComponent</at>

        <at name="id">embedded.1739097465</at>

        <at name="rowspecs">CENTER:DEFAULT:NONE</at>

        <at name="colspecs">FILL:DEFAULT:GROW(1.0),FILL:4DLU:NONE,FILL:DEFAULT:NONE</at>

        <at name="components">

         <object classname="java.util.LinkedList">

          <item >

           <at name="value">

            <object classname="com.jeta.forms.store.memento.BeanMemento">

             <super classname="com.jeta.forms.store.memento.ComponentMemento">

              <at name="cellconstraints">

               <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

                <at name="column">3</at>

                <at name="row">1</at>

                <at name="colspan">1</at>

                <at name="rowspan">1</at>

                <at name="halign">default</at>

                <at name="valign">default</at>

                <at name="insets" object="insets">0,0,0,0</at>

               </object>

              </at>

              <at name="componentclass">com.jeta.forms.gui.form.StandardComponent</at>

             </super>

             <at name="jetabeanclass">com.jeta.forms.gui.beans.JETABean</at>

             <at name="beanclass">javax.swing.JButton</at>

             <at name="beanproperties">

              <object classname="com.jeta.forms.store.memento.PropertiesMemento">

               <at name="classname">javax.swing.JButton</at>

               <at name="properties">

                <object classname="com.jeta.forms.store.support.PropertyMap">

                 <at name="border">

                  <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

                   <super classname="com.jeta.forms.store.properties.BorderProperty">

                    <at name="name">border</at>

                   </super>

                   <at name="borders">

                    <object classname="java.util.LinkedList">

                     <item >

                      <at name="value">

                       <object classname="com.jeta.forms.store.properties.EmptyBorderProperty">

                        <super classname="com.jeta.forms.store.properties.BorderProperty">

                         <at name="name">border</at>

                        </super>

                        <at name="top">2</at>

                        <at name="left">2</at>

                        <at name="bottom">2</at>

                        <at name="right">2</at>

                       </object>

                      </at>

                     </item>

                    </object>

                   </at>

                  </object>

                 </at>

                 <at name="actionCommand">...</at>

                 <at name="opaque">false</at>

                 <at name="name">btnDataBaseFile</at>

                 <at name="width">13</at>

                 <at name="rolloverEnabled">true</at>

                 <at name="text">...</at>

                 <at name="height">20</at>

                </object>

               </at>

              </object>

             </at>

            </object>

           </at>

          </item>

          <item >

           <at name="value">

            <object classname="com.jeta.forms.store.memento.BeanMemento">

             <super classname="com.jeta.forms.store.memento.ComponentMemento">

              <at name="cellconstraints">

               <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

                <at name="column">1</at>

                <at name="row">1</at>

                <at name="colspan">1</at>

                <at name="rowspan">1</at>

                <at name="halign">default</at>

                <at name="valign">default</at>

                <at name="insets" object="insets">0,0,0,0</at>

               </object>

              </at>

              <at name="componentclass">com.jeta.forms.gui.form.StandardComponent</at>

             </super>

             <at name="jetabeanclass">com.jeta.forms.gui.beans.JETABean</at>

             <at name="beanclass">javax.swing.JTextField</at>

             <at name="beanproperties">

              <object classname="com.jeta.forms.store.memento.PropertiesMemento">

               <at name="classname">javax.swing.JTextField</at>

               <at name="properties">

                <object classname="com.jeta.forms.store.support.PropertyMap">

                 <at name="border">

                  <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

                   <super classname="com.jeta.forms.store.properties.BorderProperty">

                    <at name="name">border</at>

                   </super>

                   <at name="borders">

                    <object classname="java.util.LinkedList">

                     <item >

                      <at name="value">

                       <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                        <super classname="com.jeta.forms.store.properties.BorderProperty">

                         <at name="name">border</at>

                        </super>

                       </object>

                      </at>

                     </item>

                    </object>

                   </at>

                  </object>

                 </at>

                 <at name="name">txtDatabaseFile</at>

                 <at name="width">1415</at>

                 <at name="height">22</at>

                </object>

               </at>

              </object>

             </at>

            </object>

           </at>

          </item>

         </object>

        </at>

        <at name="properties">

          <at name="classname">com.jeta.forms.gui.form.GridView</at>

               <object classname="java.util.LinkedList"/>

            <at name="name"></at>

            <at name="scollBars">

             <object classname="com.jeta.forms.store.properties.ScrollBarsProperty">

              <at name="name">scollBars</at>

              <at name="verticalpolicy">21</at>

              <at name="horizontalpolicy">31</at>

              <at name="border">

               <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

                <super classname="com.jeta.forms.store.properties.BorderProperty">

                 <at name="name">border</at>

                </super>

                <at name="borders">

                 <object classname="java.util.LinkedList">

                  <item >

                   <at name="value">

                    <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                     <super classname="com.jeta.forms.store.properties.BorderProperty">

                      <at name="name">border</at>

                     </super>

                    </object>

                   </at>

                  </item>

                 </object>

                </at>

               </object>

              </at>

             </object>

            </at>

        <at name="cellpainters">

         <object classname="com.jeta.forms.store.support.Matrix">

          <at name="rows">

           <object classname="[Ljava.lang.Object;" size="1">

            <at name="item" index="0">

             <object classname="[Ljava.lang.Object;" size="3"/>

            </at>

           </object>

          </at>

         </object>

        </at>

        <at name="rowgroups">

         <object classname="com.jeta.forms.store.memento.FormGroupSet">

          <at name="groups">

           <object classname="java.util.HashMap"/>

          </at>

         </object>

        </at>

        <at name="colgroups">

         <object classname="com.jeta.forms.store.memento.FormGroupSet">

          <at name="groups">

           <object classname="java.util.HashMap"/>

          </at>

         </object>

        </at>

           <at name="row">6</at>

        <at name="id">embedded.1576237062</at>

                <at name="column">1</at>

                <at name="row">1</at>

                <at name="colspan">1</at>

                <at name="rowspan">1</at>

                <at name="halign">default</at>

                <at name="valign">default</at>

                <at name="insets" object="insets">0,0,0,0</at>

               </object>

              </at>

              <at name="componentclass">com.jeta.forms.gui.form.StandardComponent</at>

             </super>

             <at name="jetabeanclass">com.jeta.forms.gui.beans.JETABean</at>

             <at name="beanclass">javax.swing.JTextField</at>

             <at name="beanproperties">

              <object classname="com.jeta.forms.store.memento.PropertiesMemento">

               <at name="classname">javax.swing.JTextField</at>

               <at name="properties">

                <object classname="com.jeta.forms.store.support.PropertyMap">

                 <at name="border">

                  <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

                   <super classname="com.jeta.forms.store.properties.BorderProperty">

                    <at name="name">border</at>

                   </super>

                   <at name="borders">

                    <object classname="java.util.LinkedList">

                     <item >

                      <at name="value">

                       <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                        <super classname="com.jeta.forms.store.properties.BorderProperty">

                         <at name="name">border</at>

                        </super>

                       </object>

                      </at>

                     </item>

                    </object>

                   </at>

                  </object>

                 </at>

                 <at name="name">txtProjection</at>

                 <at name="width">1415</at>

                 <at name="height">22</at>

                </object>

               </at>

              </object>

             </at>

            </object>

           </at>

          </item>

          <item >

           <at name="value">

            <object classname="com.jeta.forms.store.memento.BeanMemento">

             <super classname="com.jeta.forms.store.memento.ComponentMemento">

              <at name="cellconstraints">

               <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

                 <at name="name">btnProjection</at>

         </object>

        </at>

        <at name="properties">

         <object classname="com.jeta.forms.store.memento.PropertiesMemento">

          <at name="classname">com.jeta.forms.gui.form.GridView</at>

          <at name="properties">

           <object classname="com.jeta.forms.store.support.PropertyMap">

            <at name="border">

             <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

              <super classname="com.jeta.forms.store.properties.BorderProperty">

               <at name="name">border</at>

              </super>

              <at name="borders">

               <object classname="java.util.LinkedList"/>

              </at>

             </object>

            </at>

            <at name="name"/>

            <at name="fill">

             <object classname="com.jeta.forms.store.properties.effects.PaintProperty">

              <at name="name">fill</at>

             </object>

            </at>

            <at name="scollBars">

             <object classname="com.jeta.forms.store.properties.ScrollBarsProperty">

              <at name="name">scollBars</at>

              <at name="verticalpolicy">21</at>

              <at name="horizontalpolicy">31</at>

              <at name="border">

               <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

                <super classname="com.jeta.forms.store.properties.BorderProperty">

                 <at name="name">border</at>

                </super>

                <at name="borders">

                 <object classname="java.util.LinkedList">

                  <item >

                   <at name="value">

                    <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                     <super classname="com.jeta.forms.store.properties.BorderProperty">

                      <at name="name">border</at>

                     </super>

                    </object>

                   </at>

                  </item>

                 </object>

                </at>

               </object>

              </at>

             </object>

            </at>

           </object>

          </at>

         </object>

        </at>

        <at name="cellpainters">

         <object classname="com.jeta.forms.store.support.Matrix">

          <at name="rows">

           <object classname="[Ljava.lang.Object;" size="1">

            <at name="item" index="0">

             <object classname="[Ljava.lang.Object;" size="3"/>

            </at>

           </object>

          </at>

         </object>

        </at>

        <at name="rowgroups">

         <object classname="com.jeta.forms.store.memento.FormGroupSet">

          <at name="groups">

           <object classname="java.util.HashMap"/>

          </at>

         </object>

        </at>

        <at name="colgroups">

         <object classname="com.jeta.forms.store.memento.FormGroupSet">

          <at name="groups">

           <object classname="java.util.HashMap"/>

          </at>

         </object>

        </at>

       </object>

      </at>

     </item>

     <item >

      <at name="value">

       <object classname="com.jeta.forms.store.memento.FormMemento">

        <super classname="com.jeta.forms.store.memento.ComponentMemento">

         <at name="cellconstraints">

          <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

           <at name="column">2</at>

           <at name="row">18</at>

           <at name="colspan">3</at>

           <at name="rowspan">1</at>

           <at name="halign">default</at>

           <at name="valign">default</at>

           <at name="insets" object="insets">0,0,0,0</at>

          </object>

         </at>

         <at name="componentclass">com.jeta.forms.gui.form.FormComponent</at>

        </super>

        <at name="id">embedded.1043359006</at>

        <at name="rowspecs">CENTER:MAX(12DLU;DEFAULT):NONE,CENTER:MAX(12DLU;DEFAULT):NONE,CENTER:MAX(12DLU;DEFAULT):NONE</at>

        <at name="colspecs">FILL:DEFAULT:GROW(1.0),FILL:DEFAULT:NONE</at>

        <at name="components">

         <object classname="java.util.LinkedList">

             <at name="beanclass">com.jeta.forms.components.label.JETALabel</at>

               <at name="classname">com.jeta.forms.components.label.JETALabel</at>

                 <at name="name">lblStatusCaption</at>

                 <at name="width">1570</at>

                 <at name="fill">

                  <object classname="com.jeta.forms.store.properties.effects.PaintProperty">

                   <at name="name">fill</at>

                 <at name="height">12</at>

          <item >

           <at name="value">

            <object classname="com.jeta.forms.store.memento.BeanMemento">

             <super classname="com.jeta.forms.store.memento.ComponentMemento">

              <at name="cellconstraints">

               <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

                <at name="column">1</at>

                <at name="row">3</at>

                <at name="colspan">1</at>

                <at name="rowspan">1</at>

                <at name="halign">default</at>

                <at name="valign">default</at>

                <at name="insets" object="insets">0,0,0,0</at>

               </object>

              </at>

              <at name="componentclass">com.jeta.forms.gui.form.StandardComponent</at>

             </super>

             <at name="jetabeanclass">com.jeta.forms.gui.beans.JETABean</at>

             <at name="beanclass">com.jeta.forms.components.label.JETALabel</at>

             <at name="beanproperties">

              <object classname="com.jeta.forms.store.memento.PropertiesMemento">

               <at name="classname">com.jeta.forms.components.label.JETALabel</at>

               <at name="properties">

                <object classname="com.jeta.forms.store.support.PropertyMap">

                 <at name="border">

                  <object classname="com.jeta.forms.store.properties.CompoundBorderProperty">

                   <super classname="com.jeta.forms.store.properties.BorderProperty">

                    <at name="name">border</at>

                   </super>

                   <at name="borders">

                    <object classname="java.util.LinkedList">

                     <item >

                      <at name="value">

                       <object classname="com.jeta.forms.store.properties.DefaultBorderProperty">

                        <super classname="com.jeta.forms.store.properties.BorderProperty">

                         <at name="name">border</at>

                        </super>

                       </object>

                      </at>

                     </item>

                    </object>

                   </at>

                  </object>

                 </at>

                 <at name="name">lblStatusMsg</at>

                 <at name="width">1570</at>

                 <at name="fill">

                  <object classname="com.jeta.forms.store.properties.effects.PaintProperty">

                   <at name="name">fill</at>

                  </object>

                 </at>

                 <at name="height">12</at>

                </object>

               </at>

              </object>

             </at>

            </object>

           </at>

          </item>

          <item >

           <at name="value">

            <object classname="com.jeta.forms.store.memento.BeanMemento">

             <super classname="com.jeta.forms.store.memento.ComponentMemento">

              <at name="cellconstraints">

               <object classname="com.jeta.forms.store.memento.CellConstraintsMemento">

                <at name="column">1</at>

                <at name="row">2</at>

                <at name="colspan">1</at>

                <at name="rowspan">1</at>

                <at name="halign">default</at>

                <at name="valign">default</at>