Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to use sql loader with java?

 
Shah Hiren
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am trying to upload excel file using XSSF api ,but it gives out of memory error.How can i resolve it
I am planning to use sql loader,but i dont know how to implement that using java.Please suggest example in java to use sql loader.
Thanks
Hiren
 
Shah Hiren
Greenhorn
Posts: 21
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi ,
What is the best way to load excel file with 70 thousand records?Does sql loader or external tables help?

Hiren
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic