起步软件技术论坛
搜索
 找回密码
 注册

QQ登录

只需一步,快速开始

查看: 5542|回复: 2

[处理中3] 视图查询出错

[复制链接]

28

主题

136

帖子

246

积分

中级会员

Rank: 3Rank: 3

积分
246
QQ
发表于 2019-6-3 14:43:12 | 显示全部楼层 |阅读模式
版本: X5.3.0 小版本号:
数据库: MS SQLServer 服务器操作系统: Windows 应用服务器: Tomcat
客户端操作系统: Windows 7 浏览器: Chrome
一直运行挺好,最近莫名出错了


        at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT v_BGZR_RetWorkerDoc.*  FROM v_BGZR_RetWorkerDoc v_BGZR_RetWorkerDoc LIMIT 0, -1
--> sql: SELECT  v_BGZR_RetWorkerDoc.FATC_CRIMESITUATION AS fATC_CrimeSituation, v_BGZR_RetWorkerDoc.FATC_IS AS fATC_Is, v_BGZR_RetWorkerDoc.FATC_TROOPS AS fATC_Troops, v_BGZR_RetWorkerDoc.FAGE AS fAge, v_BGZR_RetWorkerDoc.FBANKACC AS fBankAcc, v_BGZR_RetWorkerDoc.FBANKNAME AS fBankName, v_BGZR_RetWorkerDoc.FBASEUNIT AS fBaseUnit, v_BGZR_RetWorkerDoc.FBIRTHDAY AS fBirthDay, v_BGZR_RetWorkerDoc.FCALEMONTHDIFF AS fCaleMonthDiff, v_BGZR_RetWorkerDoc.FCALESUPTIME AS fCaleSupTime, v_BGZR_RetWorkerDoc.FCREATEDATE AS fCreateDate, v_BGZR_RetWorkerDoc.FCREATEPERSON AS fCreatePerson, v_BGZR_RetWorkerDoc.FCREATEPERSONID AS fCreatePersonID, v_BGZR_RetWorkerDoc.FCREATEPERSONURL AS fCreatePersonURL, v_BGZR_RetWorkerDoc.FDM_CONFIRM AS fDM_Confirm, v_BGZR_RetWorkerDoc.FDM_TIME AS fDM_Time, v_BGZR_RetWorkerDoc.FDISCHARGETIME AS fDischargeTime, v_BGZR_RetWorkerDoc.FDOC_NAME AS fDoc_Name, v_BGZR_RetWorkerDoc.FDOC_NO AS fDoc_No, v_BGZR_RetWorkerDoc.FDOC_UID AS fDoc_Uid, v_BGZR_RetWorkerDoc.FDOC_WHERE AS fDoc_Where, v_BGZR_RetWorkerDoc.FEDU_DEGREE AS fEdu_Degree, v_BGZR_RetWorkerDoc.FEDU_FULLTIMEDEGREE AS fEdu_FullTimeDegree, v_BGZR_RetWorkerDoc.FEDU_HIGHESTDATE AS fEdu_HighestDate, v_BGZR_RetWorkerDoc.FEDU_PARTTIMEDEGREE AS fEdu_PartTimeDegree, v_BGZR_RetWorkerDoc.FFIRSTINSTIME AS fFirstInsTime, v_BGZR_RetWorkerDoc.FGOVSUB_EXPERTTITLE AS fGovSub_ExpertTitle, v_BGZR_RetWorkerDoc.FGOVSUB_IS AS fGovSub_Is, v_BGZR_RetWorkerDoc.FGOVSUB_TIME AS fGovSub_Time, v_BGZR_RetWorkerDoc.FHAND_MEMO AS fHand_Memo, v_BGZR_RetWorkerDoc.FHAND_SIT AS fHand_Sit, v_BGZR_RetWorkerDoc.FHID AS fHid, v_BGZR_RetWorkerDoc.FHOMEADDRESS AS fHomeAddress, v_BGZR_RetWorkerDoc.FINJURYTIME AS fInjuryTime, v_BGZR_RetWorkerDoc.FISANNUITY AS fIsAnnuity, v_BGZR_RetWorkerDoc.FLIVINGCONDITION AS fLivingCondition, v_BGZR_RetWorkerDoc.FNAME AS fName, v_BGZR_RetWorkerDoc.FNATION AS fNation, v_BGZR_RetWorkerDoc.FNATIVEPLACE AS fNativePlace, v_BGZR_RetWorkerDoc.FOLDUNITCODE AS fOldUnitCode, v_BGZR_RetWorkerDoc.FOLDUNITNAME AS fOldUnitName, v_BGZR_RetWorkerDoc.FORIGINALPOST AS fOriginalPost, v_BGZR_RetWorkerDoc.FOTHER_ARMYTOWORK AS fOther_ArmyToWork, v_BGZR_RetWorkerDoc.FOTHER_COUNTRYSIDETIME AS fOther_CountrysideTime, v_BGZR_RetWorkerDoc.FOTHER_DOCTOWORKDATE AS fOther_DocToWorkDate, v_BGZR_RetWorkerDoc.FOTHER_HOBBIES AS fOther_Hobbies, v_BGZR_RetWorkerDoc.FOTHER_ISCPPCCMEMBER AS fOther_IsCPPCCMember, v_BGZR_RetWorkerDoc.FOTHER_ISINJURY AS fOther_IsInjury, v_BGZR_RetWorkerDoc.FOTHER_ISMODELWORK AS fOther_IsModelWork, v_BGZR_RetWorkerDoc.FOTHER_ISNPCMEMBER AS fOther_IsNPCMember, v_BGZR_RetWorkerDoc.FOTHER_ISNUF AS fOther_IsNUF, v_BGZR_RetWorkerDoc.FOTHER_ISRELIGIOUS AS fOther_IsReligious, v_BGZR_RetWorkerDoc.FOTHER_ISREMOTEMED AS fOther_IsRemoteMed, v_BGZR_RetWorkerDoc.FOTHER_PLACEOFDOMICILE AS fOther_PlaceOfDomicile, v_BGZR_RetWorkerDoc.FOTHER_PLACEOFTIME AS fOther_PlaceOfTime, v_BGZR_RetWorkerDoc.FOTHER_SSCODE AS fOther_SSCode, v_BGZR_RetWorkerDoc.FOTHER_SSIDNUM AS fOther_SSIDNum, v_BGZR_RetWorkerDoc.FOTHER_WORKTYPE AS fOther_WorkType, v_BGZR_RetWorkerDoc.FPF_ACCOUNT AS fPF_Account, v_BGZR_RetWorkerDoc.FPF_CARDNO AS fPF_CardNo, v_BGZR_RetWorkerDoc.FPARTYREF_INTODATE AS fPartyRef_IntoDate, v_BGZR_RetWorkerDoc.FPARTYREF_INTOIS AS fPartyRef_IntoIs, v_BGZR_RetWorkerDoc.FPARTYREF_OUTDATE AS fPartyRef_OutDate, v_BGZR_RetWorkerDoc.FPARTYREF_PARTYDATE AS fPartyRef_PartyDate, v_BGZR_RetWorkerDoc.FPARTYREF_POLITICALSTATUS AS fPartyRef_PoliticalStatus, v_BGZR_RetWorkerDoc.FPOORSIT_CONFIRM AS fPoorSit_Confirm, v_BGZR_RetWorkerDoc.FPOORSIT_IS AS fPoorSit_Is, v_BGZR_RetWorkerDoc.FPOORSIT_TYPE AS fPoorSit_Type, v_BGZR_RetWorkerDoc.FRETPOST AS fRetPost, v_BGZR_RetWorkerDoc.FRETSTU_OUTCOUNTRY AS fRetStu_OutCountry, v_BGZR_RetWorkerDoc.FRETSTU_OUTTIME AS fRetStu_OutTime, v_BGZR_RetWorkerDoc.FRETSTU_RETTIME AS fRetStu_RetTime, v_BGZR_RetWorkerDoc.FRETTIME AS fRetTime, v_BGZR_RetWorkerDoc.FRETWORKTYPE AS fRetWorkType, v_BGZR_RetWorkerDoc.FSTW_NAMETIME AS fSTW_NameTime, v_BGZR_RetWorkerDoc.FSEX AS fSex, v_BGZR_RetWorkerDoc.FSORTID AS fSortID, v_BGZR_RetWorkerDoc.FSUPTIME AS fSupTime, v_BGZR_RetWorkerDoc.FTAIWAN_KMSIT AS fTaiWan_KMSit, v_BGZR_RetWorkerDoc.FTAIWAN_SIT AS fTaiWan_Sit, v_BGZR_RetWorkerDoc.FTAIWAN_FAM AS fTaiWan_fam, v_BGZR_RetWorkerDoc.FTEL AS fTel, v_BGZR_RetWorkerDoc.FTELCHILD AS fTelChild, v_BGZR_RetWorkerDoc.FTITLE AS fTitle, v_BGZR_RetWorkerDoc.FTITLETIME AS fTitleTime, v_BGZR_RetWorkerDoc.FTOWORKDATE AS fToWorkDate, v_BGZR_RetWorkerDoc.FUID AS fUid, v_BGZR_RetWorkerDoc.FUIDATTFILES AS fUidAttFiles, v_BGZR_RetWorkerDoc.FWORKERTYPE AS fWorkerType, v_BGZR_RetWorkerDoc.fID AS v_BGZR_RetWorkerDoc, v_BGZR_RetWorkerDoc.VERSION AS version FROM v_BGZR_RetWorkerDoc v_BGZR_RetWorkerDoc
--> binds: []
        at com.justep.exception.BusinessException.create(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
        at com.justep.system.data.BizData.query(Unknown Source)
        at BizProcedure.query(BizProcedure.java:18)
        ... 27 more
Caused by: java.lang.IllegalArgumentException
        at java.sql.Date.valueOf(Date.java:143)
        at net.sourceforge.jtds.jdbc.Support.convert(Support.java:412)
        at net.sourceforge.jtds.jdbc.JtdsResultSet.getDate(JtdsResultSet.java:1107)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getDate(DelegatingResultSet.java:244)
        at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getDate(DelegatingResultSet.java:244)
        at com.justep.system.data.impl.TableUtilsImplement.fillRow(Unknown Source)
        ... 32 more


28

主题

136

帖子

246

积分

中级会员

Rank: 3Rank: 3

积分
246
QQ
 楼主| 发表于 2019-6-3 14:48:24 | 显示全部楼层
直接将Sql:
SELECT  v_BGZR_RetWorkerDoc.FATC_CRIMESITUATION AS fATC_CrimeSituation, v_BGZR_RetWorkerDoc.FATC_IS AS fATC_Is, v_BGZR_RetWorkerDoc.FATC_TROOPS AS fATC_Troops, v_BGZR_RetWorkerDoc.FAGE AS fAge, v_BGZR_RetWorkerDoc.FBANKACC AS fBankAcc, v_BGZR_RetWorkerDoc.FBANKNAME AS fBankName, v_BGZR_RetWorkerDoc.FBASEUNIT AS fBaseUnit, v_BGZR_RetWorkerDoc.FBIRTHDAY AS fBirthDay, v_BGZR_RetWorkerDoc.FCALEMONTHDIFF AS fCaleMonthDiff, v_BGZR_RetWorkerDoc.FCALESUPTIME AS fCaleSupTime, v_BGZR_RetWorkerDoc.FCREATEDATE AS fCreateDate, v_BGZR_RetWorkerDoc.FCREATEPERSON AS fCreatePerson, v_BGZR_RetWorkerDoc.FCREATEPERSONID AS fCreatePersonID, v_BGZR_RetWorkerDoc.FCREATEPERSONURL AS fCreatePersonURL, v_BGZR_RetWorkerDoc.FDM_CONFIRM AS fDM_Confirm, v_BGZR_RetWorkerDoc.FDM_TIME AS fDM_Time, v_BGZR_RetWorkerDoc.FDISCHARGETIME AS fDischargeTime, v_BGZR_RetWorkerDoc.FDOC_NAME AS fDoc_Name, v_BGZR_RetWorkerDoc.FDOC_NO AS fDoc_No, v_BGZR_RetWorkerDoc.FDOC_UID AS fDoc_Uid, v_BGZR_RetWorkerDoc.FDOC_WHERE AS fDoc_Where, v_BGZR_RetWorkerDoc.FEDU_DEGREE AS fEdu_Degree, v_BGZR_RetWorkerDoc.FEDU_FULLTIMEDEGREE AS fEdu_FullTimeDegree, v_BGZR_RetWorkerDoc.FEDU_HIGHESTDATE AS fEdu_HighestDate, v_BGZR_RetWorkerDoc.FEDU_PARTTIMEDEGREE AS fEdu_PartTimeDegree, v_BGZR_RetWorkerDoc.FFIRSTINSTIME AS fFirstInsTime, v_BGZR_RetWorkerDoc.FGOVSUB_EXPERTTITLE AS fGovSub_ExpertTitle, v_BGZR_RetWorkerDoc.FGOVSUB_IS AS fGovSub_Is, v_BGZR_RetWorkerDoc.FGOVSUB_TIME AS fGovSub_Time, v_BGZR_RetWorkerDoc.FHAND_MEMO AS fHand_Memo, v_BGZR_RetWorkerDoc.FHAND_SIT AS fHand_Sit, v_BGZR_RetWorkerDoc.FHID AS fHid, v_BGZR_RetWorkerDoc.FHOMEADDRESS AS fHomeAddress, v_BGZR_RetWorkerDoc.FINJURYTIME AS fInjuryTime, v_BGZR_RetWorkerDoc.FISANNUITY AS fIsAnnuity, v_BGZR_RetWorkerDoc.FLIVINGCONDITION AS fLivingCondition, v_BGZR_RetWorkerDoc.FNAME AS fName, v_BGZR_RetWorkerDoc.FNATION AS fNation, v_BGZR_RetWorkerDoc.FNATIVEPLACE AS fNativePlace, v_BGZR_RetWorkerDoc.FOLDUNITCODE AS fOldUnitCode, v_BGZR_RetWorkerDoc.FOLDUNITNAME AS fOldUnitName, v_BGZR_RetWorkerDoc.FORIGINALPOST AS fOriginalPost, v_BGZR_RetWorkerDoc.FOTHER_ARMYTOWORK AS fOther_ArmyToWork, v_BGZR_RetWorkerDoc.FOTHER_COUNTRYSIDETIME AS fOther_CountrysideTime, v_BGZR_RetWorkerDoc.FOTHER_DOCTOWORKDATE AS fOther_DocToWorkDate, v_BGZR_RetWorkerDoc.FOTHER_HOBBIES AS fOther_Hobbies, v_BGZR_RetWorkerDoc.FOTHER_ISCPPCCMEMBER AS fOther_IsCPPCCMember, v_BGZR_RetWorkerDoc.FOTHER_ISINJURY AS fOther_IsInjury, v_BGZR_RetWorkerDoc.FOTHER_ISMODELWORK AS fOther_IsModelWork, v_BGZR_RetWorkerDoc.FOTHER_ISNPCMEMBER AS fOther_IsNPCMember, v_BGZR_RetWorkerDoc.FOTHER_ISNUF AS fOther_IsNUF, v_BGZR_RetWorkerDoc.FOTHER_ISRELIGIOUS AS fOther_IsReligious, v_BGZR_RetWorkerDoc.FOTHER_ISREMOTEMED AS fOther_IsRemoteMed, v_BGZR_RetWorkerDoc.FOTHER_PLACEOFDOMICILE AS fOther_PlaceOfDomicile, v_BGZR_RetWorkerDoc.FOTHER_PLACEOFTIME AS fOther_PlaceOfTime, v_BGZR_RetWorkerDoc.FOTHER_SSCODE AS fOther_SSCode, v_BGZR_RetWorkerDoc.FOTHER_SSIDNUM AS fOther_SSIDNum, v_BGZR_RetWorkerDoc.FOTHER_WORKTYPE AS fOther_WorkType, v_BGZR_RetWorkerDoc.FPF_ACCOUNT AS fPF_Account, v_BGZR_RetWorkerDoc.FPF_CARDNO AS fPF_CardNo, v_BGZR_RetWorkerDoc.FPARTYREF_INTODATE AS fPartyRef_IntoDate, v_BGZR_RetWorkerDoc.FPARTYREF_INTOIS AS fPartyRef_IntoIs, v_BGZR_RetWorkerDoc.FPARTYREF_OUTDATE AS fPartyRef_OutDate, v_BGZR_RetWorkerDoc.FPARTYREF_PARTYDATE AS fPartyRef_PartyDate, v_BGZR_RetWorkerDoc.FPARTYREF_POLITICALSTATUS AS fPartyRef_PoliticalStatus, v_BGZR_RetWorkerDoc.FPOORSIT_CONFIRM AS fPoorSit_Confirm, v_BGZR_RetWorkerDoc.FPOORSIT_IS AS fPoorSit_Is, v_BGZR_RetWorkerDoc.FPOORSIT_TYPE AS fPoorSit_Type, v_BGZR_RetWorkerDoc.FRETPOST AS fRetPost, v_BGZR_RetWorkerDoc.FRETSTU_OUTCOUNTRY AS fRetStu_OutCountry, v_BGZR_RetWorkerDoc.FRETSTU_OUTTIME AS fRetStu_OutTime, v_BGZR_RetWorkerDoc.FRETSTU_RETTIME AS fRetStu_RetTime, v_BGZR_RetWorkerDoc.FRETTIME AS fRetTime, v_BGZR_RetWorkerDoc.FRETWORKTYPE AS fRetWorkType, v_BGZR_RetWorkerDoc.FSTW_NAMETIME AS fSTW_NameTime, v_BGZR_RetWorkerDoc.FSEX AS fSex, v_BGZR_RetWorkerDoc.FSORTID AS fSortID, v_BGZR_RetWorkerDoc.FSUPTIME AS fSupTime, v_BGZR_RetWorkerDoc.FTAIWAN_KMSIT AS fTaiWan_KMSit, v_BGZR_RetWorkerDoc.FTAIWAN_SIT AS fTaiWan_Sit, v_BGZR_RetWorkerDoc.FTAIWAN_FAM AS fTaiWan_fam, v_BGZR_RetWorkerDoc.FTEL AS fTel, v_BGZR_RetWorkerDoc.FTELCHILD AS fTelChild, v_BGZR_RetWorkerDoc.FTITLE AS fTitle, v_BGZR_RetWorkerDoc.FTITLETIME AS fTitleTime, v_BGZR_RetWorkerDoc.FTOWORKDATE AS fToWorkDate, v_BGZR_RetWorkerDoc.FUID AS fUid, v_BGZR_RetWorkerDoc.FUIDATTFILES AS fUidAttFiles, v_BGZR_RetWorkerDoc.FWORKERTYPE AS fWorkerType, v_BGZR_RetWorkerDoc.fID AS v_BGZR_RetWorkerDoc, v_BGZR_RetWorkerDoc.VERSION AS version FROM v_BGZR_RetWorkerDoc v_BGZR_RetWorkerDoc

复制出来是可以查询成功的。
回复 支持 反对

使用道具 举报

91

主题

13万

帖子

3万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
36067
发表于 2019-6-3 16:37:45 | 显示全部楼层
java.lang.IllegalArgumentException

参数不正确,看看是不是日期相关的字段设置有问题
远程的联系方法QQ1392416607,添加好友时,需在备注里注明其论坛名字及ID,公司等信息
发远程时同时也发一下帖子地址,方便了解要解决的问题  WeX5教程  WeX5下载



如按照该方法解决,请及时跟帖,便于版主结贴
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

小黑屋|手机版|X3技术论坛|Justep Inc.    

GMT+8, 2024-11-24 08:47 , Processed in 0.114977 second(s), 25 queries .

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表