Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
From: Manasi Save (manasi.saveartificialmachines.com)
Date: Fri May 28 2010 - 07:14:14 CDT
I have one stored procedure Which inserts data into one table.
But sometimes it does not insert record. This happens when I called it from java application. But If I called same query from mysql command line. It executes successfully.
Also I have one procedure which only retrieves data from table. and it only gives one row sometime even if there are 10 rows available in for matching condition. This too happen when I called it from Java application and if I called it from mysql command line it gives me proper result set of 10 rows.
I am not able to understand Is it something known for mysql? Or am I doing something wrong?
Any input will be a great help.
Thanks and Regards,