Set up an in-memory database | MySql?

For testing purposes, we use the H2 in-memory database.

To establish an H2 JDBC connection in Java, you need to follow these steps:

1. Add the H2 dependency: Include the H2 database dependency in your project's dependencies. If you're using a build tool like Maven or Gradle, you can add the following dependency to your project configuration:

   xmlCopy code<!-- Maven --> <dependency> <groupId>com.h2database</groupId> <artifactId>h2</artifactId> <version>1.4.200</version> </dependency>

2. Import the required classes: In your Java class, import the necessary classes for establishing a JDBC connection:

   javaCopy codeimport java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException;

3. Establish the JDBC connection: Use the DriverManager.getConnection() method to establish a connection to the H2 database. Specify the JDBC URL, username, and password for the connection:

   package com.esbCefBaseProject.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class InMemoryDatabase { private static final String DB_DRIVER = "org.h2.Driver"; private static final String DB_CONNECTION = "jdbc:h2:mem:test;DB_CLOSE_DELAY=-1"; private static final String DB_USER = "Rahul"; private static final String DB_PASSWORD = "Sita"; private Connection connection; public InMemoryDatabase() { try { Class.forName(DB_DRIVER); connection = DriverManager.getConnection(DB_CONNECTION, DB_USER, DB_PASSWORD); } catch (ClassNotFoundException | SQLException e) { e.printStackTrace(); } } public void createTable() { try (Statement statement = connection.createStatement()) { statement.executeUpdate( "CREATE TABLE records (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255), age INT)"); } catch (SQLException e) { e.printStackTrace(); } } public void dropTable() { try (Statement statement = connection.createStatement()) { statement.executeUpdate("DROP TABLE IF EXISTS records"); } catch (SQLException e) { e.printStackTrace(); } } public int createRecord(String name, int age) { int recordId = 0; try (PreparedStatement statement = connection.prepareStatement("INSERT INTO records (name, age) VALUES (?, ?)", Statement.RETURN_GENERATED_KEYS)) { statement.setString(1, name); statement.setInt(2, age); statement.executeUpdate(); ResultSet generatedKeys = statement.getGeneratedKeys(); if (generatedKeys.next()) { recordId = generatedKeys.getInt(1); } } catch (SQLException e) { e.printStackTrace(); } return recordId; } public void closeConnection() { if (connection != null) { try { connection.close(); connection = null; } catch (SQLException e) { e.printStackTrace(); } } } }

   Note: Make sure to replace the JDBC URL, username, and password with the appropriate values for your H2 database configuration.

4. Perform database operations: Once the connection is established, you can use the connection object to perform various database operations like executing queries, inserting data, updating records, etc.

5. Close the connection: After you have finished using the connection, make sure to close it using the close() method to release any resources associated with it.

Also, find the example usage below for the reference: