|
|
做了一个dialog单选框，smartFilter搜索框有时报错。如图一，只搜索“南京”两个字，正常。图二，搜索“南京皓”三个字就报错。smartFilter关联的三个字段都是string的。后台报错，Caused by: java.sql.SQLException: 无法转换为内部表示java.lang.reflect.InvocationTargetException at sun.reflect.GeneratedMethodAccessor151.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.justep.system.action.Engine.invokeActions(Native Method)
at com.justep.system.action.Engine.invokeActions(Unknown Source)
at com.justep.business.server.BusinessServer.doAction(Unknown Source)
at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:745)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT PUR_CONTRACTOR_ADD.* FROM PUR_CONTRACTOR_ADD PUR_CONTRACTOR_ADD WHERE ((PUR_CONTRACTOR_ADD.ProDeptValidityDate > :toDate('2017-9-26') and PUR_CONTRACTOR_ADD.processStatus='0' ) AND ((upper(PUR_CONTRACTOR_ADD.ContractorCode) LIKE '%南京皓%') OR (upper(PUR_CONTRACTOR_ADD.ContractorName) LIKE '%南京皓%') OR (upper(PUR_CONTRACTOR_ADD.ContractorAttributes) LIKE '%南京皓%'))) LIMIT 0, 20
--> sql: SELECT PUR_CONTRACTOR_ADD.APPLYDATE AS ApplyDate, PUR_CONTRACTOR_ADD.APPLYPERSON AS ApplyPerson, PUR_CONTRACTOR_ADD.APPLYREASON AS ApplyReason, PUR_CONTRACTOR_ADD.BESELECTEDDATE AS BeSelectedDate, PUR_CONTRACTOR_ADD.BESELECTEDMAJOR AS BeSelectedMajor, PUR_CONTRACTOR_ADD.BUSINESSSCOPE AS BusinessScope, PUR_CONTRACTOR_ADD.CATEGORY AS CATEGORY, PUR_CONTRACTOR_ADD.CONTACT_PHONE AS CONTACT_PHONE, PUR_CONTRACTOR_ADD.CITY AS City, PUR_CONTRACTOR_ADD.CONTACTNUMBER AS ContactNumber, PUR_CONTRACTOR_ADD.CONTRACTORATTRIBUTES AS ContractorAttributes, PUR_CONTRACTOR_ADD.CONTRACTORCODE AS ContractorCode, PUR_CONTRACTOR_ADD.CONTRACTORNAME AS ContractorName, PUR_CONTRACTOR_ADD.CONTRACTORSTATUS AS ContractorStatus, PUR_CONTRACTOR_ADD.CONTRACTORSTATUSNAME AS ContractorStatusName, PUR_CONTRACTOR_ADD.COOPERATECOMMITMENT AS CooperateCommitment, PUR_CONTRACTOR_ADD.COOPERATETYPE AS CooperateType, PUR_CONTRACTOR_ADD.COOPERATETYPENAME AS CooperateTypeName, PUR_CONTRACTOR_ADD.CREDITCODE AS CreditCode, PUR_CONTRACTOR_ADD.CUSTOMERCLASS AS CustomerClass, PUR_CONTRACTOR_ADD.CUSTOMERCLASSNAME AS CustomerClassName, PUR_CONTRACTOR_ADD.CUSTOMERGROUP AS CustomerGroup, PUR_CONTRACTOR_ADD.CUSTOMERGROUPCODE AS CustomerGroupCode, PUR_CONTRACTOR_ADD.ESTABLISHYEAR AS EstablishYear, PUR_CONTRACTOR_ADD.EVIDENCEATTACHMENT AS EvidenceAttachment, PUR_CONTRACTOR_ADD.LEGALREPRESENTATIVE AS LegalRepresentative, PUR_CONTRACTOR_ADD.LOANINGABILITY AS LoaningAbility, PUR_CONTRACTOR_ADD.OFFICESPACE AS OfficeSpace, PUR_CONTRACTOR_ADD.ORGCODE AS OrgCode, PUR_CONTRACTOR_ADD.OTHERMETA AS OtherMeta, PUR_CONTRACTOR_ADD.fID AS PUR_CONTRACTOR_ADD, PUR_CONTRACTOR_ADD.POSTALCODE AS PostalCode, PUR_CONTRACTOR_ADD.PRODEPTVALIDITYDATE AS ProDeptValidityDate, PUR_CONTRACTOR_ADD.PROVINCE AS Province, PUR_CONTRACTOR_ADD.PURATTACH AS PurAttach, PUR_CONTRACTOR_ADD.PURDEPTVALIDITYDATE AS PurDeptValidityDate, PUR_CONTRACTOR_ADD.QUALIFICATIONSTATUS AS QualificationStatus, PUR_CONTRACTOR_ADD.REFEREE AS Referee, PUR_CONTRACTOR_ADD.REGCAPITAL AS RegCapital, PUR_CONTRACTOR_ADD.REGCAPITALUNIT AS RegCapitalUnit, PUR_CONTRACTOR_ADD.REGISTEREDADDRESS AS RegisteredAddress, PUR_CONTRACTOR_ADD.REGISTEREDCAPITAL AS RegisteredCapital, PUR_CONTRACTOR_ADD.RELEVANTMATE AS RelevantMate, PUR_CONTRACTOR_ADD.REMARK AS Remark, PUR_CONTRACTOR_ADD.SUBCATEGORY AS SubCategory, PUR_CONTRACTOR_ADD.SUBCOST AS SubCost, PUR_CONTRACTOR_ADD.SUBPRICE AS SubPrice, PUR_CONTRACTOR_ADD.TAX_REGISTRATION_NO AS TAX_REGISTRATION_NO, PUR_CONTRACTOR_ADD.TAXREGCERTIFICATE AS TaxRegCertificate, PUR_CONTRACTOR_ADD.TAXPAYERNUMBER AS TaxpayerNumber, PUR_CONTRACTOR_ADD.APPLYDEPT AS applyDept, PUR_CONTRACTOR_ADD.BECHANGEID AS beChangeID, PUR_CONTRACTOR_ADD.CITY_CODE AS city_code, PUR_CONTRACTOR_ADD.EXECUTIVESATTACH AS executivesAttach, PUR_CONTRACTOR_ADD.FACCOUNTGROUP AS fAccountGroup, PUR_CONTRACTOR_ADD.FACTIVITY AS fActivity, PUR_CONTRACTOR_ADD.FACTIVITYNAME AS fActivityName, PUR_CONTRACTOR_ADD.FBUSINESSATTACHMENT AS fBusinessAttachment, PUR_CONTRACTOR_ADD.FBUSINESSNUM AS fBusinessNum, PUR_CONTRACTOR_ADD.FCOOPERATEAREA AS fCooperateArea, PUR_CONTRACTOR_ADD.FCREATEDEPTCODE AS fCreateDeptCode, PUR_CONTRACTOR_ADD.FCREATEDEPTID AS fCreateDeptID, PUR_CONTRACTOR_ADD.FCREATEDEPTNAME AS fCreateDeptName, PUR_CONTRACTOR_ADD.FCREATEPERSON AS fCreatePerson, PUR_CONTRACTOR_ADD.FCREATEPERSONCODE AS fCreatePersonCode, PUR_CONTRACTOR_ADD.FCREATEPERSONFID AS fCreatePersonFID, PUR_CONTRACTOR_ADD.FCREATEPERSONID AS fCreatePersonID, PUR_CONTRACTOR_ADD.FCREATETIME AS fCreateTime, PUR_CONTRACTOR_ADD.FCREDITATTACHMENT AS fCreditAttachment, PUR_CONTRACTOR_ADD.FCREDITCODE AS fCreditCode, PUR_CONTRACTOR_ADD.FCUSTOMERTYPE AS fCustomerType, PUR_CONTRACTOR_ADD.FDELFALG AS fDelFalg, PUR_CONTRACTOR_ADD.FEXECUTORPERSONNAME AS fExecutorPersonName, PUR_CONTRACTOR_ADD.FORGATTACHMENT AS fOrgAttachment, PUR_CONTRACTOR_ADD.FPAPERSIGNATURETAG AS fPaperSignatureTag, PUR_CONTRACTOR_ADD.FPROCESSID AS fProcessID, PUR_CONTRACTOR_ADD.FRELATEDPARTY AS fRelatedParty, PUR_CONTRACTOR_ADD.FRELATEDPARTYNAME AS fRelatedPartyName, PUR_CONTRACTOR_ADD.FTASKID AS fTaskID, PUR_CONTRACTOR_ADD.FTAXATTACHMENT AS fTaxAttachment, PUR_CONTRACTOR_ADD.FTRADE AS fTrade, PUR_CONTRACTOR_ADD.FTYPE AS fType, PUR_CONTRACTOR_ADD.FTYPEID AS fTypeID, PUR_CONTRACTOR_ADD.FUNITPROPERTY AS fUnitProperty, PUR_CONTRACTOR_ADD.FUPDATETIME AS fUpdateTime, PUR_CONTRACTOR_ADD.ISBLOCKING AS isBlocking, PUR_CONTRACTOR_ADD.ISFRAMECONTRACTSIGNED AS isFrameContractSigned, PUR_CONTRACTOR_ADD.ISFRAMECONTRACTSIGNEDNAME AS isFrameContractSignedName, PUR_CONTRACTOR_ADD.ISINONE AS isInOne, PUR_CONTRACTOR_ADD.PRJMODE AS prjMode, PUR_CONTRACTOR_ADD.PRJNAME AS prjName, PUR_CONTRACTOR_ADD.PRJNO AS prjNo, PUR_CONTRACTOR_ADD.PROCESSSTATUS AS processStatus, PUR_CONTRACTOR_ADD.PROVINCE_CODE AS province_code, PUR_CONTRACTOR_ADD.RECORDATTA AS recordAtta, PUR_CONTRACTOR_ADD.REGISTERID AS registerID, PUR_CONTRACTOR_ADD.SHORTNAME AS shortName, PUR_CONTRACTOR_ADD.STATUS_C AS status_c, PUR_CONTRACTOR_ADD.VERSION AS version FROM PUR_CONTRACTOR_ADD PUR_CONTRACTOR_ADD WHERE ( (PUR_CONTRACTOR_ADD.PRODEPTVALIDITYDATE > ? ) AND (PUR_CONTRACTOR_ADD.PROCESSSTATUS = ?) ) AND ( (UPPER(PUR_CONTRACTOR_ADD.CONTRACTORCODE) LIKE ?) OR (UPPER(PUR_CONTRACTOR_ADD.CONTRACTORNAME) LIKE ?) OR (UPPER(PUR_CONTRACTOR_ADD.CONTRACTORATTRIBUTES) LIKE ?) )
--> binds: [2017-09-26, 0, %南京皓%, %南京皓%, %南京皓%]
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:12)
... 26 more
Caused by: java.sql.SQLException: 无法转换为内部表示
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.CharCommonAccessor.getBigDecimal(CharCommonAccessor.java:341)
at oracle.jdbc.driver.OracleResultSetImpl.getBigDecimal(OracleResultSetImpl.java:1543)
at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getBigDecimal(DelegatingResultSet.java:340)
at org.apache.tomcat.dbcp.dbcp.DelegatingResultSet.getBigDecimal(DelegatingResultSet.java:340)
at com.justep.system.data.impl.TableUtilsImplement.fillRow(Unknown Source)
... 31 more
|
|
IP卡
狗仔卡
发表于 2017-9-26 09:43:15
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
楼主
发表于 2017-9-26 11:43:17
