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, May 09 '12 at 04:53
@BhavikAmbani, thanks for bringing this out. I've added some details. — yoyosir, May 09 '12 at 04:55
I think you should find this post interesting:[Stack Overflow Run SQL Script with MySQL][1] [1]: http://stackoverflow.com/questions/1044194/running-a-sql-script-using-mysql-with-jdbc — Juan Alberto López Cavallotti, May 09 '12 at 04:57

score 1 · Accepted Answer · answered May 09 '12 at 04:56

1

You can execute any shell command using Runtime.exec:

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

answered May 09 '12 at 04:56

Abdullah Jibaly

By the way, can I record the time needed for this query? – yoyosir May 10 '12 at 01:47
Sure, using plain old `System.currentTimeMillis()` before and after. – Abdullah Jibaly May 10 '12 at 04:12
You can make it block using `waitFor()`. Just be aware of the pitfalls: http://www.javaworld.com/javaworld/jw-12-2000/jw-1229-traps.html?page=4 – Abdullah Jibaly May 10 '12 at 15:17

score 0 · Answer 2 · answered May 09 '12 at 05:08

0

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

answered May 09 '12 at 05:08

Phalgun D

2 Answers2