khandelwaldeval khandelwaldeval - 1 month ago 15
Java Question

Accessing h2 database from specified path

How do I access an H2 database from a specified file path say E:\folder\mydb.h2.db in java? What would be the jdbc url for that?

Answer

Got an example code from the H2DB tutorial site


import java.sql.*;
public class Test {
    public static void main(String[] a)
            throws Exception {
        Class.forName("org.h2.Driver");
        Connection conn = DriverManager.
            getConnection("jdbc:h2:E:\\folder\\mydb", "sa", "");
        // add application code here
        conn.close();
    }
}