liferay service connects to external oracle database

1- configure service.xml

2- create ext-spring.xml
3-create the oracle  table and sequesnce
4- build the service


1-service.xml  note that we add




<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE service-builder PUBLIC "-//Liferay//DTD Service Builder 6.2.0//EN" "http://www.liferay.com/dtd/liferay-service-builder_6_2_0.dtd">
<service-builder package-path="com.dash.hr.forms">
<author>melsonbati</author>
<namespace>SAMPLE</namespace>

<entity name="Coupon"  table="HR_COUPON" local-service="true" remote-service="true"
data-source="tcsDS" session-factory="testSessionFactory" tx-manager="testTransactionManager">

<!-- PK fields -->

<column name="couponId" type="long" primary="true"  id-type="sequence" id-param="id_sequence_cp"  />

<!-- Group instance -->

<column name="groupId" type="long" />
.....
.
.
.
.
.


2-  ext-spring.xml

<?xml version="1.0"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
default-destroy-method="destroy"
default-init-method="afterPropertiesSet"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd">


<bean id="tcsDS" lazy-init="true"  class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="oracle.jdbc.OracleDriver" />
<property name="url" value="jdbc:oracle:thin:@oracle Ip:orcl"/>
<property name="username" value="username" />
<property name="password" value="password" />
</bean>


<bean id="liferayHibernateSessionFactory"   class="com.liferay.portal.spring.hibernate.PortletHibernateConfiguration">
<property name="dataSource" ref="tcsDS" />
</bean>

<bean id="testHibernateSessionFactory" class="com.liferay.portal.spring.hibernate.PortletHibernateConfiguration" lazy-init="true">
        <property name="dataSource" ref="tcsDS" />     
    </bean>
 

    <bean id="testSessionFactory" class="com.liferay.portal.dao.orm.hibernate.SessionFactoryImpl" lazy-init="true">     
        <property name="sessionFactoryImplementor" ref="testHibernateSessionFactory" />
    </bean>
 
    <bean id="testTransactionManager" class="org.springframework.orm.hibernate3.HibernateTransactionManager" lazy-init="true">
        <property name="dataSource" ref="tcsDS" />
        <property name="globalRollbackOnParticipationFailure" value="false"/>
        <property name="sessionFactory" ref="testHibernateSessionFactory" />
    </bean>
</beans>

3-  create in oracle db the table  HR_COUPON  and the seq   id_sequence_cp

build the service and enjoy