run a mysql command from java

Question

I have a JAVA project in which I want to display the MySQL databases. I have written this code:

try {
     String []command={"mysql -u root -pmanager","show databases"};
        Process p= Runtime.getRuntime().exec("mysql -u root -pmanager");
        Process p1= Runtime.getRuntime().exec("show databases");
        if (p.waitFor()==0){System.out.println("backup done...");}
        else{System.out.println("!!!");}
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    } catch (InterruptedException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

But it gives me this error:

Cannot run program "show": CreateProcess error=2, The system cannot find the file specified

What should be done? thanks...

You aren't executing show within mysql, you're executing it as a new command line command. — Sotirios Delimanolis
– Sotirios Delimanolis, Commented Sep 25, 2013 at 13:28
I'm unsure, but try getting the outpustream from the mysql process and writing to that. — Sotirios Delimanolis
– Sotirios Delimanolis, Commented Sep 25, 2013 at 13:29
See answers of this SO question post, it shows how to get mysql database names using java. — Tariq M Nasim
– Tariq M Nasim, Commented Sep 25, 2013 at 13:34
show databases can be run through JDBC as well. Why do you want to run that as an external process? — user330315
– user330315, Commented Sep 25, 2013 at 13:35

Ammar Ali · Accepted Answer · 2018-09-04 05:14:45Z

4

Better to pass String object in exec method like:

Runtime.getRuntime().exec(  new String [] {"mysql", "-u", "root", "-pmanager", "-e", "show databases"} )

edited Sep 4, 2018 at 5:14

Ammar Ali

6906 silver badges20 bronze badges

answered Sep 25, 2013 at 13:31

Archer

5,1379 gold badges58 silver badges98 bronze badges

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

Comments

Tharaka Dilshan · Accepted Answer · 2017-07-04 14:44:32Z

0

You need to specify what is 'mysql' to command prompt... example - C:\Program Files\MySQL\MySQL Server 5.7\bin\mysql

answered Jul 4, 2017 at 14:44

Tharaka Dilshan

4,4993 gold badges17 silver badges29 bronze badges

Collectives™ on Stack Overflow

run a mysql command from java

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related