Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    24

    Unanswered: For how long transaction can be opened?

    Hey,

    I want that my client will open a transaction for a non limit time.

    Can i confiugre the MySQl to not close open transaction due to timeout?

    Thank you

  2. #2
    Join Date
    Mar 2007
    Location
    636f6d7075746572
    Posts
    770
    In what context are you planning on using this technique? Are you using it in a standalone (stateful) program, or are you using it in a stateless environment?
    Either way i'm unsure of the answer to your question. Why would you want a transaction to be open permanently? What happens if TCP/IP is interrupted, do you commit or rollback? Why don't you want to commit after each transaction set?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •