Lock in share mode problem using Innodb

mette · #1 (**permalink**) 03-14-04, 13:43

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

omiossec · #2 (**permalink**) 03-16-04, 04:39

Quote:

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.

mette · #3 (**permalink**) 03-16-04, 05:06

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

Internet Services

Web Development

Digital Marketing

Consumer Tech