Java Forum

Ask Question   UnAnswered
Home » Forum » Java       RSS Feeds

Can't insert HTML file in a BLOB column

  Asked By: Bonni    Date: Dec 26    Category: Java    Views: 876

I have been trying to insert HTML files into BLOB column using JDBC.
About 90% of the HTML files are inserted correctly, but it seems to
me that rest of the HTML files are not inserted. While others return
correct file size with a stored procedure, some return nothing. If
BLOB columns are not updated and still have emply_blob(), that stored
procedure should return 0 instead. Why those blob columns are not
updated correctly?



2 Answers Found

Answer #1    Answered By: Orville Rodriguez     Answered On: Dec 26

they where to big to fit in BLOB..............

Answer #2    Answered By: Bonifaco Garcia     Answered On: Dec 26

I checked the sizes of some files  but maximum size  I found was just
10KB or so. I even inserted  another HTML file, which was inserted
correctly before, into the row that has a problem. It worked! So, I
think the HTML files themselves may have a problem.

Do you think it causes problem if HTML files does not use appropriate
escape sequences when they are inserted into BLOB?

Didn't find what you were looking for? Find more on Can't insert HTML file in a BLOB column Or get search suggestion and latest updates.