-
1. Re: Oracle Blobs and CMP- JBoss 3.0.2/classes12.zip
magic Sep 13, 2002 8:15 AM (in response to jakasjava)I have the same Problem with an Oracle Long Raw Field. If you solve that please write it down here.
Thank you for answers! -
2. Re: Oracle Blobs and CMP- JBoss 3.0.2/classes12.zip
jakasjava Sep 13, 2002 12:56 PM (in response to jakasjava)Instead of setting Blob and living it to implementation class like in classes12.zip, can we not convert blobs to streams and write it ....
for instance we have package org.jboss.resource.adapter.jdbc.local.LocalPreparedStatement.java
method setBlob can be changed to call setBinaryStream as show in belo snippet
public void setBlob(int parameterIndex, Blob value) throws SQLException
{
try
{
Long l =new Long(value.length() );
int leng = l.intValue();
setBinaryStream(parameterIndex, value.getBinaryStream() , leng);
// ps.setBlob(parameterIndex, value);
}
catch (SQLException e)
{
checkException(e);
} // end of try-catch
}
like wise, change setClob to call setASCIIStream
What do you think of this idea. Kind of worked for me. But I get IllegalStateException now. I am not sure, this is because of the bug I just inserted.!!!
thanks
sudhi