aiyan3344
- 浏览: 203046 次
- 性别:
- 来自: 北京
-
文章分类
最新评论
-
zoutuo1986：
翻过的帖子，这篇讲配置最细
solr -
18612536750：
Struts2 标签,取得Map的某一个key对应value值 -
zhangzhihua5：
solr -
xiaguangme：
“capacity才是真正的Entry数组的大小，即真实的En ...
源码阅读之Map和Set -
qiyang199132：
我擦民工 都没人来。。 我来捧场了
JSP 防止重复提交 防止重复刷新 防止后退问题以及处理方式
最近常碰到有人问如何运用Hibernate操作Oracle中的Clob、Blob字段，相关问题大概如下几种：
如何读、写数据库中的Clob、Blob字段？
注释方式或者映射文件两种方式是如何实现的？
Clob字段是否可当成一般String来操作？
为什么Clob字段插入正常，但是读取时却为null
JDBC的驱动是不是需要最新的，才能支持Clob当成String？
JDBC驱动不更新，有没有办法实现Clob当成String操作？
。。。。。等等这些问题
下面我将以不同的实现方式的分别来演示，上述提到的问题答案将在具体的实例中给出详细的答案。本文目录：
[一]、Clob字段 - 注解方式的实现
[二]、Clob字段 - 映射文件的实现
[三]、Blob字段 - 注解方式的实现
[四]、Blob字段 - 映射文件的实现
测试的相关源代码 ：bigstring_oracle_src.7z
[一]、Clob字段 - 注解 方式的实现
域对象：TbBigStrClob.java
Java代码
package michael.hibernate.bigstring.oracle;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.Table;
import org.hibernate.annotations.Type;
/**
*
* @blog http://sjsky.iteye.com
* @author Michael
*/
@Entity
@Table(name = "MY_TB_BIG_STR_CLOB")
public class TbBigStrClob {
private Integer id;
private String name;
private String content;
/**
* @return the id
*/
@Id
@GeneratedValue
@Column(name = "ID")
public Integer getId() {
return id;
}
/**
* @return the name
*/
@Column(name = "NAME", length = 20)
public String getName() {
return name;
}
/**
* @return the content
*/
@Lob
//@Type(type = "text")
@Column(name = "CONTENT", columnDefinition = "CLOB")
public String getContent() {
return content;
}
/**
* @param pId the id to set
*/
public void setId(Integer pId) {
id = pId;
}
/**
* @param pName the name to set
*/
public void setName(String pName) {
name = pName;
}
/**
* @param pContent the content to set
*/
public void setContent(String pContent) {
content = pContent;
}
/*
* (non-Javadoc)
* @see java.lang.Object#toString()
*/
@Override
public String toString() {
return "TbBigStrClob :: id = [" + id + "],name = [" + name
+ "],content = [" + content + "].";
}
}
Hibernate 配置文件：hibernate.cfg.xml
Xml代码
<!DOCTYPE hibernate-configuration
PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.driver_class">
oracle.jdbc.driver.OracleDriver
</property>
<property name="connection.url">
jdbc:oracle:thin:@192.168.8.49:1521:ora9i
</property>
<property name="connection.username">bm2</property>
<property name="connection.password">bm2</property>
<property name="dialect">
org.hibernate.dialect.Oracle9Dialect
</property>
<property name="connection.useUnicode">true</property>
<property name="connection.characterEncoding">UTF-8</property>
<property name="connection.SetBigStringTryClob">true</property>
<property name="connection.pool_size">10</property>
<property name="hibernate.jdbc.batch_size">10</property>
<property name="show_sql">true</property>
<property name="format_sql">false</property>
<property name="current_session_context_class">thread</property>
<property name="hbm2ddl.auto">update</property>
<!-- 注释 -->
<mapping
class="michael.hibernate.bigstring.oracle.TbBigStrClob" />
</session-factory>
</hibernate-configuration>
测试程序：
Java代码
package michael.hibernate.bigstring.oracle;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.cfg.Configuration;
/**
* 大字段Clob测试
* @blog http://sjsky.iteye.com
* @author Michael
*/
public class TestTbBigStr {
/**
* @param args
*/
@SuppressWarnings("unchecked")
public static void main(String[] args) {
// 测试Hibernate 注释方法 操作 大字段 Clob
TestTbBigStr.testClob();
}
/**
* 测试Hibernate 注释方法 操作 大字段 Clob
*/
@SuppressWarnings("unchecked")
public static void testClob() {
SessionFactory sessionFactory = null;
Transaction ta = null;
try {
System.out.println("../../hibernate.cfg.xml configure");
Configuration config = new AnnotationConfiguration()
.configure("michael/hibernate/bigstring/oracle/hibernate.cfg.xml");
sessionFactory = config.buildSessionFactory();
Session session = sessionFactory.getCurrentSession();
String hsql = "select t from TbBigStrClob t ";
System.out.println("start test clob ...");
ta = session.beginTransaction();
org.hibernate.Query query = session.createQuery(hsql);
List<TbBigStrClob> list = query.list();
if (list.size() == 0) {
System.out.println("start to init clob data");
List<TbBigStrClob> initlist = initClobData(5);
for (TbBigStrClob po : initlist) {
session.save(po);
}
list = query.list();
}
System.out.println("query data list size = " + list.size());
for (TbBigStrClob vo : list) {
System.out.println(vo);
}
ta.commit();
} catch (Exception e) {
e.printStackTrace();
ta.rollback();
} finally {
if (null != sessionFactory) {
sessionFactory.close();
}
}
}
/**
*
* @param dataSize
* @return List
*/
public static List<TbBigStrClob> initClobData(int dataSize) {
List<TbBigStrClob> list = new ArrayList<TbBigStrClob>();
for (int i = 1; i <= dataSize; i++) {
TbBigStrClob vo = new TbBigStrClob();
vo.setName("test_" + i);
vo.setContent("我是大字段<Clob>,at date：" + new Date());
list.add(vo);
}
return list;
}
}
运行结果：
../../hibernate.cfg.xml configure
start test clob ...
Hibernate: select tbbigstrcl0_.ID as ID2_, tbbigstrcl0_.NAME as NAME2_, tbbigstrcl0_.CONTENT as CONTENT2_ from MY_TB_BIG_STR_CLOB tbbigstrcl0_
start to init clob data
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: insert into MY_TB_BIG_STR_CLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: insert into MY_TB_BIG_STR_CLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: insert into MY_TB_BIG_STR_CLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: insert into MY_TB_BIG_STR_CLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: insert into MY_TB_BIG_STR_CLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: select tbbigstrcl0_.ID as ID2_, tbbigstrcl0_.NAME as NAME2_, tbbigstrcl0_.CONTENT as CONTENT2_ from MY_TB_BIG_STR_CLOB tbbigstrcl0_
query data list size = 5
TbBigStrClob :: id = [1813873],name = [test_1],content = [我是大字段<Clob>,at date：Mon Aug 22 13:10:38 CST 2011].
TbBigStrClob :: id = [1813874],name = [test_2],content = [我是大字段<Clob>,at date：Mon Aug 22 13:10:38 CST 2011].
TbBigStrClob :: id = [1813875],name = [test_3],content = [我是大字段<Clob>,at date：Mon Aug 22 13:10:38 CST 2011].
TbBigStrClob :: id = [1813876],name = [test_4],content = [我是大字段<Clob>,at date：Mon Aug 22 13:10:38 CST 2011].
TbBigStrClob :: id = [1813877],name = [test_5],content = [我是大字段<Clob>,at date：Mon Aug 22 13:10:38 CST 2011].
运行结果可见：注解方式下，插入Clob数据和读取Clob数据均正常。
Tips：
1. 在Oracle10g + 10g驱动（或者Oracle11g + 11g驱动）的环境下，只需要在Clob字段上，增加注解@Column(name = "CONTENT", columnDefinition = "CLOB")，即可成功实现建表、Clob字段的读写操作。
2. 在Oracle9i+9i的驱动环境下，仅增加注释@Column(name = "CONTENT", columnDefinition = "CLOB")时，建表、写人数据均能正常，但读取时会显示数据为空。如果在Oracle9i下又必须用9i的驱动，可以在Clob字段中再增加一行注解@Lob 或者 @Type(type = "text")。（运用spring中org.springframework.jdbc.support.lob.OracleLobHandler，这个没有具体实践过，就不在本文展开了 ）
3. 在Oracle9i+10g的驱动环境下，增加注解@Column(name = "CONTENT", columnDefinition = "CLOB")，同样可以成功实现建表、Clob字段的读写操作，可见9i的驱动对Clob支持不是很好，但10g、11g已经做了更新。
[二]、Clob字段 - 映射文件的实现
bean文件：BigStrClob.java
Java代码
package michael.hibernate.bigstring.oracle;
/**
*
* @blog http://sjsky.iteye.com
* @author Michael
*/
public class BigStrClob {
private Integer id;
private String name;
private String content;
/**
* @return the id
*/
public Integer getId() {
return id;
}
/**
* @return the name
*/
public String getName() {
return name;
}
/**
* @return the content
*/
public String getContent() {
return content;
}
/**
* @param pId the id to set
*/
public void setId(Integer pId) {
id = pId;
}
/**
* @param pName the name to set
*/
public void setName(String pName) {
name = pName;
}
/**
* @param pContent the content to set
*/
public void setContent(String pContent) {
content = pContent;
}
/*
* (non-Javadoc)
* @see java.lang.Object#toString()
*/
@Override
public String toString() {
return "BigStrClob :: id = [" + id + "],name = [" + name
+ "],content = [" + content + "].";
}
}
映射文件:tb_bigstr.hb.xml
Java代码
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="michael.hibernate.bigstring.oracle">
<class name="BigStrClob" table="MY_HB_BIG_STR_CLOB">
<id name="id" type="int" unsaved-value="null">
<generator class="increment" />
</id>
<property name="name" column="NAME" type="string"
not-null="false" length="20" />
<property name="content" column="CONTENT" type="text"
not-null="false" />
</class>
</hibernate-mapping>
在hibernate.cfg.xml文件中增加域对象的映射文件：
Xml代码
<!-- 映射 -->
<mapping
resource="michael/hibernate/bigstring/oracle/tb_bigstr.hb.xml" />
测试程序：
Java代码
package michael.hibernate.bigstring.oracle;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.cfg.Configuration;
/**
* 大字段Clob测试
* @blog http://sjsky.iteye.com
* @author Michael
*/
public class TestHbBigStr {
/**
* @param args
*/
public static void main(String[] args) {
// 测试Hibernate 映射文件 操作 大字段 Clob
TestHbBigStr.testClob();
}
/**
* 测试Hibernate 映射文件 操作 大字段 Clob
*/
@SuppressWarnings("unchecked")
public static void testClob() {
SessionFactory sessionFactory = null;
Transaction ta = null;
try {
System.out.println("../../hibernate.cfg.xml configure");
Configuration config = new AnnotationConfiguration()
.configure("michael/hibernate/bigstring/oracle/hibernate.cfg.xml");
sessionFactory = config.buildSessionFactory();
Session session = sessionFactory.getCurrentSession();
String hsql = "select t from BigStrClob t ";
ta = session.beginTransaction();
org.hibernate.Query query = session.createQuery(hsql);
List<BigStrClob> list = query.list();
if (list.size() == 0) {
System.out.println("start to init clob data");
List<BigStrClob> initlist = initClobData(5);
for (BigStrClob po : initlist) {
session.save(po);
}
list = query.list();
}
System.out.println("Query data list size = " + list.size());
for (BigStrClob vo : list) {
System.out.println(vo);
}
ta.commit();
} catch (Exception e) {
e.printStackTrace();
ta.rollback();
} finally {
if (null != sessionFactory) {
sessionFactory.close();
}
}
}
/**
*
* @param dataSize
* @return List
*/
public static List<BigStrClob> initClobData(int dataSize) {
List<BigStrClob> list = new ArrayList<BigStrClob>();
for (int i = 1; i <= dataSize; i++) {
BigStrClob vo = new BigStrClob();
vo.setName("test_" + i);
vo.setContent("我是大字段<Clob>,at date：" + new Date());
list.add(vo);
}
return list;
}
}
运行结果如下：
../../hibernate.cfg.xml configure
Hibernate: select bigstrblob0_.id as id1_, bigstrblob0_.NAME as NAME1_, bigstrblob0_.CONTENT as CONTENT1_ from MY_HB_BIG_STR_BLOB bigstrblob0_
start to init blob data
Hibernate: select max(id) from MY_HB_BIG_STR_BLOB
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: select bigstrblob0_.id as id1_, bigstrblob0_.NAME as NAME1_, bigstrblob0_.CONTENT as CONTENT1_ from MY_HB_BIG_STR_BLOB bigstrblob0_
Query data list size = 5
BigStrBlob :: id = [1],name = [test_1],content = [我是大字段<Blob>,at date：Mon Aug 22 13:28:51 CST 2011].
BigStrBlob :: id = [2],name = [test_2],content = [我是大字段<Blob>,at date：Mon Aug 22 13:28:51 CST 2011].
BigStrBlob :: id = [3],name = [test_3],content = [我是大字段<Blob>,at date：Mon Aug 22 13:28:51 CST 2011].
BigStrBlob :: id = [4],name = [test_4],content = [我是大字段<Blob>,at date：Mon Aug 22 13:28:51 CST 2011].
BigStrBlob :: id = [5],name = [test_5],content = [我是大字段<Blob>,at date：Mon Aug 22 13:28:51 CST 2011].
从运行结果可见：映射文件的方式下，插入Clob数据和读取Clob数据均正常
Tips： 如果是映射文件的，只需要把Clob字段的类型指定为text即：type="text"
[三]、Blob字段 - 注解 方式的实现
域对象的文件：TbBigStrBlob.java
Java代码
package michael.hibernate.bigstring.oracle;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.Table;
/**
*
* @blog http://sjsky.iteye.com
* @author Michael
*/
@Entity
@Table(name = "MY_TB_BIG_STR_BLOB")
public class TbBigStrBlob {
private Integer id;
private String name;
private byte[] content;
/**
* @return the id
*/
@Id
@GeneratedValue
@Column(name = "ID")
public Integer getId() {
return id;
}
/**
* @return the name
*/
@Column(name = "NAME", length = 20)
public String getName() {
return name;
}
/**
* @return the content
*/
@Lob
@Column(name = "CONTENT", columnDefinition = "BLOB")
public byte[] getContent() {
return content;
}
/**
* @param pId the id to set
*/
public void setId(Integer pId) {
id = pId;
}
/**
* @param pName the name to set
*/
public void setName(String pName) {
name = pName;
}
/**
* @param pContent the content to set
*/
public void setContent(byte[] pContent) {
content = pContent;
}
/*
* (non-Javadoc)
* @see java.lang.Object#toString()
*/
@Override
public String toString() {
return "TbBigStrBlob :: id = [" + id + "],name = [" + name
+ "],content = [" + new String(content) + "].";
}
}
在hibernate.cfg.xml中增加域对象：
Xml代码
<mapping class="michael.hibernate.bigstring.oracle.TbBigStrBlob" />
运行测试程序：
Java代码
package michael.hibernate.bigstring.oracle;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.cfg.Configuration;
/**
* 大字段Clob测试
* @blog http://sjsky.iteye.com
* @author Michael
*/
public class TestTbBigStr {
/**
* @param args
*/
@SuppressWarnings("unchecked")
public static void main(String[] args) {
// 测试Hibernate 注释方法 操作 大字段 Blob
TestTbBigStr.testBlob();
}
/**
* 测试Hibernate 注释方法 操作 大字段 Blob
*/
@SuppressWarnings("unchecked")
public static void testBlob() {
SessionFactory sessionFactory = null;
Transaction ta = null;
try {
System.out.println("../../hibernate.cfg.xml configure");
Configuration config = new AnnotationConfiguration()
.configure("michael/hibernate/bigstring/oracle/hibernate.cfg.xml");
sessionFactory = config.buildSessionFactory();
Session session = sessionFactory.getCurrentSession();
String hsql = "select t from TbBigStrBlob t ";
System.out.println("start test clob ...");
ta = session.beginTransaction();
org.hibernate.Query query = session.createQuery(hsql);
List<TbBigStrBlob> list = query.list();
if (list.size() == 0) {
System.out.println("start to init blob data");
List<TbBigStrBlob> initlist = initBlobData(5);
for (TbBigStrBlob po : initlist) {
session.save(po);
}
list = query.list();
}
System.out.println("query data list size = " + list.size());
for (TbBigStrBlob vo : list) {
System.out.println(vo);
}
ta.commit();
} catch (Exception e) {
e.printStackTrace();
ta.rollback();
} finally {
if (null != sessionFactory) {
sessionFactory.close();
}
}
}
/**
*
* @param dataSize
* @return List
*/
public static List<TbBigStrBlob> initBlobData(int dataSize) {
List<TbBigStrBlob> list = new ArrayList<TbBigStrBlob>();
for (int i = 1; i <= dataSize; i++) {
TbBigStrBlob vo = new TbBigStrBlob();
vo.setName("test_" + i);
vo.setContent(("我是大字段<Blob>,at date：" + new Date()).getBytes());
list.add(vo);
}
return list;
}
}
运行结果如下：
../../hibernate.cfg.xml configure
start test clob ...
Hibernate: select tbbigstrbl0_.ID as ID3_, tbbigstrbl0_.NAME as NAME3_, tbbigstrbl0_.CONTENT as CONTENT3_ from MY_TB_BIG_STR_BLOB tbbigstrbl0_
start to init blob data
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: insert into MY_TB_BIG_STR_BLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: insert into MY_TB_BIG_STR_BLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: insert into MY_TB_BIG_STR_BLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: insert into MY_TB_BIG_STR_BLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: insert into MY_TB_BIG_STR_BLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: select tbbigstrbl0_.ID as ID3_, tbbigstrbl0_.NAME as NAME3_, tbbigstrbl0_.CONTENT as CONTENT3_ from MY_TB_BIG_STR_BLOB tbbigstrbl0_
query data list size = 5
TbBigStrBlob :: id = [1813878],name = [test_1],content = [我是大字段<Blob>,at date：Mon Aug 22 13:40:56 CST 2011].
TbBigStrBlob :: id = [1813879],name = [test_2],content = [我是大字段<Blob>,at date：Mon Aug 22 13:40:56 CST 2011].
TbBigStrBlob :: id = [1813880],name = [test_3],content = [我是大字段<Blob>,at date：Mon Aug 22 13:40:56 CST 2011].
TbBigStrBlob :: id = [1813881],name = [test_4],content = [我是大字段<Blob>,at date：Mon Aug 22 13:40:56 CST 2011].
TbBigStrBlob :: id = [1813882],name = [test_5],content = [我是大字段<Blob>,at date：Mon Aug 22 13:40:56 CST 2011].
从运行结果可见：注解的方式下，插入Blob数据和读取Blob数据均正常
Tips： 对于byte[] 类型的字段如果要映射成Blob字段，只需要在该字段增加如下注解即可：
Java代码
@Lob
@Column(name = "CONTENT", columnDefinition = "BLOB")
[四]、Blob字段 - 映射文件的实现
映射文件对象：BigStrBlob.java
Java代码
package michael.hibernate.bigstring.oracle;
/**
*
* @blog http://sjsky.iteye.com
* @author Michael
*/
public class BigStrBlob {
private Integer id;
private String name;
private byte[] content;
/**
* @return the id
*/
public Integer getId() {
return id;
}
/**
* @return the name
*/
public String getName() {
return name;
}
/**
* @return the content
*/
public byte[] getContent() {
return content;
}
/**
* @param pId the id to set
*/
public void setId(Integer pId) {
id = pId;
}
/**
* @param pName the name to set
*/
public void setName(String pName) {
name = pName;
}
/**
* @param pContent the content to set
*/
public void setContent(byte[] pContent) {
content = pContent;
}
/*
* (non-Javadoc)
* @see java.lang.Object#toString()
*/
@Override
public String toString() {
return "BigStrBlob :: id = [" + id + "],name = [" + name
+ "],content = [" + new String(content) + "].";
}
}
映射文件：tb_bigstr.hb.xml
Xml代码
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="michael.hibernate.bigstring.oracle">
<class name="BigStrBlob" table="MY_HB_BIG_STR_BLOB">
<id name="id" type="int" unsaved-value="null">
<generator class="increment" />
</id>
<property name="name" column="NAME" type="string"
not-null="false" length="20" />
<property name="content" column="CONTENT" type="binary"
not-null="false" />
</class>
</hibernate-mapping>
测试程序：
Java代码
package michael.hibernate.bigstring.oracle;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.cfg.Configuration;
/**
* 大字段Clob测试
* @blog http://sjsky.iteye.com
* @author Michael
*/
public class TestHbBigStr {
/**
* @param args
*/
public static void main(String[] args) {
// 测试Hibernate 映射文件 操作 大字段 Blob
TestHbBigStr.testBlob();
}
/**
* 测试Hibernate 映射文件 操作 大字段 Clob
*/
@SuppressWarnings("unchecked")
public static void testBlob() {
SessionFactory sessionFactory = null;
Transaction ta = null;
try {
System.out.println("../../hibernate.cfg.xml configure");
Configuration config = new AnnotationConfiguration()
.configure("michael/hibernate/bigstring/oracle/hibernate.cfg.xml");
sessionFactory = config.buildSessionFactory();
Session session = sessionFactory.getCurrentSession();
String hsql = "select t from BigStrBlob t ";
ta = session.beginTransaction();
org.hibernate.Query query = session.createQuery(hsql);
List<BigStrBlob> list = query.list();
if (list.size() == 0) {
System.out.println("start to init blob data");
List<BigStrBlob> initlist = initBlobData(5);
for (BigStrBlob po : initlist) {
session.save(po);
}
list = query.list();
}
System.out.println("Query data list size = " + list.size());
for (BigStrBlob vo : list) {
System.out.println(vo);
}
ta.commit();
} catch (Exception e) {
e.printStackTrace();
ta.rollback();
} finally {
if (null != sessionFactory) {
sessionFactory.close();
}
}
}
/**
*
* @param dataSize
* @return List
*/
public static List<BigStrBlob> initBlobData(int dataSize) {
List<BigStrBlob> list = new ArrayList<BigStrBlob>();
for (int i = 1; i <= dataSize; i++) {
BigStrBlob vo = new BigStrBlob();
vo.setName("test_" + i);
vo.setContent(("我是大字段<Blob>,at date：" + new Date()).getBytes());
list.add(vo);
}
return list;
}
}
运行结果如下：
../../hibernate.cfg.xml configure
Hibernate: select bigstrblob0_.id as id1_, bigstrblob0_.NAME as NAME1_, bigstrblob0_.CONTENT as CONTENT1_ from MY_HB_BIG_STR_BLOB bigstrblob0_
start to init blob data
Hibernate: select max(id) from MY_HB_BIG_STR_BLOB
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: select bigstrblob0_.id as id1_, bigstrblob0_.NAME as NAME1_, bigstrblob0_.CONTENT as CONTENT1_ from MY_HB_BIG_STR_BLOB bigstrblob0_
Query data list size = 5
BigStrBlob :: id = [1],name = [test_1],content = [我是大字段<Blob>,at date：Mon Aug 22 13:47:50 CST 2011].
BigStrBlob :: id = [2],name = [test_2],content = [我是大字段<Blob>,at date：Mon Aug 22 13:47:50 CST 2011].
BigStrBlob :: id = [3],name = [test_3],content = [我是大字段<Blob>,at date：Mon Aug 22 13:47:50 CST 2011].
BigStrBlob :: id = [4],name = [test_4],content = [我是大字段<Blob>,at date：Mon Aug 22 13:47:50 CST 2011].
BigStrBlob :: id = [5],name = [test_5],content = [我是大字段<Blob>,at date：Mon Aug 22 13:47:50 CST 2011].
从运行结果可见：映射文件的方式下，插入Blob数据和读取Blob数据均正常
Tips： 对于是映射文件的方式，Blob字段的类型指定为binary即：type=" binary "
转载来自：Michael's blog @ http://sjsky.iteye.com
如何读、写数据库中的Clob、Blob字段？
注释方式或者映射文件两种方式是如何实现的？
Clob字段是否可当成一般String来操作？
为什么Clob字段插入正常，但是读取时却为null
JDBC的驱动是不是需要最新的，才能支持Clob当成String？
JDBC驱动不更新，有没有办法实现Clob当成String操作？
。。。。。等等这些问题
下面我将以不同的实现方式的分别来演示，上述提到的问题答案将在具体的实例中给出详细的答案。本文目录：
[一]、Clob字段 - 注解方式的实现
[二]、Clob字段 - 映射文件的实现
[三]、Blob字段 - 注解方式的实现
[四]、Blob字段 - 映射文件的实现
测试的相关源代码 ：bigstring_oracle_src.7z
[一]、Clob字段 - 注解 方式的实现
域对象：TbBigStrClob.java
Java代码
package michael.hibernate.bigstring.oracle;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.Table;
import org.hibernate.annotations.Type;
/**
*
* @blog http://sjsky.iteye.com
* @author Michael
*/
@Entity
@Table(name = "MY_TB_BIG_STR_CLOB")
public class TbBigStrClob {
private Integer id;
private String name;
private String content;
/**
* @return the id
*/
@Id
@GeneratedValue
@Column(name = "ID")
public Integer getId() {
return id;
}
/**
* @return the name
*/
@Column(name = "NAME", length = 20)
public String getName() {
return name;
}
/**
* @return the content
*/
@Lob
//@Type(type = "text")
@Column(name = "CONTENT", columnDefinition = "CLOB")
public String getContent() {
return content;
}
/**
* @param pId the id to set
*/
public void setId(Integer pId) {
id = pId;
}
/**
* @param pName the name to set
*/
public void setName(String pName) {
name = pName;
}
/**
* @param pContent the content to set
*/
public void setContent(String pContent) {
content = pContent;
}
/*
* (non-Javadoc)
* @see java.lang.Object#toString()
*/
@Override
public String toString() {
return "TbBigStrClob :: id = [" + id + "],name = [" + name
+ "],content = [" + content + "].";
}
}
Hibernate 配置文件：hibernate.cfg.xml
Xml代码
<!DOCTYPE hibernate-configuration
PUBLIC "-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">
<hibernate-configuration>
<session-factory>
<property name="connection.driver_class">
oracle.jdbc.driver.OracleDriver
</property>
<property name="connection.url">
jdbc:oracle:thin:@192.168.8.49:1521:ora9i
</property>
<property name="connection.username">bm2</property>
<property name="connection.password">bm2</property>
<property name="dialect">
org.hibernate.dialect.Oracle9Dialect
</property>
<property name="connection.useUnicode">true</property>
<property name="connection.characterEncoding">UTF-8</property>
<property name="connection.SetBigStringTryClob">true</property>
<property name="connection.pool_size">10</property>
<property name="hibernate.jdbc.batch_size">10</property>
<property name="show_sql">true</property>
<property name="format_sql">false</property>
<property name="current_session_context_class">thread</property>
<property name="hbm2ddl.auto">update</property>
<!-- 注释 -->
<mapping
class="michael.hibernate.bigstring.oracle.TbBigStrClob" />
</session-factory>
</hibernate-configuration>
测试程序：
Java代码
package michael.hibernate.bigstring.oracle;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.cfg.Configuration;
/**
* 大字段Clob测试
* @blog http://sjsky.iteye.com
* @author Michael
*/
public class TestTbBigStr {
/**
* @param args
*/
@SuppressWarnings("unchecked")
public static void main(String[] args) {
// 测试Hibernate 注释方法 操作 大字段 Clob
TestTbBigStr.testClob();
}
/**
* 测试Hibernate 注释方法 操作 大字段 Clob
*/
@SuppressWarnings("unchecked")
public static void testClob() {
SessionFactory sessionFactory = null;
Transaction ta = null;
try {
System.out.println("../../hibernate.cfg.xml configure");
Configuration config = new AnnotationConfiguration()
.configure("michael/hibernate/bigstring/oracle/hibernate.cfg.xml");
sessionFactory = config.buildSessionFactory();
Session session = sessionFactory.getCurrentSession();
String hsql = "select t from TbBigStrClob t ";
System.out.println("start test clob ...");
ta = session.beginTransaction();
org.hibernate.Query query = session.createQuery(hsql);
List<TbBigStrClob> list = query.list();
if (list.size() == 0) {
System.out.println("start to init clob data");
List<TbBigStrClob> initlist = initClobData(5);
for (TbBigStrClob po : initlist) {
session.save(po);
}
list = query.list();
}
System.out.println("query data list size = " + list.size());
for (TbBigStrClob vo : list) {
System.out.println(vo);
}
ta.commit();
} catch (Exception e) {
e.printStackTrace();
ta.rollback();
} finally {
if (null != sessionFactory) {
sessionFactory.close();
}
}
}
/**
*
* @param dataSize
* @return List
*/
public static List<TbBigStrClob> initClobData(int dataSize) {
List<TbBigStrClob> list = new ArrayList<TbBigStrClob>();
for (int i = 1; i <= dataSize; i++) {
TbBigStrClob vo = new TbBigStrClob();
vo.setName("test_" + i);
vo.setContent("我是大字段<Clob>,at date：" + new Date());
list.add(vo);
}
return list;
}
}
运行结果：
../../hibernate.cfg.xml configure
start test clob ...
Hibernate: select tbbigstrcl0_.ID as ID2_, tbbigstrcl0_.NAME as NAME2_, tbbigstrcl0_.CONTENT as CONTENT2_ from MY_TB_BIG_STR_CLOB tbbigstrcl0_
start to init clob data
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: insert into MY_TB_BIG_STR_CLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: insert into MY_TB_BIG_STR_CLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: insert into MY_TB_BIG_STR_CLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: insert into MY_TB_BIG_STR_CLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: insert into MY_TB_BIG_STR_CLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: select tbbigstrcl0_.ID as ID2_, tbbigstrcl0_.NAME as NAME2_, tbbigstrcl0_.CONTENT as CONTENT2_ from MY_TB_BIG_STR_CLOB tbbigstrcl0_
query data list size = 5
TbBigStrClob :: id = [1813873],name = [test_1],content = [我是大字段<Clob>,at date：Mon Aug 22 13:10:38 CST 2011].
TbBigStrClob :: id = [1813874],name = [test_2],content = [我是大字段<Clob>,at date：Mon Aug 22 13:10:38 CST 2011].
TbBigStrClob :: id = [1813875],name = [test_3],content = [我是大字段<Clob>,at date：Mon Aug 22 13:10:38 CST 2011].
TbBigStrClob :: id = [1813876],name = [test_4],content = [我是大字段<Clob>,at date：Mon Aug 22 13:10:38 CST 2011].
TbBigStrClob :: id = [1813877],name = [test_5],content = [我是大字段<Clob>,at date：Mon Aug 22 13:10:38 CST 2011].
运行结果可见：注解方式下，插入Clob数据和读取Clob数据均正常。
Tips：
1. 在Oracle10g + 10g驱动（或者Oracle11g + 11g驱动）的环境下，只需要在Clob字段上，增加注解@Column(name = "CONTENT", columnDefinition = "CLOB")，即可成功实现建表、Clob字段的读写操作。
2. 在Oracle9i+9i的驱动环境下，仅增加注释@Column(name = "CONTENT", columnDefinition = "CLOB")时，建表、写人数据均能正常，但读取时会显示数据为空。如果在Oracle9i下又必须用9i的驱动，可以在Clob字段中再增加一行注解@Lob 或者 @Type(type = "text")。（运用spring中org.springframework.jdbc.support.lob.OracleLobHandler，这个没有具体实践过，就不在本文展开了 ）
3. 在Oracle9i+10g的驱动环境下，增加注解@Column(name = "CONTENT", columnDefinition = "CLOB")，同样可以成功实现建表、Clob字段的读写操作，可见9i的驱动对Clob支持不是很好，但10g、11g已经做了更新。
[二]、Clob字段 - 映射文件的实现
bean文件：BigStrClob.java
Java代码
package michael.hibernate.bigstring.oracle;
/**
*
* @blog http://sjsky.iteye.com
* @author Michael
*/
public class BigStrClob {
private Integer id;
private String name;
private String content;
/**
* @return the id
*/
public Integer getId() {
return id;
}
/**
* @return the name
*/
public String getName() {
return name;
}
/**
* @return the content
*/
public String getContent() {
return content;
}
/**
* @param pId the id to set
*/
public void setId(Integer pId) {
id = pId;
}
/**
* @param pName the name to set
*/
public void setName(String pName) {
name = pName;
}
/**
* @param pContent the content to set
*/
public void setContent(String pContent) {
content = pContent;
}
/*
* (non-Javadoc)
* @see java.lang.Object#toString()
*/
@Override
public String toString() {
return "BigStrClob :: id = [" + id + "],name = [" + name
+ "],content = [" + content + "].";
}
}
映射文件:tb_bigstr.hb.xml
Java代码
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="michael.hibernate.bigstring.oracle">
<class name="BigStrClob" table="MY_HB_BIG_STR_CLOB">
<id name="id" type="int" unsaved-value="null">
<generator class="increment" />
</id>
<property name="name" column="NAME" type="string"
not-null="false" length="20" />
<property name="content" column="CONTENT" type="text"
not-null="false" />
</class>
</hibernate-mapping>
在hibernate.cfg.xml文件中增加域对象的映射文件：
Xml代码
<!-- 映射 -->
<mapping
resource="michael/hibernate/bigstring/oracle/tb_bigstr.hb.xml" />
测试程序：
Java代码
package michael.hibernate.bigstring.oracle;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.cfg.Configuration;
/**
* 大字段Clob测试
* @blog http://sjsky.iteye.com
* @author Michael
*/
public class TestHbBigStr {
/**
* @param args
*/
public static void main(String[] args) {
// 测试Hibernate 映射文件 操作 大字段 Clob
TestHbBigStr.testClob();
}
/**
* 测试Hibernate 映射文件 操作 大字段 Clob
*/
@SuppressWarnings("unchecked")
public static void testClob() {
SessionFactory sessionFactory = null;
Transaction ta = null;
try {
System.out.println("../../hibernate.cfg.xml configure");
Configuration config = new AnnotationConfiguration()
.configure("michael/hibernate/bigstring/oracle/hibernate.cfg.xml");
sessionFactory = config.buildSessionFactory();
Session session = sessionFactory.getCurrentSession();
String hsql = "select t from BigStrClob t ";
ta = session.beginTransaction();
org.hibernate.Query query = session.createQuery(hsql);
List<BigStrClob> list = query.list();
if (list.size() == 0) {
System.out.println("start to init clob data");
List<BigStrClob> initlist = initClobData(5);
for (BigStrClob po : initlist) {
session.save(po);
}
list = query.list();
}
System.out.println("Query data list size = " + list.size());
for (BigStrClob vo : list) {
System.out.println(vo);
}
ta.commit();
} catch (Exception e) {
e.printStackTrace();
ta.rollback();
} finally {
if (null != sessionFactory) {
sessionFactory.close();
}
}
}
/**
*
* @param dataSize
* @return List
*/
public static List<BigStrClob> initClobData(int dataSize) {
List<BigStrClob> list = new ArrayList<BigStrClob>();
for (int i = 1; i <= dataSize; i++) {
BigStrClob vo = new BigStrClob();
vo.setName("test_" + i);
vo.setContent("我是大字段<Clob>,at date：" + new Date());
list.add(vo);
}
return list;
}
}
运行结果如下：
../../hibernate.cfg.xml configure
Hibernate: select bigstrblob0_.id as id1_, bigstrblob0_.NAME as NAME1_, bigstrblob0_.CONTENT as CONTENT1_ from MY_HB_BIG_STR_BLOB bigstrblob0_
start to init blob data
Hibernate: select max(id) from MY_HB_BIG_STR_BLOB
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: select bigstrblob0_.id as id1_, bigstrblob0_.NAME as NAME1_, bigstrblob0_.CONTENT as CONTENT1_ from MY_HB_BIG_STR_BLOB bigstrblob0_
Query data list size = 5
BigStrBlob :: id = [1],name = [test_1],content = [我是大字段<Blob>,at date：Mon Aug 22 13:28:51 CST 2011].
BigStrBlob :: id = [2],name = [test_2],content = [我是大字段<Blob>,at date：Mon Aug 22 13:28:51 CST 2011].
BigStrBlob :: id = [3],name = [test_3],content = [我是大字段<Blob>,at date：Mon Aug 22 13:28:51 CST 2011].
BigStrBlob :: id = [4],name = [test_4],content = [我是大字段<Blob>,at date：Mon Aug 22 13:28:51 CST 2011].
BigStrBlob :: id = [5],name = [test_5],content = [我是大字段<Blob>,at date：Mon Aug 22 13:28:51 CST 2011].
从运行结果可见：映射文件的方式下，插入Clob数据和读取Clob数据均正常
Tips： 如果是映射文件的，只需要把Clob字段的类型指定为text即：type="text"
[三]、Blob字段 - 注解 方式的实现
域对象的文件：TbBigStrBlob.java
Java代码
package michael.hibernate.bigstring.oracle;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.Id;
import javax.persistence.Lob;
import javax.persistence.Table;
/**
*
* @blog http://sjsky.iteye.com
* @author Michael
*/
@Entity
@Table(name = "MY_TB_BIG_STR_BLOB")
public class TbBigStrBlob {
private Integer id;
private String name;
private byte[] content;
/**
* @return the id
*/
@Id
@GeneratedValue
@Column(name = "ID")
public Integer getId() {
return id;
}
/**
* @return the name
*/
@Column(name = "NAME", length = 20)
public String getName() {
return name;
}
/**
* @return the content
*/
@Lob
@Column(name = "CONTENT", columnDefinition = "BLOB")
public byte[] getContent() {
return content;
}
/**
* @param pId the id to set
*/
public void setId(Integer pId) {
id = pId;
}
/**
* @param pName the name to set
*/
public void setName(String pName) {
name = pName;
}
/**
* @param pContent the content to set
*/
public void setContent(byte[] pContent) {
content = pContent;
}
/*
* (non-Javadoc)
* @see java.lang.Object#toString()
*/
@Override
public String toString() {
return "TbBigStrBlob :: id = [" + id + "],name = [" + name
+ "],content = [" + new String(content) + "].";
}
}
在hibernate.cfg.xml中增加域对象：
Xml代码
<mapping class="michael.hibernate.bigstring.oracle.TbBigStrBlob" />
运行测试程序：
Java代码
package michael.hibernate.bigstring.oracle;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.cfg.Configuration;
/**
* 大字段Clob测试
* @blog http://sjsky.iteye.com
* @author Michael
*/
public class TestTbBigStr {
/**
* @param args
*/
@SuppressWarnings("unchecked")
public static void main(String[] args) {
// 测试Hibernate 注释方法 操作 大字段 Blob
TestTbBigStr.testBlob();
}
/**
* 测试Hibernate 注释方法 操作 大字段 Blob
*/
@SuppressWarnings("unchecked")
public static void testBlob() {
SessionFactory sessionFactory = null;
Transaction ta = null;
try {
System.out.println("../../hibernate.cfg.xml configure");
Configuration config = new AnnotationConfiguration()
.configure("michael/hibernate/bigstring/oracle/hibernate.cfg.xml");
sessionFactory = config.buildSessionFactory();
Session session = sessionFactory.getCurrentSession();
String hsql = "select t from TbBigStrBlob t ";
System.out.println("start test clob ...");
ta = session.beginTransaction();
org.hibernate.Query query = session.createQuery(hsql);
List<TbBigStrBlob> list = query.list();
if (list.size() == 0) {
System.out.println("start to init blob data");
List<TbBigStrBlob> initlist = initBlobData(5);
for (TbBigStrBlob po : initlist) {
session.save(po);
}
list = query.list();
}
System.out.println("query data list size = " + list.size());
for (TbBigStrBlob vo : list) {
System.out.println(vo);
}
ta.commit();
} catch (Exception e) {
e.printStackTrace();
ta.rollback();
} finally {
if (null != sessionFactory) {
sessionFactory.close();
}
}
}
/**
*
* @param dataSize
* @return List
*/
public static List<TbBigStrBlob> initBlobData(int dataSize) {
List<TbBigStrBlob> list = new ArrayList<TbBigStrBlob>();
for (int i = 1; i <= dataSize; i++) {
TbBigStrBlob vo = new TbBigStrBlob();
vo.setName("test_" + i);
vo.setContent(("我是大字段<Blob>,at date：" + new Date()).getBytes());
list.add(vo);
}
return list;
}
}
运行结果如下：
../../hibernate.cfg.xml configure
start test clob ...
Hibernate: select tbbigstrbl0_.ID as ID3_, tbbigstrbl0_.NAME as NAME3_, tbbigstrbl0_.CONTENT as CONTENT3_ from MY_TB_BIG_STR_BLOB tbbigstrbl0_
start to init blob data
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: insert into MY_TB_BIG_STR_BLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: insert into MY_TB_BIG_STR_BLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: insert into MY_TB_BIG_STR_BLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: insert into MY_TB_BIG_STR_BLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: insert into MY_TB_BIG_STR_BLOB (NAME, CONTENT, ID) values (?, ?, ?)
Hibernate: select tbbigstrbl0_.ID as ID3_, tbbigstrbl0_.NAME as NAME3_, tbbigstrbl0_.CONTENT as CONTENT3_ from MY_TB_BIG_STR_BLOB tbbigstrbl0_
query data list size = 5
TbBigStrBlob :: id = [1813878],name = [test_1],content = [我是大字段<Blob>,at date：Mon Aug 22 13:40:56 CST 2011].
TbBigStrBlob :: id = [1813879],name = [test_2],content = [我是大字段<Blob>,at date：Mon Aug 22 13:40:56 CST 2011].
TbBigStrBlob :: id = [1813880],name = [test_3],content = [我是大字段<Blob>,at date：Mon Aug 22 13:40:56 CST 2011].
TbBigStrBlob :: id = [1813881],name = [test_4],content = [我是大字段<Blob>,at date：Mon Aug 22 13:40:56 CST 2011].
TbBigStrBlob :: id = [1813882],name = [test_5],content = [我是大字段<Blob>,at date：Mon Aug 22 13:40:56 CST 2011].
从运行结果可见：注解的方式下，插入Blob数据和读取Blob数据均正常
Tips： 对于byte[] 类型的字段如果要映射成Blob字段，只需要在该字段增加如下注解即可：
Java代码
@Lob
@Column(name = "CONTENT", columnDefinition = "BLOB")
[四]、Blob字段 - 映射文件的实现
映射文件对象：BigStrBlob.java
Java代码
package michael.hibernate.bigstring.oracle;
/**
*
* @blog http://sjsky.iteye.com
* @author Michael
*/
public class BigStrBlob {
private Integer id;
private String name;
private byte[] content;
/**
* @return the id
*/
public Integer getId() {
return id;
}
/**
* @return the name
*/
public String getName() {
return name;
}
/**
* @return the content
*/
public byte[] getContent() {
return content;
}
/**
* @param pId the id to set
*/
public void setId(Integer pId) {
id = pId;
}
/**
* @param pName the name to set
*/
public void setName(String pName) {
name = pName;
}
/**
* @param pContent the content to set
*/
public void setContent(byte[] pContent) {
content = pContent;
}
/*
* (non-Javadoc)
* @see java.lang.Object#toString()
*/
@Override
public String toString() {
return "BigStrBlob :: id = [" + id + "],name = [" + name
+ "],content = [" + new String(content) + "].";
}
}
映射文件：tb_bigstr.hb.xml
Xml代码
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="michael.hibernate.bigstring.oracle">
<class name="BigStrBlob" table="MY_HB_BIG_STR_BLOB">
<id name="id" type="int" unsaved-value="null">
<generator class="increment" />
</id>
<property name="name" column="NAME" type="string"
not-null="false" length="20" />
<property name="content" column="CONTENT" type="binary"
not-null="false" />
</class>
</hibernate-mapping>
测试程序：
Java代码
package michael.hibernate.bigstring.oracle;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.hibernate.Session;
import org.hibernate.SessionFactory;
import org.hibernate.Transaction;
import org.hibernate.cfg.AnnotationConfiguration;
import org.hibernate.cfg.Configuration;
/**
* 大字段Clob测试
* @blog http://sjsky.iteye.com
* @author Michael
*/
public class TestHbBigStr {
/**
* @param args
*/
public static void main(String[] args) {
// 测试Hibernate 映射文件 操作 大字段 Blob
TestHbBigStr.testBlob();
}
/**
* 测试Hibernate 映射文件 操作 大字段 Clob
*/
@SuppressWarnings("unchecked")
public static void testBlob() {
SessionFactory sessionFactory = null;
Transaction ta = null;
try {
System.out.println("../../hibernate.cfg.xml configure");
Configuration config = new AnnotationConfiguration()
.configure("michael/hibernate/bigstring/oracle/hibernate.cfg.xml");
sessionFactory = config.buildSessionFactory();
Session session = sessionFactory.getCurrentSession();
String hsql = "select t from BigStrBlob t ";
ta = session.beginTransaction();
org.hibernate.Query query = session.createQuery(hsql);
List<BigStrBlob> list = query.list();
if (list.size() == 0) {
System.out.println("start to init blob data");
List<BigStrBlob> initlist = initBlobData(5);
for (BigStrBlob po : initlist) {
session.save(po);
}
list = query.list();
}
System.out.println("Query data list size = " + list.size());
for (BigStrBlob vo : list) {
System.out.println(vo);
}
ta.commit();
} catch (Exception e) {
e.printStackTrace();
ta.rollback();
} finally {
if (null != sessionFactory) {
sessionFactory.close();
}
}
}
/**
*
* @param dataSize
* @return List
*/
public static List<BigStrBlob> initBlobData(int dataSize) {
List<BigStrBlob> list = new ArrayList<BigStrBlob>();
for (int i = 1; i <= dataSize; i++) {
BigStrBlob vo = new BigStrBlob();
vo.setName("test_" + i);
vo.setContent(("我是大字段<Blob>,at date：" + new Date()).getBytes());
list.add(vo);
}
return list;
}
}
运行结果如下：
../../hibernate.cfg.xml configure
Hibernate: select bigstrblob0_.id as id1_, bigstrblob0_.NAME as NAME1_, bigstrblob0_.CONTENT as CONTENT1_ from MY_HB_BIG_STR_BLOB bigstrblob0_
start to init blob data
Hibernate: select max(id) from MY_HB_BIG_STR_BLOB
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: insert into MY_HB_BIG_STR_BLOB (NAME, CONTENT, id) values (?, ?, ?)
Hibernate: select bigstrblob0_.id as id1_, bigstrblob0_.NAME as NAME1_, bigstrblob0_.CONTENT as CONTENT1_ from MY_HB_BIG_STR_BLOB bigstrblob0_
Query data list size = 5
BigStrBlob :: id = [1],name = [test_1],content = [我是大字段<Blob>,at date：Mon Aug 22 13:47:50 CST 2011].
BigStrBlob :: id = [2],name = [test_2],content = [我是大字段<Blob>,at date：Mon Aug 22 13:47:50 CST 2011].
BigStrBlob :: id = [3],name = [test_3],content = [我是大字段<Blob>,at date：Mon Aug 22 13:47:50 CST 2011].
BigStrBlob :: id = [4],name = [test_4],content = [我是大字段<Blob>,at date：Mon Aug 22 13:47:50 CST 2011].
BigStrBlob :: id = [5],name = [test_5],content = [我是大字段<Blob>,at date：Mon Aug 22 13:47:50 CST 2011].
从运行结果可见：映射文件的方式下，插入Blob数据和读取Blob数据均正常
Tips： 对于是映射文件的方式，Blob字段的类型指定为binary即：type=" binary "
转载来自：Michael's blog @ http://sjsky.iteye.com
分享到：
发表评论
-
oracle基础学习
2012-11-07 15:13 1566转自（http://www.cnblogs.com ... -
hibernate 进行多表查询每个表中各取几个字段
2012-05-23 13:57 1600hibernate 进行多表查询每个表中各取几个字段，也就是说 ... -
oracle start with connect by 用法
2011-09-30 09:49 1399oracle 提供了start with connect by ... -
Hibernate性能优化(三)
2011-09-08 09:37 1089一。 inverse = ? inver ... -
Hibernate性能优化(二)
2011-09-08 09:35 934Hibernate的缓存优化 1、 ... -
Hibernate性能优化一
2011-09-08 09:31 942有很多人认为Hibernate天生效率比较低，确实，在普遍情况 ... -
Hibernate进行大数据量处理时的优化操作
2011-09-08 09:11 23461) 在处理大数据量时， ... -
Struts spring hibernate经典面试题
2011-08-31 17:20 900Struts，Hibernate，Spring经 ... -
Hibernate中大批量处理数据机制
2011-08-22 10:10 957如果我们要保存的数据 ... -
数据库优化基本策略（转载）
2011-07-15 08:58 8951.选择正确类型的sql。 有时候你想要动态生成sql，却发现 ... -
oracle 查询数据null值排序
2011-07-11 18:16 1250sqlserver 认为 null 最小。 升序排列：nul ... -
不错的sql
2011-07-04 09:05 10091，说明：复制表（源表名a，新表名b） 法一：select ... -
oracle CLOB和BLOB
2011-06-25 21:18 1424一、区别和定义 LONG: 可变长的字符串数据， ... -
Oracle中TO_DATE格式
2011-05-19 17:34 878TO_DATE格式(以时间:2007-11-02 13:4 ... -
ORACLE错误一览表，方便大家查询！
2011-05-03 17:50 1534ORACLE错误一览表，方便 ... -
oracle 锁表
2011-04-26 16:37 1165查看锁表进程SQL语句1： select sess.sid, ... -
ORACLE 创建索引
2011-03-18 14:42 1066Oracle的分区技术在某些条件下可以极大的提高查询的性能，所 ... -
PL/SQL Developer 常用技巧
2011-03-18 14:10 8741、PL/SQL Developer记住登 ... -
谈谈Hibernate缓存使用(一)
2011-03-17 16:16 952Hibernate缓存是一种提高 ... -
java调用oracle存储过程
2010-12-17 11:14 1192在大型数据库系统中，有两个很重要作用的功能，那就是存储过程和触 ...
相关推荐
在了解如何使用OARCLE 11g RAC + ASM安装手册之前，我们需要先对Oracle的RAC和ASM技术进行一个简要的了解。RAC（Real Application Clusters）是Oracle数据库的一项高可用性技术，它允许多个Oracle实例共享同一个物理...
在DML操作中，我们还可以使用WHERE子句来设置条件，以精确地定位我们要操作的数据。 DDL（Data Definition Language）是用于创建和修改数据库结构的语言，比如定义和修改表、视图、索引等。CREATE TABLE语句用于...
- **性能影响**：相对于归档模式，非归档模式可能在某些情况下提供更好的性能，因为它减少了I/O操作。 #### 三、如何在归档模式与非归档模式之间进行切换 1. **关闭数据库**：首先需要关闭数据库实例，以避免切换...
本文将深入探讨“重装Oracle”过程中必须注意的关键点，包括但不限于卸载步骤、注册表清理、环境变量调整及后续配置等，旨在为IT专业人士提供全面的指导。 ### 一、彻底卸载Oracle #### 1. 停止所有Oracle服务 ...
Oracle是全球广泛使用的大型关系型数据库管理系统之一，其在企业级数据存储和管理中扮演着重要角色。"Oracle培训资料大全"涵盖了Oracle系统的多个关键方面，对于想要学习或提升Oracle技能的人来说，是一份非常宝贵的...
Oracle数据库是全球广泛使用的数据库管理系统，而PL/SQL（Procedural Language/Structured Query Language）则是Oracle数据库系统中的一种过程化编程语言，用于编写数据库应用程序。PL/SQL结合了SQL的强大查询功能和...
在Java编程环境中，将Oracle数据库的表结构导出到Excel是一种常见的需求，特别是在数据库管理和数据分析时。这个场景可以通过两个核心类来实现：`TableStructureToExcel.java`和`ConnectionOracle.java`。这两个类...
标题中提到的“Oracle®Database 2Day+ Security Guide 11g Release 2 (11.2) E10575-08”指的是Oracle数据库的安全指南文档，适用于Oracle数据库版本11g的第二个更新版（11.2）。E10575-08是该文档的版本号，而日期...
这样用户SONIC的所有对象被输出到文件中。 3、表模式： EXP SONIC/SONIC BUFFER=64000 FILE=C:\SONIC.DMP OWNER=SONIC TABLES=(SONIC) 这样用户SONIC的表SONIC就被导出 2、IMP: 具有三种模式（完全、用户...
在Oracle数据库中，死锁是由于多个并发操作试图同时锁定同一资源导致的。一旦发生死锁，Oracle会自动检测并解除其中一个事务的锁定，以确保其他事务可以继续执行。了解如何识别和解决Oracle中的查询死锁对于维护...
4. **字段长度限制**：在`VARCHAR2`类型中，我们指定了字段的最大长度，如`VARCHAR2(100)`表示该字段最多能存储100个字符。 5. **日期和时间处理**：Oracle支持多种日期和时间格式，使用`DATE`类型可以同时存储日期...
### Oracle过程中创建视图实例 在Oracle数据库管理中，通过PL/SQL块执行动态SQL语句是一项非常重要的技能。其中一个核心功能就是`EXECUTE IMMEDIATE`，它允许开发者在运行时构建并执行SQL语句。这在需要动态生成SQL...
【描述】：本文主要探讨了如何通过Oracle数据库的事件触发器增强“军卫一号”医院信息系统的安全性，针对系统中存在的用户权限管理漏洞提出解决方案。 【标签】：Oracle数据库、关系型数据库、参考文献、专业指导 ...
在Oracle ADF中，安全性通常涉及到对资源的访问控制，包括JSP（JavaServer Pages）页面。本文将深入探讨如何在Oracle ADF环境中配置不受保护的JSP页面，以便允许所有用户访问。 首先，了解Oracle ADF Security的...
Duplicate技术的核心优势在于它可以快速地复制主数据库到备用数据库，并且能够在复制过程中保持业务正常运行，这为实现高效的数据保护提供了一种有效途径。 #### 三、环境配置与准备 1. **网络配置**：在搭建...
在虚拟机上安装Oracle数据库是一个涉及多个步骤的过程，该教程旨在指导用户如何在虚拟机环境中设置Oracle数据库，并配置相关环境，使得用户能够在自己的主机上通过sqldeveloper这样的客户端工具连接到虚拟机中配置的...
本文详细介绍的oracle数据库如何存储bfile
在 Oracle 数据库中，经常会遇到需要导出某用户所有表的情况，这可以通过使用 exp 工具来实现。但是，这个命令需要指定具体的表名，这样就需要用户手动输入每个表名，这非常不方便。下面我们来介绍一个可以批量导出...