Technologies which I am using are flex, spring and hibernate. Backend is oracle with thin driver. System allows user to choose file from flex mxml page, it makes a HTTPService call to a servlet where I am getting inputstream object from the request.
Now my question is how do I use this inputstream object with blob.
I know if I can do it by writing simple jdbc code then I can do the same by hibernate.
Few ways which I found from google are:
1. insert a empty_blob() in that column, 2. load that column to get its pointer. Get it from ResultSet 3. Read byte from inputstream and write it in the outputstream pointing to the blob column.
I am able to write the data in the database column by above approach but not more than 3 kb. I don't know what is the problem. In my case file size is maximum 12 MB.
Second approach which I got from google is by class SQLUpdate. But it did not work.