Hi, We have a problem here. We have a situation in which we will be inserting a row in a table. Now after a time interval of say 5 minutes we want to delete this row. Is there any easy means of doing this in SQL. We know that a Scheduled object in java can do the job. But we would like to know if this can be achieved at SQL level, which whould be faster than our approach. Kindest Regards ....Prasanna
posted 14 years ago
Why are you storing something in a Database for only five minutes? Sounds to me like you need to rethink your design. Why not just serialize the data to a temporary file. If you really need to do this, I would suggest you look at using a stored procedure, but this becomes database specific, thus I can't give more information.