Testing

System.setProperty("java.class.path", System.getProperty("java.class.path") + ":/Users/mister_dew/vscode/dre2.0/_notebooks/h2-2.2.224.jar");

/Users/mister_dew/Library/Jupyter/kernels/java/ijava-1.3.0.jar:_notebooks/ojdbc11.jar:/Users/mister_dew/vscode/dre2.0/_notebooks/h2-2.2.224.jar

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

public class CreateH2Database {
    public static void main(String[] args) {
        // Load the H2 Database JDBC driver
        try {
            Class.forName("org.h2.Driver");
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
            return;
        }

        // Define the path to the H2 Database file
        String dbPath = "./volumes/sqlite.db";

        // JDBC URL for H2 Database connection
        String url = "jdbc:h2:" + dbPath;

        try (Connection connection = DriverManager.getConnection(url);
             Statement statement = connection.createStatement()) {

            // SQL statement to create a table (you can modify this as needed)
            String createTableSQL = "CREATE TABLE IF NOT EXISTS example_table (" +
                    "id INTEGER PRIMARY KEY AUTO_INCREMENT," +
                    "name VARCHAR(255) NOT NULL," +
                    "age INTEGER);";

            // Execute the SQL statement
            statement.execute(createTableSQL);

            System.out.println("Database and table created successfully.");

        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}

CreateH2Database.main(null);

java.lang.ClassNotFoundException: org.h2.Driver
	at java.base/java.net.URLClassLoader.findClass(URLClassLoader.java:476)
	at jdk.jshell/jdk.jshell.execution.DefaultLoaderDelegate$RemoteClassLoader.findClass(DefaultLoaderDelegate.java:154)
	at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:594)
	at java.base/java.lang.ClassLoader.loadClass(ClassLoader.java:527)
	at java.base/java.lang.Class.forName0(Native Method)
	at java.base/java.lang.Class.forName(Class.java:315)
	at REPL.$JShell$69$CreateH2Database.main($JShell$69.java:25)
	at REPL.$JShell$70.do_it$($JShell$70.java:21)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at io.github.spencerpark.ijava.execution.IJavaExecutionControl.lambda$execute$1(IJavaExecutionControl.java:95)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:829)