I need to implement a Spring Boot controller where each endpoint is supposed to retrieve the sql query of a java data fetch.

Example:

var users = entityManagerService.findTable("userTable").getRepository().findAllData();

I need for the hibernate query used to retrieve the data above to be return in the method.

How can I achieve that?

I need to implement a Spring Boot controller where each endpoint is supposed to retrieve the sql query of a java data fetch.

Example:

var users = entityManagerService.findTable("userTable").getRepository().findAllData();

I need for the hibernate query used to retrieve the data above to be return in the method.

How can I achieve that?

• spring-boot
• hibernate

Share Improve this question Follow edited Mar 13 at 12:29 seenukarthi 8,6841010 gold badges5050 silver badges7474 bronze badges asked Mar 13 at 12:13 Diogo AlpendreDiogo Alpendre 3011 silver badge88 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

1. Modify Your Service

Update your repository service to return the SQL query before execution.

import .hibernate.query.Query;
import .hibernate.Session;
import .springframework.stereotype.Service;
import jakarta.persistence.EntityManager;
import jakarta.persistence.PersistenceContext;

@Service
public class EntityManagerService {

    @PersistenceContext
    private EntityManager entityManager;

    public String getGeneratedSQL(String tableName) {
        Session session = entityManager.unwrap(Session.class);
        Query<?> query = session.createQuery("FROM " + tableName);
        return query.getQueryString(); // This returns HQL, not raw SQL
    }
}

2. Create a Controller to Expose SQL Query

import .springframework.web.bind.annotation.GetMapping;
import .springframework.web.bind.annotation.RequestParam;
import .springframework.web.bind.annotation.RestController;

@RestController
public class QueryController {

    private final EntityManagerService entityManagerService;

    public QueryController(EntityManagerService entityManagerService) {
        this.entityManagerService = entityManagerService;
    }

    @GetMapping("/query")
    public String getQuery(@RequestParam String tableName) {
        return entityManagerService.getGeneratedSQL(tableName);
    }
}