STEP 1:
Open the IDE. Goto File -> New -> Liferay Module Project

Click Next. Provide the package name and click finish

After that you can see two folders are created (*-api and *-service) inside your workspace.

And three folders in the IDE

Open siteService-service
and click on service.xml
. Click on the Entities and delete the default Foo column

And then add the Entity named Site
. It is just an Entity, that connects to the table.


Click on the Site
Entity and provide the table name

Add the columns as many as you want.

Select the column type from here:

Click on the Source Tab and you can see in the service.xml
details of all columns that added.

Double click on the buildService
to build the new service and double click on the deploy
to deploy the service.


Now click on the down arrow and gradle -> refresh project. You can see the bundles created.

And the .jar
bundles inside the osgi modules

Copy this *-api.jar
file into the deploy folder of the server.
~/liferay-ce-portal-tomcat-7.3.0-ga1-20200127150653953/liferay-ce-portal-7.3.0-ga1/deploy
and then copy the *-service.jar
into the same folder
You can see these are processing and started in the server logs.
INFO [com.liferay.portal.kernel.deploy.auto.AutoDeployScanner][AutoDeployDir:263] Processing sitesService.api.jar
~/liferay-ce-portal-tomcat-7.3.0-ga1-20200127150653953/liferay-ce-portal-7.3.0-ga1/osgi/modules][BundleStartStopLogger:39] STARTED sitesService.api_1.0.0 [1115]
[com.liferay.portal.kernel.deploy.auto.AutoDeployScanner][AutoDeployDir:263] Processing sitesService.service.jar
~/liferay-ce-portal-tomcat-7.3.0-ga1-20200127150653953/liferay-ce-portal-7.3.0-ga1/osgi/modules][BundleStartStopLogger:39] STARTED sitesService.service_1.0.0 [1116]
Now check the database, if the Site_
table with all columns are created or not

You can see the table and columns are created. In the next topic we discuss about adding services to this service builder.