Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Location
    London, uk & Denmark
    Posts
    5

    Question Unanswered: Lock in share mode problem using Innodb

    I have written an web application that use tomcat 5, MySQL, Java/jsp, JDBC, JNDI.

    My problem is that if an application sets a lock on a data item in share mode any other applications running on the same pc can still update this item. I know the lock is set as you cannot update the record in the database because of the lock.

    I would really appreciate if someone could help me

    Mette

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320

    Re: Lock in share mode problem using Innodb

    Originally posted by mette
    I have written an web application that use tomcat 5, MySQL, Java/jsp, JDBC, JNDI.

    My problem is that if an application sets a lock on a data item in share mode any other applications running on the same pc can still update this item. I know the lock is set as you cannot update the record in the database because of the lock.

    I would really appreciate if someone could help me

    Mette
    Apparently you use the same thread. Innodb transaction and lock are based on Thread, connection and user.
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Mar 2004
    Location
    London, uk & Denmark
    Posts
    5

    Re: Lock in share mode problem using Innodb

    I know what the problem is now and can solve it by redesigning my JSP applications to be multi threaded.

    You have saved my day…Thank you

    Mette

Posting Permissions

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