 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
deboer
Guest
|
 Posted: Sun Aug 17, 2003 7:56 am Post subject: How to make transactions on midas environment ? |
 |
|
My program is to transfer the data from a excel file to customer table
and also backup the excel file to another blobfield table . either step's
failure should cause the transaction rollback . I means we will not backup
the excel file without transfer customer data or got the customer data
without excel backup file .
But , if we use midas architecture to build the program . the transaction
feature were not supported since it base on stateless connection . If we
tranfer the whole excel file to mid-tier, the server can not bear so much
operations .
How can i handle it ? should i fall back and refactor the program to be c/s
style ?
Any suggestions or links to articles are welcome .
Thanks in advance.
|
|
| Back to top |
|
 |
Wayne Niddery [TeamB]
Guest
|
| Posted: Sun Aug 17, 2003 12:56 pm Post subject: Re: How to make transactions on midas environment ? |
|
|
deboer wrote:
| Quote: | My program is to transfer the data from a excel file to customer
table and also backup the excel file to another blobfield table .
either step's failure should cause the transaction rollback . I
means we will not backup the excel file without transfer customer
data or got the customer data without excel backup file .
But , if we use midas architecture to build the program . the
transaction feature were not supported since it base on stateless
connection . If we tranfer the whole excel file to mid-tier, the
server can not bear so much operations .
|
If you intend to b-u the excel file into a blob field, then the entire excel
file must be transferred to the mid-tier anyway. To help this, you could
perform compression on the client side first and store it that way.
There are a couple of ways to do this with DataSnap (MIDAS). The excel file
can be passed as an extra parameter to your existing ClientDataset that is
applying the customer table, or you could export a method from the mid-tier
that takes both the customer ClientDatasets Delta property and the
compressed excel doc as parameters and in that method you can wrap both
operations in a single transaction very easily.
--
Wayne Niddery - Logic Fundamentals, Inc. (www.logicfundamentals.com)
RADBooks: http://www.logicfundamentals.com/RADBooks.html
"It is error alone which needs the support of government. Truth can
stand by itself." - Thomas Jefferson
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
