Hello Manasi, If possible can you please send in the code that you mentioned (procedure or trigger).
Please give a detailed technical explanation explaining the query which you used from command line and the query used in the procedure. Please mention the table structure, show table status and few records from the query executed. Cheers, Anirudh Sundar 9594506474 DataVail Mumbai. On Fri, May 28, 2010 at 5:44 PM, Manasi Save < manasi.s...@artificialmachines.com> wrote: > Dear All, > > 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, > Manasi Save > >
