遇到了一个奇怪的问题,我在BIRT下建立了数据集,查询语句如下:
select
B.A_C_USER_ID,
B.A_C_UNIT_CODE,
B.A_C_PRODUCT_ID,
B.A_C_PRODUCT_NAME,
B.A_C_FUNC_ID,
EXIMUSER.SEC_USER_AUTH_LEVEL.I_AUTH_LEVEL
from
(select
EXIMUSER.SEC_USER_INFO.C_USER_ID A_C_USER_ID,
EXIMUSER.SEC_USER_INFO.C_UNIT_CODE A_C_UNIT_CODE,
EXIMUSER.SEC_OP_FUNC.C_PRODUCT_ID A_C_PRODUCT_ID,
EXIMUSER.SEC_OP_FUNC.C_PRODUCT_NAME A_C_PRODUCT_NAME,
EXIMUSER.SEC_OP_FUNC.C_FUNC_ID A_C_FUNC_ID
from EXIMUSER.SEC_USER_INFO
left join
EXIMUSER.SEC_OP_FUNC on EXIMUSER.SEC_OP_FUNC.C_USER_ID=EXIMUSER.SEC_USER_INFO.C_USER_ID
where EXIMUSER.SEC_USER_INFO.C_UNIT_CODE=?) B
left join
EXIMUSER.SEC_USER_AUTH_LEVEL on EXIMUSER.SEC_USER_AUTH_LEVEL.C_USER_ID=B.A_C_USER_ID
and EXIMUSER.SEC_USER_AUTH_LEVEL.C_PRODUCT_ID=B.A_C_PRODUCT_ID
在BIRT 的IDE里面预览没有任何问题,但我将模板放到J2EE应用中,结果却报错。报错信息如下:
[08-2-29 9:43:00:265 CST] 3cf03cf0 SystemErr R java.lang.NullPointerException
[08-2-29 9:43:00:296 CST] 3cf03cf0 SystemErr R at java.lang.Throwable. <init> (Throwable.java)
[08-2-29 9:43:00:296 CST] 3cf03cf0 SystemErr R at java.lang.Throwable. <init> (Throwable.java)
[08-2-29 9:43:00:296
select
B.A_C_USER_ID,
B.A_C_UNIT_CODE,
B.A_C_PRODUCT_ID,
B.A_C_PRODUCT_NAME,
B.A_C_FUNC_ID,
EXIMUSER.SEC_USER_AUTH_LEVEL.I_AUTH_LEVEL
from
(select
EXIMUSER.SEC_USER_INFO.C_USER_ID A_C_USER_ID,
EXIMUSER.SEC_USER_INFO.C_UNIT_CODE A_C_UNIT_CODE,
EXIMUSER.SEC_OP_FUNC.C_PRODUCT_ID A_C_PRODUCT_ID,
EXIMUSER.SEC_OP_FUNC.C_PRODUCT_NAME A_C_PRODUCT_NAME,
EXIMUSER.SEC_OP_FUNC.C_FUNC_ID A_C_FUNC_ID
from EXIMUSER.SEC_USER_INFO
left join
EXIMUSER.SEC_OP_FUNC on EXIMUSER.SEC_OP_FUNC.C_USER_ID=EXIMUSER.SEC_USER_INFO.C_USER_ID
where EXIMUSER.SEC_USER_INFO.C_UNIT_CODE=?) B
left join
EXIMUSER.SEC_USER_AUTH_LEVEL on EXIMUSER.SEC_USER_AUTH_LEVEL.C_USER_ID=B.A_C_USER_ID
and EXIMUSER.SEC_USER_AUTH_LEVEL.C_PRODUCT_ID=B.A_C_PRODUCT_ID
在BIRT 的IDE里面预览没有任何问题,但我将模板放到J2EE应用中,结果却报错。报错信息如下:
[08-2-29 9:43:00:265 CST] 3cf03cf0 SystemErr R java.lang.NullPointerException
[08-2-29 9:43:00:296 CST] 3cf03cf0 SystemErr R at java.lang.Throwable. <init> (Throwable.java)
[08-2-29 9:43:00:296 CST] 3cf03cf0 SystemErr R at java.lang.Throwable. <init> (Throwable.java)
[08-2-29 9:43:00:296