org.springframework.jdbc.support.lob.DefaultLobHandler

最新推荐文章于 2020-09-28 23:00:46 发布
最新推荐文章于 2020-09-28 23:00:46 发布
阅读量517 收藏
点赞数
分类专栏： Spring 文章标签： java 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/douglas8287/article/details/84428627
版权

<!-- ========= END OF TOP NAVBAR ========= -->

 链接如下：

http://static.springsource.org/spring/docs/2.5.x/api/org/springframework/jdbc/support/lob/DefaultLobHandler.html

<!-- ======== START OF CLASS DATA ======== -->

org.springframework.jdbc.support.lob
Class DefaultLobHandler

java.lang.Object

extended by

org.springframework.jdbc.support.lob.AbstractLobHandler

extended by

org.springframework.jdbc.support.lob.DefaultLobHandler
All Implemented Interfaces:
LobHandler

 

public class DefaultLobHandlerextends AbstractLobHandler
 
 
Default implementation of the LobHandler interface. Invokes the direct accessor methods that java.sql.ResultSet and java.sql.PreparedStatement offer.
 
 
This LobHandler should work for any JDBC driver that is JDBC compliant in terms of the spec's suggestions regarding simple BLOB and CLOB handling. This does not apply to Oracle 9i, and only to a limited degree to Oracle 10g! As a consequence, use OracleLobHandler for accessing Oracle BLOBs/CLOBs.
 
 
Some JDBC drivers require values with a BLOB/CLOB target column to be explicitly set through the JDBC setBlob / setClob API: for example, PostgreSQL's driver. Switch the "wrapAsLob" property to "true" when operating against such a driver.
 
 
On JDBC 4.0, this LobHandler also supports streaming the BLOB/CLOB content via the setBlob / setClob variants that take a stream argument directly. Consider switching the "streamAsLob" property to "true" when operating against a fully compliant JDBC 4.0 driver.
 
 
See the LobHandler javadoc for a summary of recommendations.
 
 
 
   
   Since: 
   
  

    04.12.2003 
  
 
   
   Author: 
   
  

    Juergen Hoeller 
  
 
   
   See Also: 
   
  
 
   setStreamAsLob(boolean), 
   ResultSet.getBytes(int), 
   ResultSet.getBinaryStream(int), 
   ResultSet.getString(int), 
   ResultSet.getAsciiStream(int), 
   ResultSet.getCharacterStream(int), 
   PreparedStatement.setBytes(int, byte[]), 
   PreparedStatement.setBinaryStream(int, java.io.InputStream, int), 
   PreparedStatement.setString(int, java.lang.String), 
   PreparedStatement.setAsciiStream(int, java.io.InputStream, int), 
   PreparedStatement.setCharacterStream(int, java.io.Reader, int) 
  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
<!-- ======== NESTED CLASS SUMMARY ======== --><!-- -->
 
 
Nested Class Summary
protected  class DefaultLobHandler.DefaultLobCreator 
          Default LobCreator implementation as inner class.
 
 
 
 
 
<!-- =========== FIELD SUMMARY =========== -->
 
 
<!-- -->
 
 
Field Summary
protected  Log logger 
           
 
 
 
 
 
<!-- ======== CONSTRUCTOR SUMMARY ======== -->
 
 
<!-- -->
 
 
Constructor Summary
 DefaultLobHandler() 
           
 
 
 
 
 
<!-- ========== METHOD SUMMARY =========== -->
 
 
<!-- -->
 
 
Method Summary
 InputStream getBlobAsBinaryStream(ResultSet rs, int columnIndex) 
          Retrieve the given column as binary stream from the given ResultSet.
 byte[] getBlobAsBytes(ResultSet rs, int columnIndex) 
          Retrieve the given column as bytes from the given ResultSet.
 InputStream getClobAsAsciiStream(ResultSet rs, int columnIndex) 
          Retrieve the given column as ASCII stream from the given ResultSet.
 Reader getClobAsCharacterStream(ResultSet rs, int columnIndex) 
          Retrieve the given column as character stream from the given ResultSet.
 String getClobAsString(ResultSet rs, int columnIndex) 
          Retrieve the given column as String from the given ResultSet.
 LobCreator getLobCreator() 
          Create a new LobCreator instance, i.e. a session for creating BLOBs and CLOBs.
 void setStreamAsLob(boolean streamAsLob) 
          Specify whether to submit a binary stream / character stream to the JDBC driver as explicit LOB content, using the JDBC 4.0 setBlob / setClob method with a stream argument.
 void setWrapAsLob(boolean wrapAsLob) 
          Specify whether to submit a byte array / String to the JDBC driver wrapped in a JDBC Blob / Clob object, using the JDBC setBlob / setClob method with a Blob / Clob argument.
 
 
 <!-- -->
 
 
Methods inherited from class org.springframework.jdbc.support.lob.AbstractLobHandler
getBlobAsBinaryStream, getBlobAsBytes, getClobAsAsciiStream, getClobAsCharacterStream, getClobAsString
 
 
 <!-- -->
 
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
 
 
 
 
<!-- ============ FIELD DETAIL =========== --><!-- -->
 
 
Field Detail
 
 
<!-- -->
 
 
logger
 
 
protected final Log logger
 
 
<!-- ========= CONSTRUCTOR DETAIL ======== -->
 
 
<!-- -->
 
 
Constructor Detail
 
 
<!-- -->
 
 
DefaultLobHandler
 
 
public DefaultLobHandler()
 
 
<!-- ============ METHOD DETAIL ========== -->
 
 
<!-- -->
 
 
Method Detail
 
 
<!-- -->
 
 
setWrapAsLob
 
 
public void setWrapAsLob(boolean wrapAsLob)
 
 
 
  

    Specify whether to submit a byte array / String to the JDBC driver wrapped in a JDBC Blob / Clob object, using the JDBC 
   setBlob / 
   setClob method with a Blob / Clob argument. 
   
Default is "false", using the common JDBC 2.0 setBinaryStream / setCharacterStream method for setting the content. Switch this to "true" for explicit Blob / Clob wrapping against JDBC drivers that are known to require such wrapping (e.g. PostgreSQL's).
 
   
This setting affects byte array / String arguments as well as stream arguments, unless "streamAsLob" overrides this handling to use JDBC 4.0's new explicit streaming support (if available).
 
   
 
 
   
 
  
 
  
 
   
 
     
     See Also: 
     
    
 
     PreparedStatement.setBlob(int, java.sql.Blob), 
     PreparedStatement.setClob(int, java.sql.Clob) 
    
 
   
 
  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
<!-- -->
 
 
 
 
 
setStreamAsLob
 
 
public void setStreamAsLob(boolean streamAsLob)
 
 
 
  

    Specify whether to submit a binary stream / character stream to the JDBC driver as explicit LOB content, using the JDBC 4.0 
   setBlob / 
   setClob method with a stream argument. 
   
Default is "false", using the common JDBC 2.0 setBinaryStream / setCharacterStream method for setting the content. Switch this to "true" for explicit JDBC 4.0 usage, provided that your JDBC driver actually supports those JDBC 4.0 operations (e.g. Derby's).
 
   
This setting affects stream arguments as well as byte array / String arguments, requiring JDBC 4.0 support. For supporting LOB content against JDBC 3.0, check out the "wrapAsLob" setting.
 
   
 
 
   
 
  
 
  
 
   
 
     
     See Also: 
     
    
 
     PreparedStatement.setBlob(int, java.io.InputStream, long), 
     PreparedStatement.setClob(int, java.io.Reader, long) 
    
 
   
 
  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
<!-- -->
 
 
 
 
 
getBlobAsBytes
 
 
public byte[] getBlobAsBytes(ResultSet rs,
                             int columnIndex)
                      throws SQLException
 
 
 
  
 
   Description copied from interface: LobHandler 
  
 
  

    Retrieve the given column as bytes from the given ResultSet. Might simply invoke 
   ResultSet.getBytes or work with 
   ResultSet.getBlob, depending on the database and driver. 
   
 
 
  
 
  
 
   
 
     
     Parameters: 
     
    
 
     rs - the ResultSet to retrieve the content from 
    
 
    
 
     columnIndex - the column index to use 
    
 
     
     Returns: 
     
    

      the content as byte array, or 
     null in case of SQL NULL 
    
 
     
     Throws: 
     
    
 
     SQLException - if thrown by JDBC methods 
    
 
     
     See Also: 
     
    
 
     ResultSet.getBytes(int) 
    
 
   
 
  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
<!-- -->
 
 
 
 
 
getBlobAsBinaryStream
 
 
public InputStream getBlobAsBinaryStream(ResultSet rs,
                                         int columnIndex)
                                  throws SQLException
 
 
 
  
 
   Description copied from interface: LobHandler 
  
 
  

    Retrieve the given column as binary stream from the given ResultSet. Might simply invoke 
   ResultSet.getBinaryStream or work with 
   ResultSet.getBlob, depending on the database and driver. 
   
 
 
  
 
  
 
   
 
     
     Parameters: 
     
    
 
     rs - the ResultSet to retrieve the content from 
    
 
    
 
     columnIndex - the column index to use 
    
 
     
     Returns: 
     
    

      the content as binary stream, or 
     null in case of SQL NULL 
    
 
     
     Throws: 
     
    
 
     SQLException - if thrown by JDBC methods 
    
 
     
     See Also: 
     
    
 
     ResultSet.getBinaryStream(int) 
    
 
   
 
  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
<!-- -->
 
 
 
 
 
getClobAsString
 
 
public String getClobAsString(ResultSet rs,
                              int columnIndex)
                       throws SQLException
 
 
 
  
 
   Description copied from interface: LobHandler 
  
 
  

    Retrieve the given column as String from the given ResultSet. Might simply invoke 
   ResultSet.getString or work with 
   ResultSet.getClob, depending on the database and driver. 
   
 
 
  
 
  
 
   
 
     
     Parameters: 
     
    
 
     rs - the ResultSet to retrieve the content from 
    
 
    
 
     columnIndex - the column index to use 
    
 
     
     Returns: 
     
    

      the content as String, or 
     null in case of SQL NULL 
    
 
     
     Throws: 
     
    
 
     SQLException - if thrown by JDBC methods 
    
 
     
     See Also: 
     
    
 
     ResultSet.getString(int) 
    
 
   
 
  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
<!-- -->
 
 
 
 
 
getClobAsAsciiStream
 
 
public InputStream getClobAsAsciiStream(ResultSet rs,
                                        int columnIndex)
                                 throws SQLException
 
 
 
  
 
   Description copied from interface: LobHandler 
  
 
  

    Retrieve the given column as ASCII stream from the given ResultSet. Might simply invoke 
   ResultSet.getAsciiStream or work with 
   ResultSet.getClob, depending on the database and driver. 
   
 
 
  
 
  
 
   
 
     
     Parameters: 
     
    
 
     rs - the ResultSet to retrieve the content from 
    
 
    
 
     columnIndex - the column index to use 
    
 
     
     Returns: 
     
    

      the content as ASCII stream, or 
     null in case of SQL NULL 
    
 
     
     Throws: 
     
    
 
     SQLException - if thrown by JDBC methods 
    
 
     
     See Also: 
     
    
 
     ResultSet.getAsciiStream(int) 
    
 
   
 
  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
<!-- -->
 
 
 
 
 
getClobAsCharacterStream
 
 
public Reader getClobAsCharacterStream(ResultSet rs,
                                       int columnIndex)
                                throws SQLException
 
 
 
  
 
   Description copied from interface: LobHandler 
  
 
  

    Retrieve the given column as character stream from the given ResultSet. Might simply invoke 
   ResultSet.getCharacterStream or work with 
   ResultSet.getClob, depending on the database and driver. 
   
 
 
  
 
  
 
   
 
     
     Parameters: 
     
    
 
     rs - the ResultSet to retrieve the content from 
    
 
    
 
     columnIndex - the column index to use 
    
 
     
     Returns: 
     
    

      the content as character stream 
    
 
     
     Throws: 
     
    
 
     SQLException - if thrown by JDBC methods 
    
 
     
     See Also: 
     
    
 
     ResultSet.getCharacterStream(int) 
    
 
   
 
  
 
 
 
 
 
 
 
 
 
 
 
 
 
 
<!-- -->
 
 
 
 
 
getLobCreator
 
 
public LobCreator getLobCreator()
 
 
 
  
 
   Description copied from interface: LobHandler 
  
 
  

    Create a new 
   LobCreator instance, i.e. a session for creating BLOBs and CLOBs. Needs to be closed after the created LOBs are not needed anymore - typically after statement execution or transaction completion. 
   
 
 
  
 
  
 
   
 
     
     Returns: 
     
    

      the new LobCreator instance 
    
 
     
     See Also: 
     
    
 
     LobCreator.close() 
    
 
   
 
  
 
 
 


                

        

        




    




    

      

        

            

              
                
                  douglas8287
                
              
            

            

                关注
              
            

        

        

          
    
            
  • 
              
                
                
                
                
                      0
                
              
              
    点赞
    
            
    • 
            
  • 
              
                
                
                
              
              
    踩
    
            
    • 
            
  • 
              
                
                
                
                
                    0
                
              
              
    
                
    
                  
                    收藏
                  
                
    
              
    
              
    
                
    
                  觉得还不错?
                  
                    一键收藏
                  
                 
                
    
              
    
            
    • 
          
  • 
            
    
              
              
            
    
              
              
              
                    0
              
            
            
    评论
    
          
    • 
          
  • 
          
    • 
          
  • 
            
              
            
              
    
            
              
                
            
    
          
    • 
        

      

      

            

                专栏目录
          










                



	

		

			

				
					
mysql spring lobhandler_Spring让LOB数据操作变得简单易行

				
			

			

				

					weixin_33908906的博客
				

				

					01-21
					
					298
					
				

			

		

		

			
				
在 Spring JDBC 中操作 LOB 数据插入 LOB 数据假设我们有一个用于保存论坛帖子的 t_post 表，拥有两个 LOB 字段，其中 post_text 是 CLOB 类型，而 post_attach 是 BLOB 类型。下面，我们来编写插入一个帖子记录的代码：清单 3. 添加 LOB 字段数据package com.baobaotao.dao.jdbc;…import java.s...

			
		

	



                

              
                



	

		

			

				
					
JDBC_oracle.zip

				
			

			

				

					09-09
				

			

		

		

			
				
**JDBC(Java Database Connectivity)** 是Java编程语言中用于与各种数据库进行交互的一套标准接口。它是Java平台的标准部分，允许开发人员编写可移植的代码来处理多种数据库系统。Oracle数据库是世界上最流行的商业...

			
		

	



                


  
              

                


	

		

			

				
					
Java本地应用 使用Spring 注解初始化

				
			

			

				

					z69183787的专栏
				

				

					12-12
					
					8545
					
				

			

		

		

			
				
service 类 及 接口
ISample.java


/**
 * 
 */
package test;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

/** 
 *

			
		

	





	

		

			

				
					
Spring配置文件各个属性详解

				
			

			

				

					luoshenFU的专栏
				

				

					08-16
					
					3972
					
				

			

		

		

			
				
<br />结论1： HQL代码 > fetch（配置） > lazy （配置）<br />结论2： 默认 lazy="true“<br />结论3： fetch 和 lazy 主要是用来级联查询的，   而 cascade 和 inverse 主要是用来级联插入和修改的 <br />         fetch参数指定了关联对象抓取的方式是select查询还是join查询，select方式时先查询返回要查询的主体对象（列表），再根据关联外键id，每一个对象发一个select查询，获取关联的对象，形成n+1

			
		

	



		

			
		



	

		

			

				
					
Spring 让 LOB 数据操作变得简单易行

				
			

			

				

					future_hui的专栏
				

				

					02-18
					
					167
					
				

			

		

		

			
				
  LobHandler 的配置 MYSQL下的&lt;bean id="lobHandler"
class="org.springframework.jdbc.support.lob.DefaultLobHandler"
lazy-init="true"&gt;
&lt;/bean&gt;
Oracle下的lobHandler配置 &lt;bean id="lobHandler"
	cl

			
		

	





	

		

			

				
					
ORACLE-SGA.docx

				
			

			

				

					03-01
				

			

		

		

			
				
3. 大池（LARGE_POOL_SIZE）：用于RMAN备份、大对象（LOB）操作和Oracle Parallel Server等。 4. Java池（JAVA_POOL_SIZE）：支持Java应用程序和存储过程在数据库中的执行。 5. 流池（STREAMS_POOL_SIZE）：处理...

			
		

	





	

		

			

				
					
ojdbc6-12.1.0.2.jar

				
			

			

				

					04-10
				

			

		

		

			
				
5. 高级特性：包括LOB（Large Object）处理、游标、存储过程调用、事务控制、并发控制等。 6. 兼容性：ojdbc6适用于JDBC 4.0规范，可与Java 6及更高版本兼容。 7. 性能优化：包含针对Oracle数据库特定的性能优化，如...

			
		

	





	

		

			

				
					
ojdbc7.jar驱动.rar

				
			

			

				

					02-24
				

			

		

		

			
				
Oracle JDBC驱动程序是Java应用程序与Oracle数据库之间通信的关键组件。`ojdbc7.jar`是Oracle公司为Java 7（JDK 7）发布的特定版本的Java Database Connectivity (JDBC)驱动程序，它允许Java应用程序执行SQL查询、...

			
		

	





	

		

			

				
					
oci.zip_oci_oratypes.h缺失

				
			

			

				

					09-24
				

			

		

		

			
				
5. **处理结果集**：`OCIFetch()` 用于获取结果集中的一行数据，而`OCILobLocatorAssign()` 和 `OCILobRead()` 等函数则用于处理LOB（Large Object）数据。  6. **游标管理**：在处理多行结果时，游标（也称为“陈...

			
		

	





	

		

			

				
					
LobHandler和LobCreator

				
			

			

				

					qq_29860591的博客
				

				

					09-24
					
					645
					
				

			

		

		

			
				
处理 BLOB 和 CLOB 对象
您可以在数据库中存储图像，其他二进制数据和大块文本。这些大对象称为二进制数据的 BLOB(二进制大型对象)，而字符数据称为 CLOB(字符大型对象)。在 Spring 中，可以直接使用JdbcTemplate来处理这些大对象，也可以使用 RDBMS Objects 和SimpleJdbc类提供的更高抽象来处理这些大对象。所有这些方法都将LobHandl...

			
		

	





	

		

			

				
					
ssh+mysql中关于大字段的设置

				
			

			

				

					nmvbliy的专栏
				

				

					11-07
					
					1502
					
				

			

		

		

			
				
Spring的HibernateTemplate的既有方法完全兼容对CLOB对象的操作，仅仅需要进行简单的配置：
1.保留实体中需要保存为CLOB对象的属性为String，而在hbm映射文件中将其类型修改为org.springframework.orm.hibernate3.support.ClobStringType
2.如果仅仅这样，会抛出异常：No LobHandler found fo

			
		

	





	

		

			

				
					
spring，hibernate处理Lob类型数据

				
			

			

				

					默翁的博客
				

				

					09-21
					
					2609
					
				

			

		

		

			
				
Lob代表大对象数据，包括BLOB和CLOB两种类型数据，前者用于存储大块的二进制数据，如图片和视频数据等，而后者用于存储长文本数据，如论坛帖子内容，产品详细描述等。在不同的数据库中，大对象对应的字段类型往往不一样，如oracle对应的是BLOB/CLOB;Mysql对应的BLOB/LONGTEXT;SQLSERER对应IMAGE/TEXT,有些数据库对大对象类型可以像简单类型一样访问，如mysq

			
		

	





	

		

			

				
					
利用lobHandler实现LOB列的查询

				
			

			

				

					davidforeverkaka的博客
				

				

					05-20
					
					272
					
				

			

		

		

			
				
Spring提供的DefaultLobHandler可以用来对lob类型的数据列进行相关的操作。如以下代码所示，image_code列的数据类型为blob，下面的代码展示了一个查询示例。

[code="java"]
public byte[] queryUserImage(String targetUserId) {
	String sql = "SELECT image_code FR...

			
		

	





	

		

			

				
					
Spring 5 中文解析数据存储篇-JDBC数据存储(下)

				
			

			

				

					liyong1028826685的专栏
				

				

					09-28
					
					385
					
				

			

		

		

			
				
3.7 作为Java对象JDBC操作模型
org.springframework.jdbc.object包包含一些类，这些类使你以更加面向对象的方式访问数据库。例如，你可以运行查询并将结果作为包含业务对象的列表返回，该业务对象的关联列数据映射到业务对象的属性。你还可以运行存储过程并运行update，delete和insert语句。

许多Spring开发人员认为，下面描述的各种RDBMS操作类（StoredProcedure类除外）通常可以用直接的JdbcTemplate调用代替。通常，编写直接在JdbcT

			
		

	





	

		

			

				
					
spring中 LobHandler 的配置

				
			

			

				

					framic的博客
				

				

					04-22
					
					2669
					
				

			

		

		

			
				
oracle数据库：


















其他数据库：

			
		

	





	

		

			

				
					
dbms_lob.export

					
最新发布

				
			

			

				

					02-19
				

			

		

		

			
				
dbms_lob.export是一个Oracle数据库中的PL/SQL包，用于将LOB（Large Object）数据类型的数据导出到外部文件。LOB数据类型包括CLOB（Character Large Object）和BLOB（Binary Large Object）。

使用dbms_lob.export可以将LOB数据导出到指定的文件中，以便进行备份、迁移或其他处理。它接受以下参数：

1. lob_loc：要导出的LOB对象的引用。
2. amount：每次从LOB对象中读取的字节数。
3. offset：从LOB对象的指定偏移量开始读取。
4. dest_offset：将数据写入到目标文件的指定偏移量处。
5. bfile：指定目标文件的位置。

以下是一个示例代码，演示了如何使用dbms_lob.export将CLOB数据导出到外部文件：

```
DECLARE
  l_clob CLOB;
  l_dest_offset NUMBER := 1;
  l_bfile BFILE;
BEGIN
  -- 获取CLOB对象
  SELECT clob_column INTO l_clob FROM your_table WHERE id = 1;

  -- 创建BFILE对象
  l_bfile := BFILENAME('DIRECTORY_NAME', 'file_name.txt');

  -- 导出CLOB数据到外部文件
  DBMS_LOB.FILEOPEN(l_bfile, DBMS_LOB.FILE_WRITE);
  DBMS_LOB.EXPORT(l_clob, l_bfile, DBMS_LOB.LOBMAXSIZE, l_dest_offset, 1);
  DBMS_LOB.FILECLOSE(l_bfile);
END;
/
```

请注意，上述示例中的DIRECTORY_NAME应替换为数据库中已创建的目录对象的名称，file_name.txt应替换为目标文件的名称。



			
		

	



              




          




        



    





    



      

      

        
      

      





	

		评论	
	

	
	




  

    

      添加红包
      
    

    

      

        
        

          
          
        

        
请填写红包祝福语或标题

      

      

        
        

          
          个
        

        
红包个数最小为10个

      

      

        
        

          
          元
        

        
红包金额最低5元

      

      

        
        

          当前余额3.43元
          前往充值 >
        

      

      

        

          需支付：10.00元
        

        
        
      

    

  





  

    
    
  

  

    
    
  








  

    

      

        

          

            
            
成就一亿技术人!

          

          

        

        

          

          

            领取后你会自动成为博主和红包主的粉丝
            规则
          

        

      

      

        

          

            
              
            
            

              
hope_wisdom
 发出的红包
            

          

        

        

          

          

          

        

      

    

    

  



      
      

      
实付元

      
使用余额支付

      

        

          

            
            点击重新获取
          

        

        
扫码支付

      

      

        
          
            
          
          
        
      

      

        
        钱包余额
          0
          

            
            

              

                
抵扣说明：

                
 1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
 2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

              

            

          

      

      余额充值