J2EE struts import data

Thread view:

Adrien Boutreau - 06 Jul 2007 12:51 GMT

Hi,

I'm developping an application wich import a lot of data into my
database.
Todo this, there is a file which data and format like that
data1|data2|data3 etc.
I'm parsing line by line the current file and doing insert in the
database.
It works fine with few datas but after 5000 lines approximately I have
this error :

"java.sql.SQLException: Exception d'E/S: The Network Adapter could not
establish the connection"

Any ideas ?

Thanks

Sorry for my poor english :(

Reply to this Message

Richard Senior - 07 Jul 2007 16:33 GMT

> I'm parsing line by line the current file and doing insert in the
> database.
[quoted text clipped - 3 lines]
> "java.sql.SQLException: Exception d'E/S: The Network Adapter could not
> establish the connection"

It's difficult to say without knowing what the database is or seeing the
code but a few wild guesses ...

a. Are you opening a new connection to the database each time and not
closing it?

b. Are you committing each row?

c. If not, and you don't have exclusive access, is there sufficient
rollback for the amount of data you are trying to commit in one go?

d. Is there anything in the trace logs or error logs for the database.

e. Is there no utility for the database that does this (probably using
direct calls and therefore quicker). For example, Oracle has SQL*Loader.

Signature

Regards,

Richard

Reply to this Message

J2EE struts import data

Free Magazines