Referrential integrity in Liferay 6.2 service builder

Question

I have been searching around for setting up referrential integrity for my database using Liferay IDE's service builder.

For e.g: I have a master table(entity) and a child table(entity). child table has a foreign key which is the primary key for the master table. If I delete one entry in the master table, the respective row in the child table should also get deleted. How can I achieve this in Liferay Service Builder.

AFAIK, there is no such provisions in liferay service builder, you manually have to write code for removing child table data — Pankaj Kathiriya, Mar 21 '14 at 07:02

score 0 · Answer 1 · answered Apr 19 '14 at 01:54

You can't, Service Builder neither provides that nor is supposed to work with such database checks. In the Service Builder design, your services should delete dependent entities. In your example, the service which manages the master table should, on its delete method, delete also the child rows pointing to the deleting master row. A good example of this is the JournalArticleLocalServiceImpl.deleteArticle(JournalArticle, String, ServiceContext) method, which does, for example, this:

journalArticleImageLocalService.deleteImages(
    article.getGroupId(), articleId, article.getVersion());

// Expando

expandoRowLocalService.deleteRows(article.getId());

Referrential integrity in Liferay 6.2 service builder

1 Answers1