Answers to: XpertIvy / SQL : How can i write a file in a sql db?

Answer by MaxIvy

MaxIvy — Mon, 01 Dec 2014 13:39:42 -0500

Hi Daniel, Thank you for your answer. I tried this of course, but i wont work. Look at the screen

Im am not sure whats wrong

Answer by Daniel Oechslin

Daniel Oechslin — Mon, 01 Dec 2014 11:41:51 -0500

Hi MaxIvy

below you see a sample database configuration. You can add your connection as shown in the picture and configure with the parameters you need and add the name- here: building as your myDatabaseContextName.

Hope this helps Daniel

Answer by MaxIvy

MaxIvy — Mon, 01 Dec 2014 11:11:39 -0500

Thank you su much for your answer and soory that i get a little bit late get back: For the moment i got an error in this line IIvyEntityManager entityManager= Ivy.persistence().get(myDatabaseContextName); --> What have i put here inside?

Thank u so much

Answer by Daniel Oechslin

Daniel Oechslin — Tue, 14 Oct 2014 08:38:23 -0400

I guess you did something like this:

UI-Dialog:

    p:row>
        p:column>
            p:fileUpload label="Upload" fileUploadListener="#{uploadBean.handleFileUpload}" mode="advanced"
                auto="true" />
        /p:column>
   /p:row>

Due to this is a primeface-action there should be no problem with this.

Your Java-Class:

import org.primefaces.event.FileUploadEvent;
import org.primefaces.model.UploadedFile;

@ManagedBean
@ViewScoped
public class UploadBean {

    public void handleFileUpload(FileUploadEvent event) {
        UploadedFile uploadedFile = event.getFile();
        byte[] myFile= uploadedFile.getContents();
    }

The byte[] you now can save to your database as bytea.

In case you wonder how the persistence could be implemented:

Dataclass:

@Entity
@Table(name = "myFunny_FilesTableName")
@Access(AccessType.PROPERTY)
public class Files implements Serializable {

private Long id;
    private static final long serialVersionUID = 1L;
        private byte[] myPdf;

    @Id
    @GeneratedValue(strategy = GenerationType.SEQUENCE)
    @Column(name = "id")
    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    @Lob //this annotation is only nescessary if you want it to save as a large object in your database. If you use @Lob //you get a postgres oid. If you just send the byte[] without annotation you get a bytea.
    public byte[] getMyPdf() {
      return myPdf;
    }

    public void set(MyPdf(byte[] myPdf){
       //do sth
     }

Persistence class:

public class FilesDao {

public Files saveOrUpdate(Files files) throws Exception {
    IIvyEntityManager entityManager= Ivy.persistence().get(myDatabaseContextName);
    Files newFiles;
    try {
        newFiles = entityManager.merge(files);
    } catch (Exception e) {
        Ivy.log().error("Unable to save file.");
        throw e;
    }
    return newFiles;
}

And now you can add these line to save your files:

byte[] pdfByteArray;  //the byteArray from the primefaces

Files myPdf= new Files(); //create a new entity
myPdf.setMyPdf(pdfByteArray) //fill it with your data
Files thePersistedPdf= new FilesDao().saveOrUpdate(myPdf); //merge it to your databse.

Hope this helps a bit.

Answer by MaxIvy

MaxIvy — Mon, 13 Oct 2014 16:18:27 -0400

Answer by Daniel Oechslin

Daniel Oechslin — Mon, 13 Oct 2014 16:02:55 -0400

Hi MaxIvy

You can do it the very same as explained here: http://jeebestpractices.blogspot.ch/2011/03/save-images-into-database-postgres-with.html

Just adjust the naming a little and remove the conversion part.