当查不出数据的时候BizUtils.getRelationValue方法就会报错，为...

wgs7909

当查不出数据的时候BizUtils.getRelationValue方法就会报错，为什么 ？如果条件成立，可以查出数据的时候，就不报错了。

jishuang

把详细的错误信息发一下

wgs7909

就是图上的这些

wgs7909

jishuang 发表于 2015-3-31 14:18
把详细的错误信息发一下

1. 2015-03-31 14:38:22 [SQL Time]sql 执行时间：1ms, exec KSQL: select BizPartner.CName from BizPartner BizPartner  where ( BizPartner.fIsDel = 1 and BizPartner.CName = '1213') limit 0,1
   
2.   --> sql:(SELECT  BizPartner.CNAME AS CName FROM BIZPARTNER BizPartner  WHERE  (BizPartner.FISDEL = ?) AND (BizPartner.CNAME = ?) )
   
3. --> binds:[1, 1213]
   
4. 2015-03-31 14:38:22 action:<?xml version="1.0" encoding="UTF-8"?>
   
5. <action direct-execute="false" process="/agan_fina/BizPartner/process/partnerMgr/partnerMgrProcess" activity="mainActivity" action-flag="__action_0__" executor="" execute-context="" name="checkRepName"><parameters xmlns:xbiz="http://www.justep.com/xbiz#"><parameter name="name"><xbiz:simple type="http://www.w3.org/2001/XMLSchema#String"><![CDATA[1213]]></xbiz:simple></parameter></parameters></action>
   
6. java.lang.reflect.InvocationTargetException
   
7.         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   
8.         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   
9.         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   
10.         at java.lang.reflect.Method.invoke(Method.java:592)
    
11.         at com.justep.system.action.Engine.invokeActions(Native Method)
    
12.         at com.justep.system.action.Engine.invokeActions(Unknown Source)
    
13.         at com.justep.business.server.BusinessServer.doAction(Unknown Source)
    
14.         at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
    
15.         at com.justep.business.server.BusinessServer.excute(Unknown Source)
    
16.         at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
    
17.         at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
    
18.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    
19.         at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
    
20.         at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    
21.         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    
22.         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    
23.         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    
24.         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    
25.         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    
26.         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    
27.         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    
28.         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    
29.         at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
    
30.         at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    
31.         at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    
32.         at java.lang.Thread.run(Thread.java:595)
    
33. Caused by: java.lang.NullPointerException
    
34.         at Common.checkRepName(Common.java:185)
    
35.         ... 26 more
    
36. 2015-03-31 14:38:22 [SQL Time]sql 执行时间：1ms, exec KSQL: SELECT Person.*  FROM Person Person WHERE ((Person.fFID='DDD50E30AF5742D0B7CAC3FA077BAADB')) LIMIT 0, 20
    
37.   --> sql:(SELECT  Person.VERSION AS version, Person.FFID AS fFID, Person.FCNAME AS fCName, Person.FENAME AS fEName, Person.FCLIENTLICPSN AS fClientLicPsn, Person.FCEDULATYPE AS fCedulaType, Person.FCEDULANO AS fCedulaNo, Person.FSEX AS fSex, Person.FBIRTHDAY AS fBirthday, Person.FINHABITAGE AS fInhabitAge, Person.FNATION AS fNation, Person.FMARITALSTATUS AS fMaritalStatus, Person.FPHOTO AS fPhoto, Person.FMOBNO AS fMobNo, Person.FTELNO AS fTelNo, Person.FFAXNO AS fFaxNo, Person.FEMAIL AS fEmail, Person.FPOSTCODE AS fPostCode, Person.FBIRTHPLACE AS fBirthPlace, Person.FADDRESS AS fAddress, Person.FIDCARDA AS fIDCardA, Person.FIDCARDB AS fIDCardB, Person.FPOLITYSTATUS AS fPolityStatus, Person.ISMASTER AS IsMaster, Person.PSNNUM AS PsnNum, Person.FAMILYADDRESS AS FamilyAddress, Person.HOUSETYPE AS HouseType, Person.USEAREA AS UseArea, Person.FAMILYAFTERTAXINCOME AS FamilyAfterTaxIncome, Person.MAYUSEFUNDS AS MayUseFunds, Person.CREDITRECORD AS CreditRecord, Person.EDUCATIONEXPERIENCE AS EducationExperience, Person.WORKEXPERIENCE AS WorkExperience, Person.FISDEL AS fIsDel, Person.FCREATEPSNID AS fCreatePsnID, Person.FCREATEPSNNAME AS fCreatePsnName, Person.FCREATETIME AS fCreateTime, Person.FUPDATEPSNID AS fUpdatePsnID, Person.FUPDATEPSNNAME AS fUpdatePsnName, Person.FUPDATETIME AS fUpdateTime, Person.OPERATORS AS Operators, Person.ISLEGALPSN AS IsLegalPsn, Person.RELEVANTENTERPRISE AS RelevantEnterprise, Person.BIZPARTNERNO AS BizPartnerNo, Person.fID AS Person FROM PERSON Person  WHERE Person.FFID = ?)
    
38. --> binds:[DDD50E30AF5742D0B7CAC3FA077BAADB]
    
39. 2015-03-31 14:38:23 [SQL Time]sql 执行时间：0ms, exec KSQL:
    
40.   --> sql:SELECT count(*) FROM PERSON Person  WHERE Person.FFID = ?
    
41. --> binds:[DDD50E30AF5742D0B7CAC3FA077BAADB]
    
42. 2015-03-31 14:38:23 [SQL Time]sql 执行时间：4ms, exec KSQL: SELECT EnterpriseInfo.*  FROM EnterpriseInfo EnterpriseInfo WHERE ((EnterpriseInfo.fFID='DDD50E30AF5742D0B7CAC3FA077BAADB')) LIMIT 0, 20
    
43.   --> sql:(SELECT  EnterpriseInfo.VERSION AS version, EnterpriseInfo.FFID AS fFID, EnterpriseInfo.FENAME AS fEName, EnterpriseInfo.FFAXNO AS fFaxNo, EnterpriseInfo.FEMAIL AS fEmail, EnterpriseInfo.FPOSTCODE AS fPostCode, EnterpriseInfo.FADDRESS AS fAddress, EnterpriseInfo.FORGNATURE AS fOrgNature, EnterpriseInfo.ORGNAME AS OrgName, EnterpriseInfo.REGCAPITAL AS RegCapital, EnterpriseInfo.ORGSHORTNAME AS OrgShortName, EnterpriseInfo.TRADETYPE AS TradeType, EnterpriseInfo.ORGCODE AS OrgCode, EnterpriseInfo.LICENSECODE AS LicenseCode, EnterpriseInfo.CURRENCY AS Currency, EnterpriseInfo.TAXREGCODE AS TaxRegCode, EnterpriseInfo.CONTACT AS Contact, EnterpriseInfo.CONTACTMOBI AS ContactMobi, EnterpriseInfo.LEGALPERSON AS LegalPerson, EnterpriseInfo.LEGALPERSONID AS LegalPersonID, EnterpriseInfo.POSSESSIONNATURE AS PossessionNature, EnterpriseInfo.CORPAGE AS CorpAge, EnterpriseInfo.STAFFNUM AS StaffNum, EnterpriseInfo.MANAGEMENTPLACE AS ManagementPlace, EnterpriseInfo.AREA AS Area, EnterpriseInfo.LANDMEASURE AS Landmeasure, EnterpriseInfo.RENTAL AS Rental, EnterpriseInfo.IMPAEXPLIC AS IMPaEXPLic, EnterpriseInfo.OPERATIONCITY AS OperationCity, EnterpriseInfo.OPERATIONADDR AS OperationAddr, EnterpriseInfo.WEBSITE AS Website, EnterpriseInfo.PSNLEV AS PSNLev, EnterpriseInfo.PSNLICER AS PSNLicer, EnterpriseInfo.BIZLICSCAN AS BizLicScan, EnterpriseInfo.ORGCODESCAN AS OrgCodeScan, EnterpriseInfo.TAXREGSCAN AS TaxRegScan, EnterpriseInfo.LOANCARDSCAN AS LoanCardScan, EnterpriseInfo.FISDEL AS fIsDel, EnterpriseInfo.FCREATEOGNID AS fCreateOgnID, EnterpriseInfo.FCREATEOGNNAME AS fCreateOgnName, EnterpriseInfo.FCREATEDEPTID AS fCreateDeptID, EnterpriseInfo.FCREATEDEPTNAME AS fCreateDeptName, EnterpriseInfo.FCREATEPSNID AS fCreatePsnID, EnterpriseInfo.FCREATEPSNNAME AS fCreatePsnName, EnterpriseInfo.FCREATEPSNFID AS fCreatePsnFID, EnterpriseInfo.FCREATETIME AS fCreateTime, EnterpriseInfo.FUPDATEPSNID AS fUpdatePsnID, EnterpriseInfo.FUPDATEPSNNAME AS fUpdatePsnName, EnterpriseInfo.FUPDATETIME AS fUpdateTime, EnterpriseInfo.fID AS EnterpriseInfo FROM ENTERPRISEINFO EnterpriseInfo  WHERE EnterpriseInfo.FFID = ?)
    
44. --> binds:[DDD50E30AF5742D0B7CAC3FA077BAADB]
    
45. 2015-03-31 14:38:23 [SQL Time]sql 执行时间：0ms, exec KSQL:
    
46.   --> sql:SELECT count(*) FROM ENTERPRISEINFO EnterpriseInfo  WHERE EnterpriseInfo.FFID = ?
    
47. --> binds:[DDD50E30AF5742D0B7CAC3FA077BAADB]

复制代码

wgs7909

jishuang 发表于 2015-3-31 14:18
把详细的错误信息发一下

急啊！上火啊！

jishuang

报错的地方

wgs7909

jishuang 发表于 2015-3-31 16:16
报错的地方

这个我知道，可是我的语句没有错的

wgs7909

jishuang 发表于 2015-3-31 16:16
报错的地方

你看最顶楼的图片，如果有数据的时候是不报错的，没有数据的时候才会报错呢。

jishuang

那就是判断不对啊，有数据的时候走的else了

java调试看看没有数据的时候那个函数返回的什么啊

wgs7909

jishuang 发表于 2015-3-31 16:47
那就是判断不对啊，有数据的时候走的else了

java调试看看没有数据的时候那个函数返回的什么啊 ...

关键是运行时在报错啊！虚拟机报错啦