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                                  Float type int, Integer                            INTEGER                              Integer type long, Long                            BIGINT                                  Long type short, Short                           INTEGER                              Short type Date                                      TIMESTAMP                        Date type String          

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 .