how to perform update records faster?
Hi All, Can someone please tell me how I able to do update/modify records faster? My user need to click/select individual records to update in one big table(or one web page). Since there are so many records need to update continually, is a way can perform faster? Someone told me using session and Arraylist, another person told me using pop-up window, but I do not know how to use these specifially, can anyone help me? Thanks, __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
How to perform update records faster?
Hi All, Can someone please tell me how I able to do update/modify records faster? My user need to click/select individual records to update in one big table(or one web page). Since there are so many records need to update continually, is a way can perform faster? Someone told me using session and Arraylist, another person told me using pop-up window, but I do not know how to use these specifially, can anyone help me? Thanks, __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: how to perform update records faster?
Andrew, Thanks for your fast response.
Yes, my user need to edit a whole bunch of records
(rows), and there might be more than 20, and for each
update, my code have to call updateRecord method to
connect to database, and do the following:
try {
stmt = conn.prepareStatement(stringSQL);
rs = stmt.executeQuery();
while (rs.next()) {
...update record
rs.close();
stmt.close();
...disconnect database...
For each record process the code, so the performance
is very slow...
Could you please give me more help?
--- Andrew Hill [EMAIL PROTECTED]
wrote:
You mean like edit a whole bunch of records (rows)
at one go where you dont
necessarily know how many there are, etc...?
Take a look at the examples here:
http://www.keyboardmonkey.com/next/index.jsp
(btw: You didnt really make your problem very clear
so I hope this was what
you meant)
-Original Message-
From: Julia Weaver
[mailto:[EMAIL PROTECTED]
Sent: Tuesday, 23 December 2003 22:12
To: Struts Users Mailing List
Subject: how to perform update records faster?
Hi All,
Can someone please tell me how I able to do
update/modify records faster? My user need to
click/select individual records to update in one big
table(or one web page). Since there are so many
records need to update continually, is a way can
perform faster? Someone told me using session and
Arraylist, another person told me using pop-up
window,
but I do not know how to use these specifially, can
anyone help me?
Thanks,
__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
-
To unsubscribe, e-mail:
[EMAIL PROTECTED]
For additional commands, e-mail:
[EMAIL PROTECTED]
-
To unsubscribe, e-mail:
[EMAIL PROTECTED]
For additional commands, e-mail:
[EMAIL PROTECTED]
__
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
error: Unable to connect to host
Hi All, Please help, I am getting the following error message: Unable to connect to host: jakarta.apache.org in the line: !DOCTYPE form-validation PUBLIC -//Apache Software Foundation//DTD Commons Validator Rules Configuration 1.0//EN http://jakarta.apache.org/commons/dtds/validator_1_0.dtd; in my validation.xml file It was ok before, I do not understand why I am getting now. Thank you for any help. __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: how to Remove the cached JSP's?
Thanks. I deleted java n class from 'WORK' directory, but still keep getting same/similar error: in the manu.jsp, I changed app.menu.profile to app.menu.po, but still show the value of app.menu.profile. item titleapp.menu.po/title item titleapp.menu.po.browse/title linkPoBrowse.do/link /item /item In application.properties, I have following: app.menu.po=PO app.menu.po.browse=Po browse app.menu.profile=Profile app.menu.profile.mbs=Default Region I am using IBM WebSphere Studio Application Developer. Please give me more help, thanks. --- Agashivala, Vishal [EMAIL PROTECTED] wrote: Remove the .java and .class file for that JSP from %Tomcat_home%\work\Standalone\localhost\%virtualdirectory% Although path depends upon the version of tomcat..you wont find exact path as shown above but try to remove java n class from 'WORK' directory under your tomcat installation. Regards, Vishal Agashivala Atos Origin India O: +91-22-5691 3870 -Original Message- From: shivanjali [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:45 AM To: 'Struts Users Mailing List' Subject: RE: how to Remove the cached JSP's? What is cached JSP's? Please let me know. thanks -Original Message- From: Julia Weaver [mailto:[EMAIL PROTECTED] Sent: Sunday, December 07, 2003 1:49 PM To: Struts Users Mailing List Subject: how to Remove the cached JSP's? Hi, I am using Tile, and getting the error javax.servlet.ServletException: org/apache/jsp/Registration_jsp (wrong name: org/apache/jsp/registration_jsp) I found one solution in one web site, said: Remove the cached JSP's and restart. But how to Remove the cached JSP's? please help, thank you very much. __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: how to Remove the cached JSP's?
Thanks. I did Stop Websphere, restart my computer, and then Start Websphere again. But still not work. Maybe I should change something in configuration. Could you please give me further instruction how to change in configuration? or something wrong in the tile definition? definition name=mainLayout path=/basic/myLayout.jsp put name=title value=My First Definition Page / put name=header value=/common/Header.jsp / put name=footer value=/common/footer.jsp / put name=menu value=/basic/menu.jsp / put name=body value=test.jsp / /definition --- Martin Gainty [EMAIL PROTECTED] wrote: in that case you should Stop Websphere and then Start Websphere most appservers and webservers will load JSPs on startup and will the program will retain jsps after precompiling into memory unless configured NOT to do so.. Bouncing the server ALWAYS works -Martin - Original Message - From: Julia Weaver [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Monday, December 08, 2003 9:53 AM Subject: RE: how to Remove the cached JSP's? Thanks. I deleted java n class from 'WORK' directory, but still keep getting same/similar error: in the manu.jsp, I changed app.menu.profile to app.menu.po, but still show the value of app.menu.profile. item titleapp.menu.po/title item titleapp.menu.po.browse/title linkPoBrowse.do/link /item /item In application.properties, I have following: app.menu.po=PO app.menu.po.browse=Po browse app.menu.profile=Profile app.menu.profile.mbs=Default Region I am using IBM WebSphere Studio Application Developer. Please give me more help, thanks. --- Agashivala, Vishal [EMAIL PROTECTED] wrote: Remove the .java and .class file for that JSP from %Tomcat_home%\work\Standalone\localhost\%virtualdirectory% Although path depends upon the version of tomcat..you wont find exact path as shown above but try to remove java n class from 'WORK' directory under your tomcat installation. Regards, Vishal Agashivala Atos Origin India O: +91-22-5691 3870 -Original Message- From: shivanjali [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:45 AM To: 'Struts Users Mailing List' Subject: RE: how to Remove the cached JSP's? What is cached JSP's? Please let me know. thanks -Original Message- From: Julia Weaver [mailto:[EMAIL PROTECTED] Sent: Sunday, December 07, 2003 1:49 PM To: Struts Users Mailing List Subject: how to Remove the cached JSP's? Hi, I am using Tile, and getting the error javax.servlet.ServletException: org/apache/jsp/Registration_jsp (wrong name: org/apache/jsp/registration_jsp) I found one solution in one web site, said: Remove the cached JSP's and restart. But how to Remove the cached JSP's? please help, thank you very much. __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: how to Remove the cached JSP's?
Martin, thank you very much for the informaion. I found one of errors about my menu is I have 2 menu.jsp in different directory. I still need work on other problems... --- Martin Gainty [EMAIL PROTECTED] wrote: for caching properties on IBM http server: http://www-3.ibm.com/software/webservers/appserv/doc/v40/ae/infocenter/was/040502.html Specifically look at httpd.conf in the IBM Http Server: AfpaEnable AfpaCache on AfpaLogFile c:/Program Files/IBM HTTP Server/logs/afpalog V-ECLF AfpaDynaCacheMax 10 The above settings enable the Cache Accelerator and limit the dynamic cache size to 10 Meg. If you use these directive to increase the cache size, do not make the cache so large that all physical memory is consumed. You can determine how much memory is available, when all the applications are running, by using the Windows Task Manager. Assign no more than 50% of available physical memory to the dynamic cache. Specifying too large a cache not only decreases the performance of other applications, but also puts you at risk for completely running out of memory. The default configuration does not include the AfpaDynaCacheMax directive where the cache size is automatically calculated as 1/8 of physical memory. for configuraing cahcing thru WebSphere console try and configure the dynacache.xml http://www-3.ibm.com/software/webservers/appserv/doc/v40/ae/infocenter/was/0606001601.html usually there is a websphere admin that can help you with this..be mindful the greater anount of storage allocated the greater the capacity that the program will cache let me know.. Martin - Original Message - From: Julia Weaver [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Monday, December 08, 2003 10:10 AM Subject: Re: how to Remove the cached JSP's? Thanks. I did Stop Websphere, restart my computer, and then Start Websphere again. But still not work. Maybe I should change something in configuration. Could you please give me further instruction how to change in configuration? or something wrong in the tile definition? definition name=mainLayout path=/basic/myLayout.jsp put name=title value=My First Definition Page / put name=header value=/common/Header.jsp / put name=footer value=/common/footer.jsp / put name=menu value=/basic/menu.jsp / put name=body value=test.jsp / /definition --- Martin Gainty [EMAIL PROTECTED] wrote: in that case you should Stop Websphere and then Start Websphere most appservers and webservers will load JSPs on startup and will the program will retain jsps after precompiling into memory unless configured NOT to do so.. Bouncing the server ALWAYS works -Martin - Original Message - From: Julia Weaver [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Monday, December 08, 2003 9:53 AM Subject: RE: how to Remove the cached JSP's? Thanks. I deleted java n class from 'WORK' directory, but still keep getting same/similar error: in the manu.jsp, I changed app.menu.profile to app.menu.po, but still show the value of app.menu.profile. item titleapp.menu.po/title item titleapp.menu.po.browse/title linkPoBrowse.do/link /item /item In application.properties, I have following: app.menu.po=PO app.menu.po.browse=Po browse app.menu.profile=Profile app.menu.profile.mbs=Default Region I am using IBM WebSphere Studio Application Developer. Please give me more help, thanks. --- Agashivala, Vishal [EMAIL PROTECTED] wrote: Remove the .java and .class file for that JSP from %Tomcat_home%\work\Standalone\localhost\%virtualdirectory% Although path depends upon the version of tomcat..you wont find exact path as shown above but try to remove java n class from 'WORK' directory under your tomcat installation. Regards, Vishal Agashivala Atos Origin India O: +91-22-5691 3870 -Original Message- From: shivanjali [mailto:[EMAIL PROTECTED] Sent: Monday, December 08, 2003 4:45 AM To: 'Struts Users Mailing List' Subject: RE: how to Remove the cached JSP's? What is cached JSP's? Please let me know. thanks -Original Message- From: Julia Weaver [mailto:[EMAIL PROTECTED] Sent: Sunday, December 07, 2003 1:49 PM To: Struts Users Mailing List Subject: how to Remove the cached JSP's? Hi, I am using Tile, and getting the error javax.servlet.ServletException: org/apache/jsp/Registration_jsp (wrong name: org/apache/jsp/registration_jsp) I found one solution in one web site, said: Remove the cached JSP's and restart. But how to Remove the cached JSP's
how to Remove the cached JSP's?
Hi, I am using Tile, and getting the error javax.servlet.ServletException: org/apache/jsp/Registration_jsp (wrong name: org/apache/jsp/registration_jsp) I found one solution in one web site, said: Remove the cached JSP's and restart. But how to Remove the cached JSP's? please help, thank you very much. __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing. http://photos.yahoo.com/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
