Running Custom SQL
In Liferay by default , ServiceBuilder generated LocalServiceBaseImpl class contains a method call runSQL. We can use that method to execute our CustomSQL Query of that Entity. If we want to execute the customSQL of Blogs Entity we can use that method by call in the localserviceImpl. Example: 1. I have a table call " Employee " and i want to execute the Employee table related custom SQL 2. So i have written a custom method in EmployeeLocalServiceImpl as below and calling runSQL method public void executeCustomQuery(String cusQuery) throws SystemException{ super.runSQL(query); } 3. Build the service and call the sql query as EmployeeLocalServiceUtil.executeCustomQuery(' update table Employee set EmpName = 'Liferay' where EmpId = 2 '); So here it is , We can Execute the SQL queries