andyj2ee

java tec sky

統計

隨筆 - 42
文章 - 13
評論 - 15
引用 - 0

留言簿(4)

閱讀排行榜

評論排行榜

1.?WARN afterTransactionCompletion() was never called(3)
2.?用maven 啟動 jboss 時出現異常：[java] FATAL ERROR in native method: JDWP No transports initialized, jvmtiError=JVMTI_ERROR_INTERNAL(113)(2)
3.?工作流方面的知識(2)
4.?How do you use findByNamedParam，findByNamedQueryAndNamedParam？(1)
5.?hibernate ant Hbm2JavaTask Exception of:org.xml.sax.SAXParseException: Attribute "insert" must be declared for element type "discriminator".(1)

Oracle Blob/Clob 字段寫入時產生轉型異常Cast Exception

CLOB clob = (CLOB)us.getStatisticsInfo();

原因是
java.sql.Blob不能強制傳喚成oracle.sql.BLOB

解決方法如下：

SerializableClob lob=(SerializableClob)us.getStatisticsInfo();
CLOB lob2 = (CLOB)lob.getWrappedClob();
Writer out = lob2.getCharacterOutputStream();

public void testAdd() throws Exception {

byte[] buffer = new byte[1];

buffer[0] = 1;

Session s = null;

try {

s = sf.openSession();

Transaction tx = s.beginTransaction();

BizUserStatistics us= new BizUserStatistics();

us.setId(new Long(100));

us.setStatisticsInfo(Hibernate.createClob(" "));

s.save(us);

s.flush();

s.refresh(us, LockMode.UPGRADE);

// CLOB clob = (CLOB)us.getStatisticsInfo();

SerializableClob lob=(SerializableClob)us.getStatisticsInfo();

CLOB lob2 = (CLOB)lob.getWrappedClob();

Writer out = lob2.getCharacterOutputStream();

String fileName = "d:/process_log.sql";

File f = new File(fileName);

FileInputStream fin = new FileInputStream(f);

StringBuffer sb = new StringBuffer();

for (int i = 0; i < 1000; i++){

sb.append("<data>" + i + "</data>");

}

out.write(sb.toString());

out.close();

s.flush();

tx.commit();

} catch (Exception e) {

e.printStackTrace();

} finally {

if (s != null)

try {

s.close();

} catch (Exception e){}

}

方向:分布式系統設計

posted on 2006-02-14 16:35 java光環閱讀(1245) 評論(0) 編輯收藏所屬分類: hibernate

新用戶注冊刷新評論列表


只有注冊用戶登錄后才能發表評論。




網站導航: 博客園 IT新聞 Chat2DB C++博客博問管理
相關文章: Oracle Blob/Clob 字段寫入時產生轉型異常Cast Exception WARN afterTransactionCompletion() was never called hibernate ant Hbm2JavaTask Exception of:org.xml.sax.SAXParseException: Attribute "insert" must be declared for element type "discriminator". hiberante persistence 關于cascade 與inverse

andyj2ee

導航

隨筆分類

文章分類

收藏夾

隨筆檔案

文章檔案

統計

留言簿(4)

activemq

aop

design pattern

other blog

spring

workflow

多線程

軟件架構師

閱讀排行榜

評論排行榜

Oracle Blob/Clob 字段寫入時產生轉型異常Cast Exception