<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName"   value="com.microsoft.sqlserver.jdbc.SQLServerDriver" />
        <property name="url" value="jdbc:sqlserver://localhost:1433;DatabaseName=koru1;" />
        <property name="username" value="admin" />
        <property name="password" value="pass" />
    </bean>


	<bean id="hibernateJpaVendorAdapter" class="org.springframework.orm.jpa.vendor.HibernateJpaVendorAdapter">
		<property name="databasePlatform" value="${hibernate.dialect}" />
		<property name="generateDdl" value="false" />
		<property name="showSql" value="${hibernate.show_sql}" />
	</bean>


    <!-- Entity Manager Factory -->
    <bean id="entityManagerFactory" class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean">
        <property name="dataSource" ref="dataSource"   />
        <property name="jpaVendorAdapter" ref="hibernateJpaVendorAdapter" />
        <property name="packagesToScan" >
            <list>
                <value>com.chubb.koru.models</value>
                <value>com.chubb.koru.dao</value>
            </list>
        </property>
        <property name="jpaProperties">
            <props>
                <prop key="hibernate.id.new_generator_mappings">${hibernate.id.generator_mappings}</prop>
            </props>
        </property>
    </bean>
    <!-- Inject enity manager bean into transaction manager -->
    <bean id="transactionManager" class="org.springframework.orm.jpa.JpaTransactionManager">
        <property name="entityManagerFactory" ref="entityManagerFactory" />
    </bean>

    <!-- Enable Transaction Manager -->
    <tx:annotation-driven transaction-manager="transactionManager" />