MySQL: Can a stored procedure invoke a Java program?

Question

I have a MySQL stored procedure. I would like to have a stored procedure run some statements, then call a Java program. Then when the java program is complete, the stored procedure should finish.

The java program will connect to the database, do some analysis and then insert rows into other tables.

Is this possible?

Wait, so you just want to execute an external java application as part of a data insert? I'm confused as to how this is related to stored procedures. — cdeszaq
– cdeszaq, Commented Mar 19, 2012 at 20:38
i wish to do this call processData() and then do everything that I typed above — stackoverflow
– stackoverflow, Commented Mar 19, 2012 at 20:39
So, what have you tried? Stack Overflow really frowns on questions that don't show what the Asker has tried and where they ran into troubles. — cdeszaq
– cdeszaq, Commented Mar 19, 2012 at 20:43
@cdeszaq its a general question relating to a programmatic approach. I guess the stackoverflow people hate those kinds of questions. And thanks for downvoting — stackoverflow
– stackoverflow, Commented Mar 19, 2012 at 20:47
No, the community hates simply providing answers to people that don't show that they have at least attempted to find a solution on their own. I'm not saying that this is a bad question, just that you will likely get more answers if you have shown what you tried and what trouble you ran into. — cdeszaq
– cdeszaq, Commented Mar 19, 2012 at 20:49

Community · Accepted Answer · 2017-04-13 12:42:40Z

3

Yes. Take a look at The MySQL UDF Repository and the sys_exec function. You could use this to launch your Java code in a new JVM.

After you get that installed here is how you run it: https://dba.stackexchange.com/a/39547/14506

edited Apr 13, 2017 at 12:42

CommunityBot

11 silver badge

answered Mar 19, 2012 at 20:44

Jim Garrison

87k20 gold badges162 silver badges197 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Satish Sharma Over a year ago

can u please provide the information about the arguments taken by sys_exec function

Collectives™ on Stack Overflow

MySQL: Can a stored procedure invoke a Java program?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related