用HQL（Hibernate query Language）转换查询Oracle

Question

SELECT NOME_PADRE, COD_PADRE, NOME_FIGLIO, COD_FIGLIO,
CONFIRM_COD_FIGLIO, LEVEL
FROM (
    SELECT s1.NOME AS NOME_PADRE, a.PADRE AS COD_PADRE, s2.NOME AS
           NOME_FIGLIO, a.CMU AS COD_FIGLIO, s2.CMU AS 
           CONFIRM_COD_FIGLIO 
FROM ALBERO a JOIN STRUTTURE s1 ON a.PADRE = s1.CMU 
        JOIN STRUTTURE s2 ON a.CMU = s2.CMU
ORDER BY PADRE ASC
) 
START WITH COD_PADRE = '00000'
CONNECT BY PRIOR COD_FIGLIO = COD_PADRE 
ORDER SIBLINGS BY COD_PADRE

非常感谢

Answer 1

我尝试使用本机查询。

我使用Spring-Boot，我有一个控制器、一个服务和一个存储库。在我的存储库中，我实现了一个原生查询，如下所示：

String QUERY = " SELECT s.CMU, s.NOME, a.PADRE, LEVEL "
             + " FROM STRUTTURE s LEFT JOIN ALBERO a ON s.CMU = a.CMU "
             + " START WITH a.PADRE = '00000' "
             + " CONNECT BY PRIOR a.CMU = a.PADRE "
             + " ORDER SIBLINGS BY a.PADRE";
@Query(nativeQuery = true, value = QUERY)
public List<Struttura> findAllWithConnectBy();

但我有这个错误：