B4J Question Remote database and bad network connection!

[david13]

Dear All,

I have this problem and coul not find the appropriate solution:

I have a table (20 lines) and want to save it in a remote database using my sql requests. the problem is because of the network connection the job sucess is false and so some lines are skiped and not sent to the remote server!

Pleqse any help

 

[DonManfred]

Why you are not using a Tractaction and send all comands in one call (send a batch of commands)?

 

[david13]

Why you are not using a Tractaction and send all comands in one call (send a batch of commands)?

Thanks For your answer, It's becase I never heard about it! I have this problem from a month ago, if you show me how I can do it, I will be so happy!

 

[DonManfred]

Search the Forum! I´ll not do your work.
Check the SQL Object Documentation. Check the Tutorial.
I´m sure you´ll find infos about Transactions.

 

[Erel]

If you are using jRDC2 then each batch of commands is executed as a single transaction.