gpt4 book ai didi

sql - DB2 查询未知列名 ERRORCODE=-4460,SQLSTATE=null

转载 作者:行者123 更新时间:2023-12-04 05:03:00 25 4
gpt4 key购买 nike

一位同事让我们所有人感到困惑,因为我们无法猜测原因而失败的查询。我可以确认ENOTE.EN_FILTER_VALUE_L.FILTER_VALUE_DECODE确实存在于数据库中。至少有三个人盯着它试图找出拼写错误。

查询:

SELECT sub.ID, sub.USER_ID, sub.EN_TYPE_CODE, 
typ.EN_TYPE_DESC, typ.APPL_CD, filterval.FILTER_VALUE_DECODE AGENCY_TYPE,
sub.EN_TYPE_CODE CONCAT ' | ' CONCAT typ.EN_TYPE_DESC ENOTE_STRING,
org1.ORG_LVL1_CD, org1.ORG_LVL1_DC,
org2.ORG_LVL2_CD, org2.ORG_LVL2_DC,
org3.ORG_LVL3_CD, org3.ORG_LVL3_DC,
org4.ORG_LVL4_CD, org4.ORG_LVL4_DC
FROM ENOTE.EN_SUBSCRIPTION_T sub
LEFT JOIN ENOTE.EN_TYPE_L typ ON sub.EN_TYPE_CODE = typ.EN_TYPE_CODE
LEFT JOIN ENOTE.EN_FILTER_OFFICE_T filteroffice ON sub.ID = filteroffice.SUBSCRIPTION_ID
LEFT JOIN UMC.ORG_LVL4_L org4 ON org4.ORG_LVL4_CD = filteroffice.ORG_LVL4_CODE
AND org4.ORG_LVL3_CD = filteroffice.ORG_LVL3_CODE
AND org4.ORG_LVL2_CD = filteroffice.ORG_LVL2_CODE
AND org4.ORG_LVL1_CD = filteroffice.ORG_LVL1_CODE
AND org4.STRUCTURE_CD = filteroffice.STRUCTURE_CODE
LEFT JOIN UMC.ORG_LVL3_L org3 ON org3.ORG_LVL3_CD = filteroffice.ORG_LVL3_CODE
AND org3.ORG_LVL2_CD = filteroffice.ORG_LVL2_CODE
AND org3.ORG_LVL1_CD = filteroffice.ORG_LVL1_CODE
AND org3.STRUCTURE_CD = filteroffice.STRUCTURE_CODE
LEFT JOIN UMC.ORG_LVL2_L org2 ON org2.ORG_LVL2_CD = filteroffice.ORG_LVL2_CODE
AND org2.ORG_LVL1_CD = filteroffice.ORG_LVL1_CODE
AND org2.STRUCTURE_CD = filteroffice.STRUCTURE_CODE
LEFT JOIN UMC.ORG_LVL1_L org1 ON org1.ORG_LVL1_CD = filteroffice.ORG_LVL1_CODE
AND org1.STRUCTURE_CD = filteroffice.STRUCTURE_CODE
LEFT JOIN ENOTE.EN_FILTER_VALUE_L filterval ON
(filteroffice.AGENCY_TYPE_CODE = filterval.FILTER_VALUE AND filterval.FILTER_NAME = 'Agency Type')

异常(exception):

com.ibm.db2.jcc.a.SqlException: [jcc][10150][10300][4.3.111] Invalid parameter: Unknown column name FILTER_VALUE_DECODE. ERRORCODE=-4460, SQLSTATE=null

最佳答案

我在这里重新问了这个问题 db2jcc4.jar Invalid parameter: Unknown column name并得到了答案。

Hibernate 3.x 和 DB2 9.5 及更高版本中的 JCC 驱动程序的组合存在规范级别不匹配。升级到 Hibernate 4.x 将解决该问题,但如果您在短期内无法做到这一点,请设置 useJDBC4ColumnNameAndLabelSemantics=2 的自定义数据源属性。解决了这个问题。

关于sql - DB2 查询未知列名 ERRORCODE=-4460,SQLSTATE=null,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/15884794/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com