• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 180
  • Last Modified:

Database table used in one session

I want users of webpage to use a table but when they close the webpage, all the stuff they add to a table in a SQL database should be automatically deleted. How can i possibly do that in jsp?
0
VbMonk
Asked:
VbMonk
1 Solution
 
jmaddaCommented:
What database are you using?

If you are using SQL Server, you could write a job that would truncate all of the data from that table periodically.  Would that work?

If the data the users are entering is only intended to be used during the time they are on the page, instead of writing that data to a database table you could store it in objects in the session.
That way there is no interaction with the datbase at all, and the data will dissappear when the user leave the site closes the brower.

Hope that helps.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now