• Post Reply Bookmark Topic Watch Topic
  • New Topic

Synchronization approach  RSS feed

 
Neeraj Vij
Ranch Hand
Posts: 315
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Process flow is as follows :-

1.)I need to read an excel file and upload it into the database table 'T'.
2.) 'X' procedure will execute to read table 'T'( from Step 1) and will perform some validations.

All this processing is done in related DAO.

My problem is :-

What parts should I synchronize to maintain data in a consistent state, while inserting/updating data into the database after reading from the excel file.

what to do when executng the insert/update part, some other user uploads his excel sheet
or
some user upoload his sheet while procedure is executing for performing the validations.


I have been told that excel will have large amount of data and no.of user will also high(I don't have numbers).


shortest way is to use single thread model or synchornize the the complte method.. which i don't want to do

Please provide inputs ASAP, I have very less time for it implement.


Sorry in advance if my language is not clear

Regards,
Neeraj.
 
Neeraj Vij
Ranch Hand
Posts: 315
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
should I introduce my own thread, rather than websphere 5.0(used for my project) for handling excel upload request ?

Regards,
Neeraj.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!