File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JSP and the fly likes Multiple records entered in DB Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Java » JSP
Reply Bookmark "Multiple records entered in DB" Watch "Multiple records entered in DB" New topic
Author

Multiple records entered in DB

Sid Scud
Ranch Hand

Joined: Mar 13, 2001
Posts: 32
When the Submit button is clicked more than once in rapid succession, multiple records are entered in DB.
The Jsp page calls a method from a worker bean that inserts the record. I tried isThreadSafe="false" but it didn't work. I tried synchronizing the insert method too ... but it failed.
How can this be avoided?
Pranit Saha
Ranch Hand

Joined: Sep 09, 2001
Posts: 130
Hi,
u can check it whether the data u r inserting id thr in database or not..
like
if(rs.next())
{
//enter data
}
else
{
//Don't
}
u can do this ny referencing id field..
Pranit..
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Multiple records entered in DB
 
Similar Threads
NX: methods problem in DBMain is puzzling me!
Regarding dopost() ?
Multiple records entered in DB
Wrongly Date is updated
Query returs empty list but getting results in TOAD