This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Agile forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

how to automatically delete a member from database

 
Murasoli Maran
Ranch Hand
Posts: 193
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all,
i have to delete members who join the website NOT making a purchase within 4 days.how can achieve the task?
may i use JSP for it or database trigger?.anybody having any pattern?.
anybody experienced plz suggest
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34084
337
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Murasoli,
A database trigger is well suited for this task. You could have it run regularly (for example, every night) and delete the members you specified.
 
Murasoli Maran
Ranch Hand
Posts: 193
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thank u Jeanne.good advice from u.i decided to use trigger.
 
Bear Bibeault
Author and ninkuma
Marshal
Pie
Posts: 64626
86
IntelliJ IDE Java jQuery Mac Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to the JDBC forum.
bear
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic