How to create liferay Service xml for multiple foreign key of same primary key?

Question

enter image description here

I know the question might be confusing,any ways I will explain it.

Basically I have two tables. Student and Course where studentid and courseid are their corresponding primary keys.

In the Student table I have two attributes courseid and courseidbackup both are key(FK) to the course table. This is the service xml I am using, but it shows build unsuccessful.

What am I missing here? How to create service xml to achieve this ?

 <service-builder package-path="com.students.db">
<author>bugs</author>
<namespace>students</namespace>
<entity name="Student" local-service="true" remote-service="true" cache-enabled="false">
<column name="studentId" type="long" primary="true" />
<column name="studentName" type="String" />

<column name="coursesid" type="Collection" entity="Course" mapping-table="Students_Courses"/>
<column name="coursesidbackup" type="Collection" entity="Course" mapping-table="Students_Courses"/>
</entity>
<entity name="Course" local-service="true" remote-service="true" cache-enabled="false">
<column name="courseId" type="long" primary="true" />
<column name="courseName" type="String" />
<column name="courseDetails" type="String" />
<column name="students" type="Collection" entity="Student" mapping-table="Students_Courses" />
</entity>
</service-builder>

AFAIK Liferay service builder does not provide support for foreign key — Pankaj Kathiriya, May 30 '14 at 05:38
Manually you may write code for handling foreign-key relation with student/course entity — Pankaj Kathiriya, May 30 '14 at 06:59
Similarly to http://stackoverflow.com/questions/24273631/liferay-service-builder-6-2-many-to-one-relationships — , May 30 '16 at 22:17

score 0 · Answer 1 · answered May 30 '14 at 11:07

0

You're giving the same mapping table - Students_Courses - in both cases. Try e.g. Students_Backupcourses as the second option. Otherwise I'd be puzzled how that mapping table should handle that relationship. As mentioned in the comments, typically Liferay doesn't enforce any foreign key relationship in the db model, but this would be as close as you get.

answered May 30 '14 at 11:07

Olaf Kock

46,930
8
59
90

Thanks for the reply.Well i tried it but my build service is still not succesfull.It generates duplicate methods – playmaker420 May 31 '14 at 07:27

score 0 · Answer 2 · edited Dec 11 '22 at 09:54

0

change your mapping-table="Students_Courses" to this--> mapping-table="Students_Course"

edited Dec 11 '22 at 09:54

logi-kal

7,107
6
31
43

answered Dec 06 '22 at 09:31

Sainath Jamashetty

1
1

How to create liferay Service xml for multiple foreign key of same primary key?

2 Answers2