下面的查询在一个环境中运行良好,但在另一个环境中给出以下错误:
SQL状态[null]; 错误代码[0]; DSRA9110E:连接已关闭。
嵌套异常为
com.ibm.websphere.ce.cm.ObjectClosedException:DSRA9110E:连接已关闭。
我无法弄清两件事:
错误状态SQL状态[null]的含义是什么; 错误代码[0]; DSRA9110E:连接已关闭。
该查询失败的环境有什么问题?
这是查询:
SELECT DISTINCT
PERS_ALST_NAVIG,
PERS_ALST_PERSNUM,
PERS_ALST_FIRSTNAME,
PERS_ALST_LASTNAME,
PERS_ALST_DOB,
ENT_PERS
FROM (
SELECT
TRIM(CUSTOMER_SOURCE_REF_ID) AS PERS_ALST_NAVIG,
TRIM(CUSTOMER_SOURCE_REF_ID) AS PERS_ALST_PERSNUM,
FIRST_NAME AS PERS_ALST_FIRSTNAME,
LAST_NAME AS PERS_ALST_LASTNAME,
DATE_OF_BIRTH AS PERS_ALST_DOB
FROM (
SELECT
DISTINCT
cust.CUSTOMER_SOURCE_REF_ID ,
cust.FIRST_NAME ,
cust.LAST_NAME ,
cust.DATE_OF_BIRTH
FROM V_CUSTOMERS cust
LEFT OUTER JOIN V_CUSTOMER_ACCOUNT_LINK cal
ON cust.CUSTOMER_SOURCE_UNIQUE_KEY1 = cal.CUSTOMER_SOURCE_UNIQUE_KEY1
AND cust.customer_source_unique_key2 = cal.customer_source_unique_key2
WHERE
cust.CUSTOMER_TYPE_GROUP = 'Person'
and
([=reserved.function.call.OrgUnitFilterKeys('cust.ORG_UNIT_CODE', '/OrgUnit Filtering')])
) x
WHERE [whereCondition]
) y
在此先感谢,Reeya