store offline transaction

[hbks]

Hello, I have some design Issue.

we have 2 front-end screens which posts online transactions to one external system. if the external system is online we dont have any issues.
if the external source is offline, we need to store all the java transactions in oracle tables, finally when the external soure is up, we need post all the transactions to external source. External system always accpets the text/flat file format.

1. what could be best approach for this?
2. how to store all java transactions/records in oracle tables
3. and how to send all offline records to external system when it is UP.

Pls suggest me the best approach/design solution.

 

[LKBrwnDBA]

1) Store as flat file
2) You don't need a database
3) Depends on how external system looks for the data, you could ftp or copy the files over.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb