Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Location
    india
    Posts
    12

    Unanswered: how to maintain database concurrence?

    My application uses sql for performing operation. something like conncetion.execute(query). so there is only conncetion object no recordset object or something like that.

    NOTE: for this issue [connection object = database hendler]

    i want to run multiple instence of my application so i want to maintain integrety of data. and i am looking for solution through sql for locking mechanism. so concurrent data access dont currept data.

    So how can i maintain concurrency.
    [HINT:] some locking mechanism should be used how to use that lock that i dont know.

    I hope you have uderstand my requirement.
    Waiting for reply.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    i notice this exact same question in half a dozen forums

    please don't do that, that's called cross-posting, and it is not polite

    besides, why would you post this question in any other forums except the one for the database system you're using

    are you using mysql?

    i didn't think so
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    As Rudy pointed out, cross posting is both rude and probably not very effective, since many times the answer may take the context into consideration and give you the best answer based on where your question is posted. If you look at my answer the SQL Server forum, it references a Microsoft web page. In this case, the advice is sound, but the reference may be of little value if you aren't using Microsoft products.

    -PatP

Posting Permissions

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