inserting an image in the database with a BLOB datatype

Question

entity:

@Lob
@Column(name = "logo")
private byte[] logo;

form:

<h:form enctype="multipart/form-data">  
    <p:messages showDetail="true"/>  

    <p:fileUpload value="#{testController.file}" 
                  update="messages"  
                  mode="simple"
                  sizeLimit="1048576"   
                  allowTypes="/(\.|\/)(gif|jpe?g|png)$/"/>  

    <p:growl id="messages" showDetail="true"/>  

    <p:commandButton value="Submit" ajax="false"  
                     actionListener="#{testController.upload}"/>  
</h:form>

bean:

private testEntity current;
private UploadedFile file;

public UploadedFile getFile() {
    return file;
}

public void upload() {
    if (file != null) {
        try {
            byte[] data = file.getContents();
            current.setLogo(data);

            getFacade().edit(current);
            JsfUtil.addSuccessMessage("Successful! " + file.getFileName() + " is uploaded.");
        } catch (Exception e) {
        }
    }
}

when i try to upload files like 80kb picture, it will give me this exception

Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.2.v20111125-r10461): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'logo' at row 1

but if i upload a mere < 10kb pictures, the code works.

using JSF 2.0, Primefaces 3.5, most codes are auto generated using CRUD.

How do you declare your database column?

skuntsel
– skuntsel

2013-03-22 06:12:05 +00:00
Commented Mar 22, 2013 at 6:12 — skuntsel
– skuntsel, Commented Mar 22, 2013 at 6:12
This is a JPA problem, not JSF.

Luiggi Mendoza
– Luiggi Mendoza

2013-03-22 06:14:00 +00:00
Commented Mar 22, 2013 at 6:14 — Luiggi Mendoza
– Luiggi Mendoza, Commented Mar 22, 2013 at 6:14
i declared it as BLOB

galao
– galao

2013-03-22 06:49:30 +00:00
Commented Mar 22, 2013 at 6:49 — galao
– galao, Commented Mar 22, 2013 at 6:49

Ares · Accepted Answer · 2013-03-22 06:20:50Z

1

The problem is that your database column is set to stored less than what you are trying to store. That's what truncating means.

You will need to change your database column definition to LONGBLOB.

answered Mar 22, 2013 at 6:20

Ares

5,9033 gold badges37 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

galao Over a year ago

but i was just uploading an 84kb size image

Ares Over a year ago

You may want to MySQL storage requirements.

Collectives™ on Stack Overflow

inserting an image in the database with a BLOB datatype

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related