How to delete an user in liferay 6.1.20 GA2 programmatically

private static void deleteUser(long userId) {
try {
UserLocalServiceUtil.deleteUser(userId);
} catch (PortalException e1) {
e1.printStackTrace();
} catch (SystemException e1) {
e1.printStackTrace();
}
}

Update an User with Phone,Address and Contact details in Liferay 6.1.0 GA2 Programmatically

Update an User with Phone,Address and Contact

User updateUser = UserLocalServiceUtil.getUser(Long
.parseLong(userId));
Long companyId = updateUser.getCompanyId();
List<Address> updateAddress = (List<Address>) AddressLocalServiceUtil
.getAddresses(updateUser.getCompanyId(),
Contact.class.getName(),
updateUser.getContactId());

UserAdditionalInfo userAdditionalInfo = UserAdditionalInfoLocalServiceUtil
.getUserAdditionalInfo(Long.parseLong(userId));

List<Phone> phoneList = PhoneLocalServiceUtil.getPhones(
companyId, Contact.class.getName(),
updateUser.getContactId());

List<ListType> phoneTypes = ListTypeServiceUtil
.getListTypes(Contact.class.getName()
+ ListTypeConstants.PHONE);
int officePhoneTypeId = 0;
int mobilePhoneTypeId = 0;
int homePhoneTypeId = 0;
int faxTypeId = 0;
for (ListType phoneType : phoneTypes) {
String phoneTypeName = phoneType.getName();
if (UserConstants.OFFICE_PHONE_TYPE.equals(phoneTypeName)) {
officePhoneTypeId = phoneType.getListTypeId();
}
if (UserConstants.MOBILE_PHONE_TYPE.equals(phoneTypeName)) {
mobilePhoneTypeId = phoneType.getListTypeId();
}
if (UserConstants.HOME_PHONE_TYPE.equals(phoneTypeName)) {
homePhoneTypeId = phoneType.getListTypeId();
}
if (UserConstants.PERSONAL_FAX_TYPE.equals(phoneTypeName)) {
faxTypeId = phoneType.getListTypeId();
}
}
String officeNumber = StringPool.BLANK;
String mobileNumber = StringPool.BLANK;
String homeNumber = StringPool.BLANK;
String faxNumber = StringPool.BLANK;
for (Phone phone : phoneList) {
if ((updateUser.getUserId() == phone.getUserId())
&& (officePhoneTypeId == phone.getTypeId())) {

officeNumber = phone.getNumber();
}
if ((updateUser.getUserId() == phone.getUserId())
&& (mobilePhoneTypeId == phone.getTypeId())) {
mobileNumber = phone.getNumber();
}
if ((updateUser.getUserId() == phone.getUserId())
&& (homePhoneTypeId == phone.getTypeId())) {
homeNumber = phone.getNumber();
}
if ((updateUser.getUserId() == phone.getUserId())
&& (faxTypeId == phone.getTypeId())) {
faxNumber = phone.getNumber();
}
}

if (!updateAddress.isEmpty() && updateAddress.size() != 0) {
Contact updateContact = ContactLocalServiceUtil
.getContact(updateUser.getContactId());
UserRegistrationDTO userRegistration = requestedUserData(
companyId, userAdditionalInfo.getRoleId(),
updateUser.getEmailAddress(),
updateUser.getFirstName(),
updateUser.getMiddleName(),
updateUser.getLastName(), updateAddress.get(0)
.getStreet1(), updateAddress.get(0)
.getStreet2(), updateAddress.get(0)
.getStreet3(), updateAddress.get(0)
.getCity(), userAdditionalInfo.getState(),
updateAddress.get(0).getZip(), updateAddress.get(0)
.getCountryId(), officeNumber,
mobileNumber, homeNumber, faxNumber,
userAdditionalInfo.getLinkedIn(),
updateContact.getFacebookSn(),
updateContact.getTwitterSn(),
userAdditionalInfo.getAnnualIncome(),
userAdditionalInfo.getCurrencyCode(),
userAdditionalInfo.getDomainExpertise(),
userAdditionalInfo.getExperience(),
userAdditionalInfo.getQualification(),
userAdditionalInfo.isSubscribeNewsAlerts());
actionRequest.setAttribute(UserConstants.USER_REGISTRATION,
userRegistration);
}

Add or Update address in liferay 6.1.20 GA2 Programmatically

Add an Address:

public static boolean addAddress(long userId, long contactId,
String street1, String street2, String street3, String city,
String zip, long countryId, String className) {
boolean isAddressAdded = false;

List<ListType> addressTypes = Collections.EMPTY_LIST;
try {
addressTypes = ListTypeServiceUtil.getListTypes(Contact.class
.getName() + ListTypeConstants.ADDRESS);

int personalAddressTypeId = 0;
// find personal phone type
for (ListType addressType : addressTypes) {
String addressTypeName = addressType.getName();
System.out.println(":::::addressTypeName:::" + addressTypeName);
if (UserConstants.PERSONAL_ADDRESS_TYPE.equals(addressTypeName)) {
personalAddressTypeId = addressType.getListTypeId();
}
}
System.out.println("::::street1:::" + street1);
if (Validator.isNotNull(street1)) {
System.out.println(":::" + street1 + ";;;" + street2 + ":::"
+ street3 + ":::" + city + ":::" + zip + ":::"
+ countryId + ":::" + personalAddressTypeId);
AddressLocalServiceUtil.addAddress(userId, className,
contactId, street1, street2, street3, city, zip, 0,
countryId, personalAddressTypeId, false, true);

System.out.println("::DATA Inserted in address::::");
isAddressAdded = true;
} else {
deleteUser(userId);
}
} catch (PortalException e) {
e.printStackTrace();
deleteUser(userId);
} catch (SystemException e) {
e.printStackTrace();
deleteUser(userId);
}
return isAddressAdded;
}

public static User updateUserDetails(long updateUserId, String oldPassword,
String newPassword1, String newPassword2, String screenName,
String emailAddress, String firstName, String middleName,
String lastName, String facebookSn, String twitterSn,
long[] groupIds, long[] organizationIds, long[] roleIds,
List<UserGroupRole> userGroupRoles, long[] userGroupIds,
boolean isUserAdd, ServiceContext serviceContext) {
User user = null;
try {
System.out.println("::emailAddress::::::::-----------"
+ emailAddress);
user = UserLocalServiceUtil.updateUser(updateUserId, oldPassword,
newPassword1, newPassword2, false, StringPool.BLANK,
StringPool.BLANK, screenName, emailAddress, 0,
StringPool.BLANK, StringPool.BLANK, StringPool.BLANK,
StringPool.BLANK, StringPool.BLANK, firstName, middleName,
lastName, 0, 0, true, Calendar.JANUARY, 1, 1979,
StringPool.BLANK, StringPool.BLANK, facebookSn,
StringPool.BLANK, StringPool.BLANK, StringPool.BLANK,
StringPool.BLANK, StringPool.BLANK, twitterSn,
StringPool.BLANK, StringPool.BLANK, groupIds,
organizationIds, roleIds, userGroupRoles, userGroupIds,
serviceContext);
} catch (PortalException e) {
e.printStackTrace();
if (isUserAdd) {

deleteUser(updateUserId);
}
} catch (SystemException e) {
e.printStackTrace();
if (isUserAdd) {

deleteUser(updateUserId);
}
}
return user;
}


Update an address:

public static boolean updateAddress(long companyId, long contactId,
String street1, String street2, String street3, String city,
String zip, long countryId, String className) {
boolean isAddressUpdated = false;
List<Address> addressList = Collections.EMPTY_LIST;
try {
System.out.println("::updating address::::");
addressList = AddressLocalServiceUtil.getAddresses(companyId,
className, contactId);
for (Address address : addressList) {
address.setStreet1(street1);
address.setStreet2(street2);
address.setStreet3(street3);
address.setCity(city);
address.setZip(zip);
address.setCountryId(countryId);
AddressLocalServiceUtil.updateAddress(address);
System.out.println("addresss updated succefully!!");
}
isAddressUpdated = true;
} catch (SystemException e) {
e.printStackTrace();
}
return isAddressUpdated;


}

Add or Update Phone in liferay 6.1.20 GA2 Programmatically

Add phone in liferay:

If you want to add an address/phone for user the class name is,
className = Contact.class.getName();


If you want to add an address/phone for organization the class name is,
className = Organization.class.getName();


public static boolean addPhone(long userId, long contactId,
String officeNumber, String mobileNumber, String homeNumber,
String faxNumber, String className) {
System.out.println("::::inside addPhone:::::");
boolean isPhoneAdded = false;

try {
List<ListType> phoneTypes = ListTypeServiceUtil
.getListTypes(Contact.class.getName()
+ ListTypeConstants.PHONE);
int officePhoneTypeId = 0;
int mobilePhoneTypeId = 0;
int homePhoneTypeId = 0;
int faxTypeId = 0;
for (ListType phoneType : phoneTypes) {
System.out.println("::phoneType:::" + phoneType.getName());
String phoneTypeName = phoneType.getName();
// personal is home
if (UserConstants.HOME_PHONE_TYPE.equals(phoneTypeName)) {
homePhoneTypeId = phoneType.getListTypeId();
}
if (UserConstants.OFFICE_PHONE_TYPE.equals(phoneTypeName)) {
officePhoneTypeId = phoneType.getListTypeId();
}
if (UserConstants.MOBILE_PHONE_TYPE.equals(phoneTypeName)) {
mobilePhoneTypeId = phoneType.getListTypeId();
}
if (UserConstants.PERSONAL_FAX_TYPE.equals(phoneTypeName)) {
faxTypeId = phoneType.getListTypeId();
}
}
if (Validator.isNotNull(officeNumber)) {
PhoneLocalServiceUtil.addPhone(userId, className, contactId,
officeNumber, "", officePhoneTypeId, true);
}
if (Validator.isNotNull(mobileNumber)) {
PhoneLocalServiceUtil.addPhone(userId, className, contactId,
mobileNumber, "", mobilePhoneTypeId, true);
}
if (Validator.isNotNull(homeNumber)) {
PhoneLocalServiceUtil.addPhone(userId, className, contactId,
homeNumber, "", homePhoneTypeId, true);
}
if (Validator.isNotNull(faxNumber)) {
PhoneLocalServiceUtil.addPhone(userId, className, contactId,
faxNumber, "", faxTypeId, false);
}

System.out.println("::DATA Inserted in Phone::::");
isPhoneAdded = true;
} catch (PortalException e) {
e.printStackTrace();
deleteUser(userId);
} catch (SystemException e) {
e.printStackTrace();
deleteUser(userId);
}
return isPhoneAdded;
}

Update phone details:

public static boolean updatePhone(long companyId, long contactId,
String officeNumber, String mobileNumber, String homeNumber,
String faxNumber, String className) {
boolean isPhoneUpdated = false;
List<Phone> phoneList = Collections.EMPTY_LIST;
try {

phoneList = PhoneLocalServiceUtil.getPhones(companyId, className,
contactId);
for (Phone phone : phoneList) {
if (phone.getType().getName()
.equals(UserConstants.MOBILE_PHONE_TYPE)) {
System.out.println("::updating phone Number "
+ phone.getType().getName());
phone.setNumber(mobileNumber);
}
if (phone.getType().getName()
.equals(UserConstants.OFFICE_PHONE_TYPE)) {
System.out.println("::updating phone Number "
+ phone.getType().getName());
phone.setNumber(officeNumber);
}
if (phone.getType().getName()
.equals(UserConstants.HOME_PHONE_TYPE)) {
System.out.println("::updating phone Number "
+ phone.getType().getName());
phone.setNumber(homeNumber);
}
if (phone.getType().getName()
.equals(UserConstants.PERSONAL_FAX_TYPE)) {
System.out.println("::updating fax Number "
+ phone.getType().getName());
phone.setNumber(faxNumber);
}
PhoneLocalServiceUtil.updatePhone(phone);

}
System.out.println("::phone & fax number updated succefully!!!");
isPhoneUpdated = true;
} catch (SystemException e) {
e.printStackTrace();
} catch (PortalException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return isPhoneUpdated;

}

Add or Update an user in liferay 6.1.20

Add and Update an  User programmatically in liferay 6.1.20

If you want to add user in liferay. You just follow the below steps

•  provide all mandatory fields like first name, screen name, email address

          long[] userGroupIds = {};
long[] roleIds = { ParamUtil.getLong(actionRequest, "roleId") };
long[] organizationIds = new long[] { ParamUtil.getLong(actionRequest,
"organizationId") };
long[] groupIds = {};
       
          ServiceContext serviceContext = ServiceContextFactory.getInstance(
User.class.getName(), actionRequest);

 public static User addUserDetails(long companyId, long roleId,
String password1, String password2, String screenName,
String emailAddress, String firstName, String middleName,
String lastName, long[] groupIds, long[] organizationIds,
long[] roleIds, long[] userGroupIds, String street1,
String street2, String street3, String city, String state,
String zip, long countryId, String officeNumber,
String mobileNumber, String homeNumber, String faxNumber,
String linkedInId, String facebookSn, String twitterSn,
long annualIncome, String currencyCode, String domainExpertise,
String experience, String qualification, boolean isSubScribe,
String aboutIway, String className, ServiceContext serviceContext)
throws PortalException, SystemException {

User user = null;
boolean flag = false;

user = UserLocalServiceUtil.addUser(0, companyId, false, password1,
password2, false, screenName, emailAddress, 0,
StringPool.BLANK, LocaleUtil.getDefault(), firstName,
middleName, lastName, 0, 0, true, Calendar.JANUARY, 1, 1979,
StringPool.BLANK, groupIds, organizationIds, roleIds,
userGroupIds, false, serviceContext);
if (Validator.isNotNull(user)) {
user = updateUserDetails(user.getUserId(), user.getPassword(),
StringPool.BLANK, StringPool.BLANK, screenName,
emailAddress, firstName, middleName, lastName, facebookSn,
twitterSn, groupIds, organizationIds, roleIds,
Collections.EMPTY_LIST, userGroupIds, true, serviceContext);
}
if (Validator.isNotNull(user)) {
flag = addPhone(user.getUserId(), user.getContactId(),
officeNumber, mobileNumber, homeNumber, faxNumber,
className);
}
if (flag) {
flag = addAddress(user.getUserId(), user.getContactId(), street1,
street2, street3, city, zip, countryId, className);
}

}

• Once add the user and if you want to add user info in contact table then you need to follow the below snippet.

   public static User updateUserDetails(long updateUserId, String oldPassword,
String newPassword1, String newPassword2, String screenName,
String emailAddress, String firstName, String middleName,
String lastName, String facebookSn, String twitterSn,
long[] groupIds, long[] organizationIds, long[] roleIds,
List<UserGroupRole> userGroupRoles, long[] userGroupIds,
boolean isUserAdd, ServiceContext serviceContext) {
User user = null;
try {

user = UserLocalServiceUtil.updateUser(updateUserId, oldPassword,
newPassword1, newPassword2, false, StringPool.BLANK,
StringPool.BLANK, screenName, emailAddress, 0,
StringPool.BLANK, StringPool.BLANK, StringPool.BLANK,
StringPool.BLANK, StringPool.BLANK, firstName, middleName,
lastName, 0, 0, true, Calendar.JANUARY, 1, 1979,
StringPool.BLANK, StringPool.BLANK, facebookSn,
StringPool.BLANK, StringPool.BLANK, StringPool.BLANK,
StringPool.BLANK, StringPool.BLANK, twitterSn,
StringPool.BLANK, StringPool.BLANK, groupIds,
organizationIds, roleIds, userGroupRoles, userGroupIds,
serviceContext);
} catch (PortalException e) {
e.printStackTrace();
if (isUserAdd) {

deleteUser(updateUserId);
}
} catch (SystemException e) {
e.printStackTrace();
if (isUserAdd) {

deleteUser(updateUserId);
}
}
return user;
}

Dynamic Query in Liferay 6.1

Dynamic Query :

Portlet that retrieves a lot of data from liferay data table, and eventually combines them by filtering out Users, Roles or Groups by certain criterias you will certainly come to a point, where the Standard "LocalServideUtil" - Methods are just too slow.
The best way to get around all that Java Reflection based Stuff is to create dynamic queries.

Liferay offers several factory classes helping with the creation of Dynamic queries right in your portlet.

They are in the package com.liferay.portal.kernel.dao.orm:

1. DynamicQueryFactoryUtil
2. OrderFactoryUtil
3. ProjectionFactoryUtil
4. PropertyFactoryUtil and
5. RestrictionsFactoryUtil

Inspecting those 5 should be enough for most of your needs.

So ...lets get started with an example.



DynamicQuery query = DynamicQueryFactoryUtil.forClass(Model.class, PortletClassLoaderUtil.getClassLoader("test_WAR_testportlet"));


// test_WAR_testportlet is portlet id in Portlet table


query.add(RestrictionsFactoryUtil.eq("primaryKey.empID",101);
query.add(RestrictionsFactoryUtil.eq("eventId",10101);

List<EmpModel> resultList = EmpLocalSerciceUtil.dynamicQuery(query);

Emp empModel  = (Emp) resultList.get(0);

empModel.setEventStatus("CLOSE");

EmpLocalServiceUtil.updateEmp(empModel);


Creating a DynamicQuery always starts with determining the Entity you want to retrieve.
For example : If you want to retrieve all Users, the class you should retrieve is com.liferay.portal.model.User

create a DynamicQuery object :

DynamicQuery UserQuery = DynamicQueryFactoryUtil.forClass(
User.class, PortletClassloaderUtil.getClassLoader());

This creates a dynamic query that goes straight for the User class.
The Portletclassloader makes sure, that the implementation class can be loaded (UserImpl.java).

So - as in SQL you have the possibility to order your result, to create a projection f.e. only returning the id of the user and you can add restrictions, for example to a property.

at first - lets try out to only retrieve users, that have the first name "Alfred".

to do so, we use the PropertyFactoryUtil :

Criterion alfredsName = PropertyFactoryUtil.forName("firstName").eq("Alfred");

PropertyFactoryUtil doesn´t offer much more than this forName factory method. But this method returns a Property instance that allows us to create Criterion objects and to assign them to the DynamicQuery.

The Property Factory allows to test for equality, if certain properties are greater or lower and to test if values are in a list provided.

There are about 30 - 40 different methods that should cover most of your needs.

We will cover only eq, in and like here. The rest will follow in a later post.

eq : EQ tests for equality - very fast ! Note that "Alfred" is notthe same as "alfred" - depending on the System the database runs on.

in : Very powerful, because it allows to take another DynamicQuery allowing the database to optimize the Query and to returns results very fast.

like : Typical SQL "like" ... is case sensitive on case sensitive systems.

But what do we do if we need to test for a name, without looking for the case ... what about "aLfreD" ?

In this case, we need to use RestrictionsFactoryUtil. It has a method called "ilike" :

ilke: Case insensitive SQL "like" and also the only possibility to retrieve all "alFreD"s in the Database - no matter how they are written. ilike also allows us to specify the "%" character we need if we want to retrieve "Walfred".

So much about the PropertyFactoryUtil. Here is the code to retrieve all Alfred - Users with the last name "Einstein":

DynamicQuery userQuery = DynamicQueryFactoryUtil.forClass(
User.class, PortletClassloaderUtil.getClassLoader());


userQuery.add(PropertyFactoryUtil.forName("lastName").eq("Einstein");
userQuery.add(RestrictionsFactoryUtil.ilike("firstName","%Alfred%"));

When working with dynamic queries it is sometimes necessary not to retrieve the complete Entities but only to retrieve certain properties - like the user id.

This is the point where the ProjectionFactoryUtil comes into place.

Projections allow (for example) to use distincts, counts, sums or to just return a single property.

This is what we will do next.

To create a Projection, just use the ProjectionFactoryUtil like this:

Projection projection = ProjectionFactoryUtil.property("userId");

That´s all to limit the result to the userId.

You can then set the projection to the dynamic query like this only returning distinct userIds like this:

userQuery.setProjection(ProjectionFactoryUtil
.distinct(ProjectionFactoryUtil.property("userId")));

Note: Of course there can be only one Projection for a query. But Projections can be nested as shown in the previous example.

Restrictions:

Restrictions basically allow to do the same as Property. There are methods to test for equality, to test whether properties are in a certain range, to test several properties at once ("and") or to test a property against a map.
For example, it allows to test whether first and last name equal for certain persons:

Criterion equalNames = RestrictionsFactoryUtil.eqProperty("firstName","lastName");

Order

The OrderFactoryUtil allows to order the results of a query by a property - ascending and descending.

Custom Query in Liferay 6.1

The following will explain how to work with custom-sql in liferay 6.1

1. Create a portlet
2. In a service.xml (Under docroot/WEB-INF) add the following lines

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE service-builder PUBLIC "-//Liferay//DTD Service Builder 6.0.0//EN" "http://www.liferay.com/dtd/liferay-service-builder_6_0_0.dtd">
<service-builder package-path="com.cignex.books">
    <author>koteswara.rao</author>
    <namespace>library</namespace>


    <entity name="Books" local-service="true" remote-service="false">
        <column name="bookId" type="long" primary="true"></column>
        <column name="title" type="String"></column>
        <column name="author" type="String"></column>
               
        <order by="asc">
            <order-column name="bookId"></order-column>
        </order>
       
        <finder return-type="Collection" name="Author">
            <finder-column name="author"></finder-column>
        </finder>
    </entity>
</service-builder>

3. Build the service (you can use ant build-service or directly from IDE)
4. Create custom-sql folder under src folder
5. Create default.xml file under custom-sql and add the following lines of code

<?xml version="1.0" encoding="UTF-8"?>
<custom-sql>
<sql file="custom-sql/book.xml" />
</custom-sql>



6. Create book.xml file under the same custom-sql folder mentioned in step 4 and add the following lines of code

<?xml version="1.0" encoding="UTF-8"?>
<custom-sql>
<sql id="findBooks">
<![CDATA[
SELECT * FROM library_books
WHERE (library_books.title like ?)
]]>
</sql>
</custom-sql>


7. Create the file BooksFinderImpl.java under persistence (persistence will get after the first time build service) and add the following lines of code

public class BooksFinderImpl extends BasePersistenceImpl implements BooksFinder {
    }

8. Now run ant build-service to generate necessary files

9. Add the following lines of code in BooksFinderImpl class

 public List findBooks(String name) throws SystemException {
       
         Session session = null;
         try {
         session = openSession();
         String sql = CustomSQLUtil.get(FIND_BOOKS);
         SQLQuery query = session.createSQLQuery(sql);
         query.addEntity("Book", BooksImpl.class);
         QueryPos qPos = QueryPos.getInstance(query);
         qPos.add(name);
         return (List)query.list();
         }catch (Exception e) {
         }
         return null;
         }
         public static String FIND_BOOKS = "findBooks";

10. Add the following lines of code under BooksLocalServiceImpl 

public class BooksLocalServiceImpl extends BooksLocalServiceBaseImpl {
    /*
     * NOTE FOR DEVELOPERS:
     *
     * Never reference this interface directly. Always use {@link com.cignex.books.service.BooksLocalServiceUtil} to access the books local service.
     */
     public List<Books> findBook(String name) throws PortalException,
     SystemException, RemoteException {
     return BooksFinderUtil.findBooks("%" + name + "%");
     }
}

11. Again run "ant build-service" again passing the service.xml file as parameter.
     This will update the corresponding interface with the new method defined.

12. Now go ahead and call BookLocalServiceImpl method from your jsp or java
      normally how    you      call other methods. For testing purpose add the following
     lines of code   in    Portlet under doView() method

public void doView(RenderRequest renderRequest,
            RenderResponse renderResponse) throws IOException, PortletException {
         try {
            List<Books> books = BooksLocalServiceUtil.findBook("es");
            System.out.println("::::::::::"+books.size());
            for(Books bookName : books){
                String book = bookName.getTitle();
                System.out.println("####"+book);

            }
        } catch (PortalException e) {
            e.printStackTrace();
        } catch (SystemException e) {
            e.printStackTrace();
        }

        super.doView(renderRequest, renderResponse);
       
    }

That's it enjoy!!!

JUnit Test-Cases to test Liferay Portlet Service Layer

Configuration Steps:

1. Create a folder named 'test' withing the project and add it as a source folder to have the test classes and maintain it separate rather than mixing with the portlet source codes.
2. Create a 'PortletHibernateTestConfiguration' with the below lines of code.

public class PortletHibernateTestConfiguration extends PortalHibernateConfiguration {

protected ClassLoader getConfigurationClassLoader() {

return this.getClass().getClassLoader();

}

protected String[] getConfigurationResources() {

return PropsUtil.getArray(PropsKeys.HIBERNATE_CONFIGS);

}

}

3. Create a 'portal-ext.properties' file directly under the 'test' folder using the below configurations as reference.

jdbc.default.driverClassName=com.mysql.jdbc.Driver

jdbc.default.url=jdbc:mysql://localhost/liferay6ce?characterEncoding=UTF-8

jdbc.default.username=root

jdbc.default.password=root

hibernate.cache.use_query_cache=false

hibernate.cache.use_second_level_cache=false

hibernate.cache.use_minimal_puts=false

hibernate.cache.use_structured_entries=false

ehcache.portal.cache.manager.jmx.enabled=false

liferay.home=D:/liferay-portal-6.1.0-ce-ga1

resource.repositories.root=D:/liferay-portal-6.1.0-ce-ga1/tomcat-7.0.23/webapps/ROOT

# Disable the scheduler for Unit testing

scheduler.enabled=false

hibernate.configs=\

META-INF/portal-hbm.xml,\

META-INF/portlet-hbm.xml,\

META-INF/portlet-orm.xml

4. Create a 'META-INF' folder under the 'test' folder and create a 'hibernate-spring.xml' within it using the below code (Note: The PortalHibernateConfiguration class is replaced with our own implementation).

<?xml version="1.0" encoding="UTF-8"?>

<beans

default-destroy-method="destroy"

default-init-method="afterPropertiesSet"

xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd"

>

<bean id="liferayHibernateSessionFactory" class="com.test.PortletHibernateTestConfiguration">

<property name="dataSource" ref="liferayDataSource" />

</bean>

<bean id="liferaySessionFactory" class="com.liferay.portal.dao.orm.hibernate.SessionFactoryImpl">

<property name="sessionFactoryClassLoader">

<bean class="com.liferay.portal.kernel.util.PortalClassLoaderUtil" factory-method="getClassLoader" />

</property>

<property name="sessionFactoryImplementor" ref="liferayHibernateSessionFactory" />

</bean>

<bean id="liferayTransactionManager" class="com.liferay.portal.spring.transaction.TransactionManagerFactory" factory-method="createTransactionManager">

<constructor-arg ref="liferayDataSource" />

<constructor-arg ref="liferayHibernateSessionFactory" />

</bean>

<bean id="hibernateStatisticsService" class="com.liferay.portal.dao.orm.hibernate.jmx.HibernateStatisticsService">

<property name="sessionFactory" ref="liferaySessionFactory" />

</bean>

<bean id="com.liferay.portal.kernel.dao.orm.DynamicQueryFactoryUtil" class="com.liferay.portal.kernel.dao.orm.DynamicQueryFactoryUtil">

<property name="dynamicQueryFactory">

<bean class="com.liferay.portal.dao.orm.hibernate.DynamicQueryFactoryImpl" />

</property>

</bean>

<bean id="com.liferay.portal.kernel.dao.orm.OrderFactoryUtil" class="com.liferay.portal.kernel.dao.orm.OrderFactoryUtil">

<property name="orderFactory">

<bean class="com.liferay.portal.dao.orm.hibernate.OrderFactoryImpl" />

</property>

</bean>

<bean id="com.liferay.portal.kernel.dao.orm.ProjectionFactoryUtil" class="com.liferay.portal.kernel.dao.orm.ProjectionFactoryUtil">

<property name="projectionFactory">

<bean class="com.liferay.portal.dao.orm.hibernate.ProjectionFactoryImpl" />

</property>

</bean>

<bean id="com.liferay.portal.kernel.dao.orm.PropertyFactoryUtil" class="com.liferay.portal.kernel.dao.orm.PropertyFactoryUtil">

<property name="propertyFactory">

<bean class="com.liferay.portal.dao.orm.hibernate.PropertyFactoryImpl" />

</property>

</bean>

<bean id="com.liferay.portal.kernel.dao.orm.RestrictionsFactoryUtil" class="com.liferay.portal.kernel.dao.orm.RestrictionsFactoryUtil">

<property name="restrictionsFactory">

<bean class="com.liferay.portal.dao.orm.hibernate.RestrictionsFactoryImpl" />

</property>

</bean>

</beans>

5. Similarly add a 'counter-spring.xml' to the 'META-INF' folder with the below codes.

<?xml version="1.0" encoding="UTF-8"?>

<beans

default-destroy-method="destroy"

default-init-method="afterPropertiesSet"

xmlns="http://www.springframework.org/schema/beans"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd"

>

<bean id="counterDataSource" class="org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy">

<property name="targetDataSource">

<bean class="com.liferay.portal.dao.jdbc.util.DataSourceFactoryBean">

<property name="propertyPrefixLookup" value="counter.jdbc.prefix" />

</bean>

</property>

</bean>

<bean id="com.liferay.counter.service.CounterLocalService" class="com.liferay.counter.service.impl.CounterLocalServiceImpl" />

<bean id="com.liferay.counter.service.persistence.CounterPersistence" class="com.liferay.counter.service.persistence.CounterPersistenceImpl" parent="basePersistence">

<property name="dataSource" ref="counterDataSource" />

</bean>

<bean id="com.liferay.counter.service.persistence.CounterFinder" class="com.liferay.counter.service.persistence.CounterFinderImpl" parent="basePersistence">

<property name="dataSource" ref="counterDataSource" />

</bean>

</beans>

6. Copy the files portlet-hbm.xml, portlet-orm.xml & portlet-spring.xml from 'docroot/WEB-INF/src/META-INF' folder to your 'test/META-INF' folder.
7. Rename the copied 'portlet-spring.xml' to 'ext-spring.xml'.
8. Now create a Test Class extending the JUnit TestCase class and within the setUp() method, add the below code snippets to initialize the Spring-Hibernate context and get the Service classes initialized and linked to the back-end DB.

super.setUp();

InitUtil.initWithSpring();

PortletBeanLocatorUtil.setBeanLocator(ClpSerializer.getServletContextName(), PortalBeanLocatorUtil.getBeanLocator());

9. It can be then continued with code to obtain the service as shown below.

userService = UserLocalServiceUtil.getService();

employeeService = EmployeeLocalServiceUtil.getService();

10. Start writing your test cases and proceed with the usual way in executing them. If any memory error occurs, add the below VM arguments to the JUnit run configuration.

-Xms256m -Xmx512m -XX:PermSize=128M -XX:MaxPermSize=256m

Steps to run JUnit test through Liferay Ant Script:

Follow the below steps to run the JUnit test through the ANT script.

1. Replace the below code of 'build-common.xml' from Liferay plugin-sdk

<path id="test.classpath">

<path refid="plugin.classpath" />

<fileset dir="${app.server.lib.portal.dir}" includes="commons-io.jar" />

<fileset dir="${project.dir}/lib" includes="junit.jar" />

<pathelement location="test-classes" />

</path>

with

<path id="test.classpath">

<path refid="plugin.classpath" />

<fileset dir="${app.server.lib.portal.dir}" includes="*.jar" />

<fileset dir="${project.dir}/lib" includes="junit.jar" />

<pathelement location="test-classes" />

</path>

2. Similarly add additional jvm memory arguments to the 'junit' tag of the 'test' target of the 'build-common-plugin.xml' which is highlighted in bold. This is to avoid the Out of Memory error while running the test cases.

<junit dir="${project.dir}" fork="on" forkmode="once" printsummary="on">

<jvmarg line="${junit.debug.jpda}" />

<jvmarg value="-Xms256m" />

<jvmarg value="-Xmx512m" />

<jvmarg value="-XX:PermSize=128m" />

<jvmarg value="-XX:MaxPermSize=256m" />

<jvmarg value="-Duser.timezone=GMT" />

<jvmarg value="-Dexternal-properties=${test.properties}" />

<classpath refid="test.classpath" />

<formatter type="brief" usefile="false" />

<formatter type="xml" />

<batchtest todir="test-results">

<fileset dir="test-classes" includes="**/*Test.class" />

</batchtest>

</junit>