【结贴】升级包出现许多插入值过大，我们用的是UTF8字符集数据库**

etqxq · 发表于 2008-9-11 16:31:10

通过升级程序upgrade.exe升级TOMCAT里面出现许多插入列值过大，因为我们是UTF8数据库，若数据类型为VARCHAR2的话，输入中文过多就会出现值过大，因为GB2312与UTF8对于中文字的算法不一样，我们怎么解决呀？？？

etqxq · 发表于 2008-9-11 16:32:49

还请问一下，升级有没有升级日志

etqxq · 发表于 2008-9-11 16:36:35

nt.java:2709)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:589)
      at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate
(DelegatingPreparedStatement.java:101)
      at com.justep.service.database.update.UpdateResolver.updateOperate(Unkno
wn Source)
      at com.justep.service.database.update.UpdateResolver.updateRecord(Unknow
n Source)
      at com.justep.service.database.update.UpdateResolver.applyUpdates(Unknow
n Source)
      at com.justep.service.database.update.UpdateSQLResolver.applyUpdates(Unk
nown Source)
      at com.justep.service.database.update.Updater.applyUpdates(Unknown Sourc
e)
      at com.justep.service.action.database.ApplyUpdatesAction.doExecute(Unkno
wn Source)
      at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
      at com.justep.service.action.base.BatchCallAction.innerExec(Unknown Sour
ce)
      at com.justep.service.action.base.BatchCallAction.execute(Unknown Source
)
      at com.justep.service.BizServiceImp.execute(Unknown Source)
      at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
      at com.justep.hessian.HessianServlet.service(Unknown Source)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
      at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
      at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
      at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
      at java.lang.Thread.run(Thread.java:595)
CommandText: select * from TFILESYSTEM where FGUID = 'C1201F589A9945AAA5D7BA76FE
B79C2C' and FPATH = '\COLLABORATION\COMMONRESFOLDER\' and FID = 'XPSTYLEICONLIB'
and FKIND ='.LIBRARY'
java.lang.Exception: error occur during invoke ApplyUpdates method, ORA-00001:
违反唯一约束条件 (QBXX.TFILESYSTEM_FULLNAMEUNIQUE)

      at com.justep.service.action.database.ApplyUpdatesAction.doExecute(Unkno
wn Source)
      at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
      at com.justep.service.action.base.BatchCallAction.innerExec(Unknown Sour
ce)
      at com.justep.service.action.base.BatchCallAction.execute(Unknown Source
)
      at com.justep.service.BizServiceImp.execute(Unknown Source)
      at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
      at com.justep.hessian.HessianServlet.service(Unknown Source)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
      at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
      at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
      at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
      at java.lang.Thread.run(Thread.java:595)
2008-9-11 16:33:21 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: invoke batch method error, error occur during invoke
ApplyUpdates method, ORA-00001: 违反唯一约束条件 (QBXX.TFILESYSTEM_FULLNAMEUNIQU
E)

java.lang.Exception: invoke batch method error, error occur during invoke ApplyU
pdates method, ORA-00001: 违反唯一约束条件 (QBXX.TFILESYSTEM_FULLNAMEUNIQUE)

      at com.justep.service.action.base.BatchCallAction.innerExec(Unknown Sour
ce)
      at com.justep.service.action.base.BatchCallAction.execute(Unknown Source
)
      at com.justep.service.BizServiceImp.execute(Unknown Source)
      at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
      at com.justep.hessian.HessianServlet.service(Unknown Source)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
      at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
      at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
      at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
      at java.lang.Thread.run(Thread.java:595)
java.sql.SQLException: ORA-00001: 违反唯一约束条件 (QBXX.TFILESYSTEM_FULLNAMEUNI
QUE)

      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2321)
      at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1741)
      at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1902)

      at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja
va:2047)
      at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
a:1940)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2709)
      at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:589)
      at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate
(DelegatingPreparedStatement.java:101)
      at com.justep.service.database.update.UpdateResolver.updateOperate(Unkno
wn Source)
      at com.justep.service.database.update.UpdateResolver.updateRecord(Unknow
n Source)
      at com.justep.service.database.update.UpdateResolver.applyUpdates(Unknow
n Source)
      at com.justep.service.database.update.UpdateSQLResolver.applyUpdates(Unk
nown Source)
      at com.justep.service.database.update.Updater.applyUpdates(Unknown Sourc
e)
      at com.justep.service.action.database.ApplyUpdatesAction.doExecute(Unkno
wn Source)
      at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
      at com.justep.service.action.base.BatchCallAction.innerExec(Unknown Sour
ce)
      at com.justep.service.action.base.BatchCallAction.execute(Unknown Source
)
      at com.justep.service.BizServiceImp.execute(Unknown Source)
      at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
      at com.justep.hessian.HessianServlet.service(Unknown Source)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
      at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
      at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
      at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
      at java.lang.Thread.run(Thread.java:595)
CommandText: select * from TFILESYSTEM where FGUID = '16B75A77AF324C4C84F5B866A8
9E7F43' and FPATH = '\COLLABORATION\TASKFOLDER\' and FID = 'TASKCENTERINFO' and
FKIND ='.INFO'
java.lang.Exception: error occur during invoke ApplyUpdates method, ORA-00001:
违反唯一约束条件 (QBXX.TFILESYSTEM_FULLNAMEUNIQUE)

      at com.justep.service.action.database.ApplyUpdatesAction.doExecute(Unkno
wn Source)
      at com.justep.service.action.base.SQLAction.doExec(Unknown Source)
      at com.justep.service.action.base.BatchCallAction.innerExec(Unknown Sour
ce)
      at com.justep.service.action.base.BatchCallAction.execute(Unknown Source
)
      at com.justep.service.BizServiceImp.execute(Unknown Source)
      at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
      at com.justep.hessian.HessianServlet.service(Unknown Source)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
      at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
      at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
      at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
      at java.lang.Thread.run(Thread.java:595)
2008-9-11 16:35:09 com.caucho.hessian.server.HessianSkeleton invoke
警告: java.lang.Exception: invoke batch method error, error occur during invoke
ApplyUpdates method, ORA-00001: 违反唯一约束条件 (QBXX.TFILESYSTEM_FULLNAMEUNIQU
E)

java.lang.Exception: invoke batch method error, error occur during invoke ApplyU
pdates method, ORA-00001: 违反唯一约束条件 (QBXX.TFILESYSTEM_FULLNAMEUNIQUE)

      at com.justep.service.action.base.BatchCallAction.innerExec(Unknown Sour
ce)
      at com.justep.service.action.base.BatchCallAction.execute(Unknown Source
)
      at com.justep.service.BizServiceImp.execute(Unknown Source)
      at sun.reflect.GeneratedMethodAccessor122.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces
sorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at com.caucho.hessian.server.HessianSkeleton.invoke(HessianSkeleton.java
:157)
      at com.justep.hessian.HessianServlet.service(Unknown Source)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
icationFilterChain.java:252)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
ilterChain.java:173)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
alve.java:213)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
alve.java:178)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
ava:126)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
ava:105)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
ve.java:107)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
a:148)
      at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcesso
r.java:831)
      at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.pr
ocess(Http11AprProtocol.java:652)
      at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:12
03)
      at java.lang.Thread.run(Thread.java:595)

etqxq · 发表于 2008-9-11 16:47:12

这就应该是那个字符集问题，我们在换成UTF8时也遇到这种情况，我们把它修改成NVARCHAR或都把长度修改大一些，

jiahaiming · 发表于 2008-9-11 16:48:16

这日志不对啊，都是违反唯一性约束的错误。

jiahaiming · 发表于 2008-9-11 16:48:55

请提供服务端的错误信息和升级程序的错误信息。

jiahaiming · 发表于 2008-9-11 16:49:22

包括：出现错误的表的结构说明。

etqxq · 发表于 2008-9-11 16:53:35

还没有升级完，前面出现过过大的情况，复制不到了

jiahaiming · 发表于 2008-9-11 17:22:42

服务端的日志可以在tomcat的日志文件里找。

另外请提供文件系统相关表的结构。

etqxq · 发表于 2008-9-19 17:04:05

对业务模型\协同系统\协同数据库\系统\通用编码表(BIZ2:\COLLABORATION\COLLABORATION.DATABASE\SYSTEMFOLDER\TCOMMONCODE.TABLE) 执行数据迁移任务时发生了错误。错误信息: 错误类型：Exception
错误信息：建表错误: 在数据表TCOMMONCODE和TCOMMONCODE_JBCK0间进行数据迁移出错, SQL: INSERT INTO TCOMMONCODE (FCODE,FSCOPE,FPARENTCODE,FCONTENT,FDESCRIPTION,FSequence) SELECT FCODE,FSCOPE,FPARENTCODE,FCONTENT,FDESCRIPTION,FSequence FROM TCOMMONCODE_JBCK0 ; info: ExecuteSQL error: ORA-01401: 插入的值对于列过大

		自动登录	找回密码
密码			立即注册

【结贴】升级包出现许多插入值过大，我们用的是UTF8字符集数据库**

部分错误信息

插入列值过大