java - "WITH"SQL 查询不工作java

Question

我在下面的查询中使用“with data as”。当我在 sql Developer 中运行它时，它执行得很好，但是在 java 代码中，当我将查询作为普通字符串或通过 xml 配置文件中的 jdbc 模板调用时，它会给出错误的 SQL 语法。下面的查询有其他选择吗？

public class NppGWOrphanMessageDao extends DefaultDao {
String sql = "same sql as i posted"
private String replayGWOrphanMsgSQL;

public void setReplayGWOrphanMsgSQL(String replayGWOrphanMsgSQL) {
    this.replayGWOrphanMsgSQL = replayGWOrphanMsgSQL;
}

public String getReplayGWOrphanMsgSQL() { return replayGWOrphanMsgSQL; }

public List<Map<String, Object>> getReplayList(HashMap<String, Object> epoch) { 
    return retrieveAll(replayGWOrphanListSQL, params); 
    return retrieveAll(sql, epoch); }
}

WITH DATA AS ( 
    SELECT GLOB.ID, GLOB.CHARACTERS 
    FROM GW_LOB_STORE GLOB 
    WHERE 
        NOT EXISTS(SELECT 1 FROM GW_NPP_MSG_INTEGRITY M WHERE M.LOB_STORE_ID=GLOB.ID) 
        AND NOT EXISTS(SELECT 1 FROM GW_NPP_SAFE_STORE S WHERE S.LOB_STORE_ID=GLOB.ID)
        AND NOT EXISTS(SELECT 1 FROM GW_POISON_LOG P WHERE P.LOB_STORE_ID=GLOB.ID)
        AND GLOB.CREATED_TS > = :epoch)
SELECT 
    A.ID AS "GLOBID", 
    INQUEUEDTL.ID AS "INQUEID", 
    A.CHARACTERS AS "REQUESTBODY", 
    INQUEUEDTL.ENDPOINT_ID AS "ENDPOINTID", 
    INQUEUEDTL.HEADER AS "HEADERS" 
FROM DATA A, GW_IN_QUEUE_DETAIL INQUEUEDTL 
WHERE A.ID=INQUEUEDTL.ID;

Answer 1

为了完整起见:

此查询的问题在于其末尾的 ;。

Oracle JDBC 驱动程序不能很好地处理它。