Inserting Multipart file in to Database

Question

I'm trying to update the files in the Oracle Db with the help of following code

@RequestMapping(value = "/person/{personId}", method = RequestMethod.POST)
    public @ResponseBody String save(@RequestParam MultipartFile files,@PathVariable int personId,) throws IOException {

        byte [] bFile =files.getBytes();
        personService.uploadImageOnId(personId,bFile);
}

This is ServiceImpl

@Override
public void uploadImageOnId(int personId,byte [] personImage) {
        entityManager.createNamedQuery("Person.uploadImageOnId")
                .setParameter("personId", personId).setParameter("personImage", personImage)
                .executeUpdate();

    }

Entity

@Entity
@Table(name = "PERSON")
@NamedQueries({ 
@NamedQuery(name = "Person.uploadImageOnId", query = "UPDATE Person p SET p.personImage= :personImage WHERE p.personId= :personId" )

})
public class Person implements java.io.Serializable {
    @Column(name="PERSON_IMAGE")
        @Lob
        private byte[] personImage;

        public byte[] getPersonImage() {
            return personImage;
        }

        public void setPersonImage(byte[] personImage) {
            this.personImage = personImage;
        }
}

but am getting following error

java.lang.ClassCastException: [B cannot be cast to [Ljava.lang.Object;

please direct where i'm doing wrong.

Which method call with which acutal parameters cause the exception? — Smutje
– Smutje, Commented Feb 15, 2014 at 9:50
@Smutje .setParameter("personImage", personImage) here it is pointing error — user2582360
– user2582360, Commented Feb 15, 2014 at 10:03
Well personImage is not an object so that might be it, can you try to use Byte[] ? — Pierre
– Pierre, Commented Feb 15, 2014 at 10:03

Community · Accepted Answer · 2017-05-23 12:20:41Z

2

Refering to Inserting byte[] array as blob in Oracle Database getting ORA-01460: unimplemented or unreasonable conversion requested, I would suggest not to set the byte array as value but a ByteArrayInputStream wrapping your array.

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Feb 15, 2014 at 10:10

Smutje

18.2k4 gold badges26 silver badges42 bronze badges

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

3 Comments

user2582360 Over a year ago

I tried this on ur suggestion .setParameter("personImage", new ByteArrayInputStream(personImage)) but am gettin exception

user2582360 Over a year ago

we cant use setBinaryStream in createNamedquery

user2582360 Over a year ago

is der any other way of doing this?

Collectives™ on Stack Overflow

Inserting Multipart file in to Database

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related