You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by Karthik Nanjangude <ka...@xius-bcgi.com> on 2010/11/17 13:41:59 UTC
WEB Application need to upload a txt / csv file with 100K records
Hi
SPEC :
JDK1.5
WEB SERVER : TOMCAT 5.0.20
O/s Linux - Unix
DB Oracle 10gAS + PLSQL
Logged Session Time
An module of our WEB Application need to upload a txt / csv file with 100K records.
These Records are to be validated with certain checks in the Business layer..Before the pumped to a PLSQL of Oracle DB
The process has to further Waite for the response of Errors from PLSQL and has to be displayed on the JSP Screen.
Question : I fear the Login session time out may NOT commit the Process for 100K records.
Can some body suggest me a better way of handling the same successfully .....:(
with regards
N.S.Karthik
RE: WEB Application need to upload a txt / csv file with 100K
records
Posted by Karthik Nanjangude <ka...@xius-bcgi.com>.
Hi
>> but if the browser has to wait more than 3-4 minutes for a server response, the browser will time out on the connection and declare the server dead.
I definitely vote for this primary Issue ...... :{
Any more suggestions
With regards
karthik
-----Original Message-----
From: André Warnier [mailto:aw@ice-sa.com]
Sent: Wednesday, November 17, 2010 6:20 PM
To: Tomcat Users List
Subject: Re: WEB Application need to upload a txt / csv file with 100K records
Karthik Nanjangude wrote:
> Hi
>
> SPEC :
>
> JDK1.5
> WEB SERVER : TOMCAT 5.0.20
> O/s Linux - Unix
> DB Oracle 10gAS + PLSQL
>
> Logged Session Time
>
> An module of our WEB Application need to upload a txt / csv file with 100K records.
> These Records are to be validated with certain checks in the Business layer..Before the pumped to a PLSQL of Oracle DB
> The process has to further Waite for the response of Errors from PLSQL and has to be displayed on the JSP Screen.
>
> Question : I fear the Login session time out may NOT commit the Process for 100K records.
>
>
> Can some body suggest me a better way of handling the same successfully .....:(
>
I don't know about the "login session timeout" (or even if it is relevant in this case),
but if the browser has to wait more than 3-4 minutes for a server response, the browser
will time out on the connection and declare the server dead.
You may want to consider that part first.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: WEB Application need to upload a txt / csv file with 100K
records
Posted by André Warnier <aw...@ice-sa.com>.
Karthik Nanjangude wrote:
> Hi
>
> SPEC :
>
> JDK1.5
> WEB SERVER : TOMCAT 5.0.20
> O/s Linux - Unix
> DB Oracle 10gAS + PLSQL
>
> Logged Session Time
>
> An module of our WEB Application need to upload a txt / csv file with 100K records.
> These Records are to be validated with certain checks in the Business layer..Before the pumped to a PLSQL of Oracle DB
> The process has to further Waite for the response of Errors from PLSQL and has to be displayed on the JSP Screen.
>
> Question : I fear the Login session time out may NOT commit the Process for 100K records.
>
>
> Can some body suggest me a better way of handling the same successfully .....:(
>
I don't know about the "login session timeout" (or even if it is relevant in this case),
but if the browser has to wait more than 3-4 minutes for a server response, the browser
will time out on the connection and declare the server dead.
You may want to consider that part first.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: WEB Application need to upload a txt / csv file with 100K
records
Posted by Marian Simpetru <ma...@esolutions.ro>.
Hi,
you can do this using some ajax:
First upload the file
then in the returning JSP you will have a ajax request that check the
status of the process. You can check the validation process, then the
actual database insert.
The resource checked will return the message (and depending of the
returned message you display 'under processing' or the error message or
whatever you need.
Best,
Marian
On Wed, 2010-11-17 at 18:11 +0530, Karthik Nanjangude wrote:
> Hi
>
> SPEC :
>
> JDK1.5
> WEB SERVER : TOMCAT 5.0.20
> O/s Linux - Unix
> DB Oracle 10gAS + PLSQL
>
> Logged Session Time
>
> An module of our WEB Application need to upload a txt / csv file with 100K records.
> These Records are to be validated with certain checks in the Business layer..Before the pumped to a PLSQL of Oracle DB
> The process has to further Waite for the response of Errors from PLSQL and has to be displayed on the JSP Screen.
>
> Question : I fear the Login session time out may NOT commit the Process for 100K records.
>
>
> Can some body suggest me a better way of handling the same successfully .....:(
>
>
>
>
>
>
>
> with regards
>
> N.S.Karthik
>
Re: WEB Application need to upload a txt / csv file with 100K
records
Posted by Christopher Schultz <ch...@christopherschultz.net>.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Karthik,
On 11/17/2010 7:41 AM, Karthik Nanjangude wrote:
> JDK1.5
Upgrade.
> WEB SERVER : TOMCAT 5.0.20
Upgrade.
> Logged Session Time
>
> An module of our WEB Application need to upload a txt / csv file
> with 100K records. These Records are to be validated with certain
> checks in the Business layer..Before the pumped to a PLSQL of Oracle
> DB The process has to further Waite for the response of Errors from
> PLSQL and has to be displayed on the JSP Screen.
Maybe a web application/service isn't appropriate for this type of
thing. Perhaps the web service could be used to /submit/ jobs like this,
but post-processing reporting should be done in another way: JMX
message, email, FTP, etc.
- -chris
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/
iEUEARECAAYFAkzkHnEACgkQ9CaO5/Lv0PAn3gCY6foyFT2wmDOQMaUozSvu/7UB
OgCfU6YgXe2BfPWZF3VF3NjM1Unk398=
=oyxT
-----END PGP SIGNATURE-----
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org