Re: data load

From: Dieter Bender (dieter.bender_at_t-online.de)
Date: 02/20/05 

Date: Sun, 20 Feb 2005 10:29:40 +0100

Hi,

thanks, I've had this idea too, but was a little bit unsure about starting a
thread and J2EE

Dieter

Leo Gaggl wrote:

> frebe wrote:
>>>whats the best way to start a long running process (> 60 minutes)from
>>
>> a web
>>
>>>application?
>>
>>
>> Start a new thread that does the work, and let the jsp page (or
>> servlet) return a response immediately. In the end of the load process,
>> write a notification in a table. Put a link in the response page, to a
>> page showing the status of the load.
>>
>> Fredrik Bertilsson
>> http://butler.sourceforge.net
>>
> Alternatively you can save the file you want to load to the webserver
> and use the databases bulk import facility to do the work. Most
> databases have these utilities and they are usually much more efficient
> than doing bulk loads via JDBC.
>
> Starting a new thread is a good idea anyway.
>
> HTH
>
> Leo