网站首页 新闻首页 网页设计图形动画软件编程网站开发办公软件操作系统数据库网络技术认证考试范文资料黑客攻防 书籍教程 进入论坛

奇怪的BIRT数据集问题

http://www.diybl.com/ 2008-2-29  网络 点击:  [ 评论 ]
文章搜索:    【点击打包该文章】

遇到了一个奇怪的问题,我在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   CST]   3cf03cf0   SystemErr           R   at   java.lang.NullPointerException. <init> (NullPointerException.java:60)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   com.ibm.ws.rsadapter.jdbc.WSJdbcResultSetMetaData.getColumnCount(WSJdbcResultSetMetaData.java:118)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.birt.report.data.oda.jdbc.Statement.getMetaData(Statement.java:278)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.doGetMetaData(OdaQuery.java:388)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.datatools.connectivity.oda.consumer.helper.OdaQuery.getMetaData(OdaQuery.java:356)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getRuntimeMetaData(PreparedStatement.java:369)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.getProjectedColumns(PreparedStatement.java:339)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.birt.data.engine.odaconsumer.PreparedStatement.setColumnsProjection(PreparedStatement.java:1028)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.birt.data.engine.executor.DataSourceQuery.prepare(DataSourceQuery.java:262)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery$OdaDSQueryExecutor.prepareOdiQuery(PreparedOdaDSQuery.java:344)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.birt.data.engine.impl.QueryExecutor.prepareExecution(QueryExecutor.java:213)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.birt.data.engine.impl.PreparedQuery.doPrepare(PreparedQuery.java:396)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:145)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.birt.data.engine.impl.PreparedOdaDSQuery.execute(PreparedOdaDSQuery.java:134)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.birt.data.engine.impl.PreparedDataSourceQuery.execute(PreparedDataSourceQuery.java:125)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.birt.report.engine.data.dte.DteDataEngine.doExecuteQuery(DteDataEngine.java:119)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.birt.report.engine.data.dte.AbstractDataEngine.execute(AbstractDataEngine.java:210)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.birt.report.engine.executor.ExecutionContext.executeQuery(ExecutionContext.java:1641)
[08-2-29   9:43:00:296   CST]   3cf03cf0   SystemErr           R   at   org.eclipse.birt.report.engine.executor.QueryItemExecutor.executeQue

欢迎光临DIY部落,点击这里查看更多文章教程   【点击打包该文章】
[1] [2]
如果图片或页面不能正常显示请点击这里 站内搜索:   

文章评论

请您留言