sql查询clob字段报错问题

最新推荐文章于 2024-04-20 22:11:49 发布

东臣

最新推荐文章于 2024-04-20 22:11:49 发布

阅读量3.7k

点赞数

CC 4.0 BY-SA版权

分类专栏：查询文章标签： sql查询Clob

本文链接：https://blog.youkuaiyun.com/weixin_43355560/article/details/86086936

查询专栏收录该内容

1 篇文章

订阅专栏

在尝试使用SQL查询包含Clob字段的数据时，遇到序列化错误，具体为No serializer found for class oracle.jdbc.driver.OracleClobReader。解决办法是使用Oracle的dbms_lob.substr方法处理Clob字段，例如`select dbms_lob.substr(clobField) from table`。若内容输出不全，可设置`set heading off`和`set long 40000`来调整输出。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

报错：
org.springframework.http.converter.HttpMessageNotWritableException: Could not write content: No serializer found for class oracle.jdbc.driver.OracleClobReader and no properties discovered to create BeanSerializer (to avoid exception, disable SerializationFeature.FAIL_ON_EMPTY_BEANS) (through reference chain: com.dzqc.campus.common.dto.AjaxResult[“data”]->com.dzqc.campus.common.entity.PageModel[“list”]->java.util.ArrayList[0]->java.util.HashMap[“ST_TG”]->com.sun.proxy. $Proxy321["characterStream"]); nested exception is com.fasterxml.jackson.databind.JsonMappingException: No serializer found for class oracle.jdbc.driver.OracleClobReader and no properties discovered to create BeanSerializer (to avoid exception, disable SerializationFeature.FAIL_ON_EMPTY_BEANS) (through reference chain: com.dzqc.campus.common.dto.AjaxResult["data"]->com.dzqc.campus.common.entity.PageModel["list"]->java.util.ArrayList[0]->java.util.HashMap["ST_TG"]->com.sun.proxy.$ Proxy321[“characterStream”])*at org.springframework.http.converter.json.AbstractJackson2HttpMessageConverter.writeInternal(AbstractJackson2HttpMessageConverter.java:272)
at org.springframework.http.converter.AbstractGenericHttpMessageConverter.write(AbstractGenericHttpMessageConverter.java:100)
at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters(AbstractMessageConverterMethodProcessor.java:222)
at org.springframework.web.servlet.mvc.method.annotation.AbstractMessageConverterMethodProcessor.writeWithMessageConverters(AbstractMessageConverterMethodProcessor.java:153)
at org.springframework.web.servlet.mvc.method.annotation.RequestResponseBodyMethodProcessor.handleReturnValue(RequestResponseBodyMethodProcessor.java:165)
at org.springframework.web.method.support.HandlerMethodReturnValueHandlerComposite.handleReturnValue(HandlerMethodReturnValueHandlerComposite.java:80)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:126)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:817)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:731)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:959)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:893)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:968)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:859)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:693)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:844)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:806)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1093)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:61)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AdviceFilter.executeChain(AdviceFilter.java:108)
at org.apache.shiro.web.servlet.AdviceFilter.doFilterInternal(AdviceFilter.java:137)
at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125)
at org.apache.shiro.web.servlet.ProxiedFilterChain.doFilter(ProxiedFilterChain.java:66)
at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449)
at org.apache.shiro.web.servlet.AbstractShiroFilter $1 . c a l l (A b s t r a c t S h i r o F i l t e r . j a v a : 365) a t o r g . a p a c h e . s h i r o . s u b j e c t . s u p p o r t . S u b j e c t C a l l a b l e . d o C a l l (S u b j e c t C a l l a b l e . j a v a : 90) a t o r g . a p a c h e . s h i r o . s u b j e c t . s u p p o r t . S u b j e c t C a l l a b l e . c a l l (S u b j e c t C a l l a b l e . j a v a : 83) a t o r g . a p a c h e . s h i r o . s u b j e c t . s u p p o r t . D e l e g a t i n g S u b j e c t . e x e c u t e (D e l e g a t i n g S u b j e c t . j a v a : 383) a t o r g . a p a c h e . s h i r o . w e b . s e r v l e t . A b s t r a c t S h i r o F i l t e r . d o F i l t e r I n t e r n a l (A b s t r a c t S h i r o F i l t e r . j a v a : 362) a t o r g . a p a c h e . s h i r o . w e b . s e r v l e t . O n c e P e r R e q u e s t F i l t e r . d o F i l t e r (O n c e P e r R e q u e s t F i l t e r . j a v a : 125) a t o r g . s p r i n g f r a m e w o r k . w e b . f i l t e r . D e l e g a t i n g F i l t e r P r o x y . i n v o k e D e l e g a t e (D e l e g a t i n g F i l t e r P r o x y . j a v a : 346) a t o r g . s p r i n g f r a m e w o r k . w e b . f i l t e r . D e l e g a t i n g F i l t e r P r o x y . d o F i l t e r (D e l e g a t i n g F i l t e r P r o x y . j a v a : 262) a t o r g . m o r t b a y . j e t t y . s e r v l e t . S e r v l e t H a n d l e r$ CachedChain.doFilter(ServletHandler.java:1084)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.mortbay.jetty.servlet.ServletHandler $C a c h e d C h a i n . d o F i l t e r (S e r v l e t H a n d l e r . j a v a : 1084) a t o r g . s p r i n g f r a m e w o r k . o r m . j p a . s u p p o r t . O p e n E n t i t y M a n a g e r I n V i e w F i l t e r . d o F i l t e r I n t e r n a l (O p e n E n t i t y M a n a g e r I n V i e w F i l t e r . j a v a : 177) a t o r g . s p r i n g f r a m e w o r k . w e b . f i l t e r . O n c e P e r R e q u e s t F i l t e r . d o F i l t e r (O n c e P e r R e q u e s t F i l t e r . j a v a : 107) a t o r g . m o r t b a y . j e t t y . s e r v l e t . S e r v l e t H a n d l e r$ CachedChain.doFilter(ServletHandler.java:1084)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:361)
at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:219)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:741)
at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)
at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:206)
at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:113)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
at org.mortbay.jetty.Server.handle(Server.java:325)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:533)
at org.mortbay.jetty.HttpConnection $R e q u e s t H a n d l e r . h e a d e r C o m p l e t e (H t t p C o n n e c t i o n . j a v a : 857) a t o r g . m o r t b a y . j e t t y . H t t p P a r s e r . p a r s e N e x t (H t t p P a r s e r . j a v a : 513) a t o r g . m o r t b a y . j e t t y . H t t p P a r s e r . p a r s e A v a i l a b l e (H t t p P a r s e r . j a v a : 211) a t o r g . m o r t b a y . j e t t y . H t t p C o n n e c t i o n . h a n d l e (H t t p C o n n e c t i o n . j a v a : 391) a t o r g . m o r t b a y . i o . n i o . S e l e c t C h a n n e l E n d P o i n t . r u n (S e l e c t C h a n n e l E n d P o i n t . j a v a : 409) a t o r g . m o r t b a y . t h r e a d . Q u e u e d T h r e a d P o o l$ PoolThread.run(QueuedThreadPool.java:497)
Caused by: com.fasterxml.jackson.databind.JsonMappingException: No serializer found for class oracle.jdbc.driver.OracleClobReader and no properties discovered to create BeanSerializer (to avoid exception, disable SerializationFeature.FAIL_ON_EMPTY_BEANS) (through reference chain: com.dzqc.campus.common.dto.AjaxResult[“data”]->com.dzqc.campus.common.entity.PageModel[“list”]->java.util.ArrayList[0]->java.util.HashMap[“ST_TG”]->com.sun.proxy.Prefetch.serialize(ObjectWriter.java:1430)
at com.fasterxml.jackson.databind.ObjectWriter.writeValue(ObjectWriter.java:951)
at org.springframework.http.converter.json.AbstractJackson2HttpMessageConverter.writeInternal(AbstractJackson2HttpMessageConverter.java:265)
… 63 more