run a mysql command from java

Question

hi I have a JAVA project in which I want to display the MySQL databases. i write 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 give me this error:

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

what it should be do? thanks...

You aren't executing `show` within `mysql`, you're executing it as a new command line command. — Sotirios Delimanolis, Sep 25 '13 at 13:28
I'm unsure, but try getting the outpustream from the mysql process and writing to that. — Sotirios Delimanolis, Sep 25 '13 at 13:29
See [answers of this SO question](http://stackoverflow.com/questions/5679259/how-to-get-list-of-databases-schema-names-of-mysql-using-java-jdbc) post, it shows how to get mysql database names using java. — Tariq M Nasim, Sep 25 '13 at 13:34
`show databases` can be run through JDBC as well. Why do you want to run that as an external process? — , Sep 25 '13 at 13:35

score 4 · Accepted Answer · edited Sep 04 '18 at 05:14

4

Better to pass String object in exec method like:

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

edited Sep 04 '18 at 05:14

Ammar Ali

692
6
20

answered Sep 25 '13 at 13:31

Archer

5,073
8
50
96

score 0 · Answer 2 · answered Jul 04 '17 at 14:44

0

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

answered Jul 04 '17 at 14:44

Tharaka Dilshan

4,371
3
14
28

run a mysql command from java

2 Answers2

Linked