oracle should change FOR UPDATE clause like following

[TimHe95]

    stmtDeliveryBGSelectOldestNewOrder = dbConn.prepareStatement(
        "SELECT no_o_id FROM bmsql_new_order WHERE no_o_id in " +
        "( " +
        "       SELECT no_o_id    FROM bmsql_new_order " +
        "       WHERE no_w_id = ? AND no_d_id = ? " +
        "       ORDER BY no_o_id ASC " +
        "       FETCH FIRST 1 ROWS ONLY" +
        ") ");
        //"SELECT no_o_id " +
        //"    FROM bmsql_new_order " +
        //"    WHERE no_w_id = ? AND no_d_id = ? " +
        //"    ORDER BY no_o_id ASC" +
        //"    FETCH FIRST 1 ROWS ONLY" +
        //"    FOR UPDATE");