Spring boot native image is not able to convert 'SORT' to json, throws org.springframework.http.converter.HttpMessageNotWritableException: Could not write JSON

[pulsar-gupta]

I am generating spring boot 3 native image using -Pnative switch.
The DAO class fetches the data from DB with SORT object passed to DAO (below is sample)

Sort sort = sortType.equalsIgnoreCase(Sort.Direction.ASC.name()) ? Sort.by(sortField).ascending()
					: Sort.by(sortField).descending();
			Pageable pageWithElements = PageRequest.of(pageNum, projectsCount,sort);
			Page<ProjectDetailsListDto> result= projectDetailsDao.getProjectList(pageWithElements);

However, the call is failed when the call is returned from controller and the exception is

"org.springframework.web.servlet.mvc.support.DefaultHandlerExceptionResolver.logException(207) : Resolved [org.springframework.http.converter.HttpMessageNotWritableException: Could not write JSON: Couldn't serialize object"

I have tried to provide hints to serialize the SORT object but this is also not working.

[wilkinsona]

Thanks for the report. Unfortunately, without knowing what type you are returning in the HTTP response and exactly what hints you provided, we can only guess about the cause of the problem. If you would like us to spend some more time investigating, please spend some time providing a complete yet minimal sample that reproduces the problem. You can share it with us by pushing it to a separate repository on GitHub or by zipping it up and attaching it to this issue.

[pulsar-gupta]

master-service.zip

Thank you for the quick response. Attached the code for your reference.
HTTP request : http://localhost:8080/master/project/list?pageNum=0&projectsCount=10&sortType=DESC&sortField=projectStatus

[wilkinsona]

Thanks for the sample. Unfortunately, I haven't been able to reproduce the problem. I am trying to do so on the JVM initially. Once that works, I'll try in a native image.

The project requires Postgres which I'd prefer not to use as there may be external configuration in the database that you haven't shared. I switched to H2 which allowed the app to start.

Accessing http://localhost:8080/master/project/list?pageNum=0&projectsCount=10&sortType=DESC&sortField=projectStatus results in a 404 response. Looking at the controllers, I think the correct URL is http://localhost:8080/list?pageNum=0&projectsCount=10&sortType=DESC&sortField=projectStatus. This results in a different 404 response:

HTTP/1.1 404 
Content-Type: application/json
Transfer-Encoding: chunked
Date: Thu, 01 Jun 2023 13:41:35 GMT

{"message":"Error while fetching project list","timestamp":"2023-06-01T14:41:35.542967","errorCode":"NOT_FOUND"}

With the following logged to the console:

2023-06-01 14:41:35,542 ERROR 32681 --- [http-nio-8080-exec-5] ERROR [master-service, 092b8de4642b945a09aed6a460e50a75, b1f64cb77d7b2d92]  org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logExceptions(138) : Table "PLANNING_LEVEL" not found; SQL statement:
select m.id, m.project_name as projectName,m.internal_project_id as internalProjectId,
l.planning_level as planningLevel,s.project_status as projectStatus,
p.name as portfolioUnitName FROM(( 
masterdata m	INNER JOIN  planning_level l
on m.planning_level=l.id )
INNER JOIN project_status s
on m.project_status=s.id
INNER JOIN portfolio_unit p on
m.portfolio_unit_id=p.portfolio_unit_id) order by projectStatus desc fetch first ? rows only [42102-214]
2023-06-01 14:41:35,542 ERROR 32681 --- [http-nio-8080-exec-5] ERROR [master-service, 092b8de4642b945a09aed6a460e50a75, b1f64cb77d7b2d92]  com.serviceImpl.ProjectServiceImpl.getProjectsList(43) : Error while fetching project listcould not prepare statement; SQL [select m.id, m.project_name as projectName,m.internal_project_id as internalProjectId,
l.planning_level as planningLevel,s.project_status as projectStatus,
p.name as portfolioUnitName FROM(( 
masterdata m	INNER JOIN  planning_level l
on m.planning_level=l.id )
INNER JOIN project_status s
on m.project_status=s.id
INNER JOIN portfolio_unit p on
m.portfolio_unit_id=p.portfolio_unit_id) order by projectStatus desc fetch first ? rows only]

It looks like the project's entities are not sufficient for Hibernate to create the expected database schema.

Can you please update the sample to use an in-memory database such as H2 and ensure that it reproduces the problem you have described without relying on any additional external configuration.

[pulsar-gupta]

I have uploaded the app with h2 enabled (demo.zip).
api: http://localhost:8080/list?pageNum=0&projectsCount=1&sortType=DESC&sortField=projectStatus
swagger: http://localhost:8080/swagger-ui/index.html#

demo.zip

Let me know If i can be a help

[wilkinsona]

Thanks for the updates. Unfortunately, I still can't reproduce the problem. With Spring Boot 3.1.0, the native image fails to start due to some known problems with Hibernate 6.2.2. When I downgrade to Spring Boot 3.0.7, the image starts and the HttpMessageNotWritableException does not occur:

$ curl 'http://localhost:8080/list?pageNum=0&projectsCount=1&sortType=DESC&sortField=projectStatus' 
{"totalPages":0,"totalElements":0,"pageable":{"pageSize":1,"pageNumber":0,"paged":true,"unpaged":false,"offset":0,"sort":{"unsorted":false,"sorted":true,"empty":false}},"numberOfElements":0,"size":1,"content":[],"sort":{"unsorted":false,"sorted":true,"empty":false},"number":0,"first":true,"last":true,"empty":true}