<bean class="org.apache.tomcat.jdbc.pool.DataSource" id="dataSource" >
        <property name="driverClassName" value="${database.driverClassName}"/>
        <property name="url" value="${database.url}"/>
        <property name="username" value="${database.username}"/>
        <property name="password" value="${database.password}"/>

<bean class="org.apache.tomcat.jdbc.pool.DataSource" id="dataSourceOrderDetail" >
        <property name="driverClassName" value="${database.driverClassName}"/>
        <property name="url" value="${database.url.orderdetail}"/>
        <property name="username" value="${database.username}"/>
        <property name="password" value="${database.password}"/>
  </bean>

<jpa:repositories base-package="com.staples.sa.pricemart.repository.pag"
    entity-manager-factory-ref="entityManagerFactory" />

<bean class="org.springframework.orm.jpa.JpaTransactionManager" id="transactionManager">
    <property name="entityManagerFactory" ref="entityManagerFactory" />
    <qualifier value="pagTransactionManager" />
</bean>

<bean class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"
    id="entityManagerFactory">
    <property name="persistenceUnitName" value="persistenceUnit" />
    <property name="dataSource" ref="dataSource" />
    <property name="jpaDialect">
        <bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" />
    </property>
</bean>

<jpa:repositories base-package="com.staples.sa.pricemart.repository.orderdetail"
    entity-manager-factory-ref="entityManagerFactoryOrderDetail" />


<bean id="transactionManagerOrderDetail" class="org.springframework.orm.jpa.JpaTransactionManager">
    <property name="entityManagerFactory" ref="entityManagerFactoryOrderDetail" />
    <qualifier value="orderDetailTX" />
</bean>


<bean
    class="org.springframework.orm.jpa.LocalContainerEntityManagerFactoryBean"
    id="entityManagerFactoryOrderDetail">
    <property name="persistenceUnitName" value="persistenceUnitOrderDetail" />
    <property name="dataSource" ref="dataSourceOrderDetail" />
    <property name="jpaDialect">
        <bean class="org.springframework.orm.jpa.vendor.HibernateJpaDialect" />
    </property>
</bean>

<!-- -->

<persistence-unit name="persistenceUnit"
        transaction-type="RESOURCE_LOCAL">

<!-- Add the persistence context for OrderDetail -->
<persistence-unit name="persistenceUnitOrderDetail"
    transaction-type="RESOURCE_LOCAL">

class Main {
  public static void main(String args[]) throws Exception {
    ApplicationContext ac = new ClassPathXmlApplicationContext("context.xml", Main.class);
    DataSource dataSource = (DataSource) ac.getBean("dataSource");
    DataSource mysqlDataSource = (DataSource) ac.getBean("mysqlDataSource");

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="oracle.jdbc.driver.OracleDriver"/>
    <property name="url" value="jdbc:oracle:thin:@oracle.devcake.co.uk:1521:INTL"/>
    <property name="username" value="sa"/>
    <property name="password" value=""/>
</bean>

<bean id="mysqlDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
    <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
    <property name="url" value="jdbc:mysql://dbhost-prospring-psql/prospring"/>
    <property name="username" value="sa"/>
    <property name="password" value=""/>
</bean>

<bean id="lobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler">
    <property name="nativeJdbcExtractor" ref="nativeJdbcExtractor"/>
</bean>

<bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.CommonsDbcpNativeJdbcExtractor"/>

<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
    <property name="dataSource" ref="dataSource"/>
</bean>