How to use sql loader with java?

Greenhorn

Posts: 21

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

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

SCJP 1.4, SCWCD 1.4

Shah Hiren

Greenhorn

Posts: 21

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi ,
What is the best way to load excel file with 70 thousand records?Does sql loader or external tables help?

Hiren

SCJP 1.4, SCWCD 1.4

get schwifty. tiny ad:

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser