when my java projects run on local machine, store procedure and functions are running well.
when i upload this java projects war files on server, store procedures and functions are not calling.

please tell me solutions its argent.

Hi all.
I have a table in Mysql. The table consists of three columns: SponsorID, LeftID and RightID. And the table consists of hierarchical data, exactly like a binary tree.

LeftID and RightID can become SponsorID and have left and right child and this continues to create a hierarchical parent child relationship in the table.

Now I need to count the number of left and right child in the table when i pass a SponsorID....