SP to output Updated value with a multithreaded java client
Posted by: saravanan santhanam
Date: August 08, 2013 03:36AM

I have a SP in Mysql , which selects a value from a table and sends it out. Then adds 1 to the value and updates the table. something i tried to emulate Oracle Sequence. The issue is this SP is called from Java Multithread program Each time it gives the same value to all the threads

CLarify my how to tackle this is there anything we can do that in MYsql or is it be handled in Java. I am not a Java resource

Options: ReplyQuote


Subject
Written By
Posted
SP to output Updated value with a multithreaded java client
August 08, 2013 03:36AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.