File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Urgent -- SQL Help Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Urgent -- SQL Help" Watch "Urgent -- SQL Help" New topic

Urgent -- SQL Help

Prasanna KumarBP

Joined: Jul 25, 2001
Posts: 21
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
Robert Brunner
Ranch Hand

Joined: Jul 18, 2001
Posts: 49
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.
I agree. Here's the link:
subject: Urgent -- SQL Help
It's not a secret anymore!