i) Created Jobcategory portlet using alloy ui.
ii)Features include: inserting, editing, updating and deleting is done
with seperate database 'hrm' in job_category table.
iii) List is displaying from database using searchcontainer.
Following changes are done.

 i) Configured seperate datasource 'hrm' in service.xml file.
 ii) Deployed the services-portlet using 'ant build-service' command.
 iii) Deployed the services-portlet using 'Ant'.
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.
Interview portlet using service builder and alloy ui.

Features:
i)adding,editing,updating and deleting the records.
ii) Displaying the list from database.
iii) Sorting the records in the list (when we click on the perticular
column)based on column using 'OrderByComparatior' class.Written
'CustomComparator' class and 'InterviewComparator' class for sorting the
records.
iv) Wriiten the code comments for all the methods.
v) validations is done for the Required field in the form.
Nationality portlet using service builder and alloy ui.

Features:
i)adding,editing,updating and deleting the records.
ii) Displaying the list from database.
iii) Sorting the records in the list (when we click on the perticular
column)based on column using 'OrderByComparatior' class.Written
'CustomComparator' class and 'NationalityComparator' class for sorting
the records.
iv) Wriiten the code comments for all the methods.
v) validations is done for the Required field in the form.