Java Concepts

Service-Builder provides flexibility to map Java data types into SQL data types as follows: <column name="type" type="String" /> <column name="type" type="long" /> <column name="answerOrder" type="int" /> Java data type                     SQL data type                   Description boolean, Boolean                 BOOLEAN                            Boolean type Double, Double                    DOUBLE                               Double type float, Float                            FLOAT                      ...

Related to Site Roles we can use  UserGroupRoleLocalServiceUtil method. To add site role to the user we can use  UserGroupRoleLocalServiceUtil .addUserGroupRoles(long userId, long groupId, long[] roleIds) To get site role for the user we can use getUserGroupRoles( long userId, long groupId); Also there are several methods to Delete site roles and to check the site roles. All these implementation we can check in the  UserGroupRoleLocalServiceImpl .