<?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:mvc="http://www.springframework.org/schema/mvc"
       xsi:schemaLocation="
       http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
       http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-3.0.xsd">

    <!-- org.apache.commons.dbcp.BasicDataSource -->
    <bean id="myDataSource" class="org.apache.tomcat.dbcp.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="org.postgresql.Driver"/>
        <property name="url" value="jdbc:postgresql://localhost/spatialdb:5432"/>
        <property name="username" value="enterprisedb"/>
        <property name="password" value="postgres"/>
    </bean>

    <bean id="mySessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
        <property name="dataSource" ref="myDataSource" />
        <property name="annotatedClasses">
            <list>
                <value>org.ala.spatial.domain.Species</value>
                <value>org.ala.spatial.domain.TaxonNames</value>
            </list>
        </property>
        <property name="hibernateProperties">
            <props>
                <prop key="hibernate.dialect">org.hibernate.dialect.PostgreSQLDialect</prop>
                <prop key="hibernate.show_sql">true</prop>
                <!-- <prop key="hibernate.hbm2ddl.auto">create</prop> -->

                <prop key="hibernate.c3p0.min_size">5</prop>
                <prop key="hibernate.c3p0.max_size">80</prop>
                <prop key="hibernate.c3p0.initial_pool_size">5</prop>
                <prop key="hibernate.c3p0.min_pool_size">15</prop>
                <prop key="hibernate.c3p0.max_pool_size">25</prop>
                <prop key="hibernate.c3p0.timeout">1800</prop>
                <prop key="hibernate.c3p0.max_statements">50</prop>
            </props>
        </property>
    </bean>

    <bean id="speciesDao" class="org.ala.spatial.dao.SpeciesDAOImpl">
        <property name="sessionFactory" ref="mySessionFactory"/>
    </bean>

    <!--
    <bean id="namesDao" class="org.ala.spatial.dao.TaxonNamesDAOImpl">
        <property name="sessionFactory" ref="mySessionFactory"/>
    </bean>
    -->

</beans>