Hi, I was trying to implement Many-to-Many relationship using ServiceBuilder in Liferay 7, but I end up with an error in the generated Persistance classes.
The following are the entities in the ServiceBuilder along with the Mapping Table;
[indent]
But then after building Service and refreshing Gradle Project, the generated Persistence Impl Classes throw an error:
The error is:
The generated tables.sql file:
^
The part where the error resides in DepartmentPersistenceImpl.java is:
[indent]
The part where the error resides in EmployeePersistenceImpl.java:
[indent]
I am new to Liferay Development, Can anyone help me resolve what's the issue here?
The following are the entities in the ServiceBuilder along with the Mapping Table;
[indent]
<service-builder package-path="com.manytomany">
<namespace>ManyToMany</namespace>
<entity name="Employee" local-service="true" remote-service="false" table="Employee">
<column name="eid" type="long" primary="true"></column>
<column name="name" type="String"></column>
<column name="address" type="String"></column>
<column name="deptid" type="Collection" entity="Department" mapping-table="Employee_department" />
</entity>
<entity name="Department" local-service="true" remote-service="false" table="Department">
<column name="deptid" type="long" primary="true"></column>
<column name="department" type="String"></column>
<column name="eid" type="Collection" entity="Employee" mapping-table="Employee_department" />
</entity>
</service-builder>But then after building Service and refreshing Gradle Project, the generated Persistence Impl Classes throw an error:
The error is:
symbol: method getCompanyId()
location: variable department of type Department
D:\Liferay\workspace\LProject\modules\ManyToMany\ManyToMany-service\src\main\java\com\mtm\service\persistence\impl\DepartmentPersistenceImpl.java:851: error: cannot find symbol
departmentToEmployeeTableMapper.addTableMapping(department.getCompanyId(),The generated tables.sql file:
create table Department (
deptid LONG not null primary key,
department VARCHAR(75) null
);
create table Employee (
eid LONG not null primary key,
name VARCHAR(75) null,
address VARCHAR(75) null
);
create table ManyToManyService_Employee_department (
companyId LONG not null,
deptid LONG not null,
eid LONG not null,
primary key (deptid, eid)
);^
The part where the error resides in DepartmentPersistenceImpl.java is:
[indent]
@Override
public void addEmployee(long pk, long employeePK) {
Department department = fetchByPrimaryKey(pk);
if (department == null) {
departmentToEmployeeTableMapper.addTableMapping(companyProvider.getCompanyId(),
pk, employeePK);
}
else {
departmentToEmployeeTableMapper.addTableMapping(department.getCompanyId(),
pk, employeePK);
}
}The part where the error resides in EmployeePersistenceImpl.java:
[indent]
@Override
public void addDepartment(long pk, long departmentPK) {
Employee employee = fetchByPrimaryKey(pk);
if (employee == null) {
employeeToDepartmentTableMapper.addTableMapping(companyProvider.getCompanyId(),
pk, departmentPK);
}
else {
employeeToDepartmentTableMapper.addTableMapping(employee.getCompanyId(),
pk, departmentPK);
}
}I am new to Liferay Development, Can anyone help me resolve what's the issue here?
