MySQL connection

Log onto http://app.jelastic.servint.net/
Create environment with MySQL database:

Check your e-mail - your inbox should have a message from Robot@jelastic with database login and password:

Click the button Config next to the application server (Tomcat 7) in the expandable list of the environment.

In the opened tab create a file mydb.cfg in the folder home and add there all necessary configurations:

host=jdbc:mysql://mysql-{your_env_name}.{hoster_domain}/{db_name}
username={get in the email from Robot@jelastic}
password={get in the email from Robot@jelastic}
driver=com.mysql.jdbc.Driver

Note

As an example here you can see the code of our application which connects to our database.

DbManager.java :

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

package connection;

import java.io.FileInputStream;

import java.io.IOException;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.Properties;

import java.util.logging.Level;

import java.util.logging.Logger;

public class DbManager {

    private final static String createTable = "CREATE TABLE `example` (id INT, data VARCHAR(100))";

    public Connection createConnection() throws IOException, ClassNotFoundException, SQLException {

        Connection connection;



        Properties prop = new Properties();

        System.out.println("test");

        prop.load(new FileInputStream(System.getProperty("user.home") + "/mydb.cfg"));

        System.out.println("user.home: "+System.getProperty("user.home"));

        String host = prop.getProperty("host").toString();

        String username = prop.getProperty("username").toString();

        String password = prop.getProperty("password").toString();

        String driver = prop.getProperty("driver").toString();

        System.out.println("host: " + host + "\username: " + username + "\password: " + password + "\ndriver: " + driver);

        Class.forName(driver);

        System.out.println("--------------------------");

        System.out.println("DRIVER: " + driver);

        connection = DriverManager.getConnection(host, username, password);

        System.out.println("CONNECTION: " + connection);

        return connection;

    }

    public void runSqlStatement() {

        try {

            Statement statement = createConnection().createStatement();

            boolean rs = statement.execute(createTable);

        } catch (IOException ex) {

            Logger.getLogger(DbManager.class.getName()).log(Level.SEVERE, null, ex);

        } catch (ClassNotFoundException ex) {

            Logger.getLogger(DbManager.class.getName()).log(Level.SEVERE, null, ex);

        } catch (SQLException ex) {

            ex.printStackTrace();

        }

    }

}

The next step is to upload .war file to Jelastic's Deployment Manager. As an example we used dbconnexample.war file (click to download it) which contains appropriate jdbc-connector.
Click the link dbconnexample to download the package with the sources of our project.
Deploy the uploaded WAR file to the environment.

Click Open in Browser next to the application server (Tomcat 7) to open the window with the button Create table "example" in your database. Click this button.