nikals.se

Prerequisites:

• MySQL Database
• Glassfish 5  – 4.1.1 won’t work for this guide
• Java 8 SE
• Java 8 EE SDK

1. Download JDBC driver

At the moment of writing, the latest version (8.0.15) of the JDBC driver does not work with Glassfish. Use 5.1.47 instead.

For the lazy, go to your glassfish domain folder

\glassfish\domains\domain1\lib\

and run the following:

wget https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.47.zip

jar xf mysql-connector-java-5.1.47.zip

move mysql-connector-java-5.1.47\mysql-connector-java-5.1.47.jar .

2. Set up JDBC Connection Pool

Glassfish Admin Console:

Resources > JDBC > JDBC Connection Pools  > New

Configure as follows:

Pool Settings and Transaction is up to you

In Properties, the following are required:

User: {your db user}

Password: {your db user password}

URL: jdbc:mysql://{host}:{port}/{database name}

Url: jdbc:mysql://{host}:{port}/{database name}

Click ”Finish”

If everything is set up correctly, you should see this:

3. Set up the JDBC Resource

Glassfish Admin Console:

 Resources > JDBC > JDBC Resources > New

Configure as follows:

Remember your JNDI Name

Click ”Save”

4. Use the JDBC Resource

Sample code to connect and start querying:

InitialContext ctx = new InitialContext();
DataSource ds = (DataSource) ctx.lookup("jdbc/DemoJNDI");
        
    conn = (Connection) ds.getConnection();
    
    try {
        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT 1");

        rs = stmt.getResultSet();
        while (rs.next()) {
        // Do something with ResultSet    
        }
    } finally {
        conn.close(); 
    }

Done!