aspose file tools*
The moose likes JSP and the fly likes Multiple records entered in DB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » JSP
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://aspose.com/file-tools
 
subject: Multiple records entered in DB
 
Similar Threads
Multiple records entered in DB
Query returs empty list but getting results in TOAD
Wrongly Date is updated
NX: methods problem in DBMain is puzzling me!
Regarding dopost() ?