Sonar Qube Issue: Remove this forbidden call: Native Queries

Question

enter image description here

public String getVersion() {
            return (String) em.createNativeQuery("SELECT pkg_deploy.get_current_build FROM dual").getSingleResult();
        }

The Sonar complain about not using native queries. In this case, what do I need to change? Should I use JPQL, how?

Answer 1

Using native queries is perfectly fine and in some situations like yours the only way to run this query.

You should go ahead and adjust the SonarQube rules for your needs.