This week's book giveaways are in the Java EE and JavaScript forums.
We're giving away four copies each of The Java EE 7 Tutorial Volume 1 or Volume 2(winners choice) and jQuery UI in Action and have the authors on-line!
See this thread and this one for details.
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


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
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..
 
Consider Paul's rocket mass heater.
 
subject: Multiple records entered in DB