POST REST API with One-To-Many Mapping : Cannot be null error

Question

I have two tables: tbl_services & tbl_sub_services. one service can have multiple sub-services. I am developing REST API using spring boot and trying to post data in services & subservices table. I can post data in services table but getting issue while posting in sub-services table. It's one-to-Many bidirectional Mapping.

Here is an exception which I am getting in postman.

{
"timestamp": "2019-06-09T04:10:22.002+0000",
"status": 500,
"error": "Internal Server Error",
"message": "could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement",
"trace": "org.springframework.dao.DataIntegrityViolationException: could not execute statement; SQL [n/a]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement\n\tat 
.
.
.
.
'tbl_services_id' cannot be null\n\tat com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117)\n\tat com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)\n\tat com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)\n\tat com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:955)\n\tat com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1094)\n\tat com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1042)\n\tat com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1345)\n\tat com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1027)\n\tat com.zaxxer.hikari.pool.ProxyPreparedStatement.executeUpdate(ProxyPreparedStatement.java:61)\n\tat com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeUpdate(HikariProxyPreparedStatement.java)\n\tat org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)\n\t... 94 more\n",
"path": "/api/subservices"

Here is structure of both tables :

Entity Classes :
Services.class

@Entity
@Table(name="tbl_services")
public class Service {

// define fields
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@Column(name="tbl_services_id")
private int id;

@Column(name="service_name")
private String serviceName;

@Column(name="service_desc")
private String serviceDesc;

@Column(name="service_image")
private String serviceImage;

@OneToMany(mappedBy="service",
        cascade= {CascadeType.PERSIST, CascadeType.MERGE,
            CascadeType.DETACH, CascadeType.REFRESH})
private List<SubService> subServices;

public List<SubService> getSubServices() {
    return subServices;
}

public void setSubServices(List<SubService> subServices) {
    this.subServices = subServices;
}
}

SubService.class

@Entity
@Table(name="tbl_sub_services")
public class SubService {

// define fields
@Id
@GeneratedValue(strategy=GenerationType.IDENTITY)
@Column(name="tbl_sub_services_id")
private int id;

@ManyToOne(
        cascade= {CascadeType.PERSIST, CascadeType.MERGE,
                CascadeType.DETACH, CascadeType.REFRESH})
@JoinColumn(name="tbl_services_id")
@JsonIgnore
private Service service;

public Service getService() {
    return service;
}

@Column(name="sub_service_name")
private String subServiceName;

@Column(name="sub_service_desc")
private String subServiceDesc;

@Column(name="sub_service_image")
private String subServiceImage;

I am trying to post data from postman then I am getting an exception. Here is data which I am posting from postman.

Here is SubServicesHibernateDAOImpl.class

@Override
public void saveSubService(SubService theSubService) {
    // get the current hibernate session
    Session currentSession = entityManager.unwrap(Session.class);
    System.out.println("SubService object : "+theSubService);       
    currentSession.saveOrUpdate(theSubService);
}

EDIT : Here is json payload I am receiving in saveSubService method :

[id=0, service=null, subServiceName=GST, subServiceDesc=GST is a subservice which currently having , subServiceImage=path-to-image]

Maciej Kowalski · Accepted Answer · 2019-06-09 05:40:48Z

1

You get:

could not execute statement; SQL [n/a]; constraint [null]

I see that you are passing the service in the request but I do not see you load it before the save of SubService:

@Override
public void saveSubService(SubService theSubService) {
    Session currentSession = entityManager.unwrap(Session.class);
    Service loadedService = currentSession.load(Service.class
           , theSubService.getService.getId();

    theSubService.setService(loadedService);         

    currentSession.saveOrUpdate(theSubService);
}

or try to simply merge as you have proper cascading already in place:

@Override
public void saveSubService(SubService theSubService) {
    // get the current hibernate session
    Session currentSession = entityManager.unwrap(Session.class);
    System.out.println("SubService object : "+theSubService);       
    currentSession.merge(theSubService);
}

Also, I am not sure why you need to unwrap the session. EntityManager and its interface would be sufficient in this case.

answered Jun 9, 2019 at 5:40

Maciej Kowalski

26.7k12 gold badges59 silver badges66 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Sandip Armal Patil Over a year ago

If I use merge then it's giving me same exception which I posted in question and if I use first solution then it's giving me null-pointer exception in Service loadedService = currentSession.load(Service.class , theSubService.getService.getId();

Maciej Kowalski Over a year ago

Are you sure the "service" is properly mapped to an object? I does not seem to in that case

Sandip Armal Patil Over a year ago

Here is json payload i am receiving in saveSubService method : ` [id=0, service=null, subServiceName=GST, subServiceDesc=GST is a subservice which currently having , subServiceImage=path-to-image]`

Collectives™ on Stack Overflow

POST REST API with One-To-Many Mapping : Cannot be null error

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related