David.Turing's blog

# re: Oracle Blob字段寫入時產(chǎn)生轉(zhuǎn)型異常Cast Exception 2006-02-09 15:19 david.turing

同樣,對Clob，也是這樣轉(zhuǎn)型

SerializableClob clob=(SerializableClob)m_sig.getSignValue();

CLOB clob2 = (CLOB)clob.getWrappedClob();

Writer out = clob2.getCharacterOutputStream();
out.write(sig);
out.close();  回復(fù)  更多評論   

# re: Oracle Blob字段寫入時產(chǎn)生轉(zhuǎn)型異常Cast Exception 2009-09-19 14:31 ccccc

jndi 下的轉(zhuǎn)換
public int setBytes(long pos, byte[] bytes) throws SQLException
{
if (blob != null)
{
if (blob.getClass().getName().toLowerCase().indexOf("weblogic") >= 0)
{
try
{
Method method = blob.getClass().getMethod("putBytes",new Class[]{long.class,byte[].class});

return ((Integer)method.invoke(blob, new Object[]{pos, bytes})).intValue();
}
catch (Exception e)
{
e.printStackTrace();
}
}
}

//[weblogic]
// if (blob instanceof weblogic.jdbc.vendor.oracle.OracleThinBlob)
// {
// weblogic.jdbc.vendor.oracle.OracleThinBlob oBlob = (weblogic.jdbc.vendor.oracle.OracleThinBlob) blob;
// return oBlob.putBytes(pos, bytes);
// }
//[endweblogic]
//[websphere]

if (blob instanceof oracle.sql.BLOB)
{
oracle.sql.BLOB oBlob = (oracle.sql.BLOB) blob;
return oBlob.putBytes(pos, bytes);
}
//[endwebsphere]

return this.blob.setBytes(pos, bytes);
}  回復(fù)  更多評論