|
版本: |
BeX5V3.5 |
小版本号: |
|
|
|
数据库: |
Oracle |
服务器操作系统: |
Windows |
应用服务器: |
Tomcat |
客户端操作系统: |
Windows 其它 |
浏览器: |
Chrome |
|
|
person表自增了一些字段,数据库执行语句正常,新增加的queryaciton测试报错,是因为数据的问题么?、
以下是报错信息:
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: select SA_OPPerson.* from SA_OPPerson SA_OPPerson LIMIT 0, 50
--> sql: SELECT SA_OPPerson.sID AS SA_OPPerson, SA_OPPerson.SNAME AS sName, SA_OPPerson.SCODE AS sCode, SA_OPPerson.SIDCARD AS sIDCard, SA_OPPerson.SNUMB AS sNumb, SA_OPPerson.SLOGINNAME AS sLoginName, SA_OPPerson.SPASSWORD AS sPassword, SA_OPPerson.SPASSWORDTIMELIMIT AS sPasswordTimeLimit, SA_OPPerson.SPASSWORDMODIFYTIME AS sPasswordModifyTime, SA_OPPerson.SMAINORGID AS sMainOrgID, SA_OPPerson.SSAFELEVELID AS sSafeLevelID, SA_OPPerson.SSEQUENCE AS sSequence, SA_OPPerson.SVALIDSTATE AS sValidState, SA_OPPerson.SDESCRIPTION AS sDescription, SA_OPPerson.SPHOTO AS sPhoto, SA_OPPerson.SPHOTOLASTMODIFIED AS sPhotoLastModified, SA_OPPerson.SSEX AS sSex, SA_OPPerson.SBIRTHDAY AS sBirthday, SA_OPPerson.SJOINDATE AS sJoinDate, SA_OPPerson.SHOMEPLACE AS sHomePlace, SA_OPPerson.SCOUNTRY AS sCountry, SA_OPPerson.SPROVINCE AS sProvince, SA_OPPerson.SCITY AS sCity, SA_OPPerson.SDEGREE AS sDegree, SA_OPPerson.SGRADUATESCHOOL AS sGraduateSchool, SA_OPPerson.SSPECIALITY AS sSpeciality, SA_OPPerson.SSCHOOLLENGTH AS sSchoolLength, SA_OPPerson.STITLE AS sTitle, SA_OPPerson.SMARRIAGE AS sMarriage, SA_OPPerson.SCARDNO AS sCardNO, SA_OPPerson.SCARDKIND AS sCardKind, SA_OPPerson.SFAMILYADDRESS AS sFamilyAddress, SA_OPPerson.SZIP AS sZip, SA_OPPerson.SMSN AS sMsn, SA_OPPerson.SQQ AS sQQ, SA_OPPerson.SMAIL AS sMail, SA_OPPerson.SMOBILEPHONE AS sMobilePhone, SA_OPPerson.SFAMILYPHONE AS sFamilyPhone, SA_OPPerson.SOFFICEPHONE AS sOfficePhone, SA_OPPerson.SENGLISHNAME AS sEnglishName, SA_OPPerson.VERSION AS version, SA_OPPerson.SPOSITIONNAME AS sPositionName, SA_OPPerson.SPOSITIONLEVEL AS sPositionLevel, SA_OPPerson.SPOSISTARTDATE AS sPosiStartDate, SA_OPPerson.STITLELEVEL AS sTitleLevel, SA_OPPerson.STITLEDATE AS sTitleDate, SA_OPPerson.STITLENAME_PY AS sTitleName_PY, SA_OPPerson.STITLELEVEL_PY AS sTitleLevel_PY, SA_OPPerson.SPOSTRANK AS sPostRank, SA_OPPerson.SSPECIALITYTYPE AS sSpecialityType, SA_OPPerson.SPOLITICALSTATUS AS sPoliticalStatus, SA_OPPerson.SCODECW_WL AS sCodeCW_WL, SA_OPPerson.SSCHOOL AS sSchool, SA_OPPerson.SPOSITIONS AS sPositions, SA_OPPerson.SSTUDY AS sStudy, SA_OPPerson.SNATION AS sNation, SA_OPPerson.SPARTYZW AS sPartyZW, SA_OPPerson.SGHNZW AS sGHNZW, SA_OPPerson.SROOMNO AS sRoomNo FROM SA_OPPerson SA_OPPerson
--> 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.KSQL.select(Unknown Source)
at KSQLProcedure.query(KSQLProcedure.java:17)
... 27 more
Caused by: java.lang.IllegalArgumentException
at java.sql.Date.valueOf(Date.java:143)
at oracle.jdbc.driver.CharCommonAccessor.getDate(CharCommonAccessor.java:410)
at oracle.jdbc.driver.OracleResultSetImpl.getDate(OracleResultSetImpl.java:737)
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
|
|