视图读取失败问题

cht0112

建立了一个视图文件，用SQL查询可以正常得到数据，但在项目中查询总是失败，log见附件。视图已授权，没有权限问题。以下是建立视图的SQL:
create view dbo.TEST_SCHEME_INFO_VIEW
as
select TEST_SCHEME_BASE_INFO.*,
BUSINESS_TYPE_CODE.BUSINESS_ID_CNAME as BUSINESS_ID_CNAME,
VALID_STATE_CODE.VALID_STATE_CNAME as VALID_STATE_CNAME,
DECTION_BASED_ON_INFO.DECTION_BASED_ON_NAME as DECTION_BASED_ON_NAME,
DETECTION_OBJECT_TYPE.DETECTION_OBJECT_CNAME as OBJECT_TYPE_CNAME, err.rar (10.6 KB, 下载次数: 73)

2018-9-12 18:11 上传

点击文件名下载附件
DEVICE_TYPE_CODE.DEVICE_TYPE_CNAME as DEVICE_TYPE_CNAME,
TEST_SCHEME_CASE_INFO.BUSINESS_STAGE as BUSINESS_STAGE,
BUSINESS_STAGE_CODE.BUSINESS_STAGE_CNAME as BUSINESS_STAGE_CNAME
FROM TEST_SCHEME_BASE_INFO TEST_SCHEME_BASE_INFO  
join BUSINESS_TYPE_CODE BUSINESS_TYPE_CODE on TEST_SCHEME_BASE_INFO.BUSINESS_ID = BUSINESS_TYPE_CODE.BUSINESS_ID
join VALID_STATE_CODE VALID_STATE_CODE on TEST_SCHEME_BASE_INFO.VALID_STATE = VALID_STATE_CODE.VALID_STATE
join DECTION_BASED_ON_INFO DECTION_BASED_ON_INFO on DECTION_BASED_ON_INFO.DECTION_BASED_ON_ID = TEST_SCHEME_BASE_INFO.DECTION_BASED_ON_ID
join DETECTION_OBJECT_TYPE DETECTION_OBJECT_TYPE on TEST_SCHEME_BASE_INFO.OBJECT_TYPE = DETECTION_OBJECT_TYPE.DETECTION_OBJECT_TYPE
join DEVICE_TYPE_CODE DEVICE_TYPE_CODE on TEST_SCHEME_BASE_INFO.DEVICE_TYPE = DEVICE_TYPE_CODE.DEVICE_TYPE
join TEST_SCHEME_CASE_INFO TEST_SCHEME_CASE_INFO on TEST_SCHEME_BASE_INFO.TEST_SCHEME_ID = TEST_SCHEME_CASE_INFO.TEST_SCHEME_ID AND TEST_SCHEME_BASE_INFO.BUSINESS_ID = TEST_SCHEME_CASE_INFO.BUSINESS_ID
join BUSINESS_STAGE_CODE BUSINESS_STAGE_CODE on TEST_SCHEME_CASE_INFO.BUSINESS_ID = BUSINESS_STAGE_CODE.BUSINESS_ID AND TEST_SCHEME_CASE_INFO.BUSINESS_STAGE = BUSINESS_STAGE_CODE.BUSINESS_STAGE AND BUSINESS_TYPE_CODE.BUSINESS_ID = BUSINESS_STAGE_CODE.BUSINESS_ID

jishuang

queryAction怎么定义的？

cht0112

select TEST_SCHEME_INFO_VIEW.*     from TEST_SCHEME_INFO_VIEW TEST_SCHEME_INFO_VIEW LIMIT 0, 50

jishuang

发完整的queryAction的定

cht0112

<?xml version="1.0" encoding="UTF-8"?><model xmlns="http://www.justep.com/model"><action name="queryTEST_SCHEME_INFO_VIEWAction" procedure="bizQueryProcedure"><permission name="range" type="List"/>
<private name="concept" type="String" value="TEST_SCHEME_INFO_VIEW"/>
<private name="select" type="String" value="TEST_SCHEME_INFO_VIEW.*"/>
<private name="from" type="String" value="TEST_SCHEME_INFO_VIEW TEST_SCHEME_INFO_VIEW"/>
<private name="aggregate" type="String"/>
<private name="dataModel" type="String" value="/metrodetection/system_code/data"/>
<private name="fnModel" type="String"/>
<protected name="condition" type="String"/>
<public name="distinct" type="Boolean" value="false"/>
<public name="idColumn" type="String" value="TEST_SCHEME_INFO_VIEW"/>
<public name="filter" type="String"/>
<public name="limit" type="Integer"/>
<public name="offset" type="Integer"/>
<public name="columns" type="String"/>
<public name="orderBy" type="String"/>
<public name="aggregateColumns" type="String"/>
<public name="variables" type="Map"/>
</action>
<action name="saveTEST_SCHEME_INFO_VIEWAction" procedure="bizSaveProcedure"><permission name="insertRange" type="List"/>
<permission name="deleteRange" type="List"/>
<permission name="updateRange" type="List"/>
<private name="concept" type="String" value="TEST_SCHEME_INFO_VIEW"/>
<private name="dataModel" type="String" value="/metrodetection/system_code/data"/>
<private name="fnModel" type="String"/>
<protected name="readOnly" type="String"/>
<protected name="notNull" type="String"/>
<public name="table" required="true" type="Table"/>
</action>
<action name="createTEST_SCHEME_INFO_VIEWAction" procedure="bizCreateProcedure"><private name="concept" type="String" value="TEST_SCHEME_INFO_VIEW"/>
<private name="fnModel" type="String"/>
<public name="table" required="true" type="Table"/>
<public name="defaultValues" type="Map"/>
</action>
</model>

jishuang

在BIZ这个模块上右键模型检查确认概念和关系是否都正确

cht0112

检查了，没有错误

jishuang

studio切换到调试视图，然后在J!标记按钮弹出的窗口中加一个NullPointerException异常如下，把“窗口——首选项——Studio配置——Tomcat”中的“不以调试模式启动”的勾选去掉，然后重启tomcat,运行出错的功能，到空指针异常时看具体的参数值都是什么

cht0112

jishuang 发表于 2018-9-13 13:50
studio切换到调试视图，然后在J!标记按钮弹出的窗口中加一个NullPointerException异常如下，把“窗口——首 ...

是环境的问题，前几天改东西项目弄乱了，重拿了代码，现在没问题了。谢谢