• 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

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.

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