Re: SP to output Updated value with a multithreaded java client

[Todd Farmer]

Hi Saravanan,

It's hard to say without looking at your stored procedure code, but it sounds like there's a bug there. The most reliable way to use incrementing values in MySQL is to create a table with an auto-incrementing primary key. This can be a dummy table referenced by the stored procedure, which would do an INSERT and then retrieve LAST_INSERT_ID():

http://dev.mysql.com/doc/refman/5.6/en/information-functions.html#function_last-insert-id

Here's a good example of a stored function using this technique:

http://www.mysqlperformanceblog.com/2008/04/02/stored-function-to-generate-sequences/

Hope that helps!

--
Todd Farmer
MySQL @ Oracle
http://www.oracle.com/mysql/