Is there a way to use Postgresql copy (loading CSV in table) from Hibernate?

Question

In my current application I am using Hibernate + PostgreSQL. For a particular case I need to use the COPY functionality available in postgres to load data from CSV file. Is there any way to use COPY using Hibernate.

Postgres version : 9.4
Hibernate version : 5.0.6

I'm new to Hibernate, so couldn't do much with Hibernate. I am able to do this using jdbc type 4 connection. If you are interested in that I can share that code, however it will be irrelevant to the topic — Ketu
– Ketu, Commented Jan 28, 2016 at 9:32
Hibernate will not support that. But you can use copy from stdin from JDBC using the CopyManager API. See e.g. here: stackoverflow.com/questions/33648947/… — user330315
– user330315, Commented Jan 28, 2016 at 9:54
@a_horse_with_no_name thanks for the reference link, gave me a way forward. — Ketu
– Ketu, Commented Jan 29, 2016 at 6:57

Ketu · Accepted Answer · 2016-01-29 06:55:47Z

7

Based on @a-horse-with-no-name comment, I put together following code as session.doWork is deprecated.

SessionFactory factory = HibernateUtil.getSessionFactory();
Session session = factory.openSession();
SessionImplementor sessImpl = (SessionImplementor) session;
Connection conn = null;
conn = sessImpl.getJdbcConnectionAccess().obtainConnection();
CopyManager copyManager = new CopyManager((BaseConnection) conn);
File tf =File.createTempFile("temp-file", "tmp"); 
String tempPath =tf.getParent();
File tempFile = new File(tempPath + File.separator + filename);
FileReader fileReader = new FileReader(tempFile);
copyManager.copyIn("copy testdata (col1, col2, col3) from  STDIN with csv", fileReader );

Hope this helps readers.

answered Jan 29, 2016 at 6:55

Ketu

1,7482 gold badges18 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

Is there a way to use Postgresql copy (loading CSV in table) from Hibernate?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related