我试图将SQL查询转换为HQL或JPQL (我希望从对象映射中获益)。
我的SQL请求是:
SELECT *
FROM (SELECT bde, MAX(creation_date)
FROM push_campaign GROUP BY bde) temp,
push_campaign pc where pc.bde = temp.bde and pc.creation_date = temp.creation_date;
我试图(不成功)在JPQL中将其转换为:
select pc
from (select bde, max(creationDate)
f
WITH qq1 AS (
SELECT
MAX(month_end_dt) AS max_month_end_dt
FROM
ods.bde_loan_mly
),
qq2 AS (
SELECT
UDF_ADD_MONTHS(current_date, -1) AS curr_date
FROM
DUAL
),
qq3 AS (
SE
我试图遵循Spring的例子,我在网上搜索了几个小时,没有找到解决方案。我发现的大多数解决方案,他们说把@ComponentScan扫描的包裹,我是不是漏掉了什么,任何一个hep都是值得赞赏的。
SpringBootApplication类:
package ben;
@SpringBootApplication
@EnableAutoConfiguration
@ComponentScan({"services","repository", "web"})
public class SpringBootWebApplication
{
pu
我试图在IF条件中使用游标FOR循环,但出现错误。以下是详细信息:
OPEN c_tab_var FOR v_sql;
Loop
fetch c_tab_var into v_cur_inv_var;
exit when c_tab_var%notfound;
For v_cur_bde IN
(
SELECT DISTINCT BDE.col1, BDE.col2
FROM tab BDE
ORDER BY BDE.col1, BDE.col2, BDE.col3....
)
LOOP
If v_cur_bde.col1 = v_cur_inv_var.c
我很难达到我的要求。我有一个名为accounts_invoice和data的表,如下所述。
DB表
AC_NO VARCHAR2(20 BYTE)
INV_NO VARCHAR2(20 BYTE)
CC VARCHAR2(20 BYTE)
FT VARCHAR2(20 BYTE)
AC_NO INV_NO CC FT
-----------------------------
1 A PTN INVOICE
1 A PTN BDE
2 B
当我尝试从我的容器内连接到一个端口到另一个容器时,我是不成功的,
root@ac1590a59fe5:/opt/f5massupgrade# curl -v https://172.17.0.1:6379
* Rebuilt URL to: https://172.17.0.1:6379/
* Hostname was NOT found in DNS cache
* Trying 172.17.0.1...
* connect to 172.17.0.1 port 6379 failed: No route to host
* Failed to connect to 172.17.0.