EDIT

     * @param path

     */

    private void makeDatasource(String path) {

    }

import eu.etaxonomy.cdm.io.sdd.out.SDDCdmExporter;

import eu.etaxonomy.cdm.io.sdd.out.SDDExportConfigurator;

import eu.etaxonomy.cdm.io.sdd.out.SDDExportState;

import eu.etaxonomy.cdm.model.taxon.Classification;

import eu.etaxonomy.cdm.model.taxon.Taxon;

import eu.etaxonomy.cdm.test.integration.CdmTransactionalIntegrationTest;

        //ICdmDataSource dataSource = CdmDataSource.NewMySqlInstance("192.168.2.10", "cdm_test_niels2", 3306, "edit", password, code);

        String dataSourceName = "cdm_test2";

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

        boolean connectionAvailable;

        try {

            connectionAvailable = dataSource.testConnection();

            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) {

            // TODO Auto-generated catch block

            e.printStackTrace();

    @Override

    public void createTestDataSet() throws FileNotFoundException {

        // TODO Auto-generated method stub

    }

}

/**

 * Cdm Source class which represents a persisted CDM source object

 * @author cmathew

 *

 */

	private static final Logger logger = Logger.getLogger(CdmPersistentXMLSource.class);

	/**

	 * CDM sources config file name

	 */

	public final static String CDMSOURCE_FILE_NAME = "cdm.datasources.xml";

	/**

	 * Directory path of the template CDM sources config file - this file is used

	 * in the case of the very first call to persist sources see {@link eu.etaxonomy.cdm.api.application.CdmApplicationUtils#getWritableResourceDir()}

	 */

	public final static String CDMSOURCE_PATH = "/eu/etaxonomy/cdm/";

	/**

	 */

	private Element bean;

	/**

	 * Post fix represeting the type of source (data / remote)

	 */

	private String postFix;

	/**

	 * Enumeration containg all possible properties of all types of

	 * CDM Sources

	 *

	 */

		URL,

		FILEPATH,

		CONTEXTPATH,

		USERNAME,

		DRIVER_CLASS,

		DATABASE,

		MODE;

					return "username";

				case PASSWORD:

					return "password";

				case DRIVER_CLASS:

					return "driverClassName";

				case DATABASE:

					return "database";

				case MODE:

					return "mode";

					throw new IllegalArgumentException( "Unknown enumeration type" );

			}

		}

	}

	private String cdmSourceName;

	/**

	 * jDom element from the source config file.

	 * @param cdmSourceName

	 * @param postFix

	 */

		this.postFix = postFix;

		bean = CdmPersistentSourceUtils.getCdmSourceBeanXml(cdmSourceName, postFix);

	}

	/**

	 * jDom element from the source config file.

	 * @param strDataSourceName

	 * @param postFix

	 * @return new CdmPersistentXMLSource object

	 */

	public final static CdmPersistentXMLSource NewInstance(String strDataSourceName, String postFix) {

	}

	/**

	 * Returns the loaded jDom element representing this object

	 * @return

	 */

	public Element getElement() {

		return bean;

	}

	/**

	 * Returns the name of the bean Element in the cdm source xml config file.

	 * @return bean name

	public String getBeanName(){

		return CdmPersistentSourceUtils.getBeanName(cdmSourceName, postFix);

	}

	/**

	 */

	@SuppressWarnings("unchecked")

	public List<Attribute> getCdmSourceAttributes(){

		if (bean == null){

			return null;

		}else{

			result = bean.getAttributes();

		}

		return result;

	/**

	 * @return the property of the cdm source or null if the datasource bean or the property does not exist.

	 */

	public String getCdmSourceProperty(String property){

		if (bean == null){

			return null;

		}else{

			}

		}

	}

	/**

	 * cdm source xml config file.

	 */

	public Properties getCdmSourceProperties(){

		if (bean == null){

			return null;

		}else{

*/

package eu.etaxonomy.cdm.config;

/**

 * Abstract class representing the base CDM Source object.

 */

public abstract class CdmSource implements ICdmSource {

	private String name;

	private String server;

	private int port;

	public static final int NULL_PORT = -1;

	public static final String DEFAULT_ENTRY = "-";

	/**

	 * Sets the CDM Source name

	 * @param name

	 */

	@Override

	/**

	 * Sets the CDM Source server

	 * @param server

	 */

	@Override

	/**

	 * Sets the CDM Source port

	 * @param port

	 */

	@Override

		this.port = port;

	}

	@Override

	public String getName() {

		return this.name;

	}

	@Override

	public String getServer() {

		return this.server;

	}

	@Override

	public int getPort() {

		return this.port;

	}

	@Override

	public abstract String getDbSchemaVersion() throws CdmSourceException;

	@Override

	public abstract boolean isDbEmpty() throws CdmSourceException;

	@Override

	public abstract boolean checkConnection() throws CdmSourceException;

	@Override

	public abstract String getConnectionMessage();

	@Override

	public void closeOpenConnections() {

}

/**

* Copyright (C) 2014 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.util.Map;

import eu.etaxonomy.cdm.model.metadata.CdmMetaData.MetaDataPropertyName;

/**

 * Interface which represents any CDM Source

 *

 */

public interface ICdmSource {

	/**

	 * Returns the name representation of this CDM Source

	 * @return name representation of this CDM Source

	 */

	public String getName();

	/**

	 * Sets the name representation of this CDM Source

	 * @param name

	 * @return

	 */

	public void setName(String name);

	/**

	 * Returns the server (string representation) where this CDM Source resides

	 * @return server (string representation) where this CDM Source resides

	 */

	public String getServer();

	/**

	 * Sets the server (string representation) where this CDM Source resides

	 * @param server

	 * @return

	 */

	public void setServer(String server);

	/**

	 * Returns the port on which this CDM Source is listening

	 * @return port on which this CDM Source is listening

	 */

	public int getPort();

	/**

	 * Sets the port on which this CDM Source is listening

	 * @param port

	 */

	public void setPort(int port);

	/**

	 * Returns the CDM  schema version of this CDM Source

	 * @return CDM  schema version of this CDM Source

	 * @throws CdmSourceException if any underlying error

	 */

	public String getDbSchemaVersion() throws CdmSourceException;

	/**

	 * Checks whether the underlying database is empty

	 * @return true if underlying database is empty, o/w false

	 * @throws CdmSourceException

	 */

	public boolean isDbEmpty() throws CdmSourceException;

	/**

	 * Tests, if a database connection can be established.

	 * @throws CdmSourceException if any underlying error

	 */

	public boolean checkConnection() throws CdmSourceException;

	/**

	 * Returns the message to display when connecting to this CDM Source

	 * @return message to display when connecting to this CDM Source

	 */

	public String getConnectionMessage();

	/**

	 * Closes any open connections to this CDM Source

	 */

	public void closeOpenConnections();

}

import org.springframework.beans.factory.support.RootBeanDefinition;

import eu.etaxonomy.cdm.common.CdmUtils;

/**

 * @author a.mueller

	private int port = -1;

	private String username;

	private String password;

	private String filePath;

	private H2Mode mode;

	private Class<? extends RegionFactory> cacheProviderClass = NoCachingRegionFactory.class;

	public static CdmDataSource NewInstance(DatabaseTypeEnum dbType, String server, String database, String username, String password){

	}

	public static CdmDataSource NewInstance(DatabaseTypeEnum dbType, String server, String database, int port, String username, String password){

	}

	static public CdmDataSource  NewMySqlInstance(String server, String database, String username, String password ){

	}

	}

	}

	}

	/** in work

	 * @param code TODO*/

	static public CdmDataSource  NewH2EmbeddedInstance(String database, String username, String password){

	}

	/** in work

	 * @param code TODO*/

		//FIXME in work

		int port = -1;

		H2Mode mode = H2Mode.EMBEDDED;

		return dataSource;

	}

		H2Mode mode = H2Mode.IN_MEMORY;

		String username = "sa";

		String password = "";

		return dataSource;

	}

				dataSource.getUsername(),

				dataSource.getPassword(),

				dataSource.getFilePath(),

	}

	/**

	 * @param server

	 * @param database

	 * @param port

	 */

		super();

		this.dbType = dbType;

		this.server = server;

		this.destroyMethodName = dbType.getDestroyMethod();

		this.filePath = filePath;

		this.mode = mode;

	}

	@Override

	public String getName() {

		return database;

	public String getServer() {

		return server;

	}

	@Override

	public int getPort() {

		return port;

	}

	@Override

	public BeanDefinition getDatasourceBean(){

		AbstractBeanDefinition bd = new RootBeanDefinition(dbType.getDataSourceClass());

		//properties

		MutablePropertyValues props = new MutablePropertyValues();

		Properties persistentProperties = getDatasourceProperties();

		while (keys.hasMoreElements()){

			String key = (String)keys.nextElement();

			props.addPropertyValue(key, persistentProperties.getProperty(key));

	public String getDatabase() {

		return database;

	}

	@Override

	public void setDatabase(String database) {

	}

	@Override

	@Override

	public void setMode(H2Mode h2Mode) {

		this.mode = h2Mode;

	}

	@Override

	public String getPassword() {

		return password;

	@Override

	public void setPassword(String password) {

		this.password = password;

	}

	@Override

	public String getUsername() {

		return username;

	@Override

	public void setUsername(String username) {

		this.username = username;

	@Override

	public String toString() {

		}

	}

}

/**

* 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 eu.etaxonomy.cdm.config.CdmPersistentXMLSource.CdmSourceProperties;

import eu.etaxonomy.cdm.config.ICdmPersistentSource;

import eu.etaxonomy.cdm.database.types.IDatabaseType;

/**

 */

public class CdmPersistentDataSource extends CdmDataSourceBase implements ICdmPersistentSource {

	private static final Logger logger = Logger.getLogger(CdmPersistentDataSource.class);

	public static final String DATASOURCE_BEAN_POSTFIX = "DataSource";

	private String beanName;

	private String database;

	/**

	 * This is strictly a <String, String> list of properties

	 */

	/**

	 * The Datasource class that Spring will use to set up the connection to the database

	 */

	/**

	 * Returns the default CdmDataSource

	 * @return the default CdmDataSource

	 */

	public final static CdmPersistentDataSource NewDefaultInstance() throws DataSourceNotFoundException {

		return NewInstance("default");

	}

	/**

	 * Returns the default CdmDataSource

	 * @return the default CdmDataSource

	 */

	public final static CdmPersistentDataSource NewLocalHsqlInstance() throws DataSourceNotFoundException{

		return NewInstance("localDefaultHsql");

	}

	/**

	 * Returns the CdmDataSource named by strDataSource

	 * @param strDataSource

	 */

	private CdmPersistentDataSource(String strDataSource){

		setName(strDataSource);

	}

	private void loadSource(String strDataSource) {

		CdmPersistentXMLSource cdmPersistentXMLSource = CdmPersistentXMLSource.NewInstance(strDataSource, DATASOURCE_BEAN_POSTFIX);

		if(cdmPersistentXMLSource.getElement() != null) {

			beanName = cdmPersistentXMLSource.getBeanName();

			cdmSourceProperties = cdmPersistentXMLSource.getCdmSourceProperties();

			cdmSourceAttributes = cdmPersistentXMLSource.getCdmSourceAttributes();

			// added database specific properties if they are null

			String url = getCdmSourceProperty(CdmSourceProperties.URL);

			DatabaseTypeEnum dbTypeEnum = getDatabaseType();

			if (dbTypeEnum != null && url != null){

				if (getCdmSourceProperty(CdmSourceProperties.DATABASE) == null){

					String database = dbType.getDatabaseNameByConnectionString(url);

					if(database != null) {

					}

				}

				if(getCdmSourceProperty(CdmSourceProperties.PORT) == null){

						if(port > 0) {

							setPort(port);

						} else {

						}

				}

			}

	}

		return beanName;

	}

	@Override

	public String getDatabase() {

		return database;

		this.database = database;

		//update url string

		cdmSourceProperties.put(CdmSourceProperties.URL.toString(), getDatabaseType().getConnectionString(this));

	}

	@Override

	public void setServer(String server) {

		super.setServer(server);

		//update url string

		cdmSourceProperties.put(CdmSourceProperties.URL.toString(), getDatabaseType().getConnectionString(this));

	}

	@Override

	public void setPort(int port) {

		super.setPort(port);

			//update url string

			cdmSourceProperties.put(CdmSourceProperties.URL.toString(), getDatabaseType().getConnectionString(this));

		}

	}

	@Override

		return getCdmSourceProperty(CdmSourceProperties.FILEPATH);

	}

	@Override

		return H2Mode.fromString(getCdmSourceProperty(CdmSourceProperties.MODE));

	}

	@Override

	public void setMode(H2Mode h2Mode) {

		cdmSourceProperties.put(CdmSourceProperties.MODE.toString(), h2Mode.name());

	}

	@Override

	public String getUsername(){

		return getCdmSourceProperty(CdmSourceProperties.USERNAME);

	}

	@Override

	public void setUsername(String username) {

		cdmSourceProperties.put(CdmSourceProperties.USERNAME.toString(), username);

	}

	@Override

	public String getPassword(){

		return getCdmSourceProperty(CdmSourceProperties.PASSWORD);

	}

	@Override

	public void setPassword(String password) {

		cdmSourceProperties.put(CdmSourceProperties.PASSWORD.toString(), password);

	}

	@Override

	public DatabaseTypeEnum getDatabaseType(){

		String strDriverClass = getCdmSourceProperty(CdmSourceProperties.DRIVER_CLASS);

		DatabaseTypeEnum dbType = DatabaseTypeEnum.byDriverClass(strDriverClass);

		return dbType;

	}

		return cdmSourceProperties.getProperty(property.toString(),null);

	}

	@SuppressWarnings("unchecked")

	@Override

	public BeanDefinition getDatasourceBean(){

				DatabaseTypeEnum.byDriverClass(getCdmSourceProperty(CdmSourceProperties.DRIVER_CLASS));

		AbstractBeanDefinition bd = new RootBeanDefinition(dbtype.getDataSourceClass());

		//attributes

		Iterator<Attribute> iterator = cdmSourceAttributes.iterator();

			}

			//Attribute attribute = iterator.next();

			//bd.setAttribute(attribute.getName(), attribute.getValue());

		//properties

		MutablePropertyValues props = new MutablePropertyValues();

		while (keys.hasMoreElements()){

		}

		bd.setPropertyValues(props);

		return bd;

	}

	/**

	 * @param hbm2dll

	 * @param showSql

		Class<? extends RegionFactory> cacheProviderClass = NoCachingRegionFactory.class;

		return getHibernatePropertiesBean(hbm2dll, showSql, formatSql, registerSearchListener, cacheProviderClass);

	}

	/**

	 * @param hbm2dll

	 * @param showSql

		if(registerSearchListener == null){

			registerSearchListener = false;

		}

		DatabaseTypeEnum dbtype = getDatabaseType();

		AbstractBeanDefinition bd = new RootBeanDefinition(PropertiesFactoryBean.class);

		MutablePropertyValues hibernateProps = new MutablePropertyValues();

		bd.setPropertyValues(hibernateProps);

		return bd;

	}

	/**

	 * Tests existing of the datsource in the according config  file.

	 * @return true if a datasource with the given name exists in the according datasource config file.

	/**

	 * @param strDataSourceName

	 * @param dataSource

	 * @return

	 * 			the updated dataSource, null if not succesful

	 */

		CdmPersistentSourceUtils.delete(CdmPersistentSourceUtils.getBeanName(strDataSourceName,DATASOURCE_BEAN_POSTFIX));

		return save(strDataSourceName, dataSource);

	}

	/**

	 * Replace the persisted datasource with another one.

	 * Used primarily for renaming a datasource.

	 * @param strDataSourceName

	 * @param dataSource

	 * @return

		CdmPersistentSourceUtils.delete(CdmPersistentSourceUtils.getBeanName(strDataSourceName,DATASOURCE_BEAN_POSTFIX));

		return save(dataSource);

	}

	/**

	 * @param dataSource

	 * @return

	public static CdmPersistentDataSource save(ICdmDataSource dataSource)  throws IllegalArgumentException {

		return save(dataSource.getName(),dataSource);

	}

	/**

	 * @param strDataSourceName

	 * @param databaseTypeEnum

	 * @param server

	 * @param mode

	 * @return

	 */

			Class<? extends DataSource> dataSourceClass,

			String initMethod,

			String destroyMethod,

			Boolean startSilent,

			String filePath,

		){

		int portNumber = "".equals(port) ? databaseTypeEnum.getDefaultPort() : Integer.valueOf(port);

		//root

		Element root = getBeansRoot(CdmPersistentSourceUtils.getCdmSourceInputStream());

		if (root == null){

		bean.setAttribute("lazy-init", "true");

		if (initMethod != null) {bean.setAttribute("init-method", initMethod);}

		if (destroyMethod != null) {bean.setAttribute("destroy-method", destroyMethod);}

		//set properties

		insertXmlValueProperty(bean, "driverClassName", databaseTypeEnum.getDriverClassName());

		insertXmlValueProperty(bean, "url", databaseTypeEnum.getConnectionString(dataSource));

		if (username != null) {insertXmlValueProperty(bean, "username", username );}

		if (password != null) {insertXmlValueProperty(bean, "password", password );}

		if (startServer != null) {insertXmlValueProperty(bean, "startServer", startServer.toString() );}

		if (filePath != null) {insertXmlValueProperty(bean, "filePath", filePath );}

		if (mode != null) {insertXmlValueProperty(bean, "mode", mode.toString() );}

		//save

				XmlHelp.prettyFormat );

		try {

			return NewInstance(strDataSourceName) ;

			return null;

		}

	}

	/**

	 * Saves a datasource to the datasource config file. If strDataSourceName differs a new dataSource

	 * will be created in config file. Use update() of real update functionality.

	 * @param strDataSourceName

	 * @param dataSource

	 * @return

	 */

	public static CdmPersistentDataSource save(String strDataSourceName,

			ICdmDataSource dataSource)  throws IllegalArgumentException{

		if(dataSource.getDatabaseType() == null){

			new IllegalArgumentException("Database type not specified");

		}

		if(dataSource.getDatabaseType().equals(DatabaseTypeEnum.H2)){

			Class<? extends DataSource> dataSourceClass =  LocalH2.class;

			if(dataSource.getMode() == null) {

				new IllegalArgumentException("H2 mode not specified");

			return save(

		}else{

			Class<? extends DataSource> dataSourceClass;

			try {

				dataSourceClass = (Class<? extends DataSource>) Class.forName(dataSourceClassName);

				String server = getCheckedDataSourceParameter(dataSource.getServer());

				CdmPersistentDataSource persistendDatasource =  save(

				return persistendDatasource;

			} catch (ClassNotFoundException e) {

				logger.error("DataSourceClass not found - stopping application", e);

		}

	}

		if(parameter != null) {

			return parameter;

		} else {

			throw new IllegalArgumentException("Non obsolete paramater was assigned a null value: " + parameter);

		}

	}

	/**

	 * Returns a list of all datasources stored in the datasource config file

	 * @return all existing data sources

	@SuppressWarnings("unchecked")

	static public List<CdmPersistentDataSource> getAllDataSources(){

		List<CdmPersistentDataSource> dataSources = new ArrayList<CdmPersistentDataSource>();

		Element root = getBeansRoot(CdmPersistentSourceUtils.getCdmSourceInputStream());

		if (root == null){

			return null;

		}else{

	    	List<Element> lsChildren  = root.getChildren("bean", root.getNamespace());

	    	for (Element elBean : lsChildren){

	    		String strId = elBean.getAttributeValue("id");

	    		if (strId != null && strId.endsWith(DATASOURCE_BEAN_POSTFIX)){

		}

		return dataSources;

	}

	@Override

	public boolean equals(Object obj){

		if (obj == null){

		}

	}

	@Override

	public String toString(){

		if (getName() != null){

import org.springframework.jdbc.CannotGetJdbcConnectionException;

import eu.etaxonomy.cdm.api.application.CdmApplicationUtils;

/**

	protected String DEFAULT_DRIVER_CLASS_NAME = "org.h2.Driver";

	String mode = H2Mode.EMBEDDED.toString();

	/**

	 *

	 */

		return mode;

	}

}