0

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 !!

Mangesh Kh
  • 13
  • 7

2 Answers2

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.

Community
  • 1
  • 1
Linuslabo
  • 1,568
  • 2
  • 24
  • 34
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.

Oscar
  • 13,594
  • 8
  • 47
  • 75