DatasourceController.java

/*
 * This program is free software; you can redistribute it and/or modify it under the 
 * terms of the GNU Lesser General Public License, version 2.1 as published by the Free Software 
 * Foundation.
 *
 * You should have received a copy of the GNU Lesser General Public License along with this 
 * program; if not, you can obtain a copy at http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html 
 * or from the Free Software Foundation, Inc., 
 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
 *
 * This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; 
 * without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
 * See the GNU Lesser General Public License for more details.
 *
 * Copyright 2008 - 2009 Pentaho Corporation.  All rights reserved.
 *
 *
 * Created April 21, 2009
 * @author rmansoor
 */
package org.pentaho.platform.dataaccess.datasource.wizard.controllers;

import java.util.ArrayList;
import java.util.List;

import org.pentaho.metadata.model.Category;
import org.pentaho.metadata.model.Domain;
import org.pentaho.metadata.model.LogicalColumn;
import org.pentaho.metadata.model.LogicalModel;
import org.pentaho.platform.dataaccess.datasource.DatasourceType;
import org.pentaho.metadata.model.concept.types.AggregationType;
import org.pentaho.metadata.model.concept.types.LocalizedString;
import org.pentaho.platform.dataaccess.datasource.DatasourceType;
import org.pentaho.platform.dataaccess.datasource.IConnection;
import org.pentaho.platform.dataaccess.datasource.beans.BusinessData;
import org.pentaho.platform.dataaccess.datasource.utils.ExceptionParser;
import org.pentaho.platform.dataaccess.datasource.wizard.DatasourceMessages;
import org.pentaho.platform.dataaccess.datasource.wizard.models.CsvModelDataRow;
import org.pentaho.platform.dataaccess.datasource.wizard.models.DatasourceModel;
import org.pentaho.platform.dataaccess.datasource.wizard.models.ModelDataRow;
import org.pentaho.platform.dataaccess.datasource.wizard.service.IXulAsyncDatasourceService;
import org.pentaho.platform.dataaccess.datasource.wizard.service.DatasourceServiceException;
import org.pentaho.ui.xul.XulException;
import org.pentaho.ui.xul.XulServiceCallback;
import org.pentaho.ui.xul.binding.Binding;
import org.pentaho.ui.xul.binding.BindingConvertor;
import org.pentaho.ui.xul.binding.BindingFactory;
import org.pentaho.ui.xul.components.XulButton;
import org.pentaho.ui.xul.components.XulLabel;
import org.pentaho.ui.xul.components.XulTextbox;
import org.pentaho.ui.xul.components.XulTreeCell;
import org.pentaho.ui.xul.components.XulTreeCol;
import org.pentaho.ui.xul.containers.XulDialog;
import org.pentaho.ui.xul.containers.XulTabbox;
import org.pentaho.ui.xul.containers.XulTree;
import org.pentaho.ui.xul.containers.XulTreeChildren;
import org.pentaho.ui.xul.containers.XulTreeRow;
import org.pentaho.ui.xul.stereotype.Bindable;
import org.pentaho.ui.xul.util.AbstractXulDialogController;

public class DatasourceController extends AbstractXulDialogController<Domain> {
  public static final int DEFAULT_RELATIONAL_TABLE_ROW_COUNT = 5;
  public static final int DEFAULT_CSV_TABLE_ROW_COUNT = 7;
  private DatasourceMessages datasourceMessages;
  private XulDialog datasourceDialog;
  private IXulAsyncDatasourceService service;
  public static final int RELATIONAL_TAB = 0;
  public static final int CSV_TAB = 1;
  private DatasourceModel datasourceModel;
  private List<IDatasourceTypeController> datasourceTypeControllers;
  BindingFactory bf;
  XulTextbox csvDatasourceName = null;
  XulTextbox relationalDatasourceName = null;
  XulButton okButton = null;

  XulButton cancelButton = null;

  private XulDialog errorDialog;

  private XulDialog successDialog;

  private XulLabel errorLabel = null;

  private XulLabel successLabel = null;

  //private XulHbox buttonBox = null;

  //private XulDeck datasourceDeck = null;
  
  /**
   * The domain being edited.
   */
  private Domain domainToBeSaved;

  //XulButton relationalButton = null;
  
  //XulButton csvButton = null;
  
  private XulTree modelDataTable = null;
  
  private XulTree csvDataTable = null;
  //private XulHbox databaseButtonBox = null;
  //private XulHbox csvButtonBox = null;
  private XulTreeCol relationalAggregationListCol;
  private XulTreeCol relationalSampleDataTreeCol;
  private XulTreeCol csvAggregationListCol;
  private XulTreeCol csvSampleDataTreeCol;
  private XulTreeCol relationalColumnNameTreeCol = null;
  private XulTreeCol relationalColumnTypeTreeCol = null;
  private XulTreeCol csvColumnNameTreeCol = null;
  private XulTreeCol csvColumnTypeTreeCol = null;
  private XulDialog clearModelWarningDialog = null;
  private XulDialog overwriteDialog = null;
  
  private BusinessData overwriteBusinessData = null;
  private Domain overwriteDomain = null;
  private DatasourceType overwriteDatasourceType = null;
  private DatasourceType tabValueSelected = null;
  private boolean clearModelWarningShown = false;
  private XulTabbox datasourceTabbox = null;
  public DatasourceController() {

  }
  
  public void setDatasourceTypeControllers(List<IDatasourceTypeController> datasourceTypeControllers) {
    this.datasourceTypeControllers = datasourceTypeControllers;
  }

  @Bindable
  public void init() {
    clearModelWarningDialog = (XulDialog) document.getElementById("clearModelWarningDialog");//$NON-NLS-1$
    //databaseButtonBox = (XulHbox) document.getElementById("databaseButtonBox");
    relationalAggregationListCol = (XulTreeCol) document.getElementById("relationalAggregationListCol"); //$NON-NLS-1$
    relationalSampleDataTreeCol = (XulTreeCol) document.getElementById("relationalSampleDataTreeCol"); //$NON-NLS-1$
    relationalColumnNameTreeCol = (XulTreeCol) document.getElementById("relationalColumnNameTreeCol");//$NON-NLS-1$
    relationalColumnTypeTreeCol = (XulTreeCol) document.getElementById("relationalColumnTypeTreeCol");//$NON-NLS-1$
    csvColumnNameTreeCol = (XulTreeCol) document.getElementById("csvColumnNameTreeCol");//$NON-NLS-1$
    csvColumnTypeTreeCol = (XulTreeCol) document.getElementById("csvColumnTypeTreeCol");//$NON-NLS-1$
    
    csvAggregationListCol = (XulTreeCol) document.getElementById("relationalAggregationListCol");//$NON-NLS-1$
    csvSampleDataTreeCol = (XulTreeCol) document.getElementById("relationalAggregationListCol");//$NON-NLS-1$
    //csvButtonBox = (XulHbox) document.getElementById("csvButtonBox");
    //datasourceDeck = (XulDeck) document.getElementById("datasourceDeck"); //$NON-NLS-1$
    csvDataTable = (XulTree) document.getElementById("csvDataTable");//$NON-NLS-1$
    modelDataTable = (XulTree) document.getElementById("modelDataTable");//$NON-NLS-1$
    //buttonBox = (XulHbox) document.getElementById("buttonBox");
    errorDialog = (XulDialog) document.getElementById("errorDialog"); //$NON-NLS-1$
    errorLabel = (XulLabel) document.getElementById("errorLabel");//$NON-NLS-1$    
    successDialog = (XulDialog) document.getElementById("successDialog"); //$NON-NLS-1$
    successLabel = (XulLabel) document.getElementById("successLabel");//$NON-NLS-1$    
    csvDatasourceName = (XulTextbox) document.getElementById("csvDatasourceName"); //$NON-NLS-1$
    relationalDatasourceName = (XulTextbox) document.getElementById("relationalDatasourceName"); //$NON-NLS-1$
    datasourceDialog = (XulDialog) document.getElementById("datasourceDialog");//$NON-NLS-1$
    okButton = (XulButton) document.getElementById("datasourceDialog_accept"); //$NON-NLS-1$
    cancelButton = (XulButton) document.getElementById("datasourceDialog_cancel"); //$NON-NLS-1$
    //relationalButton = (XulButton) document.getElementById("relationalButton"); //$NON-NLS-1$
    //csvButton = (XulButton) document.getElementById("csvButton"); //$NON-NLS-1$
    datasourceTabbox = (XulTabbox) document.getElementById("datasourceDialogTabbox"); //$NON-NLS-1$
    
    overwriteDialog = (XulDialog)document.getElementById("overwriteDialog"); //$NON-NLS-1$
    
    bf.setBindingType(Binding.Type.BI_DIRECTIONAL);
    final Binding domainBinding = bf.createBinding(datasourceModel.getRelationalModel(), "datasourceName", relationalDatasourceName, "value"); //$NON-NLS-1$ //$NON-NLS-2$
    bf.createBinding(datasourceModel.getCsvModel(), "datasourceName", csvDatasourceName, "value"); //$NON-NLS-1$ //$NON-NLS-2$
    bf.createBinding(relationalDatasourceName, "value", csvDatasourceName, "value"); //$NON-NLS-1$ //$NON-NLS-2$
    bf.setBindingType(Binding.Type.ONE_WAY);
    bf.createBinding(datasourceModel, "validated", okButton, "!disabled");//$NON-NLS-1$ //$NON-NLS-2$
    BindingConvertor<IConnection, Boolean> buttonConvertor = new BindingConvertor<IConnection, Boolean>() {

      @Override
      public Boolean sourceToTarget(IConnection value) {
        return !(value == null);
      }

      @Override
      public IConnection targetToSource(Boolean value) {
        return null;
      }

    };

    bf.setBindingType(Binding.Type.BI_DIRECTIONAL);
    BindingConvertor<DatasourceType, Integer> tabIndexConvertor = new BindingConvertor<DatasourceType, Integer>() {
      @Override
      public Integer sourceToTarget(DatasourceType value) {
        Integer returnValue = null;
        if (DatasourceType.SQL == value) {
          returnValue = 0;
        } else if (DatasourceType.CSV == value) {
          returnValue = 1;
        } else if (DatasourceType.NONE == value) {
          return 0;
        }
        return returnValue;
      }

      @Override
      public DatasourceType targetToSource(Integer value) {
        DatasourceType type = null;
        if (value == 0) {
          type = DatasourceType.SQL;
         } else if (value == 1) {
          type = DatasourceType.CSV;
        }
        return type;
      }
    };
    //bf.createBinding(datasourceModel, "datasourceType", datasourceDeck, "selectedIndex", deckIndexConvertor);//$NON-NLS-1$ //$NON-NLS-2$
    bf.createBinding(datasourceModel, "datasourceType", datasourceTabbox, "selectedIndex", tabIndexConvertor);//$NON-NLS-1$ //$NON-NLS-2$
    bf.setBindingType(Binding.Type.ONE_WAY);
    BindingConvertor<DatasourceType, Boolean> relationalToggleButtonConvertor = new BindingConvertor<DatasourceType, Boolean>() {

        @Override
        public Boolean sourceToTarget(DatasourceType value) {
          if(DatasourceType.SQL == value) {
            return true;
          } else {
            return false;
          }
        }

        @Override
        public DatasourceType targetToSource(Boolean value) {
          return null;
        }
      };

      BindingConvertor<DatasourceType, Boolean> csvToggleButtonConvertor = new BindingConvertor<DatasourceType, Boolean>() {

          @Override
          public Boolean sourceToTarget(DatasourceType value) {
            if(DatasourceType.CSV == value) {
              return true;
            } else {
              return false;
            }
          }

          @Override
          public DatasourceType targetToSource(Boolean value) {
            return null;
          }
        };
//    bf.createBinding(datasourceModel, "datasourceType", relationalButton, "disabled", relationalToggleButtonConvertor);//$NON-NLS-1$ //$NON-NLS-2$
//    bf.createBinding(datasourceModel, "datasourceType", csvButton, "disabled", csvToggleButtonConvertor);//$NON-NLS-1$ //$NON-NLS-2$

    okButton.setDisabled(true);
    initialize();
    try {
      // Fires the population of the model listbox. This cascades down to the categories and columns. In essence, this
      // call initializes the entire UI.
      domainBinding.fireSourceChanged();

    } catch (Exception e) {
      System.out.println(e.getMessage());
      e.printStackTrace();
    }
  }

  public void initialize() {
    datasourceModel.clearModel();
    /*buildRelationalEmptyTable();*/    
    selectSql();
  }

  public void showEditDialog(String domainId, String modelId) {
    XulServiceCallback<BusinessData> callback = new XulServiceCallback<BusinessData>() {
      public void error(String message, Throwable error) {
        openErrorDialog(datasourceMessages.getString("ERROR"), datasourceMessages.getString("DatasourceController.ERROR_0004_UNABLE_TO_EDIT_DATASOURCE", error.getLocalizedMessage())); //$NON-NLS-1$ //$NON-NLS-2$
      }
      public void success(BusinessData retVal) {
        initializeModel(retVal);
        showDialog();
      }
    };
    service.loadBusinessData(domainId, modelId, callback);
  }
  
  private void initializeModel(BusinessData businessData) {
    datasourceModel.clearModel();
    for (IDatasourceTypeController controller : datasourceTypeControllers) {
      if (controller.supportsBusinessData(businessData)) {
        controller.initializeBusinessData(businessData);
        break;
      }
    }
  }
  
  public void setBindingFactory(BindingFactory bf) {
    this.bf = bf;
  }

  @Bindable
  public void setDatasourceModel(DatasourceModel model) {
    this.datasourceModel = model;
  }

  @Bindable
  public DatasourceModel getDatasourceModel() {
    return this.datasourceModel;
  }

  public String getName() {
    return "datasourceController"; //$NON-NLS-1$
  }

  @Bindable
  public void saveModel() {
    try {
      if (datasourceModel.getDatasourceType() == DatasourceType.SQL) {
        saveRelationalModel();
      } else if (datasourceModel.getDatasourceType() == DatasourceType.CSV) {
        saveCsvModel();
      }
    } catch (Exception e) {
      handleSaveError(datasourceModel, e);
    }
  }
  
  private void handleSaveError(DatasourceModel datasourceModel, Throwable xe) {
    String datasourceName = null;
    if(datasourceModel.getDatasourceType() == DatasourceType.CSV) {
      datasourceName =  datasourceModel.getCsvModel().getDatasourceName();
    } else if(datasourceModel.getDatasourceType() == DatasourceType.SQL) {
      datasourceName =  datasourceModel.getRelationalModel().getDatasourceName();
    }
    openErrorDialog(datasourceMessages.getString("ERROR"), datasourceMessages.getString("DatasourceController.ERROR_0003_UNABLE_TO_SAVE_MODEL",datasourceName,xe.getLocalizedMessage())); //$NON-NLS-1$ //$NON-NLS-2$
  }

  @Bindable
  private void saveCsvModel() throws DatasourceServiceException {
    List<CsvModelDataRow> dataRows = datasourceModel.getCsvModel().getDataRows();
      // Get the domain from the business data
      BusinessData businessData = datasourceModel.getCsvModel().getBusinessData();
      if (businessData != null) {
        Domain domain = businessData.getDomain();
        if (domain != null) {
          List<LogicalModel> logicalModels = domain.getLogicalModels();
          for (LogicalModel logicalModel : logicalModels) {
            List<Category> categories = logicalModel.getCategories();
            for (Category category : categories) {
              List<LogicalColumn> logicalColumns = category.getLogicalColumns();
              int i = 0;
              for (LogicalColumn logicalColumn : logicalColumns) {
                CsvModelDataRow row = dataRows.get(i++);
                logicalColumn.setDataType(row.getSelectedDataType());
                logicalColumn.setName(new LocalizedString(domain.getLocales().get(0).getCode(), row.getColumnName()));
                List<AggregationType> aggregationList = new ArrayList<AggregationType>();
                aggregationList.addAll(row.getAggregation().getAggregationList());
                logicalColumn.setAggregationList(aggregationList);                
                logicalColumn.setAggregationType(row.getAggregation().getDefaultAggregationType());                
              }
            }
          }
          saveCsvModel(domain, false);
        } else {
          throw new RuntimeException(datasourceMessages.getString("DatasourceController.ERROR_0002_NULL_MODEL")); //$NON-NLS-1$
        }
      } else {
        throw new RuntimeException(datasourceMessages.getString("DatasourceController.ERROR_0002_NULL_MODEL")); //$NON-NLS-1$
      }
  }

  private void saveRelationalModel() throws DatasourceServiceException {
    List<ModelDataRow> dataRows = datasourceModel.getRelationalModel().getDataRows();
      // Get the domain from the business data
      BusinessData businessData = datasourceModel.getRelationalModel().getBusinessData();
      if (businessData != null) {
        Domain domain = businessData.getDomain();
        if (domain != null) {
          List<LogicalModel> logicalModels = domain.getLogicalModels();
          for (LogicalModel logicalModel : logicalModels) {
            List<Category> categories = logicalModel.getCategories();
            for (Category category : categories) {
              List<LogicalColumn> logicalColumns = category.getLogicalColumns();
              int i = 0;
              for (LogicalColumn logicalColumn : logicalColumns) {
                ModelDataRow row = dataRows.get(i++);
                logicalColumn.setDataType(row.getSelectedDataType());
                logicalColumn.setName(new LocalizedString(domain.getLocales().get(0).getCode(), row.getColumnName()));
                List<AggregationType> aggregationList = new ArrayList<AggregationType>();
                aggregationList.addAll(row.getAggregation().getAggregationList());
                logicalColumn.setAggregationList(aggregationList);
                logicalColumn.setAggregationType(row.getAggregation().getDefaultAggregationType());
              }
            }
          }
          saveRelationalModel(businessData, false);
        } else {
          throw new RuntimeException(datasourceMessages.getString("DatasourceController.ERROR_0002_NULL_MODEL")); //$NON-NLS-1$
        }
      } else {
        throw new RuntimeException(datasourceMessages.getString("DatasourceController.ERROR_0002_NULL_MODEL")); //$NON-NLS-1$
      }
  }

  private void saveRelationalModel(final BusinessData businessData, final boolean overwrite) throws DatasourceServiceException {
      // TODO setting value to false to always create a new one. Save as is not yet implemented
      service.saveLogicalModel(businessData.getDomain(), overwrite, new XulServiceCallback<Boolean>() {
        public void error(String message, Throwable error) {
          // 0013 is an overwrite exception
          if (error.getMessage().indexOf("0013") >= 0) { //$NON-NLS-1$
            // prompt for overwrite
            overwriteBusinessData = businessData;
            overwriteDatasourceType = DatasourceType.SQL;
            overwriteDialog.show();
          } else {
            handleSaveError(datasourceModel, error);
          }
        }

        public void success(Boolean value) {
          domainToBeSaved = datasourceModel.getRelationalModel().getBusinessData().getDomain();
          saveModelDone();
        }
      });
  }

  @Bindable
  public void overwriteDialogAccept() {
    try {
      overwriteDialog.hide();
      if (overwriteDatasourceType == DatasourceType.SQL) {
        saveRelationalModel(overwriteBusinessData, true);
        
      } else if (overwriteDatasourceType == DatasourceType.CSV) {
        saveCsvModel(overwriteDomain, true);
        
      }
      
      // flush overwrite state
      overwriteBusinessData = null;
      overwriteDomain = null;
      overwriteDatasourceType = null;
      
    } catch (Exception e) {
      handleSaveError(datasourceModel, e);
    }
  }
  
  @Bindable
  public void overwriteDialogCancel() {
    overwriteDialog.hide();
  }
  
  private void saveCsvModel(final Domain domain, final boolean overwrite) throws DatasourceServiceException {
      // TODO setting value to false to always create a new one. Save as is not yet implemented
      service.saveLogicalModel(domain, overwrite, new XulServiceCallback<Boolean>() {
        public void error(String message, Throwable error) {
          if (error.getMessage().indexOf("0013") >= 0) { //$NON-NLS-1$
            // prompt for overwrite
            overwriteDomain = domain;
            overwriteDatasourceType = DatasourceType.CSV;
            overwriteDialog.show();
          } else {
            handleSaveError(datasourceModel, error);
          }
        }

        public void success(Boolean value) {
          domainToBeSaved = datasourceModel.getCsvModel().getBusinessData().getDomain();
          saveModelDone();
        }
      });
  }


  private void showClearModelWarningDialog(DatasourceType value) {
    tabValueSelected = value;
    clearModelWarningDialog.show();
  }
  
  @Bindable
  public void closeClearModelWarningDialog() {
    clearModelWarningDialog.hide();
    clearModelWarningShown = false;
  }
  
  @Bindable
  public void switchTab() {
    closeClearModelWarningDialog();
    if(tabValueSelected == DatasourceType.SQL) {
      modelDataTable.update();
      datasourceModel.getCsvModel().clearModel();
      datasourceModel.setDatasourceType(DatasourceType.SQL);      
    } else if(tabValueSelected == DatasourceType.CSV) {
      csvDataTable.update();
      datasourceModel.getRelationalModel().clearModel();
      datasourceModel.setDatasourceType(DatasourceType.CSV);
    }
  }
  
  @Bindable
  public Boolean beforeTabSwitch(Integer tabIndex) {
    if(RELATIONAL_TAB == tabIndex) {
      if(!clearModelWarningShown  && datasourceModel.getCsvModel().getBusinessData() != null) {
        showClearModelWarningDialog(DatasourceType.SQL);
        clearModelWarningShown = true;
        return false;
      } else {
        return true;
      }
    } else if(CSV_TAB == tabIndex) {
      if(!clearModelWarningShown  && datasourceModel.getRelationalModel().getQuery() != null
          && datasourceModel.getRelationalModel().getQuery().length() > 0) {
        showClearModelWarningDialog(DatasourceType.CSV);
        clearModelWarningShown = true;
        return false;
      } else {
        return true;
      }
    }
    return true;
  }

  @Bindable
  public void selectCsv() {
    csvDataTable.update();
    datasourceModel.setDatasourceType(DatasourceType.CSV);
  }

  @Bindable
  public void selectOlap() {

  }
  
  @Bindable
  public void selectSql() {
    modelDataTable.update();
    datasourceModel.setDatasourceType(DatasourceType.SQL);      
  }

  public void selectMql() {

  }

  public void selectXml() {

  }

  public IXulAsyncDatasourceService getService() {
    return service;
  }

  public void setService(IXulAsyncDatasourceService service) {
    this.service = service;
  }

  @Bindable
  public void openErrorDialog(String title, String message) {
    errorDialog.setTitle(title);
    errorLabel.setValue(message);
    errorDialog.show();
  }

  @Bindable
  public void closeErrorDialog() {
    if (!errorDialog.isHidden()) {
      errorDialog.hide();
    }
  }

  @Bindable
  public void openSuccesDialog(String title, String message) {
    successDialog.setTitle(title);
    successLabel.setValue(message);
    successDialog.show();
  }

  @Bindable
  public void closeSuccessDialog() {
    if (!successDialog.isHidden()) {
      successDialog.hide();
    }
  }

  @Override
  protected XulDialog getDialog() {
    return datasourceDialog;  
  }

  @Override
  protected Domain getDialogResult() {
    return domainToBeSaved;  
  }

  @Override
  @Bindable
  public void onDialogAccept() {
    saveModel(); 
  }
  
  @Bindable
  private void saveModelDone() {
    super.onDialogAccept();
  }
  
  private void buildCsvEmptyTable() {
    // Create the tree children and setting the data
    csvAggregationListCol.setEditable(false);
    csvSampleDataTreeCol.setEditable(false);
    csvColumnNameTreeCol.setEditable(false);
    csvColumnTypeTreeCol.setEditable(false);    
    csvDataTable.update();
    csvDataTable.suppressLayout(true);
    XulTreeChildren treeChildren = csvDataTable.getRootChildren();
    if(treeChildren != null) {
      treeChildren.removeAll();
    }
    try {
      int count = csvDataTable.getColumns().getColumnCount();
      for (int i = 0; i < DEFAULT_CSV_TABLE_ROW_COUNT; i++) {
        XulTreeRow row = (XulTreeRow) document.createElement("treerow"); //$NON-NLS-1$

        for (int j = 0; j < count; j++) {
          XulTreeCell cell = (XulTreeCell) document.createElement("treecell"); //$NON-NLS-1$
          cell.setLabel(" "); //$NON-NLS-1$
          row.addCell(cell);
        }

        csvDataTable.addTreeRow(row);
      }
      csvDataTable.suppressLayout(false);
      csvAggregationListCol.setEditable(true);
      csvSampleDataTreeCol.setEditable(true);
      csvDataTable.update();
      
    } catch(XulException e) {
      e.printStackTrace();
    }
  }
  
  private void buildRelationalEmptyTable() {
    // Create the tree children and setting the data
    relationalAggregationListCol.setEditable(false);
    relationalSampleDataTreeCol.setEditable(false);
    relationalColumnNameTreeCol.setEditable(false);
    relationalColumnTypeTreeCol.setEditable(false);
    modelDataTable.update();
    modelDataTable.suppressLayout(true);
     XulTreeChildren treeChildren = modelDataTable.getRootChildren();
    if(treeChildren != null) {
      treeChildren.removeAll();
    }

    try {
      int count = modelDataTable.getColumns().getColumnCount();
      for (int i = 0; i < DEFAULT_RELATIONAL_TABLE_ROW_COUNT; i++) {
        XulTreeRow row = (XulTreeRow) document.createElement("treerow"); //$NON-NLS-1$

        for (int j = 0; j < count; j++) {
          XulTreeCell cell = (XulTreeCell) document.createElement("treecell"); //$NON-NLS-1$
          cell.setLabel(" ");//$NON-NLS-1$
          row.addCell(cell);
        }

        modelDataTable.addTreeRow(row);
      }
      modelDataTable.suppressLayout(false);
      relationalAggregationListCol.setEditable(true);
      relationalSampleDataTreeCol.setEditable(true);
      modelDataTable.update();
      
    } catch(XulException e) {
      e.printStackTrace();
    }
  }
  public void displayErrorMessage(Throwable th) {
    errorDialog.setTitle(ExceptionParser.getErrorHeader(th, getDatasourceMessages().getString("DatasourceEditor.USER_ERROR_TITLE"))); //$NON-NLS-1$
    errorLabel.setValue(ExceptionParser.getErrorMessage(th, getDatasourceMessages().getString("DatasourceEditor.ERROR_0001_UNKNOWN_ERROR_HAS_OCCURED"))); //$NON-NLS-1$
    errorDialog.show();
  }

  /**
   * @param datasourceMessages the datasourceMessages to set
   */
  public void setDatasourceMessages(DatasourceMessages datasourceMessages) {
    this.datasourceMessages = datasourceMessages;
  }

  /**
   * @return the datasourceMessages
   */
  public DatasourceMessages getDatasourceMessages() {
    return datasourceMessages;
  }
}