Adrian, If you do not want anothe rows created every time the page is submitted, then you are going to have to implement something to stop this. TOMCAT will not do this for you.
Without knowing the requirements for the form, stopping multiple rows being generated could be as simple as: - Assign a session to the user (clients browser). - When the form is submitted, capture the sessionId in the database with the record. - If there is no row with the sessionId in the database, create a new record with an insert. If there is a existing session, use an update to modify the record. Hope this helps Bill -----Original Message----- From: Adrian Beech [mailto:[EMAIL PROTECTED] Sent: Monday, 4 August 2003 8:45 PM To: [EMAIL PROTECTED] Subject: JSP seems to be executing twice and we are getting duplicate records in our database Hi folks, We have a weird problem where a JSP seems to be executing twice and we are getting duplicate records in our database. The data is coming from a HTML form and upon submit a subsequent JSP page is called that performs the SQL insert, etc. We are also getting duplicate log messages so our initial conclusion is that it's a Tomcat related issue. We have tested this with Tomcat 3.3.1, J2SE 1.3.1 and from the client side using both IE 5.5 and 6.0 and it happens intermittently. At this stage we have absolutely no idea of what is going on. Alas I didn't write the code so I'm not up to speed with its structure, flow or functionality. I've searched the list archive and there appears to be several references to similar problems. However I am unable to find any real answer to what might be causing this problem. Hoping someone out yonder can help. AB --------------------------------------------------------------------- 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]
