Perform Asynchronus db tasks in java servlet application

Question

I have a jsp/servlet based web app.

I have a button "Clean Up" which calls a servlet and the request goes till DAO class.DAO class performs different DB activities like, moving data from Master table to backup table, then deleting data from master table etc.

As of now this activity is Synchronous and user needs to wait until a response is sent.

I want to implement the same scenario as an Asynch task with user just getting a message as " Clean Up Activities Triggered"

What could be the best/easiest way to perform this task. I cannot use scheduler.

My Container is TomCat.

Yogendra Singh · Accepted Answer · 2012-10-22 18:46:06Z

2

Simplest but a different solution for this could be to use some AJAX behavior in the client side. There are lot of simple/powerful frameworks(JS files) to help you achieve AJAX in your page. Using AJAX, you just submit the request asynchronously and display the client side message "Clean Up Activities Triggered", while request is being processed in the server side. If user wait, server process will return and display a "success" message otherwise user is free to navigate other pages or perform other actions.

answered Oct 22, 2012 at 18:46

Yogendra Singh

34.5k7 gold badges66 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tomasz Nurkiewicz · Accepted Answer · 2012-10-22 18:45:33Z

2

ExecutorService is the most robust solution. Creating a simple thread is enough as well. However the bigger problem is synchronization. Use Semaphore to control whether two users aren't cleaning up simultaneously.

answered Oct 22, 2012 at 18:45

Tomasz Nurkiewicz

342k72 gold badges713 silver badges680 bronze badges

Comments

smk · Accepted Answer · 2012-10-22 18:46:40Z

0

we did this for our project once and it worked pretty well.

We sent the 200 ok to the user as long as there no issues processing the request. And we used the java executorservice to do the cleanup.

And in case something went wrong notified the user separately.

answered Oct 22, 2012 at 18:46

smk

5,9726 gold badges30 silver badges41 bronze badges

Collectives™ on Stack Overflow

Perform Asynchronus db tasks in java servlet application

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related