java.lang.ClassCastException: oracle.sql.CLOB cannot be cast to oracle.sql.CLOB

时间:2021-10-15 21:14:14

错误现象:

[framework] 2016-05-26 11:34:53,590 -INFO  [http-bio-8080-exec-7] -1231863 -com.dhcc.base.db.DBLink  - sql=select metadata from map_metadata_format where pid='agme.asm.bcgz.57989' and format_id='iso19139' and FORMAT_ORIGIN='test20160526' for update
[framework] 2016-05-26 11:35:01,471 -ERROR [http-bio-8080-exec-7] -1239744 -com.dhcc.ftpHarvester.HarvesterAction  - java.lang.ClassCastException: oracle.sql.CLOB cannot be cast to oracle.sql.CLOB
    at com.dhcc.ftpHarvester.HarvesterAction.harvest_File(HarvesterAction.java:280)
    at com.dhcc.ftpHarvester.HarvesterAction.dirHarvest(HarvesterAction.java:167)
    at com.dhcc.ftpHarvester.HarvesterAction.harvest(HarvesterAction.java:137)
    at com.dhcc.ftpHarvester.HarvesterAction.harvest(HarvesterAction.java:101)
    at com.dhcc.ftpHarvester.HarvesterAction.execute(HarvesterAction.java:62)
    at com.dhcc.base.mvc.servlet.ActionServlet.service(ActionServlet.java:299)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:171)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:953)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1023)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:589)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    at java.lang.Thread.run(Thread.java:745)

原因:web项目lib下的ojdbc14.jar和tomcat  lib下的ojdbc14.jar冲突。