<context:annotation-config/>
<context:component-scan base-package="package.services"/>


<bean id="sessionFactory" class="org.springframework.orm.hibernate3.annotation.AnnotationSessionFactoryBean">
    <property name="dataSource" ref="dataSource"/>
    <property name="packagesToScan">
        <list>
            <value>
                package.pojo.*
            </value>
        </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.connection.pool_size">
                0
            </prop>
            <prop key="hibernate.jdbc.batch_versioned_data">
                false
            </prop>
            <prop key="hibernate.hbm2ddl.auto">
                update
            </prop>
           
        </props>
    </property>
</bean>
<tx:annotation-driven transaction-manager="txManager"/>


<bean id="txManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager">
    <property name="sessionFactory">
        <ref local="sessionFactory"/>
    </property>
</bean>


<bean id="propertyConfigurer" class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
    <property name="location">
        <value>
            /WEB-INF/jdbc.properties
        </value>
    </property>
</bean>


<!-- Local DataSource that works in any environment -->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName">
        <value>
            ${jdbc.driverClassName}
        </value>
    </property>
    <property name="url">
        <value>
            ${jdbc.url}
        </value>
    </property>
    <property name="username">
        <value>
            ${jdbc.username}
        </value>
    </property>
    <property name="password">
        <value>
            ${jdbc.password}
        </value>
    </property>
</bean>