Reading a blob object from a database

[sajeev varghese]

I tried to read a blob value from a Mysql database.But this field is obtained as java.sql.types varlongbinary instead of BLOB.
Now when i tried to read the content of the blob field which is an xml using
getbinaryStream method, i encountered some problems.
I have read the contents into a byte array using read method of inputstream
and when i converted this byte array to a string using toString it returns the byte array object value and not the orirginal contents.
Actually i want to read this content and insert into a clob field of an oracle database.
Somebody Please help me to sort out the problem.

[Bear Bibeault]

"sajeev V",

You have already received two warning to change your display name to conform to JavaRanch standards. Your name must be a first name and a last name separated by a space. An initial will not do.

This is your final warning. Change your display name to a valid value prior to your next post. Otherwise, your account will be closed.

bear
JavaRanch Sheriff