Database toolkit - retry mechanism?

[nitulandia]

Hello gurus,

The following is part of a database read/write design aspect, and hope that you're able to help me find solutions :-)  I have a couple of my own, but would like to see what others may come up with.

 

Details:

I have been able to successfully use DB toolkit  vi's to read/write to an SQL database. Everything works as per the design -mostly- . The last piece I have yet to implement is the "retry-mechanism": what if during the WRITE action my database happens to be unavailable? do I save the data to a flat file and upon "reconneciton" I flush the records? this sounds quite simple, doesn't it?

 

This is the piece I'm trying to figure out. If you've done something like this already, would you please share your approach?

 

In advance, thank you.