EDIT

/**

 * Copyright (C) 2007 EDIT

 * http://www.e-taxonomy.eu

 * The contents of this file are subject to the Mozilla Public License Version 1.1

 * See LICENSE.TXT at the top of this package for the full license terms.

 */

import java.net.URL;

import java.sql.SQLException;

import org.apache.log4j.Logger;

import eu.etaxonomy.cdm.common.CdmUtils;

import eu.etaxonomy.cdm.io.common.CdmDefaultImport;

import eu.etaxonomy.cdm.io.common.IImportConfigurator.CHECK;

import eu.etaxonomy.cdm.io.sdd.in.SDDImportConfigurator;

/**

 * @author h.fradin

       String dataSourceName = CdmUtils.readInputLine("Database name: ");

       String username = CdmUtils.readInputLine("Username: ");

       String password = CdmUtils.readInputLine("Password: ");

       dataSourceName = (dataSourceName.equals("")) ? "cdm_test4" : dataSourceName;

       username = (username.equals("")) ? "ljm" : username;

       //ICdmDataSource dataSource = CdmDataSource.NewMySqlInstance("127.0.0.1", "cdm_edit_cichorieae", 3306, "ljm", password, NomenclaturalCode.ICBN);

       //ICdmDataSource dataSource = CdmDataSource.NewMySqlInstance("160.45.63.201", "cdm_edit_cichorieae", 3306, "edit", password, NomenclaturalCode.ICBN);

       boolean connectionAvailable;

           Assert.assertTrue("Testdatabase is not available", connectionAvailable);

       } catch (ClassNotFoundException e1) {

           e1.printStackTrace();

       } catch (SQLException e1) {

           e1.printStackTrace();

       }

       try {

           loadedDataSource = CdmPersistentDataSource.NewInstance(dataSourceName);

//			CdmApplicationController.NewInstance(loadedDataSource, DbSchemaValidation.CREATE);

       } catch (DataSourceNotFoundException e) {

           e.printStackTrace();

       }

       //return loadedDataSource;

	        source = url.toURI();

			//source = new URI("/eu/etaxonomy/cdm/app/sdd/SDDImportTest-input3.xml");

			System.out.println("Start import from SDD("+ source.toString() + ") ...");

		//	ICdmDataSource destination = CdmDestinations.localH2("cdm","sa","C:/Documents and Settings/lis/Mes documents/CDMtest/");

			//lorna//ICdmDataSource destination = CdmDestinations.localH2(args[3],"sa",args[2]);

			ICdmDataSource destination = customDataSource();

			SDDImportConfigurator sddImportConfigurator = SDDImportConfigurator.NewInstance(source,  destination);

			///sddImportConfigurator.setSourceSecId(sourceSecId);

			///sddImportConfigurator.setCheck(check);

			///sddImportConfigurator.setDbSchemaValidation(hbm2dll);

			// invoke import

			CdmDefaultImport<SDDImportConfigurator> sddImport = new CdmDefaultImport<SDDImportConfigurator>();

			sddImport.invoke(sddImportConfigurator);

			System.out.println("End import from SDD ("+ source.toString() + ")...");

		} catch (URISyntaxException e) {

			e.printStackTrace();