Java / postgresql COPY with JPA

Question

I have a file which i want to import to the postgres database. I know i can do it with jdbc and copymanager.

My Question is, how can i do it when i'm using JPA.

EntityManager em = JpaUtil.createEntityManager();
    em.getTransaction().begin();

    System.out.println(file2);
    Query copyQuery = em.createQuery("COPY temp_import FROM STDIN WITH DELIMITER E'\t'" +file2);

This isn't working.

Thanks for Help.

Craig Ringer · Accepted Answer · 2014-11-21 11:17:50Z

2

I know i can do it with jdbc and copymanager.

My Question is, how can i do it when i'm using JPA.

No, you can't, except by unwrapping the JPA connection to get the underlying JPA provider session, then unwrapping that to get the pooled connection, then unwrapping that to get the underlying SQL connection, then casting that to PSQLConnection and getting the CopyManager API for it.

JPA doesn't have a bulk-loading API.

answered Nov 21, 2014 at 11:17

Craig Ringer

329k84 gold badges742 silver badges820 bronze badges

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

Collectives™ on Stack Overflow

Java / postgresql COPY with JPA

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related