insert BLOB file from Local to DB

Question

I am trying to allow users to choose a file from local hard disk and to insert it with java in a Oracle Data base as BLOB value.

The setBinaryStream did not allow big files.

with the setBlob I have no way to convert the file to a blob.

Is the import of a blob file from the DB then overwrite it the unique solution?.

Regards, Haythem

score 2 · Accepted Answer · answered Nov 26 '10 at 09:03

2

This is a suggestion that I've used before

In essence a file is an array of bytes, what you can do is to read the file data and use PreparedStatement.setBytes(index, byte[]) to store the data.

Hope this helps.

answered Nov 26 '10 at 09:03

Buhake Sindi

87,898
29
167
228

setBytes did not allow big files. – Haythem Nov 26 '10 at 09:07
How big is the file? Why not increase the BLOB size? – Buhake Sindi Nov 26 '10 at 09:08
for 1 kB is ok for 1 MB not. – Haythem Nov 26 '10 at 09:11
I store 5MB file in MySQL using Blob with not problems (and I use `setBytes()`. – Buhake Sindi Nov 26 '10 at 09:12
1

I am using oracle DB perhapes is this made a difference. – Haythem Nov 26 '10 at 09:15
@Haythem, it shouldn't, make sure your Blob size can accept files >= 1MB. – Buhake Sindi Nov 26 '10 at 09:16
I defined the File as Oracle.sql.BLOB and it works. with java.sql.blob is not working – Haythem Nov 26 '10 at 14:52

score 1 · Answer 2 · answered Nov 26 '10 at 09:04

1

You need to read the file as any byte array. This byte array can be assigned to Oracle BLOB column.

answered Nov 26 '10 at 09:04

Shekhar

11,438
36
130
186

insert BLOB file from Local to DB

2 Answers2

Linked