Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Inserting BLOB data

 
Mainak Goswami
Ranch Hand
Posts: 52
Eclipse IDE Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I am facing a very critical issue when we try to insert a file in the blob column in the Oracle database.
Steps for inserting data in Blob column in Oracle.
1) Insert other fields and EMPTY_BLOB() in the Table T1.
2) Getting the byte array of the file and updating the blob column with this value.

Issue:
This is working fine with file of size less than 4KB. But if it is more than '4KB' it is giving the following error:
"java.sql.SQLException: Data size bigger than max size for this type: 10640"

Code snippet:-

dao.setBytes(1, objAttachment.getFileObject()); //getFileObject() returns byte[]

Please suggest how can we resolve this issue.

Many thanks
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic