<?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:jdbc="http://www.springframework.org/schema/jdbc"
   xsi:schemaLocation="
      http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd
      http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
      http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-3.1.xsd ">
   
   <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://localhost:3306/ludus_realm" />
        <property name="username" value="root" />
        <property name="password" value="" />
   </bean>
   
   <bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <property name="annotatedClasses">
       <list>
       </list>
        </property>
        <property name="hibernateProperties">
          <props>
               <prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
               <prop key="hibernate.show_sql">true</prop>
               <prop key="hibernate.hbm2ddl.auto">update</prop>
          </props>
        </property>
   </bean>
   
   <bean id="transactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
        <property name="sessionFactory" ref="sessionFactory" />
   </bean>
   <tx:annotation-driven />
</beans>

<tx:annotation-driven />

<?xml version="1.0" encoding="ISO-8859-1"?>

<!DOCTYPE beans SYSTEM "http://www.springframework.org/dtd/spring-beans.dtd" PUBLIC "-//SPRING//DTD BEAN//EN">
-<beans>
<!-- ========================= Start of PERSISTENCE DEFINITIONS ========================= -->

<!-- DataSource Definition via JNDI -->
-<bean destroy-method="close" class="org.apache.commons.dbcp.BasicDataSource" id="database">
<property value="com.mysql.jdbc.Driver" name="driverClassName"/>
<property value="jdbc:mysql://localhost:3306/ludus" name="url"/>
<property value="root" name="username"/>
<property value="" name="password"/>
</bean>
<!-- Hibernate SessionFactory Definition -->
-<bean class="org.springframework.orm.hibernate3.LocalSessionFactoryBean" id="sessionFactory">
-<property name="mappingResources">
-<list>
<value>data/sql/entity/account.hbm.xml</value>
<value>data/sql/entity/player.hbm.xml</value>
</list>
</property>
-<property name="hibernateProperties">
-<props> <prop key="hibernate.hbm2ddl.auto">update</prop>
<prop key="hibernate.dialect">org.hibernate.dialect.MySQLDialect</prop>
<prop key="hibernate.show_sql">false</prop>
<prop key="hibernate.format_sql">false</prop>
<prop key="hibernate.bytecode.use_reflection_optimizer">true</prop>
<prop key="hibernate.cache.provider_class">net.sf.ehcache.hibernate.EhCacheProvider</prop>
<prop key="hibernate.cache.region.factory_class">net.sf.ehcache.hibernate.EhCacheRegionFactory</prop>
<prop key="hibernate.cache.use_second_level_cache">true</prop>
<prop key="hibernate.cache.use_query_cache">true</prop>
</property>
<property name="dataSource" ref="database"/>
</bean>
<!-- Hibernate Transaction Manager Definition -->
-<bean class="org.springframework.orm.hibernate3.HibernateTransactionManager" id="transactionManager">
<property name="sessionFactory" ref="sessionFactory"/>
</bean>
</beans>