|
|
| 版本: |
X5.2.5 |
小版本号: |
|
|
|
| 数据库: |
MS SQLServer |
服务器操作系统: |
Windows |
应用服务器: |
|
| 客户端操作系统: |
Windows 7 |
浏览器: |
IE9 |
|
|
添加人员时报如下错误Caused by: java.sql.SQLDataException: [FMWGEN][SQLServer JDBC Driver][SQLServer]操作数类型冲突: nvarchar 与 image 不兼容
求大神帮忙解决
com.justep.model.exception.ModelException: java.lang.reflect.InvocationTargetException
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.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:184)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3732)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.justep.system.action.Engine.invokeActions(Native Method)
... 22 more
Caused by: com.justep.model.exception.ModelException: 执行ksql:INSERT INTO SA_OPPerson SA_OPPerson(SA_OPPerson, SA_OPPerson.version, SA_OPPerson.sName, SA_OPPerson.sCode, SA_OPPerson.sIDCard, SA_OPPerson.sNumb, SA_OPPerson.sLoginName, SA_OPPerson.sPassword, SA_OPPerson.sPasswordTimeLimit, SA_OPPerson.sPasswordModifyTime, SA_OPPerson.sMainOrgID, SA_OPPerson.sSafeLevelID, SA_OPPerson.sSequence, SA_OPPerson.sValidState, SA_OPPerson.sDescription, SA_OPPerson.sPhoto, SA_OPPerson.sSex, SA_OPPerson.sBirthday, SA_OPPerson.sJoinDate, SA_OPPerson.sHomePlace, SA_OPPerson.sCountry, SA_OPPerson.sProvince, SA_OPPerson.sCity, SA_OPPerson.sDegree, SA_OPPerson.sGraduateSchool, SA_OPPerson.sSpeciality, SA_OPPerson.sSchoolLength, SA_OPPerson.sTitle, SA_OPPerson.sMarriage, SA_OPPerson.sCardNO, SA_OPPerson.sCardKind, SA_OPPerson.sFamilyAddress, SA_OPPerson.sZip, SA_OPPerson.sMsn, SA_OPPerson.sQQ, SA_OPPerson.sMail, SA_OPPerson.sMobilePhone, SA_OPPerson.sFamilyPhone, SA_OPPerson.sOfficePhone, SA_OPPerson.sEnglishName) VALUES (:SA_OPPerson, :version, :sName, :sCode, :sIDCard, :sNumb, :sLoginName, :sPassword, :sPasswordTimeLimit, :sPasswordModifyTime, :sMainOrgID, :sSafeLevelID, :sSequence, :sValidState, :sDescription, :sPhoto, :sSex, :sBirthday, :sJoinDate, :sHomePlace, :sCountry, :sProvince, :sCity, :sDegree, :sGraduateSchool, :sSpeciality, :sSchoolLength, :sTitle, :sMarriage, :sCardNO, :sCardKind, :sFamilyAddress, :sZip, :sMsn, :sQQ, :sMail, :sMobilePhone, :sFamilyPhone, :sOfficePhone, :sEnglishName)时出错！
at com.justep.system.data.impl.TableUtilsImplement.ksqlInsert(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlExecuteUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.KSQL.executeUpdate(Unknown Source)
at com.justep.system.data.impl.TableImpl.insert(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.data.impl.TableImpl.save(Unknown Source)
at com.justep.system.opm.api.PersonHelper.appendPersons(Unknown Source)
at com.justep.system.opm.api.PersonHelper.appendPersons(Unknown Source)
at OrgProcedure.saveOPPerson(OrgProcedure.java:198)
... 27 more
Caused by: com.justep.model.exception.ModelException: 执行sql：INSERT INTO SA_OPPerson (SA_OPPerson.sID, SA_OPPerson.VERSION, SA_OPPerson.SNAME, SA_OPPerson.SCODE, SA_OPPerson.SIDCARD, SA_OPPerson.SNUMB, SA_OPPerson.SLOGINNAME, SA_OPPerson.SPASSWORD, SA_OPPerson.SPASSWORDTIMELIMIT, SA_OPPerson.SPASSWORDMODIFYTIME, SA_OPPerson.SMAINORGID, SA_OPPerson.SSAFELEVELID, SA_OPPerson.SSEQUENCE, SA_OPPerson.SVALIDSTATE, SA_OPPerson.SDESCRIPTION, SA_OPPerson.SPHOTO, SA_OPPerson.SSEX, SA_OPPerson.SBIRTHDAY, SA_OPPerson.SJOINDATE, SA_OPPerson.SHOMEPLACE, SA_OPPerson.SCOUNTRY, SA_OPPerson.SPROVINCE, SA_OPPerson.SCITY, SA_OPPerson.SDEGREE, SA_OPPerson.SGRADUATESCHOOL, SA_OPPerson.SSPECIALITY, SA_OPPerson.SSCHOOLLENGTH, SA_OPPerson.STITLE, SA_OPPerson.SMARRIAGE, SA_OPPerson.SCARDNO, SA_OPPerson.SCARDKIND, SA_OPPerson.SFAMILYADDRESS, SA_OPPerson.SZIP, SA_OPPerson.SMSN, SA_OPPerson.SQQ, SA_OPPerson.SMAIL, SA_OPPerson.SMOBILEPHONE, SA_OPPerson.SFAMILYPHONE, SA_OPPerson.SOFFICEPHONE, SA_OPPerson.SENGLISHNAME) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), binds:[FD9E093F84F04258821FBF45BC96F442, 0, QQ, QQ, null, 104, null, E10ADC3949BA59ABBE56E057F20F883E, 90, 2013-12-11 16:16:12.758, 252A27B7AA724C4AB8B31DA744233A51, null, 0, 1, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null]出错！
at com.justep.system.ksql.KSQLUtils.execSqlUpdate(Unknown Source)
... 40 more
Caused by: java.sql.SQLDataException: [FMWGEN][SQLServer JDBC Driver][SQLServer]操作数类型冲突: nvarchar 与 image 不兼容
at weblogic.jdbc.sqlserverbase.ddb_.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb_.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.b(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddb9.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.v(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddq.a(Unknown Source)
at weblogic.jdbc.sqlserver.tds.ddr.a(Unknown Source)
at weblogic.jdbc.sqlserver.ddj.m(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.e(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.a(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.v(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddel.x(Unknown Source)
at weblogic.jdbc.sqlserverbase.ddde.executeUpdate(Unknown Source)
at weblogic.jdbc.wrapper.PreparedStatement.executeUpdate(PreparedStatement.java:172)
... 41 more
url:/UI/system/service/common/bizAction.j
param:/system/dataSA_OPPersonStringSA_OPPersonwhereVersionSA_OPPerson.sName,SA_OPPerson.sCode,SA_OPPerson.sIDCard,SA_OPPerson.sNumb,SA_OPPerson.sLoginName,SA_OPPerson.sPassword,SA_OPPerson.sPasswordTimeLimit,SA_OPPerson.sPasswordModifyTime,SA_OPPerson.sMainOrgID,SA_OPPerson.sSafeLevelID,SA_OPPerson.sSequence,SA_OPPerson.sValidState,SA_OPPerson.sDescription,SA_OPPerson.sPhoto,SA_OPPerson.sSex,SA_OPPerson.sBirthday,SA_OPPerson.sJoinDate,SA_OPPerson.sHomePlace,SA_OPPerson.sCountry,SA_OPPerson.sProvince,SA_OPPerson.sCity,SA_OPPerson.sDegree,SA_OPPerson.sGraduateSchool,SA_OPPerson.sSpeciality,SA_OPPerson.sSchoolLength,SA_OPPerson.sTitle,SA_OPPerson.sMarriage,SA_OPPerson.sCardNO,SA_OPPerson.sCardKind,SA_OPPerson.sFamilyAddress,SA_OPPerson.sZip,SA_OPPerson.sMsn,SA_OPPerson.sQQ,SA_OPPerson.sMail,SA_OPPerson.sMobilePhone,SA_OPPerson.sFamilyPhone,SA_OPPerson.sOfficePhone,SA_OPPerson.sEnglishName,SA_OPPerson.version,SA_OPOrg.sName,SA_OPOrg.sFID,SA_OPOrg.sFName,SA_OPOrg.sSequenceString,String,String,Integer,String,String,Integer,DateTime,String,String,Integer,Integer,String,Blob,String,Date,Date,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,String,Integer,String,String,String,StringsName,sCode,sIDCard,sNumb,sLoginName,sPassword,sPasswordTimeLimit,sPasswordModifyTime,sMainOrgID,sSafeLevelID,sSequence,sValidState,sDescription,sPhoto,sSex,sBirthday,sJoinDate,sHomePlace,sCountry,sProvince,sCity,sDegree,sGraduateSchool,sSpeciality,sSchoolLength,sTitle,sMarriage,sCardNO,sCardKind,sFamilyAddress,sZip,sMsn,sQQ,sMail,sMobilePhone,sFamilyPhone,sOfficePhone,sEnglishName,version,mainOrgName,mainOrgFID,mainOrgFName,mainOrgSequenceSA_OPPerson0SA_OPPersonSA_OPPersonwhereVersionnewQQQQ104E10ADC3949BA59ABBE56E057F20F883E902013-12-11T16%3A16%3A12.758Z252A27B7AA724C4AB8B31DA744233A51010 |
|
IP卡
狗仔卡
发表于 2013-12-11 16:34:28
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
发表于 2013-12-11 17:07:51
楼主
