DocHelper.uploadDoc调用报错

zhang_xf

String str = DocHelper.uploadDoc(attpo.getFilename(), sysData.downfile(attpo.getFileurl(), null), "/文档中心");
java层执行文件上传的时候报错，发现后台有个字段时clob类型，平台的数据库字段设计的String类型，这个改怎么解决，执行下列语句的时候
SELECT  SA_DocNode.sID, SA_DocNode.sParentID AS sParentID, SA_DocNode.SDOCNAME AS sDocName, SA_DocNode.SSEQUENCE AS sSequence, SA_DocNode.SSIZE AS sSize, SA_DocNode.SKIND AS sKind, SA_DocNode.SDOCPATH AS sDocPath, SA_DocNode.SDOCDISPLAYPATH AS sDocDisplayPath, SA_DocNode.SCREATORFID AS sCreatorFID, SA_DocNode.SCREATORNAME AS sCreatorName, SA_DocNode.SCREATORDEPTNAME AS sCreatorDeptName, SA_DocNode.SCREATETIME AS sCreateTime, SA_DocNode.SEDITORFID AS sEditorFID, SA_DocNode.SEDITORNAME AS sEditorName, SA_DocNode.SEDITORDEPTNAME AS sEditorDeptName, SA_DocNode.SLASTWRITERFID AS sLastWriterFID, SA_DocNode.SLASTWRITERNAME AS sLastWriterName, SA_DocNode.SLASTWRITERDEPTNAME AS sLastWriterDeptName, SA_DocNode.SLASTWRITETIME AS sLastWriteTime, SA_DocNode.SFILEID AS sFileID, SA_DocNode.SDESCRIPTION AS sDescription, SA_DocNode.SDOCLIVEVERSIONID AS sDocLiveVersionID, SA_DocNode.VERSION AS version, SA_DocNode.SFINISHTIME AS sFinishTime, SA_DocNode.SCLASSIFICATION AS sClassification, SA_DocNode.SKEYWORDS AS sKeywords, SA_DocNode.SDOCSERIALNUMBER AS sDocSerialNumber, SA_DocNode.SNAMESPACE AS sNameSpace, SA_DocNode.SFLAG AS sFlag, SA_DocNode.SCACHENAME AS sCacheName, SA_DocNode.SREVISIONCACHENAME AS sRevisionCacheName FROM SA_DocNode SA_DocNode  WHERE  (? = ?) AND (SA_DocNode.SFLAG = ?) AND (SA_DocNode.SDOCDISPLAYPATH = ?) AND (SA_DocNode.SKIND = ?) , binds: [1, 1, 1, -, dir]

jishuang

平台默认的就是String类型的，确认不是自己修改了数据库的字段类型

zhang_xf

jishuang 发表于 2018-3-30 13:55
平台默认的就是String类型的，确认不是自己修改了数据库的字段类型

肯定没人改，我们系统的数据库是从3.0版本刚发布的时候在用了，我们是最早用3.0版本的，会不会版本升级后部分数据库修改了，再者，我打开3.7版本的自带数据库中的字段也不是string类型的，是text类型的

zhang_xf

jishuang 发表于 2018-3-30 13:55
平台默认的就是String类型的，确认不是自己修改了数据库的字段类型

中间做过数据库的升级

jishuang

1.java中上传文件参考http://bbs.wex5.com/forum.php?mo ... &extra=page%3D1
2.现在的版本中oracle中默认是clob，mysql中默认的是text
  概念中定义的是String

zhang_xf

jishuang 发表于 2018-3-30 15:08
1.java中上传文件参考http://bbs.wex5.com/forum.php?mod=viewthread&tid=40457&extra=page%3D1
2.现在的版 ...

但是oracle中如果是clob的话会报错怎么办

jishuang

上传文件参考5楼发API，不要用你现在使用的API