Hi,

I want to create MySQL stored function and procedure from Java using the JDBC Library.

Tried with different ways, but coulnt get that working.

Any suggestion or code would be really helpful.

Thanks,

Set the procedure from a script.
No reason whatsoever to want to do that from inside an application software, it's something you do when you create the database.

If you do want to initiate it from inside an application then issue the command that will run the script that created the procedure.