EDIT

cdmlib-remote-webapp/ide/src/main/java/eu/etaxonomy/cdm/remote/config/AbstractWebApplicationConfigurer.java -text

cdmlib-remote-webapp/ide/src/main/java/eu/etaxonomy/cdm/remote/config/DataSourceConfigurer.java -text

cdmlib-remote-webapp/ide/src/main/java/eu/etaxonomy/cdm/remote/config/LoggingConfigurer.java -text

cdmlib-remote-webapp/ide/src/main/resources/log4j.properties -text

cdmlib-remote-webapp/ide/src/main/webapp/WEB-INF/applicationContext.views.xml -text

cdmlib-remote-webapp/ide/src/main/webapp/WEB-INF/applicationContext.xml -text

cdmlib-remote-webapp/ide/src/main/webapp/WEB-INF/cdmlib-remote-servlet.xml -text

cdmlib-remote-webapp/ide/src/main/webapp/WEB-INF/cdmrest-servlet.xml -text

cdmlib-remote-webapp/ide/src/main/webapp/WEB-INF/datasources/configurable.xml -text

cdmlib-remote-webapp/ide/src/main/webapp/WEB-INF/datasources/datasources-local.xml -text

cdmlib-remote-webapp/ide/src/main/webapp/WEB-INF/datasources/empty-default-datasource.xml -text

cdmlib-remote-webapp/ide/src/main/webapp/WEB-INF/datasources/p6spy.xml -text

cdmlib-remote-webapp/ide/src/main/webapp/WEB-INF/datasources/routing-datasource.xml -text

cdmlib-remote-webapp/ide/src/main/webapp/WEB-INF/json-views.xml -text

cdmlib-remote-webapp/ide/src/main/webapp/WEB-INF/jsp/index.jsp -text

cdmlib-remote-webapp/ide/src/main/webapp/WEB-INF/oai-views.xml -text

cdmlib-remote-webapp/ide/src/main/webapp/WEB-INF/web.xml -text

cdmlib-remote-webapp/ide/src/main/webapp/WEB-INF/xml-views.xml -text

cdmlib-remote-webapp/ide/src/main/webapp/human.xsl -text

cdmlib-remote-webapp/ide/src/main/webapp/oai2.xsl -text

cdmlib-remote-webapp/ide/src/test/java/eu/etaxonomy/AppTest.java -text

cdmlib-remote-webapp/ide/src/test/resources/log4j.properties -text

// $Id$

/**

 * Copyright (C) 2009 EDIT

 * European Distributed Institute of Taxonomy 

 * 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.

 */

package eu.etaxonomy.cdm.remote.config;

import java.util.ArrayList;

import java.util.List;

import org.apache.log4j.Logger;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.context.ApplicationContext;

import org.springframework.web.context.WebApplicationContext;

/**

 * @author a.kohlbecker

 * @date 20.07.2010

 *

 */

public abstract class AbstractWebApplicationConfigurer {

    private static final String ATTRIBUTE_ERROR_MESSAGES = "cdm.errorMessages";

	public static final Logger logger = Logger.getLogger(AbstractWebApplicationConfigurer.class);

	WebApplicationContext webApplicationContext;

	@Autowired

	public void setApplicationContext(ApplicationContext applicationContext){

		if(WebApplicationContext.class.isAssignableFrom(applicationContext.getClass())) {

			this.webApplicationContext = (WebApplicationContext)applicationContext;

		} else {

			logger.error("The " + this.getClass().getSimpleName() + " only can be used within a WebApplicationContext");

		}

	}

	/**

	 * Find a property in the ServletContext if not found search in a second

	 * step in the environment variables of the OS

	 * 

	 * @param property

	 * @param required

	 * @return

	 */

	protected String findProperty(String property, boolean required) {

		// 1. look for the property in the ServletContext

		Object obj = webApplicationContext.getServletContext().getAttribute(property);

		String value = (String)obj;

		// 2. look for the property in environment variables of the OS

		if(value == null){

			value = System.getProperty(property);

		}

		if(value == null && required){

			logger.error("property {" + property + "} not found.");

			logger.error("--> This property can be set in two ways:");

			logger.error("--> 		1. as attribute to the ServletContext");

			logger.error("--> 		2. as system property e.g. -D" + property);

			logger.error("Stopping application ...");

			System.exit(-1);

		}

		return value;

	}

	protected void addErrorMessageToServletContextAttributes(String errorMessage) {

		Object o = webApplicationContext.getServletContext().getAttribute(ATTRIBUTE_ERROR_MESSAGES);

		List<String> messages;

		if(o != null  && o instanceof List<?>){

			messages = (List<String>) o;

		} else {

			messages = new ArrayList<String>();

		}

		messages.add(errorMessage);

		webApplicationContext.getServletContext().setAttribute(ATTRIBUTE_ERROR_MESSAGES, messages);

	}

}

// $Id$

/**

 * Copyright (C) 2009 EDIT

 * European Distributed Institute of Taxonomy 

 * 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.

 */

package eu.etaxonomy.cdm.remote.config;

import java.io.File;

import java.lang.reflect.InvocationTargetException;

import java.lang.reflect.Method;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.Properties;

import javax.naming.NamingException;

import javax.sql.DataSource;

import org.apache.log4j.Logger;

import org.springframework.beans.factory.xml.XmlBeanFactory;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import org.springframework.core.io.FileSystemResource;

import org.springframework.jndi.JndiObjectFactoryBean;

import com.mchange.v2.c3p0.ComboPooledDataSource;

import eu.etaxonomy.cdm.model.common.CdmMetaData;

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

/**

 * The <code>DataSourceConfigurer</code> can be used as a replacement for a xml configuration in the application context.

 * Enter the following in your application context configuration in order to enable the <code>DataSourceConfigurer</code>:

 *  

<pre>

<!-- enable processing of annotations such as @Autowired and @Configuration -->

<context:annotation-config/>

<bean class="eu.etaxonomy.cdm.remote.config.DataSourceConfigurer" >

</bean>

</pre>

 * The <code>DataSourceConfigurer</code> allows alternative ways to specify a data source:

 * 

 * <ol>

 * <li>Specify the data source bean to use in the Java environment properties: 

 * <code>-Dcdm.datasource={dataSourceName}</code> ({@link #ATTRIBUTE_DATASOURCE_NAME}). 

 * The data source bean with the given name will then be loaded from the <code>cdm.beanDefinitionFile</code> 

 * ({@link #CDM_BEAN_DEFINITION_FILE}), which must be a valid Spring bean definition file.

 * </li>

 * <li> 

 * Use a JDBC data source which is bound into the JNDI context. In this case the JNDI name is specified 

 * via the {@link #ATTRIBUTE_JDBC_JNDI_NAME} as attribute to the ServletContext. 

 * This scenario usually being used by the cdm-server application.

 * </li>

 * </ol>

 * The attributes used in (1) and (2) are in a first step being searched in the ServletContext 

 * if not found search in a second step in the environment variables of the OS, see:{@link #findProperty(String, boolean)}. 

 * 

 * @author a.kohlbecker

 * @date 04.02.2011

 *

 */

@Configuration

public class DataSourceConfigurer extends AbstractWebApplicationConfigurer {

	public static final Logger logger = Logger.getLogger(DataSourceConfigurer.class);

    private static final String ATTRIBUTE_JDBC_JNDI_NAME = "cdm.jdbcJndiName";

    private static final String ATTRIBUTE_HIBERNATE_DIALECT = "hibernate.dialect";

    private static final String CDM_BEAN_DEFINITION_FILE = "cdm.beanDefinitionFile";

    private static final String ATTRIBUTE_DATASOURCE_NAME = "cdm.datasource";

    private static final String DATASOURCE_BEANDEF_DEFAULT = System.getProperty("user.home")+File.separator+".cdmLibrary"+File.separator+"datasources.xml";

	private static String beanDefinitionFile = DATASOURCE_BEANDEF_DEFAULT;

	public void setBeanDefinitionFile(String filename){

		beanDefinitionFile = filename;

	}

	private DataSource dataSource;

	private Properties getHibernateProperties() {

		Properties hibernateProperties = webApplicationContext.getBean("jndiHibernateProperties", Properties.class);

		return hibernateProperties;

	}

	@Bean

	public DataSource dataSource() {

		String beanName = findProperty(ATTRIBUTE_DATASOURCE_NAME, true);

		String jndiName = null;

		if(this.dataSource == null){

			jndiName = findProperty(ATTRIBUTE_JDBC_JNDI_NAME, false);

			if(jndiName != null){

				dataSource = useJndiDataSource(jndiName);

			} else {

				dataSource = loadDataSourceBean(beanName);

			}

		}

		if(dataSource == null){

			return null;

		} 

		// validate correct schema version

		try {

			Connection connection = dataSource.getConnection();

			ResultSet resultSet = connection.createStatement().executeQuery(MetaDataPropertyName.DB_SCHEMA_VERSION.getSqlQuery());

			String version = null;

			if(resultSet.next()){

				version = resultSet.getString(1);

			} else {

				throw new RuntimeException("Unable to retrieve version info from data source " + dataSource.toString());

			}

			connection.close();

			if(!CdmMetaData.isDbSchemaVersionCompatible(version)){

				/*

				 * any exception thrown here would be nested into a spring

				 * BeanException which can not be caught in the servlet

				 * container, so we post the information into the

				 * ServletContext

				 */

				String errorMessage = "Incompatible version [" + (beanName != null ? beanName : jndiName) + "] expected version: " + CdmMetaData.getDbSchemaVersion() + ",  data base version  " + version;

				addErrorMessageToServletContextAttributes(errorMessage);

			}

		} catch (SQLException e) {

			RuntimeException re =   new RuntimeException("Unable to connect or to retrieve version info from data source " + dataSource.toString() , e);

			addErrorMessageToServletContextAttributes(re.getMessage());

			throw re;

		}

		return dataSource; 

	}

	private DataSource useJndiDataSource(String jndiName) {

		logger.info("using jndi datasource '" + jndiName + "'");

		JndiObjectFactoryBean jndiFactory = new JndiObjectFactoryBean();

		/*

		JndiTemplate jndiTemplate = new JndiTemplate();

		jndiFactory.setJndiTemplate(jndiTemplate); no need to use a JndiTemplate 

		if I try using JndiTemplate I get an org.hibernate.AnnotationException: "Unknown Id.generator: system-increment" 

		when running multiple intances via the Bootloader

		*/

		jndiFactory.setResourceRef(true);

		jndiFactory.setJndiName(jndiName);

		try {

			jndiFactory.afterPropertiesSet();

		} catch (IllegalArgumentException e) {

			logger.error(e);

		} catch (NamingException e) {

			logger.error(e);

		}

		Object obj = jndiFactory.getObject();

		return (DataSource)obj;

	}

	private DataSource loadDataSourceBean(String beanName) {

		String beanDefinitionFileFromProperty = findProperty(CDM_BEAN_DEFINITION_FILE, false);

		String path = (beanDefinitionFileFromProperty != null ? beanDefinitionFileFromProperty : beanDefinitionFile);

		logger.info("loading DataSourceBean '" + beanName + "' from: " + path);

		FileSystemResource file = new FileSystemResource(path);

		XmlBeanFactory beanFactory  = new XmlBeanFactory(file);

		DataSource dataSource = beanFactory.getBean(beanName, DataSource.class);

		if(dataSource instanceof ComboPooledDataSource){

			logger.info("DataSourceBean '" + beanName + "' is a ComboPooledDataSource [URL:" + ((ComboPooledDataSource)dataSource).getJdbcUrl()+ "]");

		} else {

			logger.error("DataSourceBean '" + beanName + "' IS NOT a ComboPooledDataSource");

		}

		return dataSource;

	}

	@Bean

	public Properties hibernateProperties(){

		Properties props = getHibernateProperties();

		props.setProperty(ATTRIBUTE_HIBERNATE_DIALECT, inferHibernateDialectName());

		return props;

	}

	public String inferHibernateDialectName() {

		DataSource ds = dataSource();

		String url = "<SEE PRIOR REFLECTION ERROR>";

		Method m = null;

		try {

			m = ds.getClass().getMethod("getUrl");

		} catch (SecurityException e) {

			logger.error(e);

		} catch (NoSuchMethodException e) {

			try {

				m = ds.getClass().getMethod("getJdbcUrl");

			} catch (SecurityException e2) {

				logger.error(e2);

			} catch (NoSuchMethodException e2) {

				logger.error(e2);

			}

		}

		try {

			url = (String)m.invoke(ds);

		} catch (IllegalArgumentException e) {

			logger.error(e);

		} catch (IllegalAccessException e) {

			logger.error(e);

		} catch (InvocationTargetException e) {

			logger.error(e);

		} catch (SecurityException e) {

			logger.error(e);

		} 

		if(url != null && url.contains("mysql")){

			return "org.hibernate.dialect.MySQLDialect";

		}

		logger.error("hibernate dialect mapping for "+url+ " not jet implemented or unavailable");

		return null;

	}

}

// $Id$

/**

 * Copyright (C) 2009 EDIT

 * European Distributed Institute of Taxonomy 

 * 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.

 */

package eu.etaxonomy.cdm.remote.config;

import java.io.IOException;

import org.apache.log4j.Logger;

import org.apache.log4j.PatternLayout;

import org.apache.log4j.RollingFileAppender;

import org.springframework.beans.factory.InitializingBean;

import org.springframework.context.annotation.Configuration;

/**

 * @author a.kohlbecker

 * @date 20.07.2010

 * 

 */

@Configuration

public class LoggingConfigurer extends AbstractWebApplicationConfigurer implements InitializingBean  {

	/**

	 * 

	 */

	private static final String ROLLING_FILE_APPENDER = "rollingFileAppender";

	private static final String CDM_LOGFILE = "cdm.logfile";

	protected void configureLogFile() {

		PatternLayout layout = new PatternLayout("%d %p [%c] - %m%n");

		String logFile = findProperty(CDM_LOGFILE, false);

		if (logFile == null) {

			logger.info("No logfile specified, runing without.");

			return;

		}

		try {

			RollingFileAppender appender = new RollingFileAppender(layout, logFile);

			appender.setName(ROLLING_FILE_APPENDER);

			appender.setMaxBackupIndex(3);

			appender.setMaxFileSize("2MB");

			Logger.getRootLogger().addAppender(appender);

			logger.info("logging to :" + logFile);

		} catch (IOException e) {

			logger.error("Creating RollingFileAppender failed:", e);

		}

	}

	/* (non-Javadoc)

	 * @see org.springframework.beans.factory.InitializingBean#afterPropertiesSet()

	 */

	@Override

	public void afterPropertiesSet() throws Exception {

		configureLogFile();

	}

}

#

#

# If you are having problems with logging you may debug Log4J initialization, 

# start the application with a system property log4j.configDebug set to "true". 

# E.g.:

#

#     java -Dlog4j.configDebug=true

#

log4j.rootLogger=WARN, stdout

log4j.appender.stdout=org.apache.log4j.ConsoleAppender

log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

log4j.appender.stdout.layout.ConversionPattern=%d %p [%c] - %m%n

##

## NOTICE !!!!

## no need to configure a FileAppender here

## use eu.etaxonomy.cdm.remote.config.LoggingConfigurer instead

##

###

# cdm

###

log4j.logger.eu.etaxonomy.cdm = INFO

# 	  avoid vast amount of "getCitation not yet implemented" & "getProblems not yet implemented" messages

log4j.logger.eu.etaxonomy.cdm.model.name.TaxonNameBase = ERROR

log4j.logger.eu.etaxonomy.cdm.database.UpdatableRoutingDataSource = INFO

log4j.logger.eu.etaxonomy.cdm.persistence.dao.AbstractBeanInitializer = ERROR

log4j.logger.eu.etaxonomy.cdm.remote.controller = INFO

log4j.logger.eu.etaxonomy.cdm.remote.controller.interceptor = WARN

#log4j.logger.eu.etaxonomy.cdm.remote.json.processor.AbstractCdmBeanProcessor  = DEBUG

#     prevent CdmExceptionResolver from logging errors

log4j.logger.eu.etaxonomy.cdm.remote.exception.CdmExceptionResolver = ERROR

###

# springframework

### 

log4j.logger.org.springframework = warn

log4j.logger.org.springframework.web.servlet.DispatcherServlet = WARN

log4j.logger.org.springframework.web.servlet.mvc.annotation = WARN

#log4j.category.org.springframework.web.servlet.mvc.support=DEBUG, stdout

log4j.logger.org.springframework.web.servlet.view = WARN

###

# json-lib

### 

log4j.logger.net.sf.json.JSONObject = ERROR

###

# Hibernate

###

log4j.logger.org.hibernate=WARN

#     log just the SQL

log4j.logger.org.hibernate.SQL=WARN

log4j.logger.org.hibernate.search = ERROR

#     log JDBC bind parameters

log4j.logger.org.hibernate.type=WARN

#     log schema export/update

log4j.logger.org.hibernate.tool.hbm2ddl=WARN

# This overcomes the proxy narrow log of hibernate

log4j.logger.org.hibernate.engine.StatefulPersistenceContext.ProxyWarnLog=ERROR

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xmlns:tx="http://www.springframework.org/schema/tx"

    xmlns:context="http://www.springframework.org/schema/context"

    xsi:schemaLocation="http://www.springframework.org/schema/beans   http://www.springframework.org/schema/beans/spring-beans-2.5.xsd

    http://www.springframework.org/schema/context   http://www.springframework.org/schema/context/spring-context-2.5.xsd

    http://www.springframework.org/schema/tx   http://www.springframework.org/schema/tx/spring-tx-2.5.xsd

    ">

  <!--

    - Accepts a configuration file.

    - The default configuration file is /WEB-INF/views.xml

    <bean  name="viewResolver" class="org.springframework.web.servlet.view.XmlViewResolver">

     <!- -

     FOR DEBUGING ONLY !!!!

     <property name="cache" value="false"/>

      - ->

    </bean>

  -->

  <import resource="classpath:eu/etaxonomy/cdm/remote/json/jsonConfigurations.xml"/>

  <!--

    A TaxonNodeComparator with substitutionRules to allow correct sorted

    taxon nodes e.g. in a taxonomic tree browser

  -->

    <bean  name="taxonNodeByNameComparator" class="eu.etaxonomy.cdm.model.taxon.TaxonNodeByNameComparator">

      <property name="substitutionRules">

        <map>

          <entry key=".*?( sp\.| ssp\.| spp\.| n\.|Nomina dubia|Incertae sedis|Nomina excludenda).*" value="_" />

        </map>

      </property>

    </bean>

</beans>

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xmlns:tx="http://www.springframework.org/schema/tx"

    xmlns:context="http://www.springframework.org/schema/context"

    xsi:schemaLocation="http://www.springframework.org/schema/beans   http://www.springframework.org/schema/beans/spring-beans-2.5.xsd

    http://www.springframework.org/schema/context   http://www.springframework.org/schema/context/spring-context-2.5.xsd

    http://www.springframework.org/schema/tx   http://www.springframework.org/schema/tx/spring-tx-2.5.xsd

    ">

   <!-- include default application context and customization -->

    <import resource="classpath:/eu/etaxonomy/cdm/defaultApplicationContext.xml"/>

    <bean id="persistentTermInitializer" class="eu.etaxonomy.cdm.database.PersistentTermInitializer">

       <property name="omit" value="false" />

    </bean>

   <context:component-scan base-package="eu/etaxonomy/cdm/ext" />

   <import resource="classpath:/eu/etaxonomy/cdm/remote.xml"/>

    <context:component-scan base-package="eu/etaxonomy/cdm/io">

        <context:exclude-filter type="regex" expression="eu\.etaxonomy\.cdm\.io\.pesi.*" />

        <context:exclude-filter type="regex" expression="eu\.etaxonomy\.cdm\.io\.faunaEuropaea.*" />

        <context:exclude-filter type="regex" expression="eu\.etaxonomy\.cdm\.io\.erms.*" />

        <context:exclude-filter type="regex" expression="eu\.etaxonomy\.cdm\.io\.eflora.*" />

        <context:exclude-filter type="regex" expression="eu\.etaxonomy\.cdm\.io\.berlinModel.*" />

    </context:component-scan>

    <bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

    <property name="properties">

      <props>

          <prop key="eu.etaxonomy.cdm.base.path">${user.home}/.cdmLibrary/</prop>

          <prop key="eu.etaxonomy.cdm.search.index.path">${user.home}/.cdmLibrary/index/</prop>

      </props>

        </property>

  </bean>

    <!-- enable the configuration of transactional behavior based on annotations -->

    <tx:annotation-driven transaction-manager="transactionManager"/>

    <!-- import additional beans into the root context -->

    <import resource="applicationContext.views.xml"/>

    <!-- CONFIGURE WEB APPLICATION HERE -->

    <import resource="datasources/configurable.xml" />

    <context:annotation-config/>

    <bean class="eu.etaxonomy.cdm.remote.config.LoggingConfigurer">

    </bean>

     <!-- OAI-PMH TODO externalize? -->

     <bean name="taxonOaiPmhController" class="eu.etaxonomy.cdm.remote.controller.oaipmh.TaxonOaiPmhController">

     <property name="cachingModel" ref="taxonOaiPmhCacheMapping"/>

   </bean>

  <bean name="taxonOaiPmhCacheMapping" class="org.springmodules.cache.provider.ehcache.EhCacheCachingModel">

          <property name="cacheName" value="eu.etaxonomy.cdm.remote.controller.TaxonOaiPmhController.resumptionToken"/>

  </bean>

  <bean id="cacheManager" class="org.springframework.cache.ehcache.EhCacheManagerFactoryBean">

    <property name="configLocation" value="classpath:/eu/etaxonomy/cdm/remote/ehcache.xml" />

        <property name="shared" value="true"/>

    </bean>

  <bean id="serializableFactory" class="org.springmodules.cache.serializable.XStreamSerializableFactory"/>

  <bean id="cacheProviderFacade" class="org.springmodules.cache.provider.ehcache.EhCacheFacade">

      <property name="cacheManager" ref="cacheManager" />

      <property name="serializableFactory" ref="serializableFactory"/>

  </bean>

</beans>

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"

	xmlns:tx="http://www.springframework.org/schema/tx"

	xsi:schemaLocation="http://www.springframework.org/schema/beans 

    http://www.springframework.org/schema/beans/spring-beans-2.5.xsd

    http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd

    http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd

    ">

	<context:component-scan base-package="eu/etaxonomy/cdm/remote" />

	<!-- 

	  ======= HandlerMappings =======

	  -->

	<!--

		first we try to find the controller using the simpleurlmapping, then

		the classname this follows the principal of "convention over

		configuration"

	-->

	<bean

		class="org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping">

		<property name="order" value="1" />

		<property name="interceptors">

			<list>

				<!--<ref bean="contentNegociationHandlerInterceptor" /> -->

				<ref bean="localeContextHandlerInterceptor" />

			</list>

		</property>

		<property name="pathMatcher">

		  <!--  must match the pathMatcher as set in AnnotationMethodHandlerAdapter -->

		  <bean class="eu.etaxonomy.cdm.remote.controller.util.CdmAntPathMatcher" />

		</property>

	</bean>

    <!-- 

	<bean class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">

		<property name="order" value="0" />

		<property name="mappings">

			<props>

				<prop key="/index.do">urlFilenameViewController

				</prop>

				<prop key="/">welcomeFileViewController

				</prop>

			</props>

		</property>

	</bean>

	 -->

	<!-- 

	======= HandlerAdapters =======

	-->

	<bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">

	   <property name="pathMatcher">

	        <!--  must match the pathMatcher as set in DefaultAnnotationHandlerMapping -->

            <bean class="eu.etaxonomy.cdm.remote.controller.util.CdmAntPathMatcher" />

       </property>

	</bean>

	<!-- 

	======= Remoting =======

	-->

	<import resource="classpath:/eu/etaxonomy/cdm/httpinvokerServices.xml"/>

	<bean class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">

		<property name="order" value="0" />

		<property name="mappings">

	 	<!-- Needed for spring remoting with the http invoker -->

	 	<!-- The configuration of the services is imported from httpinvokerServices.xml -->

			<props>

				<prop key="/remoting/agent.service">httpAgentService</prop>

				<prop key="/remoting/annotation.service">httpAnnotationService</prop>

				<prop key="/remoting/auditevent.service">httpAuditEventService</prop>

				<prop key="/remoting/classification.service">httpClassificationService</prop>

				<prop key="/remoting/collection.service">httpCollectionService</prop>

				<prop key="/remoting/common.service">httpCommonService</prop>

				<prop key="/remoting/description.service">httpDescriptionService</prop>

				<prop key="/remoting/featurenode.service">httpFeatureNodeService</prop>

				<prop key="/remoting/featuretree.service">httpFeatureTreeService</prop>

				<prop key="/remoting/group.service">httpGroupService</prop>

				<prop key="/remoting/identificationkey.service">httpIdentificationKeyService</prop>

				<prop key="/remoting/location.service">httpLocationService</prop>

				<prop key="/remoting/marker.service">httpMarkerService</prop>

				<prop key="/remoting/media.service">httpMediaService</prop>

				<prop key="/remoting/name.service">httpNameService</prop>

				<prop key="/remoting/occurrence.service">httpOccurrenceService</prop>

				<prop key="/remoting/polytomouskeynode.service">httpPolytomousKeyNodeService</prop>

				<prop key="/remoting/polytomouskey.service">httpPolytomousKeyService</prop>

				<prop key="/remoting/reference.service">httpReferenceService</prop>

				<prop key="/remoting/service.service">httpServiceService</prop>

				<prop key="/remoting/taxonnode.service">httpTaxonNodeService</prop>

				<prop key="/remoting/taxon.service">httpTaxonService</prop>

				<prop key="/remoting/term.service">httpTermService</prop>

				<prop key="/remoting/user.service">httpUserService</prop>

				<prop key="/remoting/vocabulary.service">httpVocabularyService</prop>

				<prop key="/remoting/authenticationManager.service">httpAuthenticationManager</prop>

			</props>

		</property>

	</bean>

	<!-- needed when using SimpleUrlHandlerMapping 	-->

	<bean

		class="org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter" />

    <!-- needed for HTTPInvoker  -->	

	<bean class="org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter" />

	<!-- 

	======= HandlerInterceptors =======

	-->

	<!-- 

	<bean id="datasourceContextHandlerInterceptor"

		class="eu.etaxonomy.cdm.remote.controller.interceptor.DatasourceContextHandlerInterceptor" /> -->

	<bean id="localeContextHandlerInterceptor"

		class="eu.etaxonomy.cdm.remote.controller.interceptor.LocaleContextHandlerInterceptor" />

	<!-- 

	   === no longer needed, replaced by ContentNegotiatingViewResolver ==	   

	<bean id="contentNegociationHandlerInterceptor"

		class="eu.etaxonomy.cdm.remote.controller.interceptor.ContentNegociationHandlerInterceptor">

		<property name="mapping">

			<map>

				<entry key="text/json" value="json" />

				<entry key="application/json" value="json" />

				<entry key="application/xml" value="xml" />

			</map>

		</property>

		<property name="defaultExtension" value="xml" />

	</bean>

	 -->

	<!-- 

	 ======= ViewControllers =======

	 -->

	<bean id="urlFilenameViewController" class="org.springframework.web.servlet.mvc.UrlFilenameViewController">

	</bean>

	<!--

		The welcome-file-list in the web.xml will is ignored since the

		cdmserver servlet is mapped to the root path [/] So the welcome file

		list is being replaced by a SimpleUrlHandlerMapping on the root path

		[/] which is mapped via this ViewController to the [index] view

	<bean id="welcomeFileViewController"

		class="org.springframework.web.servlet.mvc.UrlFilenameViewController">

		<property name="suffix">

			<value>index</value>

		</property>

	</bean>

	-->

	<!-- 

    ======= ViewResolver =======

    -->

	<bean id="oaiViewResolver" class="org.springframework.web.servlet.view.XmlViewResolver">

        <property name="order" value="0"/>

        <property name="location" value="/WEB-INF/oai-views.xml"/>

        <!-- FOR DEBUGING ONLY !!!!   

        <property name="cache" value="false"/> 

         -->

    </bean>

	 <bean id="contentNegotiatingViewResolver" class="org.springframework.web.servlet.view.ContentNegotiatingViewResolver">

	      <property name="order" value="1" />

	      <property name="mediaTypes">

	         <map>

			    <entry key="xml" value="application/xml" />

				<entry key="dc" value="application/xml" />

				<entry key="rdf" value="application/xml" />

				<entry key="json" value="application/json" />

				<entry key="json" value="application/json" />

	         </map>

	      </property>

	      <property name="viewResolvers">

	          <list>

			    <bean id="xmlTypeViewResolver" class="eu.etaxonomy.cdm.remote.view.PatternViewResolver">

			        <property name="location" value="/WEB-INF/xml-views.xml"/>

			        <!--

			            turn caching off FOR DEBUGING ONLY !!!! 

			        <property name="cache" value="false"/>

			        -->

			    </bean>

			    <bean id="jsonTypeViewResolver" class="eu.etaxonomy.cdm.remote.view.PatternViewResolver">

			        <property name="location" value="/WEB-INF/json-views.xml"/>

			        <!-- 

			          turn caching off FOR DEBUGING ONLY !!!! 

			        <property name="cache" value="false"/>

			        -->

			    </bean>

	          </list>

	      </property>

	</bean>

    <!--  

        === the viewResolverJsp is currently unused ===

	<bean id="viewResolverJsp"

		class="org.springframework.web.servlet.view.InternalResourceViewResolver">

		<property name="order" value="1" />

		<property name="prefix" value="/WEB-INF/jsp/" />

		<property name="suffix" value=".jsp" />

		<property name="viewNames">

			<!- -

				view names (or name patterns) that can be handled

			- ->

			<list>

				<value>index</value>

			</list>

		</property>

	</bean>

    -->

	<!-- 

	======= Exception Handling =======

	-->

	<bean id="exceptionResolver" class="eu.etaxonomy.cdm.remote.exception.CdmExceptionResolver">

	</bean>

	<!--  

    ======= Security ======= 

    -->

<!--    <bean id="basicProcessingFilter" class="org.springframework.security.ui.basicauth.BasicProcessingFilter">-->

<!--		<property name="authenticationManager"><ref bean="authenticationManager"/></property>-->

<!--		<property name="authenticationEntryPoint"><ref bean="authenticationEntryPoint"/></property>-->

<!--	</bean>-->

<!--	<bean id="authenticationEntryPoint" class="org.springframework.security.ui.basicauth.BasicProcessingFilterEntryPoint">-->

<!--		<property name="realmName"><value>Name Of Your Realm</value></property>-->

<!--	</bean>-->

</beans>

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context"

	xmlns:tx="http://www.springframework.org/schema/tx"

	xsi:schemaLocation="http://www.springframework.org/schema/beans 

    http://www.springframework.org/schema/beans/spring-beans-2.5.xsd

    http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd

    http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd

    ">

	<context:component-scan base-package="eu/etaxonomy/cdm/remote" />

	<!-- 

	  ======= HandlerMappings =======

	  -->

	<!--

		first we try to find the controller using the simpleurlmapping, then

		the classname this follows the principal of "convention over

		configuration"

	-->

	<bean

		class="org.springframework.web.servlet.mvc.annotation.DefaultAnnotationHandlerMapping">

		<property name="order" value="1" />

		<property name="interceptors">

			<list>

				<!--<ref bean="contentNegociationHandlerInterceptor" /> -->

				<ref bean="localeContextHandlerInterceptor" />

			</list>

		</property>

		<property name="pathMatcher">

		  <!--  must match the pathMatcher as set in AnnotationMethodHandlerAdapter -->

		  <bean class="eu.etaxonomy.cdm.remote.controller.util.CdmAntPathMatcher" />

		</property>

	</bean>

	<bean class="org.springframework.web.servlet.handler.SimpleUrlHandlerMapping">

		<property name="order" value="0" />

		<property name="mappings">

    <!-- 

			<props>

				<prop key="/index.do">urlFilenameViewController

				</prop>

				<prop key="/">welcomeFileViewController

				</prop>

			</props>

	 -->

	 	<!-- Needed for spring remoting with the http invoker -->

	 	<!-- The configuration of the services is imported from httpinvokerServices.xml -->

			<props>

				<prop key="/agent.service">httpAgentService</prop>

				<prop key="/annotation.service">httpAnnotationService</prop>

				<prop key="/auditevent.service">httpAuditEventService</prop>

				<prop key="/classification.service">httpClassificationService</prop>

				<prop key="/collection.service">httpCollectionService</prop>

				<prop key="/common.service">httpCommonService</prop>

				<prop key="/description.service">httpDescriptionService</prop>

				<prop key="/featurenode.service">httpFeatureNodeService</prop>

				<prop key="/featuretree.service">httpFeatureTreeService</prop>

				<prop key="/group.service">httpGroupService</prop>

				<prop key="/identificationkey.service">httpIdentificationKeyService</prop>

				<prop key="/location.service">httpLocationService</prop>

				<prop key="/marker.service">httpMarkerService</prop>

				<prop key="/media.service">httpMediaService</prop>

				<prop key="/name.service">httpNameService</prop>

				<prop key="/occurrence.service">httpOccurrenceService</prop>

				<prop key="/polytomouskeynode.service">httpPolytomousKeyNodeService</prop>

				<prop key="/polytomouskey.service">httpPolytomousKeyService</prop>

				<prop key="/reference.service">httpReferenceService</prop>

				<prop key="/service.service">httpServiceService</prop>

				<prop key="/taxonnode.service">httpTaxonNodeService</prop>

				<prop key="/taxon.service">httpTaxonService</prop>

				<prop key="/term.service">httpTermService</prop>

				<prop key="/user.service">httpUserService</prop>

				<prop key="/vocabulary.service">httpVocabularyService</prop>

			</props>

		</property>

	</bean>

	<!-- 

	======= HandlerAdapters =======

	-->

	<bean class="org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter">

	   <property name="pathMatcher">

	        <!--  must match the pathMatcher as set in DefaultAnnotationHandlerMapping -->

            <bean class="eu.etaxonomy.cdm.remote.controller.util.CdmAntPathMatcher" />

       </property>

	</bean>

	<!-- needed when using SimpleUrlHandlerMapping 	-->

	<bean

		class="org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter" />

	<!-- needed for HTTPInvoker  -->	

	<bean class="org.springframework.web.servlet.mvc.HttpRequestHandlerAdapter" />

	<!-- 

	======= HandlerInterceptors =======

	-->

	<!-- 

	<bean id="datasourceContextHandlerInterceptor"

		class="eu.etaxonomy.cdm.remote.controller.interceptor.DatasourceContextHandlerInterceptor" /> -->

	<bean id="localeContextHandlerInterceptor"

		class="eu.etaxonomy.cdm.remote.controller.interceptor.LocaleContextHandlerInterceptor" />

	<!-- 

	   === no longer needed, replaced by ContentNegotiatingViewResolver ==	   

	<bean id="contentNegociationHandlerInterceptor"

		class="eu.etaxonomy.cdm.remote.controller.interceptor.ContentNegociationHandlerInterceptor">

		<property name="mapping">

			<map>

				<entry key="text/json" value="json" />

				<entry key="application/json" value="json" />

				<entry key="application/xml" value="xml" />

			</map>

		</property>

		<property name="defaultExtension" value="xml" />

	</bean>

	 -->

	<!-- 

	 ======= ViewControllers =======

	 -->

	<bean id="urlFilenameViewController" class="org.springframework.web.servlet.mvc.UrlFilenameViewController">

	</bean>

	<!--

		The welcome-file-list in the web.xml will is ignored since the

		cdmserver servlet is mapped to the root path [/] So the welcome file

		list is being replaced by a SimpleUrlHandlerMapping on the root path

		[/] which is mapped via this ViewController to the [index] view

	<bean id="welcomeFileViewController"

		class="org.springframework.web.servlet.mvc.UrlFilenameViewController">

		<property name="suffix">

			<value>index</value>

		</property>

	</bean>

	-->

	<!-- 

    ======= ViewResolver =======

    -->

	<bean id="oaiViewResolver" class="org.springframework.web.servlet.view.XmlViewResolver">

        <property name="order" value="0"/>

        <property name="location" value="/WEB-INF/oai-views.xml"/>

        <!-- FOR DEBUGING ONLY !!!!   

        <property name="cache" value="false"/> 

         -->

    </bean>

	 <bean id="contentNegotiatingViewResolver" class="org.springframework.web.servlet.view.ContentNegotiatingViewResolver">

	      <property name="order" value="1" />

	      <property name="mediaTypes">

	         <map>

			    <entry key="xml" value="application/xml" />

				<entry key="dc" value="application/xml" />

				<entry key="rdf" value="application/xml" />

				<entry key="json" value="application/json" />

				<entry key="json" value="application/json" />

	         </map>

	      </property>

	      <property name="viewResolvers">

	          <list>

			    <bean id="xmlTypeViewResolver" class="eu.etaxonomy.cdm.remote.view.PatternViewResolver">

			        <property name="location" value="/WEB-INF/xml-views.xml"/>

			        <!--

			            turn caching off FOR DEBUGING ONLY !!!! 

			        <property name="cache" value="false"/>

			        -->

			    </bean>

			    <bean id="jsonTypeViewResolver" class="eu.etaxonomy.cdm.remote.view.PatternViewResolver">

			        <property name="location" value="/WEB-INF/json-views.xml"/>

			        <!-- 

			          turn caching off FOR DEBUGING ONLY !!!! 

			        <property name="cache" value="false"/>

			        -->

			    </bean>

	          </list>

	      </property>

	</bean>

    <!--  

        === the viewResolverJsp is currently unused ===

	<bean id="viewResolverJsp"

		class="org.springframework.web.servlet.view.InternalResourceViewResolver">

		<property name="order" value="1" />

		<property name="prefix" value="/WEB-INF/jsp/" />

		<property name="suffix" value=".jsp" />

		<property name="viewNames">

			<!- -

				view names (or name patterns) that can be handled

			- ->

			<list>

				<value>index</value>

			</list>

		</property>

	</bean>

    -->

	<!-- 

	======= Exception Handling =======

	-->

	<bean id="exceptionResolver" class="eu.etaxonomy.cdm.remote.exception.CdmExceptionResolver">

	</bean>

	<!-- 

	======= Remoting =======

	-->

	<import resource="classpath:/eu/etaxonomy/cdm/httpinvokerServices.xml"/>

	<!--  

    ======= Security ======= 

    -->

<!--    <bean id="basicProcessingFilter" class="org.springframework.security.ui.basicauth.BasicProcessingFilter">-->

<!--		<property name="authenticationManager"><ref bean="authenticationManager"/></property>-->

<!--		<property name="authenticationEntryPoint"><ref bean="authenticationEntryPoint"/></property>-->

<!--	</bean>-->

<!--	<bean id="authenticationEntryPoint" class="org.springframework.security.ui.basicauth.BasicProcessingFilterEntryPoint">-->

<!--		<property name="realmName"><value>Name Of Your Realm</value></property>-->

<!--	</bean>-->

</beans>

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

	xmlns:context="http://www.springframework.org/schema/context"

	xsi:schemaLocation="http://www.springframework.org/schema/beans

    http://www.springframework.org/schema/beans/spring-beans-2.5.xsd

    http://www.springframework.org/schema/context

    http://www.springframework.org/schema/context/spring-context-2.5.xsd">

    <!-- enable processing of annotations such as @Autowired and @Configuration -->

    <context:annotation-config/>

    <bean class="eu.etaxonomy.cdm.remote.config.DataSourceConfigurer" >

    </bean>

    <bean id="jndiHibernateProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">

        <property name="properties"><!-- This configures default hibernate properties -->

            <props>

              <!-- 

                the hibernate.dialect will be set by the JndiDataSourceConfig accorging to the 

                according WebAppContext attributes or to the environment variable

              -->

              <prop key="hibernate.hbm2ddl.auto">validate</prop><!-- !!! must never be update !!! -->

              <prop key="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</prop>

              <prop key="hibernate.show_sql">false</prop>

              <prop key="hibernate.format_sql">false</prop>

              <prop key="hibernate.search.default.indexBase">${eu.etaxonomy.cdm.search.index.path}</prop>

            </props>

        </property>

    </bean>

</beans>

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

	xmlns:context="http://www.springframework.org/schema/context"

	xsi:schemaLocation="http://www.springframework.org/schema/beans

    http://www.springframework.org/schema/beans/spring-beans-2.5.xsd

    http://www.springframework.org/schema/context

    http://www.springframework.org/schema/context/spring-context-2.5.xsd">

    <bean id="dataSource"  lazy-init="true" class="eu.etaxonomy.cdm.database.UpdatableRoutingDataSource">

    	<property name="targetDataSources">

	      <map key-type="java.lang.String">

	         <entry key="cichorieae" value-ref="cichorieaeDataSource"/>

	         <entry key="palmae" value-ref="palmaeDataSource"/>

	         <entry key="diptera" value-ref="dipteraDataSource"/>

	      </map>

   		</property>

   		<property name="defaultTargetDataSource" ref="cichorieaeDataSource"/>

   </bean>

    <bean id="cichorieaeDataSource"  lazy-init="true" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>

        <property name="username" value="${local.usr}"/>

        <property name="password" value="${local.pwd}"/>

        <property name="url" value="jdbc:mysql://${local.host}/cdm_local_cichorieae"/>

    </bean>

    <bean id="palmaeDataSource"  lazy-init="true" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>

        <property name="username" value="${local.usr}"/>

        <property name="password" value="${local.pwd}"/>

        <property name="url" value="jdbc:mysql://${local.host}/cdm_local_palmae"/>

    </bean>

    <bean id="dipteraDataSource"  lazy-init="true" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>

        <property name="username" value="${local.usr}"/>

        <property name="password" value="${local.pwd}"/>

        <property name="url" value="jdbc:mysql://${local.host}/cdm_local_diptera"/>

    </bean>

    <!-- This configures default properties, which can overridden with the file specified by the location property -->

    <bean id="hibernateProperties" 

        class="org.springframework.beans.factory.config.PropertiesFactoryBean">

        <property name="properties">

            <props>

                <prop key="hibernate.hbm2ddl.auto">validate</prop>

                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>

                <prop key="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</prop>

                <prop key="hibernate.show_sql">true</prop>

                <prop key="hibernate.format_sql">false</prop>

            </props>

        </property>

    </bean>

</beans>

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

	xmlns:context="http://www.springframework.org/schema/context"

	xsi:schemaLocation="http://www.springframework.org/schema/beans

    http://www.springframework.org/schema/beans/spring-beans-2.5.xsd

    http://www.springframework.org/schema/context

    http://www.springframework.org/schema/context/spring-context-2.5.xsd">

    <bean id="dataSource"  lazy-init="true" class="eu.etaxonomy.cdm.database.UpdatableRoutingDataSource">

    	<property name="targetDataSources">

	      <map key-type="java.lang.String">

	         <entry key="empty_default" value-ref="empty_defaultDataSource"/>

	      </map>

   		</property>

   		<property name="defaultTargetDataSource" ref="empty_defaultDataSource"/>

   </bean>

    <bean id="empty_defaultDataSource"  lazy-init="true" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

        <property name="driverClassName" value="com.mysql.jdbc.Driver"/>

        <property name="username" value="${local.usr}"/>

        <property name="password" value="${local.pwd}"/>

        <property name="url" value="jdbc:mysql://${local.host}/cdm_empty_default"/>

    </bean>

    <!-- This configures default properties, which can overridden with the file specified by the location property -->

    <bean id="hibernateProperties" 

        class="org.springframework.beans.factory.config.PropertiesFactoryBean">

        <property name="properties">

            <props>

                <prop key="hibernate.hbm2ddl.auto">validate</prop>

                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>

                <prop key="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</prop>

                <prop key="hibernate.show_sql">false</prop>

                <prop key="hibernate.format_sql">false</prop>

            </props>

        </property>

    </bean>

</beans>

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xmlns:tx="http://www.springframework.org/schema/tx"

    xmlns:context="http://www.springframework.org/schema/context"

    xsi:schemaLocation="http://www.springframework.org/schema/beans   http://www.springframework.org/schema/beans/spring-beans-2.5.xsd

    http://www.springframework.org/schema/context   http://www.springframework.org/schema/context/spring-context-2.5.xsd

    http://www.springframework.org/schema/tx   http://www.springframework.org/schema/tx/spring-tx-2.5.xsd

    ">

    <!-- 

		see also /cdmlib-remote/src/main/resources/spy.properties in which P6Spy is configured 

		important properities are:

			realdriver=com.mysql.jdbc.Driver

			log4j.logger.p6spy=INFO,STDOUT

			log4j.logger.p6spy=INFO, SQLPROFILER_CLIENT

			log4j.appender.SQLPROFILER_CLIENT.RemoteHost = 

		you can use sqlprofiler as SQLPROFILER_CLIENT

	-->

    <bean id="dataSource"  lazy-init="true" class="org.springframework.jdbc.datasource.DriverManagerDataSource">

        <property name="driverClassName" value="com.p6spy.engine.spy.P6SpyDriver"/>

    	<property name="username" value="${local.usr}"/>

        <property name="password" value="${local.pwd}"/>

        <property name="url" value="jdbc:mysql://${local.host}/cdm_local_cichorieae"/>

    </bean>

    <!-- This configures default properties, which can overridden with the file specified by the location property -->

    <bean id="hibernateProperties" 

        class="org.springframework.beans.factory.config.PropertiesFactoryBean">

        <property name="properties">

            <props>

                <prop key="hibernate.hbm2ddl.auto">validate</prop>

                <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>

                <prop key="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</prop>

                <prop key="hibernate.show_sql">false</prop>

                <prop key="hibernate.format_sql">false</prop>

            </props>

        </property>

    </bean>

</beans>

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

	xmlns:context="http://www.springframework.org/schema/context"

	xsi:schemaLocation="http://www.springframework.org/schema/beans

    http://www.springframework.org/schema/beans/spring-beans-2.5.xsd

    http://www.springframework.org/schema/context

    http://www.springframework.org/schema/context/spring-context-2.5.xsd">

    <bean id="dataSource"  lazy-init="true" class="eu.etaxonomy.cdm.database.SelectableDataSource">

    	<!--  The property beanDefinitionFile defaults to "datasources.xml" in {USER_HOME}./cdmLibrary 

    	WARNING !!!

    	The beanDefinitionFile now mus be configured in 

    	eu.etaxonomy.cdm.database.DataSourceBeanLoader

    	-->

    	<!--  The property defaultDatasourceName defaults to "default" 

    	<property name="beanDefinitionFile" value="datasources-p6spy.xml" />

    	<property name="defaultDatasourceName" value="cichorieae" />

    	-->

    </bean>

    <!-- This configures default properties, which can overridden with the file specified by the location property -->

    <bean id="hibernateProperties" class="org.springframework.beans.factory.config.PropertiesFactoryBean">

        <property name="properties">

            <props>

             <!-- 

                  Configuring the C3P0ConnectionProvider

                  ========================================

                  see http://www.mchange.com/projects/c3p0/index.html#hibernate-specific

                  and also org.springframework.orm.hibernate3.AbstractSessionFactoryBean.setDataSource(DataSource dataSource)

                  IMPORTANT: 

                  Because of the constraint (1) the org.hibernate.connection.C3P0ConnectionProvider anc not be used 

                  for the cdm library because it requires the dataSource bean in some cases. 

				          (1)

				          Do NOT specify the dataSource in the sessionFactory for example in the 

				          org.springframework.orm.hibernate3.LocalSessionFactoryBean

				          !!!==> If *dataSource* is set, this will override corresponding settings in Hibernate properties.!!!

 						  If this is set, the Hibernate settings should not define a connection provider to 

 					      avoid meaningless double configuration.

				          (2)

				          Hibernate uses the hibernate.c3p0.max_size property to determine if c3p0

                          is begin used.  Therefore the max_size property MUST be set. - maybe not need in hibernate 3.4 +

                          (3) If you are using Hibernate's C3P0ConnectionProvider you must set the following properties 

                          in your hibernate configuration, using hibernate-specific configuration keys. 

                          All other properties must be defined as usual in a c3p0.properties file. 

                          This is confusing, and will hopefully be simplified some time in the future, but for now... 

                          	hibernate.c3p0.acquire_increment

							hibernate.c3p0.idle_test_period

							hibernate.c3p0.timeout

							hibernate.c3p0.max_size

							hibernate.c3p0.max_statements

							hibernate.c3p0.min_size

							hibernate.c3p0.validate 

				      -->

              <prop key="hibernate.hbm2ddl.auto">update</prop>

              <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>

              <prop key="hibernate.cache.provider_class">org.hibernate.cache.NoCacheProvider</prop>

              <prop key="hibernate.show_sql">false</prop>

              <prop key="hibernate.format_sql">false</prop>

              <prop key="hibernate.search.default.indexBase">${user.home}/.cdmLibrary/</prop>

            </props>

        </property>

    </bean>

</beans>

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xsi:schemaLocation="http://www.springframework.org/schema/beans

    http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">

    <!-- 

        ===============================================================

        This is the configuaration file for the 

        eu.etaxonomy.cdm.remote.view.PatternViewResolver

        ===============================================================

    	- bean names are ant style patterns

    	- the eu.etaxonomy.cdm.remote.view.PatternViewResolver 

    	  must be used to resolve patterns used as bean names

    -->

    <!-- entity services -->

    <bean name="**/*" class="eu.etaxonomy.cdm.remote.view.JsonView">

    	<property name="jsonConfig" ref="jsonConfig" />

    </bean>

    <!-- taxonomy service -->

    <bean name="**/classification **/classification/* **/classification/**/*" class="eu.etaxonomy.cdm.remote.view.JsonView">

        <property name="jsonConfig" ref="jsonConfigClassification" />

    </bean>

    <!-- portal service -->

    <bean name="**/portal/* **/portal/**/*" class="eu.etaxonomy.cdm.remote.view.JsonView">

        <property name="jsonConfig" ref="jsonConfigPortal" />

    </bean>

</beans>

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"

    pageEncoding="ISO-8859-1"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">

<title>CDM Remote API</title>

</head>

<body>

<h1>CDM Remote API</h1>

<p>This is the root of the CDM remote web application which offers the following APIs.</p>

<ul>

<li><a href="http://wp5.e-taxonomy.eu/cdmlib/rest-api.html">RESTful API</a></li>

<li><a href="http://wp5.e-taxonomy.eu/cdmlib/oai-pmh.html">OAI-PMH</a></li>

</ul>

</body>

</html>

<?xml version="1.0" encoding="UTF-8"?>

<beans xmlns="http://www.springframework.org/schema/beans"

    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

    xsi:schemaLocation="http://www.springframework.org/schema/beans

    http://www.springframework.org/schema/beans/spring-beans-2.5.xsd">

    <!-- 

        ===============================================================

        This is the configuaration file for a 

        eu.etaxonomy.cdm.remote.view.XMLViewResolver

        ===============================================================

    -->

    <bean name="oai/exception" class="eu.etaxonomy.cdm.remote.view.oaipmh.ExceptionView">

        <property name="contentType" value="text/xml; charset=UTF-8"/>

        <property name="marshaller" ref="marshaller"/>

        <property name="mapper" ref="dozerMapper"/>

    </bean>

    <bean name="oai/identify" class="eu.etaxonomy.cdm.remote.view.oaipmh.IdentifyView">

        <property name="contentType" value="text/xml; charset=UTF-8"/>

        <property name="marshaller" ref="marshaller"/>

        <property name="mapper" ref="dozerMapper"/>

    </bean>

    <bean name="oai/getRecord.rdf" class="eu.etaxonomy.cdm.remote.view.oaipmh.rdf.GetRecordView">

        <property name="contentType" value="text/xml; charset=UTF-8"/>

        <property name="marshaller" ref="marshaller"/>

        <property name="mapper" ref="dozerMapper"/>

    </bean>