hi all, i have select statements in my java code which are followed by updates in my Innodb table. the desired behaviour shud have been check and then update but because of tomcat accepting connections the above becomes check check update update i dont want to set the table locking, as it will make the system slower how can i set exclusive row locking until the update is finished?
Any pointers are appreciated. -Regards Sahil Aggarwal