Steps for Configuring seperate datasource:

   i) Add attached service.xml file in WEB-INF.

   ii) Add ext-spring.xml file in following path..
          WEB-INF---->src----->META-INF

  iii) Add the following another datasource details in properties file
where mysql details are present(portal-setup-wizard.properties)

     jdbc.test.driverClassName=com.mysql.jdbc.Driver
     jdbc.test.url=jdbc:mysql://localhost/hrm?useUnicode=true&characterEncoding=UTF-8&useFastDateParsing=false
     jdbc.test.username=root
     jdbc.test.password=mysql


  The value prefix for anotherDataSource in ext-spring.xml file
'jdbc.test' should be match with the above lines staring with
'jdbc.test'.

  iv) Create the database 'hrm' in mysql.

  v) Open the command prompt in services-portlet and build the code
using 'ant build-service'.All the code(sql scripts, service classes,
modal classes, util classes) will be generated after showing   'Build
Successfull'.

  vi) Now deploy the services-portlet build.xml file using Ant build.
 
  vii) Now after deploying the services-portlet in Ant,  the tables
'job_category' and 'jobtitles' are created in seperate database 'hrm'.

  viii) Now deploy the jobcategory portlet and run.


  ix) Still the tables are not creating after deploying the services
portlet using Ant, then change the build number in service.properties
present in src folder.The build number should be changed to newer than
old which is shown in console.

  x) Please make sure that ext-spring.xml file is configured in
service.properties file which is by default present.