storing byte[] in a (oracle)blob

[snoofle]

hello all,
i've have again a problem with storing a byte[] in a blob under oracle ...
is there a way to store byte[]like this ( or another way any help is great ) ?

  
byte[] bytedata = null;
and then storing it with
SqlStatement = 
INSERT INTO BLOB_TABLE 
(FILENAME,FILESIZE,BLOBDATA) VALUES (?,?,?);

insertstatement.setString(1,filename);
insertstatement.setInt(2,filesize);
insertstatement.setXXX(3,bytedata);
int rows = insertstatement.executeUpdate();
insertstatement.close();

i have an example with a filestream, but no idea how to insert byte[] directly ...

tia
andreas

[Jamie Robertson]

PreparedStatement ps = con.prepareStatement( "Update table set field1 = ? WHERE ..." )
String longString = "super duper long big...a couple thousand more characters...huge String"; 
int size = longString.length();
BufferedInputStream bais = new BufferedInputStream( new ByteArrayInputStream( longString.getBytes() ) );
ps.setAsciiStream( 1, bais, size );//or setBinaryStream()
ps.executeUpdate();

the above might work for you. If not try these:

java.io.OutputStream outstream;
// read data into a byte array 
byte[] data = {0, 1, 2, 3, 4, 5, 6, 7, 8, 9};
// write the array of binary data to a BLOB
outstream = ((BLOB)my_blob).getBinaryOutputStream();
outstream.write(data);

There is more info
here.
Jamie

[Harry Wood]

Yeah 'ps.setBinaryStream' worked for me.

...and for reading the blob back again I used:

Blob aBlob = resultSet.getBlob( "MY_BLOB_FIELD_NAME");
byte[] theBytes = aBlob.getBytes( 1, (int)aBlob.length() );

Trying to use 'resultSet.getBytes' seemed to work, but it always came back with 86 bytes of useless poo (???)

Probably all depends what JDBC driver you're using though.

[Ajith Kallambella]

Hello "snoofle"-

Welcome to JavaRanch.

On your way in you may have missed that JavaRanch has a policy on display names, and yours does not comply with it - please adjust it accordingly, which you can do right here. Thanks for your prompt attention to this matter.

Enyoy your time here.

[Jeanne Boyarsky]

Ajith,
Given Snoofle's posting date of 2002, it sounds like he's long gone. I suspect he won't give the display name any "prompt attention"

Harry,
When you do a search, note that the date of each post is on top. Ones from the past are valuable to read, but not likely awaiting help.