Newbie Spring Boot developer looking for some assistance to resolve my blocker.
I am working on Spring Boot practice project that uses a H2 db.
The main objective of the project is to use API calls to get data from the database.
The majority of the API calls are returning data as expected but the filtering one is not.
I have looked on Stack overflow to try and resolve my error but have not been successful.
I have a compile error and this is stoping progress:
Caused by: org.h2.jdbc.JdbcSQLIntegrityConstraintViolationException: NULL not allowed for column "VALUE"; SQL statement:
INSERT INTO organization_application_lookup (organization_id, application_id) VALUES ('1', '1') [23502-200]
I am trying to introduce a filter query to the application whereby the results will return upon entering the first letter of the application name. When 'c' is entered applications starting with 'c' will be returned.
After reading this article I added the annotation @EmbeddedId to resolve the issue but unfortunately, it has not worked.
The point is, table organization_application_lookup should not really have a PK id column I don't think.
I created an object and table in the OrgAppMapper class as follows:
package com.ciaranmckenna.companycoordinatorapp.model;
import javax.persistence.Column;
import javax.persistence.EmbeddedId;
import javax.persistence.Entity;
import javax.persistence.Table;
@Entity
@Table(name= "organization_application_lookup")
public class OrgAppMapper {
@EmbeddedId
@Column(name = "organization_id")
private Long organisationId;
@Column(name = "application_id")
private Long applicationId;
public OrgAppMapper() {
}
public OrgAppMapper(Long organisationId, Long applicationId) {
this.organisationId = organisationId;
this.applicationId = applicationId;
}
public Long getOrganisationId() {
return organisationId;
}
public void setOrganisationId(Long organisationId) {
this.organisationId = organisationId;
}
public Long getApplicationId() {
return applicationId;
}
public void setApplicationId(Long applicationId) {
this.applicationId = applicationId;
}
}
The line private Long organizationId is causing a compile error. Stating that the 'Embedded' attribute type should not be 'Long'.
I have uploaded the project to codesandbox for the first time to make it easy for developers to help me out.
