How to use java to execute some 'source' commands in mysql?

Question

I have a large number of source commands to execute. So I want to write some Java code to do this. Is there a way to do this in Java?

source command is like this:

 mysql> source /home/liova/download/tpch/queries/Q1.sql;

Not able to understand. What type of source command you cant to say ? — Bhavik Ambani
– Bhavik Ambani, Commented May 9, 2012 at 4:53
@BhavikAmbani, thanks for bringing this out. I've added some details. — yoyosir
– yoyosir, Commented May 9, 2012 at 4:55
I think you should find this post interesting:[Stack Overflow Run SQL Script with MySQL][1] [1]: stackoverflow.com/questions/1044194/… — Juan Alberto López Cavallotti
– Juan Alberto López Cavallotti, Commented May 9, 2012 at 4:57

Abdullah Jibaly · Accepted Answer · 2012-05-09 04:56:56Z

1

You can execute any shell command using Runtime.exec:

Runtime.exec("mysql db_name < /home/liova/download/tpch/queries/Q1.sql");

answered May 9, 2012 at 4:56

Abdullah Jibaly

55.1k45 gold badges129 silver badges201 bronze badges

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

3 Comments

By the way, can I record the time needed for this query?

Sure, using plain old System.currentTimeMillis() before and after.

You can make it block using waitFor(). Just be aware of the pitfalls: javaworld.com/javaworld/jw-12-2000/jw-1229-traps.html?page=4

Phalgun D · Accepted Answer · 2012-05-09 05:08:24Z

0

You can use Runtime class to execute any commands in java. It executes the command as seperate process.

answered May 9, 2012 at 5:08

Phalgun D

211 bronze badge