con-current access
"tadta" <[email protected]> Mon, 01 Apr 2002 14:12:33 -0000
| Newsgroups | gmane.comp.java.ejb.general |
|---|---|
| Message-ID | <[email protected]> |
Hello,
please give suggestions...
We are using application server with jsp and servlets in our
application. We use connection pooling
In code we have the problem like
we have following tables manager,employee,workAllocated
The manager allocates the work to the employee.The work allocated is
stored in workAllocated table. The employee replies back as to
whether he accepts the work or wants a change in work
allocated to him. The manager can at any time change the work
allocated to employees.
Now the problem is this. Manager assigns work to employee1. employee1
opens the browser and is about to click the button 'accept work' at
that time the manager assigns the work of employee1 to another
employee. The employee1 clicks the 'accept work' button. Here we are
directly updating the status as 1 in database indicating that
employee1 has accepted the work whereas the manager has assigned the
work to another employee.
What is this problem called is this con-current access problem
We have written code in jsp. So we have to take care of this problem
by coding how to do that in jsp any idea?
Or is it advisable to use EJB. What are points in favour with regard
to this problem alone to shift to EJB. How does EJB solve this
problem better than doing doing ourself by code.
regards
Javid