csv file import into DB using hibernate

Question

I have requirement, where we have to read the huge csv file and dump data into sql table as it is. We are using hibernate for current project, any suggestion for importing csv file into db using hibernate with keeping eye on performance too. is there any tools available for csv to database dumb. Thanks in advance !!

Community · Accepted Answer · 2017-05-23 11:44:07Z

1

If you don't have to do that programmatically, SQLDeveloper or similar tools can do the job.

Otherwise you can use a simple bulk insert. Its syntax depends on your DBMS:

For bulk operations ("...to read the huge csv file and dump data...") you should opt for pure JDBC: any ORM introduces unavoidable overhead.

edited May 23, 2017 at 11:44

CommunityBot

11 silver badge

answered May 24, 2016 at 10:42

Linuslabo

1,6582 gold badges25 silver badges34 bronze badges

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

Comments

Oscar · Accepted Answer · 2016-05-24 10:25:18Z

0

Hibernate is ok for transactional operations, but might not be the best tool for bulk loads or ETL process.

I would use some specialized tool like Integration Services.

answered May 24, 2016 at 10:25

Oscar

14.1k9 gold badges53 silver badges84 bronze badges

Collectives™ on Stack Overflow

csv file import into DB using hibernate

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related