How to start a Mysql server in Java programatically?

Question

My Java application needs to connect to a Mysql database file which is present on disk.

For that, it needs to start a Mysql server and use the server to read the file. The problem is that I am not sure how to start the server from within my Java code, read the Mysql file, make modifications to it, and then stop the server.

Currently, I am using something like below, but I don't see a way to start the server from code.

MysqlDataSource dataSource = new MysqlDataSource();
dataSource.setUser("root");
dataSource.setPassword("root");
dataSource.setServerName("MysqlServer");
Connection conn = dataSource.getConnection();

Using this, I run into

Exception in thread "main" java.lang.RuntimeException: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

which I think is because the server is not up. How do I start the server from code?

Were you able to run the app if mysql is started manually? Network errors could come from antivirus software/firewall etc — Jayan
– Jayan, Commented Apr 24, 2013 at 2:04
@Sai: I am using OSX but looking for a platform independent solution. — Moeb
– Moeb, Commented Apr 24, 2013 at 2:14
If you want platform independence then why not use Apache Derby instead of MySQL? — Thorbjørn Ravn Andersen
– Thorbjørn Ravn Andersen, Commented Apr 24, 2013 at 3:09

Jayan · Accepted Answer · 2013-04-24 02:01:51Z

4

Option 1 : Find out how to start mysql from command line. Then use ProcessBuilder to do that
Option 2: Use embeddable version of mysql , if that suits you : See details

answered Apr 24, 2013 at 2:01

Jayan

18.6k15 gold badges92 silver badges147 bronze badges

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

Comments

user2487575 · Accepted Answer · 2013-06-20 03:29:15Z

4

you need to run 'mysqld.exe' to start the mysql server. This file can be found in the 'bin' folder in the mysql main folder (Assuming that you are working in windows). In my case 'mysql-5.6.10-win32\bin\mysqld.exe' .

From Java if you want to do the same - I used the following code and it worked. Hope it helps.

======================================================

String command = "~path~\\mysql-5.6.10-win32\\bin\\mysqld.exe";

try
{
    Process process = Runtime.getRuntime().exec(command);
} 
catch (IOException e)
{
    e.printStackTrace();
}

answered Jun 20, 2013 at 3:29

user2487575

411 bronze badge

Comments

MarsAtomic · Accepted Answer · 2013-04-24 01:51:04Z

1

Look into Runtime.exec(), which will allow you to start mySQL via console.

http://docs.oracle.com/javase/1.5.0/docs/api/java/lang/Runtime.html

answered Apr 24, 2013 at 1:51

MarsAtomic

10.7k5 gold badges37 silver badges59 bronze badges

2 Comments

syb0rg Over a year ago

1) I would recommend the use of a ProcessBuilder instead of Runtime.exec() 2) Try to link to more up-to-date documentation in an answer. Right now, you are linking to Java 1.5

MarsAtomic Over a year ago

Fair enough. It's just the Java Doc link that came up first in Google, still works the same in 1.7.

Gary Wong · Accepted Answer · 2014-10-27 03:11:09Z

0

Runtime runTime = Runtime.getRuntime();
Process p = runTime.exec(String[] cmdarray, String[] envp, File dir);
p.waitFor();

answered Oct 27, 2014 at 3:11

Gary Wong

91 silver badge2 bronze badges

Comments

Mike Betterton · Accepted Answer · 2013-04-24 02:46:39Z

-3

Easiest way is to use JDBC all you need to do then is send queries to the server and interpret the results. A simple way to connect is below.

import java.sql.*;
Connection conn;
private void connect()
{
    try
    {
        Class.forName("com.mysql.jdbc.Driver").newInstance();
        conn = DriverManager.getConnection("jdbc:mysql://serverURL","user","pass);
        System.out.println("Connection Established");
    }
    catch (Exception ex) 
    {
        System.err.println("Unable to load the MySQL driver.");
        ex.printStackTrace();
    }

answered Apr 24, 2013 at 2:46

Mike Betterton

721 silver badge9 bronze badges

1 Comment

Thorbjørn Ravn Andersen Over a year ago

This expects the server to be running. He needs to start it.

Collectives™ on Stack Overflow

How to start a Mysql server in Java programatically?

5 Answers 5

Comments

Comments

2 Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

2 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related